Excel Lecture 3-2 (multiple) Formulas 3L-2a (Sheet1) Create spreadsheet on right Save as 3L-2 D2 Type “Salary” Bold & Center Formula for Salary B3*C3 Copy down Change B4 to 28 C5 to 19.10 B7 to 24 Save Multiple 3L-2b (Sheet2) Type in D1 “% of Actual” Divide Column C by B Dividing Copy Formulas Format Column D to Percent =cell/cell Format Column B - C to Currency Copy and paste 3L-1a Use Auto Width for columns Save again Save as 3L-2 Delete data in Column D 3L-2c (Sheet3) Create spreadsheet below Use auto fill for months of” Time” A11 type “Percentage (alt + enter) “Down B11 Formula for downtime =(B3-B9)/B3 Copy Formula Across Format Row 11 to Percent A13 type Available” enter) June” “Hours (alt+ “January – B13 Formula for Hours =Sum(B3:G3) A14 Type Available” enter) Dec.” “Hours (alt + “July – B14 Formula for Hours =Sum(H3:M3)
Excel Lecture 3-2 (multiple) Formulas 3L-2a (Sheet1) Create spreadsheet on right Save as 3L-2 D2 Type “Salary” Bold & Center Formula for Salary B3*C3 Copy down Change B4 to 28 C5 to 19.10 B7 to 24 Save Multiple 3L-2b (Sheet2) Dividing =cell/cell Copy and paste 3L-1a Save as 3L-2 Delete data in Column D Type “% of Actual” in D1 Divide Column C by B Copy Formulas Format Column D to Percent Format Column B - C to Currency Use Auto Width for columns Save again 3L-2c (Sheet3) Create spreadsheet below Use auto fill for months A11 type “Percentage of” (alt + enter) “Down Time” B11 Formula for downtime =(B3-B9)/B3 Copy Formula Across Format Row 11 to Percent A13 type “Hours Available” (alt+ enter) “January – June” B13 Formula for Hours =Sum(B3:G3) A14 Type “Hours Available” (alt + enter) “July – Dec.” B14 Formula for Hours =Sum(H3:M3)
6amultiple.docx