Top 100+ Spreadsheet MCQ Questions and Answers 2019-2020 - 3

Question: 11

If a cell’s column width is zero, the cell’s contents is not

(A) Stored in memory

(B) Shown in the display

(C) Both (a) and (b)

(D) None of these

Question: 12

When merging two worksheets

(A) Label and formulas cells are not affected by the incoming value

(B) Empty cells acquire the value of the incoming value

(C) Number cells have their value added to the incoming value, so that the sum of the two values is displayed

(D) All of these

Question: 13

Copy command in a spreadsheet

(A) Copies formulas giving a special treatment in order to handle different types of addresses

(B) Copies only these formulas with addresses of one type

(C) Copies formulas treating them like labels

(D) Never copies formulas

Question: 14

The formula in the cell B5 is +A4+C3. This is copied to cell D8. What will be the formula in D8?

(A) +C7+E6

(B) +C4+E3

(C) +E7+C5

(D) +A4+C3

Question: 15

The formula cell A2 is +B2+C3. On copying this formula to cell C2, the formula in cell C2 will be

(A) +A2+C3

(B) +B2+E3

(C) +D2+C3

(D) +D2+E3