A numeric value can be treated as label value if ...... precedes it.
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Excel MCQ
comments powered by Disqus.
If you need to remove only the formatting done in a range (numbers and formula typed there should not…
When you insert an excel file into a word document. The data are
The spelling dialog box can be involved by choosing spelling from ________ menu.
To save a workbook, you:
Edit >> Delete command
What is represented by the small, black square in the lower-right corner of an active cell or range?
The command Edit >> Fill Across Worksheet is active only when
Which elements of a worksheet can be protected from accidental modification?
You can check the conditions against __________ when applying conditional formatting
Which of the following option is not available in Paste Special dialog box?
How do you insert a row?
When a label is too long to fit within a worksheet cell, you typically must
What are the tabs that appear at the bottom of each workbook called?
Each excel file is called a workbook because
Paste Special allows some operation while you paste to new cell. Which of the following operation is…
How do you rearrange the data in ascending or descending order?
Which of the following is not true regarding Conditional Formatting?
To create a formula, you first:
The Name box on to the left of formula bar
How can you remove borders applied in cells?ACC
The auto calculate feature
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
Which language is used to create macros in Excel?
You can activate a cell by
Which function is not available in the Consolidate dialog box?
What does COUNTA () function do?
Which menu option can be sued to split windows into two
MS Excel provides the default value for step in Fill Series dialog box
Rounding errors can occur
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter