In Excel which of the following is an absolute cell reference?

Sail E0 Webinar

Question

In Excel which of the following is an absolute cell reference?

Options:

A . !A!1

B . $A$1

C . #a#1

D . A1

Answer: Option B
Answer: (b)

Was this answer helpful ?

Next Question

Submit Solution

More Questions on This Topic :

Question 1. You can not link excel worksheet data to a word document....

Question 2. When you group worksheets....

Question 3. To copy formatting from one area in a worksheet and apply it to another area you would use....

Question 4. The name box....

Question 5. A numeric value can be treated as label value If...... precedes It.....

Question 6. You can use a function to combine text from two cells into one cell. But you can use an opera-tor to do the same thing. ....opera-tor to do the same thing. Which operator is that?

Question 7. The spelling dialog box can be involved by choosing spelling from ___ menu.....

Question 8. Which is not the function of "Edit, Clear" command?....

Question 9. In Excel when you are typing an equation into a cell the first thing that must be entered is....

Question 10. In Excel the following is not information you can specify using the solver....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0