Computers and Technology, 22.03.2020 23:27 sonykorah7279

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?

Answers: 1

Show answers

Answers

Answer from: trillsmith

The column position B will not change for the referenced cell $B7. This is known as mixed referencing.

Explanation:

In spreadsheet, the dollar sign is used in signifying locked entry which is either the row or the column or both of them. We have three main ways by which cell position are referenced, which are as follows:

1. Mixed referencing: this is a referencing type that either locks the row or the column position, but not both. This means that if the column is locked as we had in the question above, $B7, the dollar sign in-front of the B signifies that the column position will not change during the use of the formula, which means it will remain permanently at column B, while the position of the row could change as the execution of the formula progresses. We can also have a situation that is vice-versa, meaning, the position of the row might be locked, while that of the column might be the one changing. An example of this is, B$7. The dollar sign in-front of the figure "7", signifies that the 7 is locked.

2. Absolute referencing: this is a referencing type in which both the position of both the column and row are locked. Locking them means preventing them from moving to other cell position while fixing them to that same location for the use of their value. Examples of absolute reference is; $C$5, meaning both the row and the column positions are locked to that single location or position.

3. Relative referencing: this is the referencing type that is the default, as it does not need the dollar sign in specifying it. An example is, B7. This type of referencing transfers control progressively to other cell locations during operations such as auto-fill and the likes.

Answer from: Quest

Maybe a timeline because it shows what's going on in for a long period of time

Answer from: Quest

Just trying to get some points : p sorry bro

Another question on Computers and Technology

Computers and Technology, 22.06.2019 14:30

The “rule of 72” is used to approximate the time required for prices to double due to inflation. if the inflation rate is r%, then the rule of 72 estimates that prices will double in 72/r years. for instance, at an inflation rate of 6%, prices double in about 72/6 or 12 years. write a program to test the accuracy of this rule. for each interest rate from 1% to 20%, the program should display the rounded value of 72/r and the actual number of years required for prices to double at an r% inflation rate. (assume prices increase at the end of each year.)

Answers: 1

Answer

Computers and Technology, 22.06.2019 20:10

Assume that minutes is an int variable whose value is 0 or positive. write an expression whose value is "undercooked" or "soft-boiled" or "medium-boiled" or "hard-boiled" or "overcooked" based on the value of minutes. in particular: if the value of minutes is less than 2 the expression's value is "undercooked"; 2-4 would be a "soft-boiled", 5-7 would be "medium-boiled", 8-11 would be "hard-boiled" and 12 or more would be a "overcooked".

Answers: 1

Answer

Computers and Technology, 23.06.2019 03:30

Many everyday occurrences can be represented as a binary bit. for example, a door is open or closed, the stove is on or off, and the fog is asleep or awake. could relationships be represented as a binary value? give example.

Answers: 1

Answer

Computers and Technology, 23.06.2019 06:00

What machine listens for http requests to come in to a website’s domain? a. a router b. a browser c. a server d. a uniform resource locator

Answers: 1

Answer

You know the right answer?

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in...

Questions