MGT334 Chp 4: Google Sheets

Which of the following is the default file extension for a Google Sheets document?

• .xlsx

• .gsheet

• .ods

• .xls

How can you freeze the top row in Google Sheets?

• Click "View" and select "Freeze" > "1 row"

• Right-click and select "Freeze"

• Click "Data" and select "Freeze"

• Drag the line between rows 1 and 2

Which formula in Google Sheets is used to calculate the sum of a range of cells?

• =SUM()

• =TOTAL()

• =ADD()

• =SUMIF()

How can you add a new sheet to an existing Google Sheets document?

• Click the " + " icon at the bottom of the screen

• Go to "File" > "New" > "Sheet"

• Right-click any sheet tab and select "Add Sheet"

• Both A and C

What does the formula =A1+B1 do in Google Sheets?

• Adds the values of cells A1 and B1

• Subtracts the values of B1 from A1

• Multiplies the values of A1 and B1

• Divides the value of A1 by B1

Which function in Google Sheets would you use to find the average of a range of numbers?

• =MEAN()

• =AVERAGE()

• =AVG()

• =SUM()

What is the purpose of the =IF() function in Google Sheets?

• To check if a condition is true or false and return a result based on that condition

• To perform a logical comparison

• To filter data based on specific conditions

• Both A and B

Which of these is a correct way to reference a cell in another sheet in the same Google Sheets document?

• =Sheet2!A1

• =A1:Sheet2

• =Sheet2(A1)

• =A1:Sheet2!A1

How can you change the color of text in a cell?

• Use the "Fill color" tool in the toolbar

• Use the "Text color" tool in the toolbar

• Right-click the cell and select "Text color"

• Both B and C

What is the function of the Google Sheets 'Explore' tool?

• To calculate averages of data

• To suggest formulas and insights based on your data

• To sort data alphabetically

• To automatically format cells