Font size
WorksheetsIntro to Computing Excel
Total questions: 80
Worksheet time: 50mins
What is the correct formula to add the values in cells A1 and A2?
=A1 + A2
=SUM(A1, A2)
=ADD(A1:A2)
=A1:A2
Which function calculates the average of a range of cells, such as B1:B5?
=MEAN(B1:B5)
=AVERAGE(B1:B5)
=AVG(B1:B5)
=SUM(B1:B5)/5
What does the SUM function do in Excel?
Multiplies all numbers in a range
Adds all numbers in a range
Finds the highest value in a range
Counts the number of cells with values
Which formula checks if A1 is greater than 10 and returns "Yes" if true, otherwise "No"?
=IF(A1>10, "Yes", "No")
=IF(A110, "No", "Yes")
In VLOOKUP, what does the last argument (range_lookup) control?
The column to return
Whether to perform an exact or approximate match
The range to search
The value to look up
What is the result of =SUM(A1:A3) if A1=5, A2=10, A3=15?
20
30
25
15
Which formula multiplies the values in cells C1 and D1?
=C1 * D1
=MULT(C1, D1)
=PRODUCT(C1:D1)
=C1 x D1
What does the formula =AVERAGE(10, 20, 30) return?
60
20
30
15
Which formula returns "Pass" if B1 is at least 70, otherwise "Fail"?
=IF(B1>=70, "Pass", "Fail")
=IF(B170, "Fail", "Pass")
What is the correct syntax for a basic VLOOKUP to find a value in A1 from a table in B1:C10?
=VLOOKUP(A1, B1:C10, 2, FALSE)
=VLOOKUP(A1, B1:C10, 1, TRUE)
=VLOOKUP(B1:C10, A1, 2, FALSE)
=VLOOKUP(A1, B1:C10, 2, TRUE)
What does =A1-B1 calculate?
The sum of A1 and B1
The difference between A1 and B1
The product of A1 and B1
The average of A1 and B1
Which function would you use to add all values in a range A1:A10?
=ADD(A1:A10)
=SUM(A1:A10)
=TOTAL(A1:A10)
=PLUS(A1:A10)
What is the result of =IF(A1=100, "Perfect", "Not Perfect") if A1=100?
Not Perfect
Perfect
Error
100
In VLOOKUP, what does the second argument (table_array) represent?
The value to look up
The range containing the lookup and return values
The column number to return
The match type
What is the result of =AVERAGE(A1:A4) if A1=10, A2=20, A3=30, A4=40?
25
100
30
20
Which formula divides the value in A1 by the value in B1?
=A1 / B1
=DIVIDE(A1, B1)
=A1 ÷ B1
=QUOTIENT(A1:B1)
What does =SUM(B1:B5) do if B1:B5 contains 2, 4, 6, 8, 10?
30
20
10
5
Which formula checks if C1 is less than 50 and returns "Low" if true, otherwise "High"?
=IF(C150, "Low", "High")
=IF(C1=50, "Low", "High")
=IF(C1100, "Above", "Below")
returns "Above" if A1 is (a) 100.
In =VLOOKUP(D1, A1:B10, 2, FALSE), the value in D1 is looked up in the (a) column of the range A1:B10.
To subtract cell B1 from cell A1, use the formula: (a)
The formula =SUM(C1:C3) adds the values in cells (a) .
To check if E1 equals 0 and return "Zero" or "Non-Zero", use the formula: ________
The formula =AVERAGE(10, 20, 30, 40) returns (a) .
In =VLOOKUP(A1, B1:C100, 2, TRUE), the TRUE argument allows an (a) match.
What does the formula =COUNT(A1:A10) do?
Counts the total of values in A1:A10
Counts the number of non-empty cells in A1:A10
Counts the unique values in A1:A10
Counts the number of cells in A1:A10
Which formula would you use to find the maximum value in the range B1:B10?
=MAXIMUM(B1:B10)
=MAX(B1:B10)
=HIGHEST(B1:B10)
=B1:B10.MAX()
What is the result of =IF(D1<50, "Fail", "Pass") if D1=45?
Pass
Fail
45
Error
What is the result of =IF(E1>100, "Exceeds", "Within Limits") if E1=90?
Exceeds
Within Limits
90
Error
Which formula would you use to find the minimum value in the range C1:C10?
=MINIMUM(C1:C10)
=C1:C10.MIN()
=MIN(C1:C10)
=LOWEST(C1:C10)
What does the formula =COUNTIF(D1:D10, ">50") do?
Counts cells in D1:D10 that are less than 50
Counts all cells in D1:D10
Counts cells in D1:D10 that are greater than 50
Counts unique values in D1:D10
What is in cell A6?
Monday
Tuesday
Wednesday
Thursday
Which of the following cursor allows you to select a range of cells
Drag to widen or narrow the width of a column.
How would you write a formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
Identify the numbered #4 part of MS Excel window
Column Header
Row Header
Name box
Sheet Tabs
Identify the numbered #5 part of MS Excel window
Column Header
Row Header
Name box
Sheet Tabs
Identify the numbered #6 part of MS Excel window
Formula bar
Ribbon
Sheet tabs
Worksheet Window
If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:
=sum(C2:C11)
=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)
=sum(D2:D11)
$13,442.90
What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen.
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen.
The past cell in a worksheet. It is indicated by a dark border onscreen.
What is a spreadsheet?
An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.
An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.
An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.
An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
When starting a formula what is the first thing you type in the cell?
+
-
%
=
The letters in Excel represent the _______?
columns
rows
data
functions
The numbers in Excel represent the _____?
columns
rows
data
functions
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
Bottom left of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
In Excel, what symbol do you use for division?
x
\
/
*
What cell is red?
A1
C1
C4
C5
What cell is red?
A1
C1
C4
C5
What cell is red?
A1
C1
C4
C5
Which formula returns "Pass" if B1 is at least 70, otherwise "Fail"?
=IF(B1>=70, "Pass", "Fail")
=IF(B1<70, "Pass", "Fail")
=IF(B1=70, "Pass", "Fail")
=IF(B1>70, "Fail", "Pass")
What does =A1-B1 calculate?
The sum of A1 and B1
The difference between A1 and B1
The product of A1 and B1
The average of A1 and B1
Which function would you use to add all values in a range A1:A10?
=ADD(A1:A10)
=SUM(A1:A10)
=TOTAL(A1:A10)
=PLUS(A1:A10)
Which formula divides the value in A1 by the value in B1?
=A1 / B1
=DIVIDE(A1, B1)
=A1 ÷ B1
=QUOTIENT(A1:B1)
To add the values in cells A1 through A5, use the formula: (a)
The formula to calculate the average of cells B1 to B10 is: ________
To multiply cell C1 by 5, the formula is: (a)
The formula =IF(A1>100, "Above", "Below") returns "Above" if A1 is (a) 100.
In =VLOOKUP(D1, A1:B10, 2, FALSE), the value in D1 is looked up in the (a) column of the range A1:B10.
To subtract cell B1 from cell A1, use the formula: (a)
The formula =SUM(C1:C3) adds the values in cells (a) .
The formula =AVERAGE(10, 20, 30, 40) returns (a) .
In a grocery receipt, items cost $5, $3, $4.50 in cells A1:A3. The formula to total them is: (a)
In a customer database, names in A1:A20, emails in B1:B20. To get the email for a name in C1, the VLOOKUP formula is: (a)
For a car loan, principal in K1: $15000, annual rate in K2: 4%, term in years in K3: 3. The formula for simple annual interest is: (a)
A bakery tracks weekly ingredient costs in J1:J3: $50, $75, $100. The formula for average weekly cost is: (a)
A bakery tracks weekly ingredient costs in J1:J3: $50, $75, $100. The formula for average weekly cost is: (a)
In a time-off tracker, if hours requested in I1: 8, formula returns "Approved" if <=8, else "Review": (a)
For a fitness challenge, daily calories burned in H1:H4: 300, 400, 350, 500. The formula to sum total calories burned is: (a)
A delivery company tracks fuel costs: miles driven in G1: 150, cost per mile in G2: $0.75. The formula for total fuel cost is: (a)
For a savings tracker, monthly deposits in C1: $500 and interest rate in C2: 2%. The formula to calculate simple monthly interest is: (a)
