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.
Which of the following is an absolute cell reference?
To create a formula, you can use:
Concatenation of text can be done using
Which of the following options is not located in the Page Setup dialog box?
Which of the following is not true regarding Conditional Formatting?
Which key do you press to check spelling?
Rounding errors can occur
You can convert existing excel worksheet data an charts to an HTML document by using
The command Edit >> Fill Across Worksheet is active only when
Which of the following is not information you can specify using the solver?
Status indicators are located on the
When integrating word and excel, word is usually the
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
A numeric value can be treated as a label value if it precedes with
Which of the following is not a basic step in creating a worksheet?
Hyperlinks can be
Which command will you choose to convert a column of data into row?
How can you delete a record?
When you insert an excel file into a word document. The data are
A __________ is a grid with labeled columns and rows.
How can you print three copies of a workbook?
What is the correct way to refer the cell A10 on sheet3 from sheet1?
Which of the following is not a way to complete a cell entry?
In Excel, a Data Series is defined as what?
Which of following is Not one of Excels what-if function?
Which of the following methods cannot be used to enter data in a cell
Tab scrolling button
When you link data maintained in an excel workbook to a word document
You can activate a cell by
Comments put in cells are called .....