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+D10
=(D2:D10)
=sum(D2:D10)
=D2+D3+D4+D5+D6+D7+D8+D9+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
=D13-1000
=D14-1000
6.
LABELLING QUESTION
1 min • 1 pt
What formula would you use the get the total cost (D4)?
=B4+C4
Copy the formula from cell D2 down
=B4*C4
=B4-C4
7.
LABELLING QUESTION
1 min • 1 pt
What label is in cell B1
Total Cost
Price per item
Item
Quanity
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Spreadsheets

Quiz
•
1st - 12th Grade
14 questions
Introduction to the word - Formative

Quiz
•
4th - 6th Grade
6 questions
Linear Search

Quiz
•
7th - 11th Grade
16 questions
Электронные таблицы

Quiz
•
8th - 9th Grade
10 questions
¡Adivina el personaje! Versión Marvel / Star Wars

Quiz
•
1st - 12th Grade
15 questions
(ASK T3) Bab 3 : Algoritma

Quiz
•
7th - 10th Grade
16 questions
CPA Excel Revision Quiz

Quiz
•
7th Grade
11 questions
Spreadsheets Quiz

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

Quiz
•
6th Grade
15 questions
Acceptable Use Policy (Quiz)

Quiz
•
6th - 8th Grade
25 questions
Career Vs. Job

Quiz
•
6th - 8th Grade
20 questions
Digital Citizenship

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

Quiz
•
8th - 9th Grade
20 questions
Copyright and Fair Use

Quiz
•
6th - 8th Grade
15 questions
Computer Components Video

Interactive video
•
8th Grade