Computer Awareness Online Test | Ebooks Free Download - 3

Question: 11

Which of the following is not a formula and cannot be entered in a cell?

(A) A1-A2

(B) +A1+A2

(C) +A1*100

(D) –B1*B2

Question: 12

The control panel displays a/an

(A) Window into the spreadsheet

(B) Entry line

(C) Status and help area

(D) Both (a) and (c)

Question: 13

The easiest way to modify slightly a cell that contains a long label is to

(A) Use an erase command to erase the cell and start over

(B) Retype the correct entry

(C) Use an edit command to edit the cell

(D) None of these

Question: 14

To keep a portion of the worksheet fixed in place regardless a how the rest of the worksheet is moved, use

(A) PROTECT command

(B) WINDOW command

(C) FIX command

(D) TITLE command

Question: 15

Column-oriented recalculation will evaluate a formula in cell C3 before evaluating a formula in

(A) Cell A2

(B) Cell B5

(C) Cell E3

(D) Both (a) and (c)