Google Sheets Quiz

Serenity, Camille, and Janiya are collaborating on a budget report using Google Sheets for their economics class. To enhance the readability of their shared document, they need to combine several cells. What steps should they follow to merge these cells?

• Go to the 'Format' menu and select 'Merge cells'

• Press the 'Ctrl' key and click on the cells to be merged

• Click on the 'Merge cells' button in the toolbar

• Right-click on the selected cells and choose 'Merge cells'

Garrard and Xavier are working together on a school project to create a budget spreadsheet in Google Sheets for their school's annual sports event. What is the purpose of the cell reference in a formula they use in their spreadsheet?

• To determine the order of operations in the formula

• To identify the formatting of the cells in the formula

• To exclude certain cells from the budget calculations for specific sports

• To specify which cells the formula should use for calculations related to different sports

Takari is organizing a budget in Google Sheets for a school project. What are the cells that Takari is using to enter and manipulate data?

• Individual circular boxes where you can enter and manipulate data

• Individual square boxes where you can enter and manipulate data

• Individual triangular boxes where you can enter and manipulate data

• Individual rectangular boxes where you can enter and manipulate data

Chasity and Xavier are tracking their weekly hours spent on their gardening project in Google Sheets. How would Chasity find the difference in hours spent between two weeks?

• Subtraction formula

• Addition formula

• Multiplication formula

• Division formula

Camille has a list of monthly sales figures for her homemade candle business in Google Sheets and wants to calculate the total product of these figures. How should she do this?

• Use the SUM function

• Use the MAX function

• Use MULTIPLY function

• Use the AVERAGE function

Jamiracle, Reynard, and Jasmine are collaborating on a market research project where they have to evaluate customer feedback. They need to count the number of feedback entries that contain text. Which function should they use?

• SUM

• AVERAGE

• COUNTA

• COUNT

Zavian, Joshua, and Camille are planning a budget for their college expenses. They want to calculate their average monthly expenses from their past expenditure data in Google Sheets. What formula should they use?

• =MEDIAN(range)

• =SUM(range)/COUNT(range)

• =MODE(range)

• =AVERAGE(range)

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?

• MAX

• MIN

• SUM

• AVERAGE

Azaria, Camille, and Roderick are comparing their scores in multiple basketball games. Which function can be used to find the highest score among their game scores?

• MAX

• SUM

• AVERAGE

• MIN

Jordan is working on a budget spreadsheet for a school project. How can Zavian use functions to make his task easier?

• Functions in spreadsheets can be used to perform calculations, summarize expenses, and automate repetitive tasks.

• Functions in spreadsheets are not useful for budgeting and should be avoided by Zavian.

• Functions in spreadsheets are only used by Jamiracle for formatting the budget report.

• Saniya uses functions in spreadsheets exclusively to create charts and graphs for the economics class.