NEW
Font size
WorksheetsGoogle Sheets Midterm Quiz - 21/10/2024
Total questions: 25
Worksheet time: 25mins
Which GS formula would you use to add up values in cells A1 through A10?
=SUM(A1:A10)
=ADD(A1:A10)
=TOTAL(A1:A10)
=SUMIF(A1:A10)
What will happen if you use =A1+A2 in a cell and A1 contains "5" while A2 contains "3"?
It will concatenate the values to "53"
It will add the values to get 8
It will return an error
It will return the value of A2
What does the =IF(A1>10, "High", "Low") function do?
Checks if A1 is less than 10
Returns "High" if A1 is greater than 10, otherwise "Low"
Returns "Low" if A1 is greater than 10
Checks if A1 equals 10
Which of the following is the correct way to multiply values in A1 and A2 in GS?
=A1 x A2
=MULTIPLY(A1, A2)
=A1 * A2
=A1 / A2
What does =SUM(A1:A10)/COUNT(A1:A10) calculate?
The sum of A1 to A10
The median of A1 to A10
The average of A1 to A10
The mode of A1 to A10
What will be the output of =IF(OR(A1>10, AND(B1<5, C1>3)), "Pass", "Fail") if A1 is 8, B1 is 4, and C1 is 4?
Pass
Fail
Error
No output
What will be the result of =IF(A1=10, A1*2, A1+2) if A1 contains 8?
12
16
8
10
How does =COUNTA(A1:A10) function differ from =COUNT(A1:A10)?
COUNTA counts only numbers while COUNT counts all values
COUNTA counts all non-blank cells, while COUNT counts only numbers
Both count only numbers
Both count all cells
What will =IF(AND(A1=10, OR(B1=5,C1=3)), "Match", "No Match") return if A1 is 10, B1 is 4, and C1 is 3?
Match
No Match
Error
10
Which function is used in Google Sheets to check if all arguments are TRUE?
=IF()
=ISALL()
=AND()
=OR()
What will be the result of =IF(AND(A1>5, A110, A1/2, A1*2) return if A1 is 12?
24
6
12
0
In Google Sheets, which feature allows you to copy the formatting of one cell to another cell?
Fill Down
Conditional Formatting
Format Painter
Data Validation
Which function should be used to automatically adjust cell formatting based on specific conditions, like highlighting all values greater than 100?
=IF
=CONDITIONALFORMATTING
Conditional Formatting menu option
=FORMATIF
You want to add all the numbers in cells A1 but only include those greater than 5. Which formula should you use?
=SUM(A1:A10)
=SUMIF(A1:A10, ">5")
=SUMIF(A1:A10, "5")
=SUMIF(A1:A10,"<5")
What will =MEDIAN(A1:A10) calculate in Google Sheets?
The sum of values in A1
The average of values in A1
The middle value of A1 when sorted
The range of values in A1
How does =AVERAGEIFS(A1:A10, B1:B10, ">5") function?
Averages values in A1 that are greater than 5
Averages values in B1 that are greater than 5
Averages values in A1 where corresponding B1 values are greater than 5
Sums values in A1
Which function would you use to determine if a cell contains text in GS?
=IF(A1="TEXT", TRUE, FALSE)
=ISTEXT(A1)
=IF(TEXT(A1))
=ISNUMBER(A1)
Which Google Sheets formula can be used to determine if the formula =AND(A1 > 5, A1 < 10) will return TRUE or FALSE when A1 is 7?
TRUE
FALSE
ERROR
NULL
How would you find out the number of cells that contain numerical values in the range A1?
=COUNTIF(A1:A10, "isnumber")
=COUNTA(A1:A10)
=COUNT(A1:A10)
=SUMIF(A1:A10)
Which of the following is the correct syntax for the SUMIFS function?
=SUMIFS(range, criteria_range, criteria)
=SUMIF(range, criteria, criteria_range)
=SUM(range, criteria)
=SUMIF(range, criteria)
What is the outcome of =IF(OR(A1="Yes", B1="Yes"), "Approved", "Rejected") when A1 contains "No" and B1 contains "Yes"?
Approved
Rejected
Error
NULL
How would you return the number of cells with a value greater than 50 in A1?
=COUNTIF(A1:A10, "50")
=COUNTIF(A1:A10, ">50")
=COUNTIF(A1:A10, ">=50")
=SUMIF(A1:A10, ">50")
Which of the following formulas can be used to round a value in A1 to the nearest integer?
=ROUNDUP(A1)
=ROUNDDOWN(A1)
=ROUND(A1)
=RND(A1)
What is the purpose of the =OR(A1>5, B1 5, A1 < 10) will return TRUE or FALSE when A1 is 7?
TRUE
FALSE
ERROR
NULL
In Google Sheets, which feature allows you to copy the formatting of one cell to another cell?
Fill Down
Conditional Formatting
Format Painter
Data Validation
