Google Sheets Functions Review

Select ______________ from the functions drop-down menu to add a set of numbers together. 

• average
• count
• max
• sum

What is the name of this cell?

• B10
• 5B
• B5
• you cannot know the name from this picture

Mr. Esker wanted to see how the class did as a whole on the most recent test. Using spreadsheets he used the ______________ function to calculate the classes score as a whole.

• Sum

• Average

• Count

• Max

• Min

Mr. Tone wanted to see which student received the highest score on the last Quizizz. In his spread sheet he used the ______________ function to identify the highest score.Mi

• Sum

• Average

• Count

• Max

• Min

Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.

• Sum

• Average

• Count

• Max

• Min

Mr. Esker is looking over his quiz data again in his spreadsheet. He wanted to know how many students received an 80% on his latest quiz. In his spreadsheet he would use the ___________________ function.

• Sum

• Average

• Count

• Max

• Min

Mr. Tone's favorite baseball team is...

• Chicago White Sox

• Chicago Cubs

• Chicago Bears

• Iowa Hawkeyes

Which of the following is a correctly named cell?

• 8B
• B8
• 8-B
• BB-8

This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 

• Skinny Plus Sign
• Hand
• Arrow
• Fat Plus Sign

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

• max
• min
• sum
• average