Excel Skills: Charts and Functions Quiz
Authored by E Inglis
Business
11th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is the correct term for the horizontal arrangements of cells in Microsoft Excel?
Columns
Rows
Sheets
Tables
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In Microsoft Excel, which function is used to quickly add up a range of numbers?
AUTOSUM
AUTOFILL
AUTOCALC
AUTOFIT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart type is best suited to show the proportion of different categories in a whole?
Line chart
Pie chart
Scatter chart
Area chart
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to compare the values of different categories side by side, which chart should you use in Excel?
Pie chart
Bar chart
Line chart
Doughnut chart
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
13
40
35
45
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used for division in Excel formulas?
+
*
/
^
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Multiplies the values in cells A1 to A5
Adds the values in cells A1 to A5
Divides the values in cells A1 to A5
Subtracts the values in cells A1 to A5
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 Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
