Question 1

How can you freeze the first row in Google Sheets?

Accepted Answer

View > Freeze > 1 row

Answer

Format > Freeze > 1 row

Answer

Insert > Freeze > 1 row

Answer

Data > Freeze > 1 row

Question 2

What is the purpose of freezing rows or columns in a spreadsheet?

Accepted Answer

To keep specific rows/columns visible while scrolling

Answer

To highlight cells in a different color

Answer

To merge cells together

Answer

To lock the spreadsheet from editing

Question 3

How do you apply alternating row colors in Google Sheets?

Accepted Answer

Format > Alternating colors

Answer

View > Alternating colors

Answer

Insert > Alternating colors

Answer

Data > Alternating colors

Question 4

What is the advantage of exporting a Google Sheet as a PDF?

Accepted Answer

To preserve the formatting and layout for printing

Answer

To increase the file size

Answer

To convert it into an image format

Answer

To allow others to edit the sheet

Question 5

When setting custom page breaks, what is the main goal?

Accepted Answer

To control how the data is split across pages when printing

Answer

To change the cell format

Answer

To hide specific rows or columns

Answer

To combine multiple sheets into one

Question 6

What happens if you select 'Fit to width' in the print settings?

Accepted Answer

The sheet will be adjusted to fit the width of the paper

Answer

The margins will be removed

Answer

The sheet will be converted to portrait mode

Answer

The sheet will be split into multiple pages

Question 7

How can you include notes in your printed Google Sheets?

Accepted Answer

Enable 'Show notes' in the print settings

Answer

Format > Show notes

Answer

Insert > Notes

Answer

Enable 'Show comments' in the view menu

Question 8

What does the 'Create a filter' option do in Google Sheets?

Accepted Answer

Allows you to sort and filter data in the sheet

Answer

Changes the data format

Answer

Combines multiple cells into one

Answer

Hides specific rows or columns

Question 9

How can you apply conditional formatting to highlight sales above $20,000?

Accepted Answer

Format > Conditional formatting > Greater than > 20000

Answer

Data > Conditional formatting > Greater than > 20000

Answer

View > Conditional formatting > Greater than > 20000

Answer

Insert > Conditional formatting > Greater than > 20000

Question 10

What feature allows you to filter data by cell color in Google Sheets?

Accepted Answer

Filter by color

Answer

Insert by color

Answer

Sort by color

Answer

Format by color

Question 11

How can you quickly see the total sales amount in a column?

Accepted Answer

Use the SUM function

Answer

Use the AVERAGE function

Answer

Use the MAX function

Answer

Use the MIN function

Question 12

What does the MOD function do in Google Sheets?

Accepted Answer

Returns the remainder after dividing two numbers

Answer

Multiplies two numbers

Answer

Subtracts two numbers

Answer

Divides two numbers

Question 13

How can you display hours worked as a duration in Google Sheets?

Accepted Answer

Format the cells as 'Duration'

Answer

Format the cells as 'Number'

Answer

Format the cells as 'Date'

Answer

Format the cells as 'Currency'

Question 14

What should you do if an employee forgets to sign out on a timesheet?

Accepted Answer

Use a formula to check for blank cells and display a reminder

Answer

Assume they worked a full day

Answer

Manually enter a default time

Answer

Leave the cell empty

Question 15

What is the advantage of using an array formula in Google Sheets?

Accepted Answer

It calculates once for all rows, improving performance

Answer

It is easier to read

Answer

It allows for complex text formatting

Answer

It hides the underlying data

Question 16

How can you transpose data from rows to columns in Google Sheets?

Accepted Answer

Use the TRANSPOSE function

Answer

Use the SUM function

Answer

Use the CONCATENATE function

Answer

Use the SPLIT function

Question 17

What is a pivot table used for in Google Sheets?

Accepted Answer

To summarize and analyze large data sets

Answer

To merge cells

Answer

To format cells

Answer

To insert charts

Question 18

How can you add a new column to a pivot table to show the year?

Accepted Answer

Extract the year from the date in the raw data and include it in the pivot table range

Answer

Change the date format in the pivot table

Answer

Use the SUM function in the pivot table

Answer

Add a new row in the pivot table

Question 19

What is the benefit of using slicers in Google Sheets?

Accepted Answer

They provide an interactive way to filter data

Answer

They highlight cells

Answer

They merge cells

Answer

They format cells

Question 20

How can you ensure your pivot table data remains clear and organized?

Accepted Answer

Use filters and sorting options

Answer

Hide columns

Answer

Use bright colors

Answer

Add comments to each cell

Related quizzes

Related quizzes