Google Sheets Quiz - 17/09/2024

Which command lets you undo your last action in GS?

• CTRL + S

• CTRL + Z

• CTRL + C

• CTRL + V

What is the purpose of using parentheses in GS formulas?

• To multiply values

• To organize the order of operations

• To divide values

• To add two numbers

Which operator is used for addition in Google Sheets?

• *

• /

• +

• %

Which key combination can you use to redo an action in GS?

• CTRL + Y

• CTRL + X

• CTRL + R

• CTRL + P

What does a relative reference in a Google Sheet refer to?

• A fixed position

• A reference that changes when copied

• A text-based reference

• A hidden reference

Where would you change the default location settings in Google Sheets?

• File > Export

• Data > Location

• File > Settings > General > Locale

• Edit > Preferences

How do you create an absolute reference in Google Sheets?

• Use dollar signs, e.g., $A$1

• Use parentheses, e.g., (A1)

• Use the & symbol

• Double click the cell

Which of these is a valid arithmetic operator in Google Sheets?

• #

• %

• &

• $

How can you apply a formula to an entire column in GS?

• Double-click the fill handle

• Drag the fill handle manually

• Copy and paste the formula in every cell

• Use the 'Move Cells' option

What is the main difference between relative and absolute references?

• Relative references change when copied; absolute references stay the same

• Absolute references are hidden

• Relative references can’t contain formulas

• There’s no difference between the two