
Excel Formulas and Functions Basics

Interactive Video
•
Computers
•
6th - 8th Grade
•
Hard
Medina James
FREE Resource
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of using formulas in spreadsheets like Excel?
To create charts and graphs
To organize data alphabetically
To calculate math problems
To design visually appealing layouts
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which symbol is used for multiplication in Excel formulas?
+
-
*
/
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What symbol must always come first when entering a formula in Excel?
+
-
=
*
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to add the values in cells D10 and D11 in Excel, what would the formula look like?
D10+D11
=D10+D11
SUM(D10:D11)
ADD(D10,D11)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main advantage of using cell references in Excel formulas instead of directly typing numbers?
It makes the spreadsheet look neater
It allows for automatic recalculation when original values change
It prevents errors in data entry
It speeds up the initial formula creation
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you edit an existing formula in Excel?
Right-click the cell and select 'Edit'
Press F2
Double-click the cell
Select the cell and press 'Delete'
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the "point-and-click" method used for when creating formulas in Excel?
To select multiple cells for formatting
To quickly enter cell addresses into a formula
To navigate between different worksheets
To apply conditional formatting
8.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the "fill handle" in Excel when working with formulas?
To change the font size of the formula
To delete a formula from multiple cells
To duplicate a formula to several adjacent cells
To highlight cells containing formulas
Similar Resources on Wayground
2 questions
Calculating Averages in Excel Using Formulas and Autosum Feature

Interactive video
•
6th - 7th Grade
11 questions
Spreadsheet Functions and Features

Interactive video
•
7th - 9th Grade
11 questions
Budget Percentages and Excel Functions

Interactive video
•
6th - 10th Grade
11 questions
Excel Functions and Formulas

Interactive video
•
6th - 10th Grade
10 questions
Microsoft Excel Workbook Management

Interactive video
•
6th - 10th Grade
6 questions
Microsoft Excel Tutorial: Relative vs Absolute Cell Reference in Formulas

Interactive video
•
6th - 8th Grade
2 questions
Microsoft Excel Tutorial: Relative vs Absolute Cell Reference in Formulas

Interactive video
•
6th - 8th Grade
3 questions
Calculating Averages in Excel Using Formulas and Autosum Feature

Interactive video
•
6th - 7th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
20 questions
Brand Labels

Quiz
•
5th - 12th Grade
15 questions
Core 4 of Customer Service - Student Edition

Quiz
•
6th - 8th Grade
15 questions
What is Bullying?- Bullying Lesson Series 6-12

Lesson
•
11th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
10 questions
Exploring Digital Citizenship Essentials

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

Interactive video
•
6th - 10th Grade
20 questions
typing

Quiz
•
6th Grade
18 questions
Company Logos

Quiz
•
6th - 8th Grade
10 questions
Proper Keyboarding Techniques

Interactive video
•
6th - 10th Grade
14 questions
Inputs and Outputs: Computer Science Intro

Lesson
•
5th - 9th Grade
20 questions
Input, Output, Processing or Storage

Quiz
•
5th - 6th Grade
10 questions
Understanding Computers: Hardware, Software, and Operating Systems

Interactive video
•
7th - 12th Grade