Which function is not available in the Consolidate dialog box?
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Excel MCQ
comments powered by Disqus.
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
How can you remove borders applied in cells?ACC
When you link data maintained in an excel workbook to a word document
Rounding errors can occur
The auto calculate feature
To save a workbook, you:
Each excel file is called a workbook because
Multiple calculations can be made in a single formula using
What do you call the chart that shows the proportions of how one or more data elements relate to another…
What symbol is used before a number to make it a label?
The Cancel and Enter buttons appear in the:
Hyperlinks can be
How do you wrap the text in a cell?
Long text can be broken down into many lines within a cell. You can do this through
Which of the following methods can not be used to edit the contents of a cell?
While Finding and Replacing some data in Excel, which of the following statement is valid?
Comments put in cells are called .....
How do you rearrange the data in ascending or descending order?
Which button do you click to add up a series of numbers?
When a row of data is to be converted into columns
Files created with Lotus 1-2-3 have an extension
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
How do you display current date only in MS Excel?
Which of the following is not an example of a value?
Ctrl + D shortcut key in Excel will
The name box
How can you delete a record?
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
What are the tabs that appear at the bottom of each workbook called?
When a label is too long to fit within a worksheet cell, you typically must
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter