First Quarter Test Review - AQR

Front

What is the name of this cell? Options: B10, 5B, B5, you cannot know the name from this picture

Back

B5

Front

Select ___________________ from the functions menu to find the smallest value in a group.

Back

min

Front

A group of cells is called a ____________. Options: cell range, multicell, cell cluster, chart

Back

cell range

Front

Which of the following features allows you to narrow down the data in your worksheet? merge cells, sorting, filters, relative cell references

Back

filters

Front

According to the order of operations, which calculation comes first in the following formula? =3^2+(12-3)

Back

12-3

Front

What formula would be used in cell B14 to add up the total number of miles the person biked in a month? Options: =(B2+B10), =SUM(B2:B10), =SUM(B2+B10), =(B2*B10)

Back

=SUM(B2:B10)

Front

If I want to add a Chart, one way is to select the ____________ tab.

Back

Insert

Front

Which function can be used to find the highest score among Azaria, Camille, and Roderick's basketball game scores? Options: MAX, SUM, AVERAGE, MIN

Back

MAX

Front

Amari, Alyeriah, and Jamoree participated in a school sprint event. They each had their race times recorded in seconds. Which function can Amari use to determine who was the fastest runner among them?

Back

MIN

Front

What formula should Zavian, Joshua, and Camille use to calculate their average monthly expenses from their past expenditure data in Google Sheets? Options: =MEDIAN(range), =SUM(range)/COUNT(range), =MODE(range), =AVERAGE(range)

Back

=AVERAGE(range)