Quiz 4

Match the following

• =(A1*$B$1)

• Absolute Cell Reference

• =(A1*B1)

• Wrong Formula

• (A1+B1)

• Relative Cell Reference

• =(A1/B1)

• Division Function

• =(A1+B1)

• Sum Function

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)