Font size
WorksheetsExcel Summative Test
Total questions: 30
Worksheet time: 40mins
Which of the following is used to create a visual representation of data in Excel?
Formula
Chart
Cell
Worksheet
What function would you use to find the average of a range of cells in Excel?
SUM
AVERAGE
MEDIAN
COUNT
Which of the following is NOT a type of chart available in Excel?
Bar Chart
Line Chart
Pie Chart
Apple Chart
What is the purpose of the VLOOKUP function in Excel?
To sort data
To find a value in a table based on a lookup value
To calculate the sum of a range
To format cells
Which feature in Excel allows you to automatically fill cells with a series of data?
AutoSum
AutoFill
Flash Fill
Data Validation
What symbol must a formula in Excel always start with?
+
@
=
#
Which of the following is the correct formula to add the values in cells A1 and B1?
=A1+B1
=A1-B1
=A1*B1
=A1/B1
What function would you use to find the maximum value in a range of cells?
MIN
MAX
SUM
AVERAGE
Which of the following formulas correctly calculates the average of the values in cells A1 through A10?
=SUM(A1:A10)/10
=AVERAGE(A1:A10)
=MEAN(A1:A10)
=AVG(A1:A10)
What does the formula =IF(A1>10, “Yes”, “No”) do?
It checks if A1 is greater than 10 and returns “Yes” if true, otherwise “No”.
It adds 10 to the value in A1.
It multiplies the value in A1 by 10.
It subtracts 10 from the value in A1.
Excel can only handle numerical data.
The SUM function in Excel is used to add up a range of cells.
You can create a pivot table in Excel to summarize large amounts of data.
Conditional formatting in Excel allows you to apply formatting based on specific criteria.
Excel does not support the use of macros for automating tasks.
Formulas in Excel can only perform basic arithmetic operations.
The SUM function in Excel adds all the numbers in a range of cells.
You can use cell references in formulas to make them dynamic and update automatically when the data changes.
The formula =A1+A2 is an example of a relative reference.
Excel does not support the use of logical functions like IF.
alm four
(a)
buns rem
(a)
Agra eve
(a)
agent crepe
(a)
eighths
(a)
able paths
(a)
orsw
(a)
aero piston
(a)
ellsc
(a)
stable
(a)
