You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Correct Answer :
B. Double clicking the format painter button
Related Questions
How can you show or hide the gridlines in Excel Worksheet?
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
server
source
client
none
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
Which of the following is the latest version of Excel
Excel 2000
Excel 2002
Excel ME
Excel XP
The name box
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
How can you find specific information in a list?
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
Which of the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
You can use the formula pallette to
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
A numeric value can be treated as a label value if it precedes with
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&