NEW
Font size
WorksheetsSpreadsheet Functions and Chart Types Quiz
Total questions: 15
Worksheet time: 5mins
Which formula correctly adds up the numbers in cells A1 to A5?
=ADD(A1:A5)
=SUM(A1:A5)
=TOTAL(A1:A5)
=A1+A2+A3+A4+A5
What is the purpose of the AVERAGE function?
To find the middle number in a list.
To find the most common number.
To calculate the sum of a range and divide by the count of numbers in that range.
To count how many numbers are in a list.
Which function would you use to find the highest value in a range of cells?
MIN
HIGH
TOP
MAX
You have a list of students' test scores. Which function would you use to count how many students passed if the pass mark was 50?
COUNT
IF
COUNTIF
SUM
What does the formula =IF(A1>10, "Yes", "No") do?
It checks if A1 contains the word "Yes" or "No".
It puts the word "Yes" in cell A1.
It displays "Yes" if the value in A1 is greater than 10, otherwise it displays "No".
It causes an error because text and numbers are mixed.
Which function would you use to find the lowest value in a list of numbers?
MIN
MAX
LOWEST
BOTTOM
What is the main purpose of the VLOOKUP function?
To look up a value in the top row of a table.
To find a value in the first column of a table and return a corresponding value from another column.
To verify that a lookup table is correct.
To create a vertical list of data.
If you want to count the number of cells in a range that are not empty (including text), which function should you use?
COUNT
COUNTA
COUNTALL
IFEMPTY
What result would the formula =MAX(A1:A4) give for the following data: A1=5, A2=15, A3=8, A4=12?
5
8
15
40
A teacher wants to give students a "Pass" or "Fail" grade based on their score in B2. If a score of 50 or more is a pass, which formula is correct?
=IF(B2>=50, "Fail", "Pass")
=IF(B2<50, "Pass", "Fail")
=IF(B2>=50, "Pass", "Fail")
=IF(B2="Pass", 50, 0)
Which type of chart is best for showing proportions or percentages of a whole?
Bar Chart
Pie Chart
Line Chart
Scatter Plot
A scientist is tracking the temperature every day for a month. Which chart would be best to show this trend over time?
Bar Chart
Pie Chart
Line Chart
Area Chart
What is the name for the horizontal line at the bottom of a bar chart that often shows categories?
Y-axis
X-axis
Legend
Chart Title
You want to compare the final exam scores of 10 different students. Which chart type would be most effective for this comparison?
Bar Chart
Pie Chart
Line Chart
Doughnut Chart
What is the purpose of a chart legend?
To give the chart a main title.
To label the numbers on the vertical axis.
To explain what the different colors or patterns in the chart represent.
To cite the source of the data.
