NEW
Font size
WorksheetsMastering Excel Formulas
Total questions: 20
Worksheet time: 10mins
What formula would you use to add two numbers in Excel?
=A1 * B1
=TOTAL(A1, B1)
=SUM(A1, B1) or =A1 + B1
=ADD(A1, B1)
Which function calculates the total of a range of cells?
COUNT
MAX
SUM
AVERAGE
If you have the numbers 10 and 5, what formula would you use to subtract them in Excel?
=10/5
=SUBTRACT(10, 5)
=10-5
=5-10
What is the correct formula to divide 20 by 4 in Excel?
=20-4
=20/2
=20/4
=4/20
Which operator is used for multiplication in Excel?
*
%
-
/
What function would you use to find the average of a set of numbers in Excel?
MAX
AVERAGE
SUM
COUNT
How do you rank a list of numbers in Excel?
Apply conditional formatting to highlight numbers.
Sort the numbers manually in a column.
Use the RANK function in Excel.
Use the SUM function in Excel.
What is the purpose of the VLOOKUP function in Excel?
To format cells with specific styles.
To calculate the sum of a range of cells.
To search for a value in a table and return a corresponding value from another column.
To create a chart based on selected data.
Which formula would you use to add the values in cells A1 and A2?
=A1 * A2
=SUM(A1,A2)
=A1 - A2
=A1 + A2
If you want to subtract the value in cell B1 from A1, what formula would you use?
=A1-B1
=A1*B1
=A1+B1
=B1-A1
What is the result of the formula =20/5 in Excel?
4
5
2
10
How do you multiply the values in cells C1 and C2?
=C1*C2
=C1/C2
=C1+C2
=C1-C2
What is the formula to calculate the average of cells D1 to D5?
=SUM(D1:D5)
=AVERAGE(D1:D5)
=AVERAGEIF(D1:D5)
=COUNT(D1:D5)
How can you rank the values in a list from highest to lowest in Excel?
Use the 'FILTER' function to isolate values.
Manually rearrange the values in the list.
Use the 'SORT' function or the 'Sort' feature in the Data tab.
Apply conditional formatting to highlight the highest values.
What does the VLOOKUP function require as its first argument?
lookup_value
col_index_num
table_array
range_lookup
Which formula would you use to find the sum of cells E1 through E10?
=ADD(E1:E10)
=TOTAL(E1:E10)
=SUMMATION(E1:E10)
=SUM(E1:E10)
If you want to divide the value in cell F1 by 2, what formula would you use?
=F1*2
=F1/2
=2/F1
=F1-2
What is the result of the formula =A1*A2 if A1 is 3 and A2 is 4?
7
12
15
10
How do you use VLOOKUP to find a value in a table?
Utilize VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup]) to retrieve data.
Use HLOOKUP(lookup_value, table_array, col_index_num) to find a value in a table.
Apply VLOOKUP(lookup_value, col_index_num, table_array, [range_lookup]) for searching values.
Use VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) to find a value in a table.
What formula would you use to subtract 15 from 30 in Excel?
=15-30
=30/15
=30-15
=SUBTRACT(30, 15)
