EA2 Ch4 Quiz (General)

Which of the following statements is/are correct?

• The number format of a cell can be defined after storing data.

• The text alignment of a cell cannot be changed.

• Every row must share the same row height.

• None of the above

Which of the following formulae return the same result?

• =INT (ABS (-1.5))

• =INT (RAND () ) +1

• =LEN (9)

Which of the following charts should be used to display the data on the left?

• Bar chart

• Line chart

• Pie chart

• None of the above

Assume the cell value of A1 is 8. Which of the following is the result of the formula below? = ((A1+4)/2-6/3)*5+7

• 3

• 27

• 47

• 48

It shows a spreadsheet before and after using a certain function.

What is the function used?

• Filtering

• Sorting

• Merge cells

• Wrap text

Refer to the following spreadsheet and answer question 6 and 7. The formula of cell E10 and F10 are =VLOOKUP (201, A2: D4, 3) and =VLOOKUP (202, A2: D4, 4) respectively. Which of the following is the result of the formula below?

=IF(E10>F10, E10 - F10, F10 - E10)

• -0.5

• 0.5

• 10

• 44.5

Which of the following formulae return(s) TRUE?

• =C2*D2>C3*D3

• =MID (B2, FIND ("_", B2) +1, 6) = MID (B3, FIND ("_", B3), 6) AND (C4>C2, C4>C3, C2>C3)

• None of the above

Which of the following is the result of the formula below?

=IF (OR (A1-B1, C1=D1), 1, 2) * IF (AND (A2>=B2, C2<=D2), 1, 3)

• 1

• 2

• 3

• 6

Sam enters the formula below into cell E1, then copies E1 to F2:

=SUM (A1: B2)

Which of the following will be shown on cell F2?

• 91

• 93

• 100

• 105

Ada enters the formula below into cell A10, then copies A10 to B10:

=IF (A$1<$B1, Al&B1, B1&A1)

Which of the following will be shown on cell B10?

• 1113

• -113

• 13-1

• An error occurs