ICT Spreadsheet Essentials - Lesson 3
7th - 8th Grade
•26 Qs
Similar activities
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
AR Vocabulary - Sean
8th Grade
•23 Qs
Asesemen Sumatif
8th Grade
•25 Qs
Presentation P3
8th Grade
•22 Qs
Revision Grade 8
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
Access all questions and much more by creating a free account
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
26 questions
Keyboard Letters
Quiz
•
1st - 12th Grade
22 questions
Computer Health and Safety, The Desktop or Dashboard and Key
Quiz
•
7th - 9th Grade
24 questions
Topic 2: Hardware Recap Quiz
Quiz
•
8th Grade
21 questions
Code.Org - Part II
Quiz
•
6th - 8th Grade
21 questions
Scratch
Quiz
•
8th Grade
25 questions
Hidden Figures
Quiz
•
7th - 8th Grade
25 questions
Healthcare Careers
Quiz
•
8th Grade
21 questions
Grade 7 - Revision UT1
Quiz
•
7th Grade
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
