Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?

My Practice Data

Your name goes here Raneen Allan

Location

January

February

March

Total Sales

North

$100$

$75$

$250$

South

$245$

East

$200$

$80$

West

$300$

$145$

$200$

$70$

Grand

Total

Instructions:

$1$ Merge and center the titles over the data columns

$2$ Format the titles as $14pt$ bold

$3$ Row $4$ data should be $12$ pt and a different color

$4$ Calculate Total Sales

$5$ Calculate Average Sales

$9$

$6$ Calculate the grand total

$10$

$7$ Calculate percent of total $($total sales divided by grand total; be sure to use absolute addressing$)$

$11$

$8$ From the Number panel, format column E as Currency, no decimal places

$12$

$9$ Format Column F with two decimal places

$13$

$14$

$15$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

$23$

$24$

$25$

$26$

$27$

$28$

$29$

$30$

$31$

$32$

Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?

My Practice Data

Your name goes here Raneen Allan

Location

January

February

March

Total Sales

North

$100$

$75$

$250$

South

$245$

East

$200$

$80$

West

$300$

$145$

$200$

$70$

Grand

Total

Instructions:

$1$ Merge and center the titles over the data columns

$2$ Format the titles as $14pt$ bold

$3$ Row $4$ data should be $12$ pt and a different color

$4$ Calculate Total Sales

$5$ Calculate Average Sales

$9$

$6$ Calculate the grand total

$10$

$7$ Calculate percent of total $($total sales divided by grand total; be sure to use absolute addressing$)$

$11$

$8$ From the Number panel, format column E as Currency, no decimal places

$12$

$9$ Format Column F with two decimal places

$13$

$14$

$15$

$16$

$17$

$18$

$19$

$20$

$21$

$22$

$23$

$24$

$25$

$26$

$27$

$28$

$29$

$30$

$31$

$32$