Quiz 4
Authored by Jehanzaib Chaudhry
Computers
1st - 10th Grade
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MATCH QUESTION
3 mins • 5 pts
(A1+B1)
Sum Function
=(A1/B1)
Absolute Cell Reference
=(A1*B1)
Relative Cell Reference
=(A1*$B$1)
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
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?
