WorksheetsSpreadsheet Formulas Quiz CT5-DAT-02
Total questions: 30
Worksheet time: 25mins
What function in spreadsheets is used to calculate the sum of a range of cells?
=PRODUCT()
=SUM()
=AVERAGE()
=COUNT()
Which function would you use to find the average value in a range of cells?
=MEDIAN()
=MODE()
=AVERAGE()
=SUM()
If you want to find the largest number in a range of cells, which function would you use?
=MIN()
=MAX()
=AVERAGE()
=SUM()
Write the formula that will calculate the highest mark for Stu Gabriel
If E1 contains 15, what is the result?
=IF(E1<10,"Small","Large")
IF
E1<10
Small
Write the formula that will calculate the average mark for Stu Gabriel
Write the formula that will calculate the total marks for Stu Gabriel
Write the formula that will calculate the % for Stu Gabriel
What function returns the current date?
=TODAY()
=NOW()
=CURRENT()
=TIME()
What does the SUM function in Excel do?
Returns the smallest value in a range
Adds up a range of numbers
Finds the average of a range of numbers
Counts the number of cells that meet a specific conditionsums
Which Excel function is used to calculate the average of a range of numbers?
=MAX
=MIN
=AVERAGE
=COUNT
What does the VLOOKUP function do in Excel?
Calculates the square root of a number
Searches for a value in the first column of a table and returns a value in the same row from another column
Extracts a specified number of characters from a text string
Counts the number of cells that meet a specific condition
Which formula checks whether D1 is less than or equal to 20?
=IF(D1<=20,"Yes","No")
=IF(D1>=20,"Yes","No")
=IF(D1=20,"Yes","No")
=IF(D1<>20,"Yes","No")
If B2 contains 42, what is the result of:
=IF(B2>50,"High","Low")
If G1 contains 65, what is the result?
=IF(G1<>50,"Different","Same")
Different
Same
50
What does the formula =SUM(A1:A5) do?
What does the formula =AVERAGE(B2:B6) do?
What symbol is used to start a formula in Excel?
What does =MAX(C1:C10) return?
The largest value in the range C1:C10.
Which of these formulas uses absolute referencing?
What does $ in a formula mean?
Makes the number biger
Makes a cell reference stay the same when copied
What is the purpose of the formula =MIN(D2:D7)?
To calculate the largest value in the range D2 to D7.
To find the smallest value in the range D2 to D7.
Which formula will count how many numbers are in a list?
What will =IF(B2>50, "Pass", "Fail") return if B2 is 45?
50
>50
What does =IF(A1=100, "Perfect", "Try again") do?
What will the formula =A1*$B$1 do?
Multiply A1 with cell B1 and keep B1 fixed
What does =A1/B1 do?
Adds the values in A1 and B1.
Divides the value in A1 by the value in B1.
Which function helps you find the total quickly?
=ADD()
=PLUS()
=COUNT()
=SUM()
If A1 contains 75, what will this formula return?
=IF(A1>=50,"Pass","Fail")
What is the main purpose of the IF function in Excel?
