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?
Value Formatting Cell Style Formatting Conditional Formatting Tabular format
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?
=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?
OR(B3=>15,B3<=20) AND (B3>=15,B3<=20) OR(B3>15,B3<20) AND(B3>15, B3<20)
Of these four chart types, which works best for summarizing time-based data?
pie chart XY scatter chart bar chart line chart
Which format setting does not change the background appearance of a cell?
Cell style Fill color Pattern style Font color