Answer:
To protect a formula
Explanation:
One common example to apply cell protection to spreadsheet entries is to protect a formula used in the sheet to calculate payouts or rankings for example. A manager might want to share the results of the team to all its team and provides some ranking or other form of calculations in the sheet. He then needs to protect the formula so it's not altered by the team members or anyone else reviewing the file.
They won’t let it be on your computer, knowing it well give you answers
The answer is A. Occupational Safety and health Administration.
Answer:
In cell B6, formula =INDEX(INDIRECT($B$3),A6)
CallCenter Worksheet Details:
The image of the CallCenter Report worksheet for reference to the question asked is attached below.
Explanation:
Firtsly, an absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. To do this,we put a $ dollar sign ( =A$1,) before the row coordinate to lock only the row.
A relative reference in Excel is a cell address without the $ sign in the row and column coordinates example A1.
Having known what absolute and relative reference are, we wlil write the below formula in cell B6 that will later be copied to cell B9:
: =INDEX(INDIRECT($B$3),A6)