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 Name box on to the left of formula bar
You can auto fit the width of column by
Which setting you must modify to print a worksheet using letterhead?
How do you rearrange the data in ascending or descending order?
Comments can be added to cells using
To create a formula, you can use:
The Chart wizard term data categories refers to;
Which of the following is an absolute cell reference?
Which key do you press to check spelling?
To center worksheet titles across a range of cells, you must
A circular reference is
You can use the drag and drop method to
Which of the following formulas is not entered correctly?
When a range is selected, how can you activate the previous cell?
You can use the formula pallette to
Which symbol must all formula begin with?
Which command will you choose to convert a column of data into row?
You can use the formula palette to
To create a formula, you first:
The short cut key Ctrl + R is used in Excel to
Which of the following Excel screen components can NOT be turned on or off?
When a row of data is to be converted into columns
Which of the following formulas will Excel Not be able to calculate?
Which tool you will use to join some cells and place the content at the middle of joined cell?
Which of the cell pointer indicate that you can move the content to other cell?
The auto calculate feature
You can activate a cell by
The spelling dialog box can be involved by choosing spelling from ________ menu.
Which of the following methods cannot be used to enter data in a cell
Which elements of a worksheet can be protected from accidental modification?
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter