1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
nikdorinn [45]
3 years ago
5

Which sign or symbol will you use to lock cells for absolute cell reference

Computers and Technology
1 answer:
denis-greek [22]3 years ago
7 0

Answer:

Dollar ($) is used to lock cells for absolute cell reference.

Explanation:

There is two type of referencing in MS Excel. Relative reference and absolute reference. These are used for copying formula to other cells.

<u>Relative reference</u>

If we want to keep change the formula in the for different cell while copying in different cells we use relative reference.

For example

we want to add value of A1 and B1 and store it into C1. We want to copy this formula into next rows by changing the cell reference as in C2=A2+B2, C3=A3 + B3, we use relative referencing. There we just copy the formula to C2, C3 and so on, the formula remains same but cell references will changed.

<u>absolute reference</u>

If We want to to copy same formula with same cell references into different cells, we use look cell formula using absolute reference. We just put the $ sign before cell reference, it will make that cell absolute. Now where we copy and paste that cell the formula and references remains same.

<u>For Example </u>

we want to add two values of A1 and B1 into C1. we use C1=A1+B1. To make this cell absolute, we use $ sign as, C1= A$1 + B$1. Now this cell becomes absolute. Now if we want to copy the formula in C2, so C2= A$1 + B$1.

There cell is different bu in both cells formula and cell references are same.

<u></u>

You might be interested in
Inattentional blindness occurs when individuals do not observe certain objects or events because they are focused on something e
PSYCHO15rus [73]
The answer is True have a good day
5 0
3 years ago
Read 2 more answers
The best technique to read​
Readme [11.4K]

Answer:

The best reading techniques are the SQ3R technique, skimming, scanning, active reading, detailed reading, and structure-proposition-evaluation.

Explanation:

6 0
3 years ago
What are network operating systems
Svetllana [295]
A network operating system is basically a computer operating system that is designed to support a workstation, and other machines that are connected in the Local Area Network. It allows access to a certain devices and machines like printer, file sharing, etc.

4 0
3 years ago
The value 8/10 in a cell refers to which of these?
AleksAgata [21]
D. all of these, since it depends on how the cell is formatted.
8 0
3 years ago
Read 2 more answers
I have no idea, this has two parts. Any help I would love.
lana [24]

Answer:

2that is the question??? then many I could help

7 0
2 years ago
Other questions:
  • What the address for dns server that the eorkstation will use?
    10·1 answer
  • If you work up to your potential but fall short of your goals, you
    15·2 answers
  • Which of the following is NOT a Boolean Search term used to refine search engine results? A. AND B. With C. OR D. NOT
    14·2 answers
  • Computers heat resistant materials breathing systems for fire fighters food-growing technologies improvements in all of the item
    14·1 answer
  • 2. What is the layout of the modern keyboard known as?
    13·1 answer
  • A Silicon Valley billionaire purchases 3 new cars for his collection at the end of every month. Let a_n denote the number of car
    8·1 answer
  • Fact Pattern: A sales transaction record designed to contain the information presented below. Column Information 1-10 Customer a
    13·1 answer
  • How is the bootstrap program started?
    6·2 answers
  • Does anyone else have edge and think its not the awful?
    12·2 answers
  • Tips for staying safe using social media. Using in your own words.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!