Which of the following is not the correct method of editing the cell content?
A worksheet can have a maximum of …. Number of rows
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
When you group worksheets
You can check the conditions against __________ when applying conditional formatting
You can activate a cell by
What symbol is used before a number to make it a label?
The Name box on to the left of formula bar
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
To copy formatting from one area in a worksheet and apply it to another area you would use:
Which of the following methods will not enter data in a cell?
Which of the following is correct?
Which elements of a worksheet can be protected from accidental modification?
To center worksheet titles across a range of cells, you must
If particular workbook have to open each time Excel started, where that workbook should be placed?
What function displays row data in a column or column data in a row?
You can activate a cell by
Formulas in Excel start with
Which is an example of a formula?
You can quickly change the appearance of your work by choosing Auto Format from the ________ Menu.
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ________.
Which symbol must all formula begin with?
When integrating Ms-Word and Excel, Word is usually the
Give me an example of a cell address.
You can use the horizontal and vertical scroll bars to
What is the shortcut key to insert current date in a cell?
To edit in an embedded excel worksheet object in a word document
How do you wrap the text in a cell?
Selecting the Rows 5 & 6 then choose Insert > Ro What will happen?
Which of the following options is appropriate to show the numbers 9779851089510 in a cell?
Clear the contents by pressing “DELETE” key from a keyboard will clear
In Excel _______ may not contain in Formula
You can select a single range of cells by