An Excel Workbook is a collection of ________.
It is acceptable to let long text flow into adjacent cells on a worksheet when
How to fit long texts in a single cell with multiple lines?
What does the VLOOKUP function do?
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ________.
You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Which of the following formulas will Excel Not be able to calculate?
If you press ________, the cell accepts your typing as its contents.
Which of the following is a correct order of precedence in formula calculation?
Which option allows you to Bold all the negative values within the selected cell range:
Can you set 0.5 inch left indentation for a cell in Excel?
A function inside another function is called _______
What is entered by the function =today()
You can enter which types of data into worksheet cells?
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
To create a formula, you first:
What is the shortcut key to hide entire row?
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
In maximum, how many sheets can be set as default while creating new workbook?
Which of the following is the oldest spreadsheet package?
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
How can you find specific information in a list?
You can use the horizontal and vertical scroll bars to
Excel probably considers the cell entry January 1, 2000 to be a
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
When you group worksheets
If you need a text to show vertically in a cell. How will you achieve this?
To activate the previous cell in a pre-selected range, press
Which of the following is not a valid Zoom percentage in Excel?
Which button do you click to add up a series of numbers?
Got functions? No You need the insert function dialog box. How do you get it?
Right clicking something in Excel:
Rounding errors can occur
What should be add before a fraction to avoid entering it as a date?
The Chart wizard term data categories refers to;
Which of the following is not the correct method of editing the cell content?
How to specify cell range from A9 to A99 in Excel?
Which of the cell pointer indicates that you can fill series?
You can check the conditions against __________ when applying conditional formatting