NEW
Font size
WorksheetsSpreadSheets
Total questions: 60
Worksheet time: 42mins
To select a block of cells, hold down the ________ key or drag.
Shift
Command
Option
Delete
Filtering in a spreadsheet hides the data you do not want to see.
True
False
When you want to apply total sales in dollars to a cell which number format would you choose?
Percentage
Date
Currency
What does it mean to merge cells?
apply a border around a set of cells
center the text content in the center of the cell
combine cells into a single cell
split a single cell into multiple cells
Which of the following functions returns the largest number from the range of cells?
SUM
AVERAGE
MIN
MAX
What set of data is in descending order?
4, 3, 1, 2
7/1/2017, 6/2/2017, 5/3/2018, 4/2/2016
grapes, pineapples, bananas, oranges
sheep, rabbits, ponies, ostriches
Where would you click on the Tool bar to add a border around a cell?
A
B
C
D
E
What function should be entered into B7 to calculate the total budget?
=CALCULATE(B3:B6)
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
Where would you click to select a row?
A
B
C
D
Where is the Formula Bar?
A
B
C
D
Which formula contains a cell reference?
“=F6/3”
“=10+13”
“=21-6”
“=G10”
A cell has a very long formula that you must edit. What would be the best way to edit the formula.
“Select the cell and edit the formula in the Formula Bar.”
“Double-click on the cell and edit the formula in the cell.”
Which function would return the number 45.1?
“=MIN(A2:B5)”
“=AVERAGE(A2:B5)”
“=MAX(A2:B5)”
“=SUM(A2:B5)”
What number would the function =COUNT(A2:A7) return?
“=3”
“=4”
“=5”
“=6”
Define the following operator: /
“Division”
“Addition”
“Subtraction”
“Multiplication”
What does this formula do : =COUNTIF(B2:B15, “<10”)
Displays number of values from B2 to B15
Displays the total for values less than 10
Display how many values are less than 10
Displays values that are equal to 10
What does the function =AVERAGE(B2:B10) calculate?
The sum of values in cells B2 to B10
The maximum value in cells B2 to B10
The average of values in cells B2 to B10
The minimum value in cells B2 to B10
Which function should be used to count the number of cells in a range that meet a specific condition?
COUNT
SUM
AVERAGE
COUNTIF
What is the purpose of the function =MAX(C2:C15)?
To find the average of values in cells C2 to C15
To find the highest value in cells C2 to C15
To find the minimum value in cells C2 to C15
To find the sum of values in cells C2 to C15
What function would you use to count the number of cells that contain numbers in a range?
AVERAGE
SUM
COUNTA
COUNT
What does the formula =IF(A1>10, "Yes", "No") do?
Checks if A1 is equal to 10
Calculates the sum of A1 and 10
Returns 'No' if A1 is greater than 10, otherwise returns 'Yes'
Returns 'Yes' if A1 is greater than 10, otherwise returns 'No'
Which formula would correctly calculate the total of cells B1 through B5?
=B1+B2+B3+B4+B5
=TOTAL(B1:B5)
=SUM(B1:B5)
=ADD(B1:B5)
What does the formula =IF(B2<100, "Under Budget", "Over Budget") do?
Checks if B2 is less than 100 and returns 'Under Budget' or 'Over Budget'
Calculates the difference between B2 and 100
Returns 'Over Budget' if B2 is less than 100
Returns 'Under Budget' if B2 is greater than 100
What does the formula =IF(C3="Yes", "Approved", "Denied") do?
Returns 'Approved' if C3 is not equal to 'Yes'
Returns 'Denied' if C3 is equal to 'Yes'
Calculates the total of C3
Checks if C3 is equal to 'Yes' and returns 'Approved' or 'Denied'
What does the formula =COUNTIF(A1:A10, "Yes") do?
Counts all cells in A1:A10
Counts cells in A1:A10 that contain 'Yes'
Counts cells in A1:A10 that are empty
Counts unique values in A1:A10
What is the result of the formula =IF(D1="No", "Rejected", "Accepted")?
Returns 'Accepted' if D1 is 'No'
Returns 'No' if D1 is 'Yes'
Returns 'Rejected' if D1 is 'No'
Returns 'Yes' if D1 is 'No'
Which function would you use to find the total number of entries in a range?
AVERAGE
COUNT
MAX
SUM
What does the formula =SUMIF(A1:A10, ">=50", B1:B10) do?
Calculates the total of A1:A10 if they are greater than or equal to 50
Returns the average of B1:B10 if A1:A10 is greater than or equal to 50
Counts the number of cells in A1:A10 that are greater than or equal to 50
Calculates the sum of all values in B1:B10 where the corresponding A1:A10 values are greater than or equal to 50
Which function would you use to find the highest value in a range of cells?
MAX
COUNT
MIN
AVERAGE
What does the function =IF(A1>100, "High", "Low") do?
Returns 'High' if A1 is greater than 100
Returns 'Low' if A1 is greater than 100
Calculates the total of A1
Checks if A1 is equal to 100 and returns 'High' or 'Low'
Which of the following is a practical real-world use of spreadsheets?
Writing a novel
Tracking business expenses and income
Editing videos
Designing logos
A business buys products for £20 each (cell A2) and sells them for £35 (cell B2).
Which formula calculates the profit per item?
=A2+B2
=B2-A2
=A2-B2
=B2/A2
If a company sells 50 items (cell C2) and profit per item is in D2, which formula calculates total profit?
=C2+D2
=C2-D2
=C2*D2
=SUM(C2:D2)
A business must pay 10% tax on profit (profit in E2).
Which formula calculates the tax amount?
=E2+10%
=E2*10%
=E2-10%
=10/E2
If tax amount is in F2 and profit is in E2, which formula calculates profit after tax?
=E2+F2
=F2-E2
=E2-F2
=E2*F2
A shop wants to know if they made more than £1000 profit.
Which formula would check this?
=IF(E2>1000,"Good","Bad")
=E2+1000
=COUNT(E2)
=SUM(E2,1000)
A school is tracking student attendance percentages.
Which function would calculate the average attendance?
COUNT
SUMIF
MAX
AVERAGE
A business wants to highlight any losses (negative numbers).
Which feature should they use?
Sorting
Filtering
Conditional formatting
Merge cells
A business increases prices by 5%.
If the original price is in cell A2, which formula gives the new price?
=A25%
=A2+5
=A2*1.05
=A2-5%
If a product costs £80 and VAT is 20%, what formula calculates the total price including VAT?
=80*0.2
=80+0.2
=80*1.2
=80-0.2
A company wants to count how many products sold more than 100 units. Which function should they use?
=COUNT(A2:A20)
=COUNTIF(A2:A20,">100")
=SUM(A2:A20)
=MAX(A2:A20)
A budget spreadsheet shows expenses in column B and income in column C. Which formula calculates net profit?
=B2+C2
=C2-B2
=B2-C2
=SUM(B2:C2)
A manager wants to see only sales from January. Which tool should they use?
Sort
Filter
Merge
Freeze
Why do businesses use spreadsheets instead of calculators?
They look better
They automatically update when data changes
hey are harder to use
They have more colours
A gym tracks monthly membership payments. Which function would calculate total monthly income? (PAYMENTS ARE B2-B20)
=SUM(B2:B20)
=COUNT(B2:B20)
=MIN(B2:B20)
=IF(B2>0)
If cell A2 contains 200 units sold and B2 contains £15 per unit, which formula calculates total revenue?
=SUM(A2:B2)
=A2+B2
=A2*B2
=A2-B2
A business wants to check if stock levels fall below 10 items. Which formula would work?
=IF(A2<10,"Reorder","OK")
=A2+10
=COUNT(A2)
=SUM(A2)
A company wants to compare monthly sales visually. Which chart would be most suitable?
Pie chart
Bar chart
Scatter chart
Line chart
If expenses are £400 and revenue is £1000, what formula calculates profit?
=1000-400
=1000+400
=400-1000
=1000/400
Why is it important to use formulas instead of typing answers manually?
It looks more professional
It saves electricity
It automatically updates when values change
It makes the sheet colourful
