In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Correct Answer :
D. To add shading or color to a cell range
Related Questions
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
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
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
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
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
How can you delete a record?
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
While Finding and Replacing some data in Excel, which of the following statement is valid?
You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
You can move a sheet from one workbook into new book by
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Which symbol must all formula begin with?
=
+
(
@
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above