Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

u&Te; ong formula 1:16 PM 1 84% Question 17 Formula auditing is used by accounta

ID: 3881121 • Letter: U

Question

u&Te; ong formula 1:16 PM 1 84% Question 17 Formula auditing is used by accountants is used by the IRS is a color-coded editing system all of the above answers & 2 Question 18 in MS Excel cell references may be (select all that apply relative absolute mixed Question 19 An absolute reference adjusts when you copy does not adjust when you copy a contains one relative and one absolute reference all of the above answers 1 & 2 a formula formula Question 20 A relative reference adjusts when you copy a formula does not adjust when you copy a formula contains one relative and one absolute reference all of the above answers 1&2 Question 21 A mixed reference a formula adjusts when you copy does not adjust when you copy a contains one relative and one absolute reference all of the above answers 1 & 2 formula

Explanation / Answer

Question 17

Formula auditing is a color coded editing system in excel. It may be used to trace dependents or precedents.

Question 18

In MS-Excel, a cell reference may be mixed

Question 19

An absolute reference does not adjust when you copy a formula

Question 20

A relative reference adjusts when you copy a formula

Question 21

A mixed reference contains an absolute reference and a relative reference.