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
=(D2:D10)
=sum(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
=D13-1000
=D14-1000
6.
LABELLING QUESTION
1 min • 1 pt
What formula would you use the get the total cost (D4)?
=B4-C4
=B4+C4
=B4*C4
Copy the formula from cell D2 down
7.
LABELLING QUESTION
1 min • 1 pt
What label is in cell B1
Quanity
Price per item
Total Cost
Item
Create a free account and access millions of resources
Similar Resources on Wayground
15 questions
Kiểm tra thường xuyên tin 7 lần 2

Quiz
•
1st - 12th Grade
15 questions
ICDL-TIN 8

Quiz
•
8th Grade
10 questions
ANALISA DATA KELAS 8D 2024

Quiz
•
8th Grade
15 questions
Trắc nghiệm Excel

Quiz
•
7th Grade
15 questions
Memo Review

Quiz
•
6th Grade
10 questions
Assesmen Awal ANALISIS DATA

Quiz
•
8th Grade
15 questions
Y7Spreadsheet Homework 1 Quiz

Quiz
•
6th Grade - University
15 questions
Remidi Informatika US Genap Word & Excel

Quiz
•
7th 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