Business Services

Test your knowledge

Select the correct answer for each of the following

If cell C4 contains a formula. Where would you see the formula displayed?
1. In cell C4
2. In the Formula bar
3. In the Name box
4. In the Status bar
How can you tell which cell in a worksheet is the active cell?
1. It is blinking
2. It is displayed in reverse video
3. It is surrounded by a heavy border
4. All of the above
How can you change the active cell?
1. Only by clicking in a different cell
2. Only by using the arrow keys to move to a different cell
3. By clicking or by using the arrow keys
4. By using the Taskbar
Which of the following options is controlled through the Page Setup command in Excel?
1. Margins
2. Orientation (portrait or landscape)
3. Headers and footers
4. All of the above
Which of the following is a valid Excel formula?
1. =C4*D4
2. B4*D4
3. Both =C4*D4 and B4*D4
4. Neither =C4*D4 nor B4*D4
The function =AVERAGE(A6:A8) is the equivalent of the formula
1. A6+A7+A8/3
2. =(A6+A7+A8/3)
3. =(A6+A7+A8)/3
4. =(A6+A8)/2
Which of the following is a valid cell range?
1. B6
2. A2:A3
3. C4:G9
4. All of the above
Which of the following formats will display a number with a dollar sign ($1234.56)?
1. Accounting format
2. Currency format
3. Both Accounting and Currency formats
4. Neither Accounting nor Currency format

Answer True or False for the following statements

	True	False
9. Excel cell references refer to the row by letter and the column by number.
10. All Excel formulae must be preceded by the equal sign (=).
11. An Excel worksheet may contain several workbooks.
12. A Function is a built-in mathematical formula.
13. If your worksheet is one column too wide, you have no choice but to print it on two pages.
14. A cell range may be as small as a single cell or as large as the entire worksheet.