Which one of the following is an example of a cell with an absolute reference? a

Question

Which one of the following is an example of a cell with an absolute reference?

a. A1

b. $A$1

c. A1$

d. $A1$

The reference to a cell in a formula is A1. What type of reference is this?

a. Absolute

b. Mixed

c. Relative

d. Unknown

A mixed reference describes a cell:

a. for which the row is frozen or the column if frozen

b. for which both the row and the column are frozen

c. for which neither the row nor the column is frozen

d. that contains both text and a numeric value

Which statement below about data in an original cell is TRUE?

a. Both moving and coping delete data in the original cell location

b. Neither moving nor coping data delete data in the original location

c. Copying data deletes data in the original cell location, whereas moving data does not

d. Moving data deletes data in the original cell location, whereas copying does not

When you copy or move data:

a. formulas are not copied

b. cell contents, formats, and any comments are all transfered

c. formats are not copied

d. cell contents, formats, and any comments are reformatted

Explanation / Answer

1. b. $A$1

2. c. Relative

3. a. for which the row is frozen or the column if frozen.

4. d. Moving data deletes data in the original cell location, whereas copying does not.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.