NEW
Font size
WorksheetsGoogle Sheets Quiz - 17/09/2024
Total questions: 20
Worksheet time: 20mins
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
What does the following formula do in GS: =SUM(A1:A10)?
It adds the values from cells A1 to A10
It subtracts the values from cells A1 to A10
It multiplies the values
It copies the values to a new sheet
In Google Sheets, what is the purpose of the function =AVERAGE(B1:B5)?
It calculates the sum of values
It finds the middle value of the range
It calculates the average of the values in B1 to B5
It multiplies all values
Which of the following would result in a 'circular dependency error' in GS?
A formula that refers to its own cell
A formula that uses two different sheets
A formula that contains a function like SUM
A formula with multiple operators
What is the role of parentheses in the formula =SUM((A1:A5), B1)?
To multiply the values
To determine which ranges or cells to sum first
To reference an external sheet
To subtract the values in A1 to A5 from B1
What happens when you change the locale in the location settings?
It changes the language of the sheet
It changes the currency and date formats
It adds more columns
It deletes your data
How do you combine multiple ranges for a sum in Google Sheets?
Use the SUMIF function
Use a comma between the ranges, e.g., =SUM(A1:A5, B1:B5)
Use a plus sign, e.g., =SUM(A1:A5 + B1:B5)
Use parentheses around the ranges
How do you lock a formula cell reference to make it absolute?
Use the F1 key
Add a dollar sign before the column and row reference, e.g., $B$2
Type the cell reference in capital letters
Press ALT + L
What is the effect of using parentheses in formulas involving multiple operators, such as =5 + (3 * 2)?
The formula will calculate from left to right
The parentheses force multiplication to be calculated first
The formula will give an error
The addition happens first
Which of these is something you cannot do with Google Sheets formulas?
Create a relative reference
Combine absolute and relative references in a single formula
Use the SUM function inside an IF statement
Use a formula to format cells automatically
How can you create a function that works both as an absolute and a relative reference in a single Google Sheets formula?
By mixing references, like $A1 or A$1
By using only absolute references
By using only relative references
This is impossible, you can't mix reference types
