Font size
WorksheetsQuiz 4
Total questions: 10
Worksheet time: 20mins
Absolute Cell Reference
=(A1*$B$1)
Relative Cell Reference
=(A1*B1)
Sum Function
=(A1+B1)
Wrong Formula
(A1+B1)
Division Function
=(A1/B1)
Which sign do you use to lock the rows and columns in Absolute Cell reference function?
#
$
%
&
Which one is the correct formula?
=(A1*$B$1)
=(A1*B$1$)
=(A1*B$1)
=(A1*B1$)
In the formula =(A1*$D$15), which cell is locked?
A1
D15
A15
D1
Every formula in MS Excel starts with which sign?
+
=
/
?
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
What is the formula in the picture called?
Relative Cell Reference
Absolute Cell Reference
In this picture, which formula is used?
Absolute Cell Reference
Relative Cell Reference
No Formula
Which of the following is a SPREADSHEET Software?
Type the formula to add all numbers in A1:A15 with B1
(Hint: Absolute Cell Reference)
(a)
