$4$:$27$ C

all $56$:

$26$

chapter$\_2\_$ASSIGN copy

A

B

C

D

E

F

G

H

I

J

K

L

M

Production of the Acme Widget Company

All figures are in kilo$-$tons

$1$ Add "summation" formulas to all relevant rows and$/$or columns to compute the production totals for each year. Add "summation" formulas to all relevant rows and$/$or columns to compute the production totals for each region. Change the background colors of all cells for the Pacific Coast region to yellow

$2$ In each of the following cells, you need to enter formulas that in turn will compute the correct values. Do notenter the values directly. The increase in production from $2017$ to $2018$ was: $($enter a formula uch as $=J7-56$ in the cell on the left$)$

Total production across the Eastern Seaboard $($New England, Atlantic Coast, and South$-$East$)$: $($use appropriate formula in the cell on the left$)$

The average production level from $2016$ to $2020$ was: $($use appropriate formula in the cell on the left$)$

$3$ Use the mouse or cursor keys to mark the data from cell A$4$ to cell I$9.$ Use the appropriate "Insert" menu to insert the "recommended chart" below $140012001000800$

$28$

$29$

$31$

$32$

$33$

$35$

$36$

$37$

$39$

$40$

$41$

$42$

$43$

$44$

$45$

$46$

$47$

$48$

$49$

$50$

$51$

$52$

$54$

$55$

$56$

$57$

$58$

$59$

$60$

$62$

$63$

$64$

$66$

$67$

$68$

$70$

$71$

$72$

$73$

$74$

$75$

$76$

$fx$

Enter text or formula here