Computers And Technology High School

Which sign or symbol will you use to lock cells for absolute cell reference?
A.
ampersand
B.
asterisk
C.
dollar sign
D.
exclamation mark

Answers

Answer 1

Answer:

Option C. dollar sign is the correct answer

Explanation:

There are two types of referencing styles used in MS excel.

Relative and absolute.

Out of these two, absolute referencing is used where we don't want the cell addresses to change when the formula with cell reference is copied. Dollar sign is with the row and column number to write an absolute cell reference.

An absolute cell reference for cell C5 is written as:

$C$5

Hence,

Option C. dollar sign is the correct answer

Answer 2

Answer:

C. dollar sign

Explanation:

Related Questions

Other Questions
Which conclusion can you draw regarding the circumstances the led to this document? A. People disagree about the procedures for the office. B. People are relocating into new work areas after renovation. C. People have been careless with food and beverages in the work area. D. People are taking too many private calls on their cell phones during work. What group was part of the rising middle class of the Sung period?servantsscholarsshopkeeperssoldiers i will give a thanks 5 stars and i will give you the brainliest Gwen mows 1/4 acre in 3/4 hours. what fraction is used to find the unit rate, in acres per hour?A. 3/4B. 1/4/3/4C. 4/3D. 3/4/1/4 Should students receive a summer break? Please include facts!! answer the question below to be featured in a Mr. Beast video! Question 1 (1 point) Saved What is the summary of the plot? A pancake mix requires 5 cups of flour for every 10 pancakes. How much flour is used per pancake? The next two terms of the sequence 4,7,10,13 are...and ---- Which of the following quotients are negative? Check all that apply.2.2 9.50.5 0.0211.3 54.3210.4 0.4 If a state has 5 members in the House of Representatives, how many total electoral votes will it have?a. 5b. 6c. 7d. 8 Question 16 (1 point) (04.05 MC) The graph shows a journey in a car. Which of the statements most likely describes the start of the journey at the portion of the graph labeled I? (1 point) M M Distance (mi) N Time (hr) a Ob The car travels the same distance per unit of time because the portion shows a linear, increasing function The car travels different distances per unit of time because the portion shows a linear, increasing function. The car travels the same distance per unit of time because the portion shows a nonlinear, increasing function Od The car travels different distances per unit of time because the portion shows a nonlinear, increasing function. HELP! i can not figure this out! y=4x+1 WILL MARK ANYONE THE BRAINIEST IF THEY ANSWER ASAP AND CORRECT!!! A= 20 square root of 2B= 5C=20D=10 What is the slope? WILL MARK AS BRAINLIEST!! !(picture included ^^^^) I dont get this pls help Carbon is an important element for biological life because it-is always attached to oxygen atoms.can form varied, large, and intricate molecules.is stable and does not easily go through changes.is only found in plant species, such as trees. How do people living in areas around Africa's rainforestusually make their living? As you can see I NEED HELP RIGHT NOW! The new owner of a beauty shop is trying to decide whether to hire one, two, or three beauticians. She estimates that profits next year (in thousands of dollars) will vary with demand for her services, and she has estimated demand in three categories, low, medium, and high. NUMBER OF BEAUTICIANS DEMAND LOW MEDIUM HIGH One 50 75 100 Two 0 100 100 Three (100 ) 70 300 If she feels the chances of low, medium, and high demand are 50 percent, 20 percent, and 30 percent respectively, what are the expected annual profits for the number of beauticians she will decide to hire?