Google Sheets Vocab Quiz

What does an Absolute Cell Reference in Google Sheets ensure?

• It ensures that the cell reference automatically adjusts when copied to another cell.

• It keeps a row and/or column constant in the formula when copying or filling cells.

• It calculates the average of the values included in the argument.

• It merges two or more cells into one large cell.

What is the purpose of the AVERAGE function in Google Sheets?

• It displays the highest cell value included in the argument.

• It saves time by repeating the same kind of calculation across multiple rows or columns.

• It finds the average of the values included in the argument by calculating the sum and then dividing the sum by the number of cells.

• It sorts the data in the spreadsheet.

What is a Cell in Google Sheets?

• A group of cells that run vertically from top to bottom.

• A set of rules for evaluating an expression involving more than one operation.

• Each rectangle in a spreadsheet that is called a cell, being the intersection of a row and a column.

• A small tab at the bottom of a worksheet that allows movement between worksheets.

What does the COUNT function do in Google Sheets?

• It filters data to display only the data that interests you.

• It displays the formula bar to enter and edit data, functions and formulas.

• It displays the number of cells that have been included in the argument.

• It wraps text within the cell to modify a cell's row height.

What is the result of using the MAX function in Google Sheets?

• It calculates the sum of the cells and divides the sum by the number of cells.

• It displays the highest cell value included in the argument.

• It allows for changing or customizing the order of the spreadsheet data.

• It adds all the values of the selected cells in the argument.

What is the purpose of the MIN function in Google Sheets?

• It allows you to merge adjacent cells into one larger cell.

• It displays the lowest cell value included in the argument.

• It applies filters to improve the performance of your worksheet.

• It changes or customizes the order of your spreadsheet data.

What does the SUM function do in Google Sheets?

• It merges cells together.

• It sorts the data in the spreadsheet.

• It wraps text within the cell.

• It adds all the values of the selected cells in the argument.

What is the effect of using Wrap Text in Google Sheets?

• It merges cells together.

• It sorts the data in the spreadsheet.

• It automatically adjusts the row height to display multiple lines of text within a cell.

• It adds all the values of the selected cells in the argument.

What function would you use in Google Sheets to count the number of cells that contain numbers?

• COUNTA

• SUM

• COUNT

• AVERAGE

How can you freeze rows in Google Sheets to keep them visible while scrolling?

• Use the MAX function

• Apply conditional formatting

• Select 'Freeze' from the View menu

• Insert a new column