Spreadsheet Formulas/Functions

Quiz
•
Computers
•
6th - 8th Grade
•
Medium
Bo Riddick
Used 9+ times
FREE Resource
11 questions
Show all answers
1.
LABELLING QUESTION
1 min • 1 pt
What is the formula you would use in cell D2 to find the total cost per item?
=B1/C1
=B1*C1
=B1+C1
=B1-C1
2.
LABELLING QUESTION
1 min • 1 pt
What is the formula or function you would use to get the subtotal?
=D2+D3+D4+D5+D6+D7+D8+D9+D10
=(D2:D10)
=sum(D2:D10)
=D2+D10
3.
LABELLING QUESTION
1 min • 1 pt
How would you calculate the tax in cell D13 ($55.50)
=D12-.06
=D12*.06
=D12+.06
=D12/.06
4.
LABELLING QUESTION
1 min • 1 pt
How would you find the total cell D14?
=D12/D13
=D12+D13
=D12-D13
=D12*D13
5.
LABELLING QUESTION
1 min • 1 pt
How would you find the remaining balance from your budget of $1,000?
=D12-1000
=D14-1000
=D13-1000
6.
LABELLING QUESTION
1 min • 1 pt
What formula would you use the get the total cost (D4)?
=B4-C4
=B4*C4
Copy the formula from cell D2 down
=B4+C4
7.
LABELLING QUESTION
1 min • 1 pt
What label is in cell B1
Total Cost
Item
Quanity
Price per item
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Excel - nível básico

Quiz
•
6th Grade
10 questions
Input Devices

Quiz
•
1st - 10th Grade
10 questions
HTML

Quiz
•
8th Grade
12 questions
KT CHK1 Tin 8

Quiz
•
8th Grade
15 questions
Занятие 26_02 (Arduino)

Quiz
•
6th - 8th Grade
10 questions
EASY LEARNING

Quiz
•
8th Grade
15 questions
Начала программирования на языке Паскаль

Quiz
•
8th - 11th Grade
12 questions
6th Grade-Energy Assessment

Quiz
•
6th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

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

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th 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
8 questions
Time Management

Quiz
•
6th Grade
18 questions
Digital Footprint

Quiz
•
6th Grade
20 questions
typing

Quiz
•
6th Grade
18 questions
Company Logos

Quiz
•
6th - 8th Grade
10 questions
Exploring Cybersecurity Techniques and Threats

Interactive video
•
6th - 10th Grade
10 questions
Understanding the Internet and Data Transmission

Interactive video
•
7th - 12th Grade
25 questions
How to Email a Teacher- https://youtu.be/NioeNhfpVfI

Quiz
•
6th - 8th Grade