CISS MID

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

fill-flash

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK.

true

To unprotect a workbook, open the Excel file, then click on Review > Unprotected Sheet, then enter the password for the unprotected sheet and click OK.

true

A student wants to round the number 24.7835 entered in cell A2 to two decimal places. Which of these formulas can she use to do so?

=ROUND(A5,2)

In the formula =A8*$A$1, which of the following describes A8?

Relative cell reference

To enter your name in the lower right corner of a worksheet page, you can _____.

Select the right footer text box and type your name.

In the formula =SUM(A6:A9), which of the following best describes A6?

argument

The Comma Style format adds a comma and a dollar sign to a cell value.

false

To combine multiple cells into one combined cell, which of the following do you use?

merge and center button

After you delete a worksheet column, _____.

the columns to its right shift left