Mastering Excel: Skills for Success
Authored by Simon O'Connell
Information Technology (IT)
8th Grade
Used 2+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a correct formula to add the values in cells A1 and A2 in Excel?
`=A1 + A2`
`=ADD(A1, A2)`
`=SUM(A1, A2)`
`=TOTAL(A1, A2)`
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to find the average of the numbers in cells B1 through B10?
`=AVERAGE(B1:B10)`
`=MEAN(B1:B10)`
`=AVG(B1:B10)`
`=SUM(B1:B10)/10`
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel feature allows you to visually represent data using bars, lines, or pie slices?
Chart
Pivot Table
Data Validation
Conditional Formatting
4.
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 column
To calculate the sum of a range
To find the maximum value in a dataset
To create a chart
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a method to apply the same formatting to multiple cells in Excel?
Format Painter
Copy and Paste
Data Validation
Conditional Formatting
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you quickly sum a column of numbers in Excel?
Use the AutoSum button
Use the `=SUM()` function
Manually add each cell
Use the `=ADD()` function
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to count the number of cells that contain numbers in a range?
`=COUNT()`
`=COUNTIF()`
`=COUNTA()`
`=COUNTBLANK()`
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
Already have an account?
