Google Sheets™ Common Spreadsheet Tasks Quiz

What are cells in Google Sheets™?

• A type of function

• Intersection of a column and a row

• A type of data

• A type of formatting

How are cell references named in Google Sheets™?

• By specifying the address or location of a cell

• By using a specific data type

• By using a specific formula

• By using a specific function

What is the purpose of AutoComplete in Google Sheets™?

• To finish an entry based on previous entries made in the column

• To apply color to the background of a cell

• To format text to fit in a single cell

• To arrange the data horizontally or vertically within the cell

How can data be formatted to meet a user's needs in Google Sheets™?

• By using a specific formula

• By using a specific function

• By formatting the text, fill color, borders, merging cells, alignment, text wrapping, and size

• By using a specific data type

What does the Freeze feature do in Google Sheets™?

• Keeps column or row titles visible while scrolling to see more data

• Applies pre-made spreadsheet styles

• Filters data based on specified criteria

• Inserts headers and footers

How can a user insert a new sheet in Google Sheets™?

• By selecting the Format menu and choosing the Theme option

• By right-clicking and choosing an Insert location option

• By selecting the Insert menu and choosing the Sheet option

• By clicking on the Add Sheet button

What is the purpose of the Move command in Google Sheets™?

• To format text to fit in a single cell

• To move a column or row to a different location in the spreadsheet

• To apply color to the background of a cell

• To arrange the data horizontally or vertically within the cell

How can a user copy a sheet to a new or existing spreadsheet in Google Sheets™?

• By clicking on the Filter button on the Shortcut Toolbar

• By selecting the Data menu and choosing the Sort sheet option

• By clicking the sheet tab arrow and choosing Copy to from the menu

• By selecting the Format menu and choosing the Theme option

What does the Clearing a Filter feature do in Google Sheets™?

• Removes any filters and returns the spreadsheet to its original state

• Applies pre-made spreadsheet styles

• Inserts headers and footers

• Filters data based on specified criteria

How can a user delete a sheet in Google Sheets™?

• By clicking the sheet tab arrow and clicking Delete on the menu

• By selecting the Edit menu and choosing the Delete option

• By clicking on the Filter button on the Shortcut Toolbar

• By selecting the Format menu and choosing the Theme option