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
After purchasing new computers for her​ department, a manager is now comparing the performance of the new computers to the compu
AlladinOne [14]

Answer:

evaluation of decision effectiveness

Explanation:

Based on the information provided within the question it can be said that in this scenario she is in the stage of evaluation of decision effectiveness. This is the stage after the decision has been made in which the individual begins to analyze the decision and determine whether the decision was as effective as originally anticipated , and whether or not it was the correct decision.

8 0
3 years ago
What is one step taken when solving a computer software problem?
k0ka [10]
Properly scanning the computer and deleting any viruse. this is Answer

Some of the feedback I hear from new developers working on a programming problem revolves around uncertainty of where to start. You understand the problem, the logic, basics of the syntax, etc. If you see someone else’s code or have someone to guide you, you can follow along. But maybe you feel uncertain about doing it yourself and have trouble turning your thoughts into code at first even though you understand the syntax or logic. Here’s my process and some tips to tackling a sample problem that hopefully some of you may find helpful in your journey.
HOME







Some of the feedback I hear from new developers working on a programming problem revolves around uncertainty of where to start. You understand the problem, the logic, basics of the syntax, etc. If you see someone else’s code or have someone to guide you, you can follow along. But maybe you feel uncertain about doing it yourself and have trouble turning your thoughts into code at first even though you understand the syntax or logic. Here’s my process and some tips to tackling a sample problem that hopefully some of you may find helpful in your journey.


3 0
3 years ago
Read 2 more answers
Why is audio greyed out on powerpoint ms office 2011?
-BARSIC- [3]
Because its a old type of software and probably wont run on your computer
7 0
3 years ago
Which is an example of an active visual interface? a display indicating the amount of ammunition for the currently equipped weap
AnnyKZ [126]

Hello.

The answer is : weapon a display indicating an object that can be explored by clicking on it a display indicating the types of weapons available a display indicating keys collected

An active visual interface is one in which a player can click to interact with the game mechanics.

have  a nice day

7 0
3 years ago
Read 2 more answers
Name the bar that displays the information about the current document like the number of pages and words
Wittaler [7]

Answer:

Word Status Bar or Status Bar

Explanation:

3 0
3 years ago
Other questions:
  • If you quote an author from a website in a paper, it will be important to create a _____ in your writing to give them credit for
    7·2 answers
  • Which is the output of the formula =AND(12&gt;6;6&gt;3;3&gt;9)
    6·1 answer
  • Write algorithm to find (a+b)^2=(a+b)*(a+b)​
    9·1 answer
  • In order to get a comprehensive evaluation of the computer programmers he managed, Justin organized a(n) __________, where he as
    11·1 answer
  • What is the name of the unique identifier assigned to any personal computer that is connected to the internet?
    11·1 answer
  • 6. You and your friends take an awesome selfie, and you add your name and addresses to the picture. It is a good idea to share t
    11·1 answer
  • In order to get the maximum functionality out of a device that is plugged in, a user should download the specific ___ for that d
    10·2 answers
  • Consider the following declaration:
    11·1 answer
  • How many pages is 1500 words double spaced 12 font?.
    10·1 answer
  • True or false FAFSA awards work study, but jobspeaker can be used to learn which jobs are available
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!