COMPUTER QUIZ FOR CLERK - III

1. You can quickly change the appearance of your work by choosing Auto Format from the …. Menu

(1) Edit

(2) View

(3) Format

(4) Tools 

2. To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu

(1) Edit

(2) Format

(3) Tools

(4) Data 

3. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.

(1 Edit

(2) Insert

(3) Format

(4) Tools 

4. you can use the formula palette to 

(1) format cells containing

numbers

(2) create and edit formulas

containing functions

(3) entered assumptions data

(4) copy a range of cells 

5. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data changed

(1) Format Report

(2) Pivot Table

(3) Refresh Data

(4) Show Detail 

6. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

(1) Formula

(2) Field

(3) Data

(4) Query Correct Answer 

7. “Qtr 1, Qtr 2, Qtr 3” is an example of a

(1) Formula

(2) Function

(3) Series

(4) Syntax 

8. You can edit existing Excel data by pressing the

(1) F1 key

(2) F2 key

(3) F3 key

(4) F4 key 

9. 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 ….

(1) G1-G10

(2) B1.G10

(3) B1:G10

(4) B1:G10 

10. Which of the following is not a worksheet design criterion?

(1) Efficiency

(2) Auditability

(3) Description

(4) Clarity 

ANSWERS:

1. 3

2. 3

3. 4

4. 2

5. 3

6. 1

7. 3

8. 2

9. 4

10. 3