Excel Basics & Cell Reference

Full Name

Email ID

Student ID (ID No)

Which symbol specifies that rows/columns/cell is fixed?

• $

• %

• &

• #

What shortcut button is used to fix rows/colums/cells?

• F4

• F11

• F8

• F3

Getting data from a cell located in the same sheet, a different sheet, or a different worksheet is called -------.

• Referencing

• Accessing

• Pulling

• Updating

Short-cut to select the whole column

• Ctrl + Shift + down arrow

• Ctrl + Alt + down arrow

• Ctrl + down arrow

• Alt + Shift + down arrow

We need to find the product of the numbers in table. Which formula in B2 cell will work correctly when dragged horizontally and vertically?

• =$A2*B$1

• =A2*$B1

• =$A$2*$B1

• =A$2*$B1

Which example is true for "Mixed Reference with Row-Lock"?

• A$1

• $A1

• $A$1

• None