Quiz 4
Quiz
•
Computers
•
1st - 10th Grade
•
Practice Problem
•
Easy
Jehanzaib Chaudhry
Used 6+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MATCH QUESTION
3 mins • 5 pts
=(A1*$B$1)
Sum Function
=(A1/B1)
Absolute Cell Reference
=(A1*B1)
Relative Cell Reference
(A1+B1)
Division Function
=(A1+B1)
Wrong Formula
2.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Which sign do you use to lock the rows and columns in Absolute Cell reference function?
#
$
%
&
3.
MULTIPLE CHOICE QUESTION
3 mins • 5 pts
Which one is the correct formula?
=(A1*$B$1)
=(A1*B$1$)
=(A1*B$1)
=(A1*B1$)
4.
MULTIPLE CHOICE QUESTION
3 mins • 5 pts
In the formula =(A1*$D$15), which cell is locked?
A1
D15
A15
D1
5.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
Every formula in MS Excel starts with which sign?
+
=
/
?
6.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
How do we change the names of the sheets in Excel?
Double Click the Sheet
One Click on the Sheet
Cannot Rename
Write a name in a cell
7.
MULTIPLE CHOICE QUESTION
30 sec • 5 pts
What is the formula in the picture called?
Relative Cell Reference
Absolute Cell Reference
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
13 questions
Powtórka z arkusza
Quiz
•
1st - 6th Grade
14 questions
Linux-1-Week 3
Quiz
•
1st - 5th Grade
10 questions
Función CONTAR
Quiz
•
KG - Professional Dev...
10 questions
Grade 9 - User Defined Methods
Quiz
•
9th Grade
10 questions
kiểm tra 15 phút tin 7
Quiz
•
6th - 9th Grade
10 questions
Post Tes Quiz Pembuatan Tabel dan Fungsi Dasar MS.Excel
Quiz
•
7th Grade
10 questions
Fungsi IF dan Grafik Microsoft Excel
Quiz
•
6th Grade
15 questions
Spreadsheets and Sports Stats
Quiz
•
7th Grade
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
9 questions
FOREST Community of Caring
Lesson
•
1st - 5th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
14 questions
General Technology Use Quiz
Quiz
•
8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
19 questions
Thanksgiving Trivia
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Company Logos
Quiz
•
6th - 8th Grade
13 questions
PowerPoint Basics
Quiz
•
6th - 8th Grade
10 questions
App Creators Lesson 2.1-2.4
Quiz
•
8th Grade
10 questions
Exploring Computer Science Careers and Subfields
Interactive video
•
6th - 10th Grade
15 questions
AP CSP Unit 4
Quiz
•
10th - 12th Grade
23 questions
Prog 1 Python Q1 Practice
Quiz
•
9th - 12th Grade
20 questions
logo quiz
Quiz
•
3rd Grade
