## What does this formula do? =Sum(Sheet1:Sheet4!D18)What does this formula do? =Sum(Sheet1:Sheet4!D18)

It adds data from cell D18 of Sheet1 and cell D18 of Sheet4  It adds data from cell A1 of[...]

## Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?

Value Formatting  Cell Style Formatting  Conditional Formatting  Tabular format[...]

## Which format setting does not change the background appearance of a cell?Which format setting does not change the background appearance of a cell?

Fill color Font Color Pattern Style Cell Style[...]

## Which of these functions returns the largest value within the range H2:H30?Which of these functions returns the largest value within the range H2:H30?

=MAXIMUM (H2:H30)  =MAX(H2:H30)  =LARGE (H2:H30, 29)  =UPPER(H2:H30,1)[...]

## For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

OR(B3=>15,B3<=20)  AND (B3>=15,B3<=20)  OR(B3>15,B3<20)  AND(B3>15, B3<20)[...]

4  1  5  3[...]

## Of these four chart types, which works best for summarizing time-based data?Of these four chart types, which works best for summarizing time-based data?

pie chart  XY scatter chart  bar chart  line chart[...]

## You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?You need to determine the commission earned by each Sales Rep, based on the Sales amounts in B3:B50 and the Commission rate specified in cell A1. You want to enter a formula in C3 and copy it down to C50. Which formula should you use?

A                              [...]

:  =  (  *[...]

## Which format setting does not change the background appearance of a cell?Which format setting does not change the background appearance of a cell?

Cell style  Fill color  Pattern style  Font color[...]