Excel Functions and Formatting Quiz

What is the formula to add cell A2 and B2?

• =SUM(A2, B2)

• =A2 + B2

• =ADD(A2:B2)

Change the font color of cell A5 to red.

• Home > Font Color > Red

• Format > Font Color > Red

• Font > Color > Red

What function should you use to find the highest number in a range of cells?

• =MAX()

• =LARGEST()

• =HIGH()

Create a bar chart using data from cells A12 to B15.

• Insert > Bar Chart

• Chart > Bar Chart

• Home > Bar Chart

Data Sorting and Filtering: Sort column F in descending order.

• Data > Sort > Descending

• Home > Sort > Descending

• Sort > Descending

Calculate the average of cells D6 to D10.

• =AVERAGE(D6:D10)

• =MEAN(D6:D10)

• =AVG(D6:D10)

Add a title to your chart: "Grade 5 Test Scores."

• Chart > Title > "Grade 5 Test Scores"

• Design > Chart Title > "Grade 5 Test Scores"

• Format > Title > "Grade 5 Test Scores"

Filter column G to display only values greater than 50.

• Data > Filter > Greater Than > 50

• Home > Filter > Greater Than > 50

• Filter > Greater Than > 50

Use a function to count the number of cells that contain text in range E6 to E10.

• =COUNTA(E6:E10)

• =COUNTIF(E6:E10, "text")

• =TEXTCOUNT(E6:E10)

Save your document as "Grade5_Test_[YourName]".

• File > Save As > "Grade5_Test_[YourName]"

• Save > Save As > "Grade5_Test_[YourName]"

• Home > Save As > "Grade5_Test_[YourName]"