1.5.3 Progressive 1

1. To select multiple non-adjacent cells in a worksheet, click on the cells whilst holding the

• ALT KEY
• CTRL KEY
• SHIFT KEY
• CTRL + ALT KEY

2. Which of the following displays the content of an active cell in a worksheet?

• Formula Bar
• Menu Bar
• Name Box
• Status Bar

3. A cell formatted to have an accounting style shows negative numbers in

• bold
• brackets
• double quotes
• parentheses

4. The process of identify specific rows and columns so that these rows and columns are always visible on the screen is

• fixing
• freezing
• locking
• selecting

5. To select multiple non-adjacent cells in a worksheet, click on the cells while holding down the

• ALT KEY
• CTRL KEY
• CTRL + ALT KEY
• SHIFT KEY

6. Which of the following displays the contents of an active cell in workbook?

• Formula bar
• Menu bar
• Name box
• Status bar

7. The process of identifying specific rows and columns so that these rows and columns are always visible on the screen is called

• fixing
• freezing
• looking
• selecting

8. In a spreadsheet, which of the following is a text function?

• COUNT()
• DMAX()
• ROUND()
• UPPER()

9. A red triangle at the top right comer of a cell in a spreadsheet program indicates that

• the value in the cell is incorrect
• the cell cannot accept formula
• there is a comment associated with the cell
• the formula entered into the cell has an error

10. Which of the following displays the contents of an active cell in a worksheet?

• Name box
• Menu bar
• Formula bar
• Status bar