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.
You cannot link excel worksheet data to a word document
How can you print three copies of a workbook?
How do you display current date only in MS Excel?
In Excel, a Data Series is defined as what?
To activate the previous cell in a pre-selected range, press
Which of the following methods can not be used to edit the contents of a cell?
A circular reference is
You can use the drag and drop method to
Which is used to perform what if analysis?
Which of the following is a correct order of precedence in formula calculation?
You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Excel displays the current cell address in the ........
To save a workbook, you:
The Chart wizard term data categories refers to;
Multiple calculations can be made in a single formula using
To select an entire column in MS-EXCEL, press?
You can convert existing excel worksheet data an charts to an HTML document by using
Which of the following is not a term of MS-Excel?
A worksheet range is a
The chart wizard term data series refers to
The name box
What do you call the chart that shows the proportions of how one or more data elements relate to another…
Documentation should include
What is the short cut key to replace a data with another in sheet?
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
How can you remove borders applied in cells?ACC
Which area in an Excel window allows entering values and formulas?
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
What symbol is used before a number to make it a label?
Concatenation of text can be done using
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter