Answer:
absolute cell referencing
Explanation:
Excel has an A1 reference style, which means that the columns are called letters A to XFD and the rows have numbers, 1 to 1,048,576. The total number of columns in Excel 2007 is 16384.
A cell can contain a value, formula or constants. A formula begins with a sign = (equal). You can use values from other cells in your formula. To use another value, create a reference to the cell that contains the value you want to use in your formula.
When you copy a cell that contains a relative reference and paste it into another cell, the relative reference changes
When you copy a formula that contains relative references, the reference changes when you paste it into another cell.
How much the reference changes in relation to the position of the copied cell and the position of the new cell in which the formula is pasted. Excel uses relative references by default.
Instead, an absolute reference in a formula remains the same if it is copied to another cell.
Contactles..........................................................
Answer: In this context, the best answer for the given questions would be (B) you offer to take on some extra work when a coworker is out sick.
Explanation: Initiative is pretty much defined as an action that is taken independently by someone. It could be said that one person with an initiative does not need someone else to tell him/her to do something.
Answer:
a. =IF(H4>0,12*$D$5-J4,0)
Explanation:
a. =IF(H4>0,12*$D$5-J4,0)
If( H4>0 is the logical test,
12*$D$5-J4 is [value_if_true]
0 is [value_if_false]
b. Referencing to the above formula in (a), which is the required formula which should be typed in cell K4.
Absolute referencing of cell D5 means that this will not change while extending this formula to the entire column. Whereas, since cell H4 and J4 have relative cell referencing, these will change relatively as we extend the formula to the entire column.
