Which column and row references are updated when you copy the formula f$3/15

Computers and Technology

1 answer:

Tasya [4]3 years ago

3 0

Answer: Column F

Explanation: In Microsoft excel, for the sake of robustness and to aid the effectiveness of updating formulas across cells. The reference of cells are treated as relative which means that when formulas are copied across columns or within rows, they get updated automatically. However, some numbers may be treated as constants such that we do not want them to change or be updated as we move acisss cells. Thus, such numbers are treated Given absolute references, which is made possible by adding a '$' prefix before the colum alphabet or row number or both. in the scenario given above, the row has the $ prefix, hence, it is absolute and will not change but the column alphabet does not and hence, treated as relative.

You might be interested in

Ivy is a student. She is looking for some freelance assignments during her vacation. Which of the following networking sites can

lara [203]

The answer is D. XING

3 0

3 years ago

Write the interface (.h file) of a class Counter containing: A data member counter of type int. A data member named counterID of

OlgaM077 [116]

Explanation:

See the attached image for The interface (.h file) of a class Counter

8 0

3 years ago

I don't know what to do for these two questions

Rainbow [258]

我沒有看到問題？如果您可以在此問題上發布問題，那將非常有幫助！

6 0

2 years ago

When breaking a problem down, you often encounter elements that you want to use repeatedly in your code. Sometimes it's appropri

ddd [48]

Answer:

FUNCTION:

A function does not require the number of times that the code script needs to be executed

When we go for large programming, ie. while creating projects, we can invoke function from one file to another based on the access specifier mentioned for the function.

There is a stack call created in the memory whenever a function is called.

LOOP :

Whereas the number of times that the loop has to be executed must be defined

A loop cannot be called, it can be used only the code block in which it is present.

There is not overhead of creating a stack since it is not invoked and there is no transfer of control from one module to another

8 0

3 years ago

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