How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Excel MCQ
comments powered by Disqus.
It is acceptable to let long text flow into adjacent cells on a worksheet when
In Excel, the Fill Color button on the Formatting toolbar is used for what?
How do you delete a column?
How do you wrap the text in a cell?
Which of the cell pointer indicates that you can fill series?
Which of the following formulas is not entered correctly?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Which of the following you can paste selectively using Paste Special command?
The Cancel and Enter buttons appear in the:
The command Edit >> Fill Across Worksheet is active only when
Concatenation of text can be done using
In the formula, which symbol specifies the fixed columns or rows?
Which command will you choose to convert a column of data into row?
You can select a single range of cells by
You cannot link excel worksheet data to a word document
What are the tabs that appear at the bottom of each workbook called?
How do you rearrange the data in ascending or descending order?
When you want to insert a blank imbedded excel object in a word document you can
Which of the cell pointer indicate that you can move the content to other cell?
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
While Finding and Replacing some data in Excel, which of the following statement is valid?
What is represented by the small, black square in the lower-right corner of an active cell or range?
Tab scrolling button
Excel displays the current cell address in the ........
Which of the following is not a basic step in creating a worksheet?
Multiple calculations can be made in a single formula using .......
Which of the following is an absolute cell reference?
Where can you change automatic or manual calculation mode in Excel?
Edit >> Delete command
You can use the horizontal and vertical scroll bars to