EA2 Ch4_WB

Which of the following statements regarding spreadsheets is/are correct?

• Spreadsheets can fill in other cells based on the pattern of selected cells.

• A spreadsheet file can only contain one workbook.

• A spreadsheet file can only contain one worksheet.

The table shows a spreadsheet before and after using a certain function. Which of the following is the function used?

• Filtering

• Freeze panes

• Wrap text

• Column width

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

=AVERAGE ( (4+3) * (7+5), (50/5*2))

• 20

• 51

• 52

• 84

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

=MAX (B1: C2)

• 23

• 43

• 50

• 51

If the value of cell A1 is 57, which of the following is the result of the formula below?

=IF (A1>90, "A", IF (A1>75, "B", IF (A1>50, "C", "F")))

• A

• B

• C

• F

Refer to the spreadsheet.

Which of the following formulas return(s) TRUE?

• =LEN (A3) = LEN (A4)

• =MIN (B2: D2) < MIN(B4:D4)

• =LARGE(B3:D3,2) > LARGE(B5:D5,1)

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

=SUMIF (A1:B3, ">5")

• 13

• 57

• 51

• 91

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

=SUMIF (A1:A4, "B", B1:B4)

• 13

• 47

• 64

• 132

Austin enters the formula below into cell D1 and then copies D1 to E2. =COUNTIF (A1:B2,">25").

Which of the following is the result of cell E2?

• 2

• 3

• 84

• 157

The formula in E2 is "=AVERAGE (A1: B3) ", which of the following is the value of F3 if E2 is copied to F3?

• 23.8

• 27

• 143.5

• 162.4