ICT Spreadsheet Essentials - Lesson 3
7th - 8th Grade
•26 Qs
Similar activities
Revision Grade 8
8th Grade
•22 Qs
Computer
6th - 9th Grade
•21 Qs
Anime
5th Grade - Professional Development
•21 Qs
WheelersLTC OCR
5th - 12th Grade
•22 Qs
Multiverse of Computers
4th Grade - Professional Development
•22 Qs
INFORMATIKA KELAS 8 Bab 4&5
8th Grade
•25 Qs
Asesemen Sumatif
8th Grade
•25 Qs
Presentation P3
8th Grade
•22 Qs
ICT Spreadsheet Essentials - Lesson 3
Quiz
•
Computers
•
7th - 8th Grade
•
Practice Problem
•
Medium
Geri Thornton
Used 39+ times
FREE Resource
Enhance your content in a minute
26 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consider the following formula:
=(H12*H13)/H14
What does this formula accomplish?
It divides the value in Cell H12 by the value in Cell H13, and then multiplies the total by the value in Cell H14.
It multiplies the values in Cells H12 and H13, and then divides the total by the value in Cell H14.
It subtracts the value in Cell H13 from the value in Cell H12, and then multiplies the total by the value in Cell H14.
It adds the values in Cells H12 and H13, and then divides the total by the value in Cell H14.
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What value would be the result of the formula =A2/B2 in the spreadsheet shown?
32
2
4
12
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following is an example of an absolute cell reference?
F5:E5
F4
$A$5
D5+F5
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Aman wants to multiply the values in cells B2 and B3, and then divide the total by the value in cell D7. Which of the following would be the correct formula?
=(B2*B3)%D7
=B2*B3-D7
=(B2*B3)/D7
=(B2xB3)/D7
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?
$B7 is a mixed cell reference in which the column would not change when moved.
$B7 is a relative cell reference in which the row would not change when moved.
$B7 is an absolute cell reference in which the row would not change when moved.
$B7 is an example of an absolute cell reference in which the column and row would not change when moved.
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Charles is working with several team members on the same spreadsheet. He wants to use an absolute cell reference for the data in cell C7 in one of his formulas. Which of the following is an example of how he would make this absolute cell reference?
&C7
C7
$C$7
C+7
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Helen used a formula to calculate values using the data in Column A and the data in Column B. Which formula did Helen use in Column C to produce the result in Cell C1?
=A1+B1
=A1/B1
=A1*B1
=A1-B1
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
24 questions
Search Engines
Quiz
•
8th - 10th Grade
21 questions
Computational Thinking
Quiz
•
5th - 12th Grade
21 questions
Persiapan UTS
Quiz
•
7th Grade
21 questions
ICT Prep1 2nd Term Lesson 3 Robots (True or False)
Quiz
•
7th Grade
29 questions
Computing Essentials A
Quiz
•
6th - 8th Grade
23 questions
Computer ICT - L7
Quiz
•
7th Grade
23 questions
grade 8 review SJC
Quiz
•
8th Grade
25 questions
Bab 6 Analisis Data
Quiz
•
7th Grade
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
