
Excel Functions and Formulas

Interactive Video
•
Computers
•
9th - 10th Grade
•
Hard

Emma Peterson
FREE Resource
Read more
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using the dollar sign in Excel when formatting numbers?
To convert numbers to text
To add a percentage symbol
To highlight the cell
To format numbers as currency
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why is it beneficial to use formulas in spreadsheets?
They allow for automatic updates when data changes
They prevent any errors from occurring
They make the spreadsheet look colorful
They increase the file size
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What happens when you change a value in a cell that is part of a formula?
Nothing changes
The spreadsheet crashes
The formula needs to be re-entered
The formula automatically updates the result
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function can be used to efficiently add up a large range of cells in Excel?
PRODUCT
COUNT
SUM
AVERAGE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the benefit of using the SUM function over manually adding cells?
It is faster and reduces errors
It makes the spreadsheet look better
It increases the number of cells
It allows for text formatting
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you calculate the total normal pay in a spreadsheet?
Add the hourly rate to the total hours
Subtract the hourly rate from the total hours
Multiply the hourly rate by the total hours
Divide the hourly rate by the total hours
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What symbol is used for multiplication in Excel formulas?
x
*
+
/
Create a free account and access millions of resources
Similar Resources on Wayground
9 questions
Understanding Sumproduct in Excel

Interactive video
•
9th - 10th Grade
11 questions
Spreadsheet Functions and Calculations

Interactive video
•
9th - 10th Grade
11 questions
Creating Age Structure Diagrams for Population Analysis

Interactive video
•
9th - 10th Grade
11 questions
Spreadsheet Functions and Fitness Advisor

Interactive video
•
9th - 10th Grade
11 questions
Spreadsheet Functions and Goal Seek

Interactive video
•
9th - 10th Grade
11 questions
Physics Concepts and Calculations

Interactive video
•
9th - 10th Grade
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Using Forecast Sheets

Interactive video
•
9th - 10th Grade
11 questions
Excel Esports and Competitive Gaming Quiz

Interactive video
•
9th - 10th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
10 questions
1.2 OSI & TCP IP Models Quiz

Quiz
•
10th Grade
20 questions
Digital Citizenship

Quiz
•
8th - 12th Grade
30 questions
Introduction to Computers

Quiz
•
8th - 9th Grade
35 questions
Computer Baseline Examination 2025-26

Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process

Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz

Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts

Interactive video
•
9th - 12th Grade