Spreadsheet Objective Questions and Answers - 3

Question: 11

Maximum width of a cell is

(A) 128 characters

(B) 240 characters

(C) 480 characters

(D) 1024 characters

Question: 12

Values, entered in a cell, are always

(A) Centred

(B) Left aligned

(C) Right aligned

(D) Not aligned at all

Question: 13

To create a worksheet, it is

(A) Not important to be knowledgeable about the task to be done

(B) Important to understand a programming language

(C) Important to be knowledgeable about the spreadsheet

(D) Both (a) and (b)

Question: 14

Mixed cell references are useful if

(A) A formula should be interpreted relative to the formula’s current row position but should not be adjusted because of its column position

(B) References to the cells that contain the worksheet’s critical assumptions should not be adjusted

(C) A formula should be interpreted relative to the formula’s current position

(D) None of these

Question: 15

If cell D1 contains 20, cell D2 contains 30, and cell D3 contains the formula +D1+D2, then cell D3 display 50. If cell D1 has its value changed to 12, then cell D3 will now display

(A) +D1+D2

(B) 12

(C) 30

(D) 42