WorksheetsExcel(Task2,Functions (1,2)
Total questions: 24
Worksheet time: 24mins
Someone is trying to find the average profit amount between January and July, using the formula in cell B9.
What mistake did this person make?
Using parentheses in the formula
Using an incorrect formula
The location of the equals sign
Using the incorrect range
What is the formula in cell B3 doing?
Subtracting inventory costs from the total budget
Subtracting the total budget from inventory costs
Finding the average budget total
Multiplying inventory costs by the total budget
In this example, what information would this formula find:
=MAX(B2:B6)
Average distance
Longest distance
Total distance
Shortest distance
In this example, what's wrong with the formula in cell B5?
It should use division instead of multiplication.
It should use subtraction instead of addition.
Without parentheses, multiplication is performed too early.
Nothing. This formula is correct.
Select the formula that will subtract the inventory costs from the monthly budget.
=B3/B2
=B3-B2
=B3*B2
=B2-B3
Which formula will subtract the inventory costs from the annual budget and then divide by 12?
=(B2-B1)/12
=(B1-B2)/12
=B2-B1/12
=B2-(B1/12)
Which formula would find the fastest time for this running log?
=AVERAGE(B2:B6)
=SUM(B2:B6)
=MIN(B2:B6)
=MAX(B2:B6)
In this example, which formula would find the average time for a 3-mile run?
=AVERAGE(B2,B6)
=AVERAGE(B2:C6)
=AVERAGE(B2:B5)
=AVERAGE(B2:B6)
How would we type 15% as a decimal?
1.5
0.15
0.015
15
Which formula would calculate the price after a 15% discount?
Here's a hint: Because we know we'll get 15% off, you could also say the final cost would be 85% of the original total.
=B5/0.85
=B5*0.85
=B5-0.15
=B5*0.15
Which function could we use to find the total points scored?
COUNTA
SUM
AVERAGE
TOTAL
For calculating the total points scored for Tonya in row 2.What cell range to include in the argument.
A2:G2
B2:F2
B2:F9
B2:B9
Which function could we use to find the highest-scoring game?
MIN
MVP
MAX
BEST
For finding the highest-scoring game for Bella in row 2.What cell range to include in the argument.
B2:F2
B2:F9
2
B2:G2
Which formula would calculate the leftover amount?
=B3-B1*B2
=B3-B1/B2
=B1*B2-B3
=B3+B1*B2
A group of cells is called a ________.
cell cluster
multicell
chart
cell range
Which of the formulas below are valid? Select all that apply.
=A+B+C
=J5+C21/D21
=C8+C7
=1-M2
In the order of operations, which of the following comes first?
Exponential calculations
Operations enclosed in parentheses
Multiplication
Operations involving large numbers
In Excel, the values 75 and 75% are equivalent.
False
True
Which function would you use to add several numeric values?
TOTAL
COUNTA
SUM
AVERAGE
Which function can find the highest value in a cell range?
MAXVALUE
MAX
HIGHEST
TOP
Which formula is an example of finding the smallest number in a range?
=MIN(D3,D6,D10)
=MIN(D3:D13)
=MIN(D3,D6,50,3)
=MIN(B14:B16,D3,4)
All answers are correct.
Using the example in the image below, what will the value or result be using the following formula? =MIN(D3:D12)
25
None of these answers are correct.
28
2
5
Which formula would find the largest number in the range?
=MIN(D3:D12)
None of these answers are correct.
=IF(D3:D12)
=MAX(D3:D12)
(MAX(D3:D12))
