Excel

Question 1

What is a Cell?

Answer 1

A cell is the basic unit where data is entered. Each cell has a unique address, which is a combination of a column letter and a row number. For example, the top-left cell is A1, where “A” represents Column A and “1” represents Row 1.

Question 2

What is a Cell Reference?

Answer 2

A cell reference in Excel identifies a specific cell or range using a column letter and row number (e.g., A1). It is used in formulas to retrieve or calculate data.

Question 3

What is a Relative Reference

Answer 3

Changes when copied to another location.

Question 4

What is a Absolute Reference

Answer 4

Remains fixed when copied, using $ signs.

Question 5

What is a Mixed Reference

Answer 5

Either the row or column is fixed.

Question 6

What is an Absolute Cell Reference?

Answer 6

An absolute cell reference in Excel is a fixed reference to a specific cell, meaning it does not change when copied to another location. It is denoted by a dollar sign ($) before the column letter and row number (e.g., $A$1).