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.
The active cell:
Where can you set the shading color for a range of cells in Excel?
Paste Special allows some operation while you paste to new cell. Which of the following operation is…
What are the tabs that appear at the bottom of each workbook called?
To view a cell comment
Which elements of worksheet can be protected from accidental modification
You cannot link excel worksheet data to a word document
You can use drag-and-drop to embed excel worksheet data in a word document
Documentation should include
Which of the following is not the correct method of editing the cell content?
Which of the following formulas is not entered correctly?
A worksheet can have a maximum of . Number of rows
Which would you choose to create a bar diagram?
You can move a sheet from one workbook into new book by
You can use the formula pallette to
Microsoft Excel is a powerful ...........
A worksheet range is a
Excel files have a default extension of
An Excel Workbook is a collection of .......
Data can be arranged in a worksheet in a easy to understand manner using
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
A numeric value can be treated as label value if ...... precedes it.
Right clicking something in Excel:
When you want to insert a blank imbedded excel object in a word document you can
Comments can be added to cells using ......
The spelling dialog box can be involved by choosing spelling from ________ menu.
Concatenation of text can be done using
It is acceptable to let long text flow into adjacent cells on a worksheet when
When you link data maintained in an excel workbook to a word document
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter