
Excel Functions and Formatting Concepts
Interactive Video
•
Mathematics, Computers, Instructional Technology
•
9th - 10th Grade
•
Practice Problem
•
Hard
Patricia Brown
FREE Resource
Read more
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in setting up a relative frequency table in Excel?
Create a pie chart.
Calculate the average of the data.
Copy and paste a chart from another source.
Use the VLOOKUP function.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel function is used to calculate the total of a set of numbers?
AVERAGE
PRODUCT
COUNT
SUM
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you ensure a cell reference remains constant when copying a formula in Excel?
Use a hashtag (#).
Use a semicolon.
Use an asterisk (*).
Use a dollar sign ($).
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of dragging the formula down in the relative frequency calculation?
To change the formula to a different function.
To apply the formula to all cells in the column.
To create a new worksheet.
To delete the formula.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens if you don't use a dollar sign in a cell reference when copying a formula?
The cell will be highlighted.
The reference will remain constant.
The reference will change relative to the position.
The formula will not work.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you change the number of decimal places displayed in Excel?
By adjusting the column width.
By formatting the cells.
By using the SUM function.
By changing the font size.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the default number of decimal places shown in Excel?
Two
Four
Zero
One
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?
Similar Resources on Wayground
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Mathematics
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
12 questions
Exponential Growth and Decay
Quiz
•
9th Grade
20 questions
Exponent Rules Review
Quiz
•
8th - 9th Grade
25 questions
Complementary and Supplementary Angles
Quiz
•
7th - 10th Grade
12 questions
Add and Subtract Polynomials
Quiz
•
9th - 12th Grade
13 questions
Model Exponential Growth and Decay Scenarios
Quiz
•
9th - 12th Grade
15 questions
Combine Like Terms and Distributive Property
Quiz
•
8th - 9th Grade
27 questions
7.2.3 Quadrilateral Properties
Quiz
•
9th - 12th Grade