Office T&T

True or False: By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.

• True

• False

Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades in red. Which of the following is a fast way for her to do this?

• Page layout

• Conditional formatting

• Quick formatting

• Cell alignment

True or False: Sparklines are tiny charts that fit into one cell.

• True

• False

Which orientation is best for displaying a wide chart?

• Letter

• Flyer

• Landscape

• Portrait

While reviewing her worksheet, Megan noticed she had made a mistake in several places and used the color name burgundy when she should have used maroon. Which feature will allow her to correct her mistake the fastest?

• Sort and Replace

• Search and Find

• Sort and Format

• Find and Replace

Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?

• =(C3+C5+C9)

• =SUM(C2:C10)

• =(C3+C5+C9)

Which of these formulas will add three cells and then divide the sum by 4?

• =A1+A2+A3^4

• =(A1+A2+A3)/4

• (A1+A2) + A3/4

• A1+A2+A3/4

Minh wanted to find the average of all of her grades, but she cannot get her function to work. Her spreadsheet is below. What error is she making in cell C11?

• The colon should be replaced with a dash (-)

• She has the wrong function name

• She has incorrect arguments

• She is missing an equals sign at the beginning of her formula

Which of the following Counts the number of cells that are not empty in a range

• IF function

• IFS function

• COUNT function

• COUNTA function

What tab do you go to to start a MAIL Merge

• The Insert Tab

• The Merging Tab

• You do not go to a tab

• The Mailings Tab