Week 2 - Quiz

What is the formula to add values in cells A1, B1, and C1?

• =A1 + B1 - C1

• =A1 - B1 + C1

• =A1 + B1 + C1

• =A1 - B1 - C1

What is the function will achieve the same result of A1+B1+C1?

• =SUM(A1:C1)

• =SUMIF(A1:C1)

• =COUNT(A1:C1)

• =COUNTIF(A1:C1)

Cell E11 contains the formula =SUM(E1:E10). How is the formula adjusted when a new row is inserted above row 5?

• =SUM(E1:E11)

• =SUM(E1:E10)

• =SUM(E1:E12)

• =SUM(E1:E13)

What is the formula to count the number of numeric values in the range A1:A30?

• =SUM(A1:A30)

• =COUNT(A1:A30)

• =COUNTA(A1:A30)

• =SUMIF(A1:A30)

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

• Column Width command

• Center button

• Merge and Center button

• Increase Ident button

Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?

• Icon Sets

• Color Scales

• Data Bars

• Highlight Cells Rules

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

• reverse

• transpose

• fill

• merge

To copy a cell's formatting to another cell, which of the following can you use?

• Format Cells dialog box

• Format Painter

• Quick Analysis Tool

• Format as Table

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

• Delete the conditional formatting rule.

• Edit the conditional formatting rule.

• Format the range in the Font dialog box.

• Format the range as a table.

A _____ is a named operation that replaces the action of an arithmetic expression.

• formula

• chart

• cell reference

• function