Excel Basics & Cell Reference

Full Name

Evaluate responses using AI:

OFF

Email ID

Evaluate responses using AI:

OFF

Student ID (ID No)

Evaluate responses using AI:

OFF

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 a different sheet 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

Why should we use named ranges in Excel?

• Much easier to remember a name rather than cell address

• Less error prone

• They are a must while writing formulas

• All columns must have a proper name