Excel Quiz
Authored by Liyana Kamsani
Science
8th Grade
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function in Excel is used to calculate the average of a range of cells?
SUM
AVERAGE
MEDIAN
COUNT
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to add the values in cells A1 and B1?
=A1+B1
=SUM(A1:B1)
=ADD(A1,B1)
=A1*B1
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type is best for showing trends over time?
Pie Chart
Line Chart
Bar Chart
Scatter Plot
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you apply bold formatting to the text in a cell?
Right-click the cell and select "Bold"
Press Ctrl + B
Use the "Bold" button on the Home tab
All of the above
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the highest value in a range of cells?
MIN
MAX
LARGE
HIGHEST
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the VLOOKUP function in Excel?
To look up a value in a vertical table
To look up a value in a horizontal table
To sum a range of cells
To find the average of a range of cells
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which type of chart is best for comparing parts of a whole?
Line Chart
Pie Chart
Column Chart
Area Chart
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
