Home /
Expert Answers /
Computer Science /
ashley-is-interested-in-how-much-revenue-the-nine-consultants-each-generate-on-average-per-month-an-pa229

Ashley is interested in how much revenue the nine consultants each generate on average per month and for the year to date. Find this information as follows: a. Edit cell B14 to include a formula that divides the value in cell B13 (the total sales for Connecticut in January) by the value in cell \( \mathbf{3 2} \) (the number of consultants). Don't change the reference to cell \( \mathrm{J} 2 \) that is already there. b. Fill the range \( \mathrm{C} 14: \mathrm{H} 14 \) with the formula in cell \( \mathrm{B} 14 \) to determine the average revenue per consultant from February to June and for the year to date.

ANSWER: Formula for cell B14 =(B13/$J$2)

Live Sessions

Online Lab Report Help

Online Project Report Help

Online Assignment Help

Essay Writing Help

CPM Homework Help

Mortgage Calculator

Electrical Engineering

Civil Engineering

Chemical Engineering

Electronics and Communication Engineering

Mathematics

Physics

Chemistry

Software Works/ Computer Science

Other Subjects

100% Correct Solutions

24/7 Availability

One stop destination for all subject

Cost Effective

Solved on Time

Plagiarism Free Solutions

Confidentiality