IFSM 201
Excel lab/homework 1/G
Do these:
All create the worksheets from scratch.
1. Apply all the data and formula entry and formatting of Unit G to a
"Kite Sales Forecast" file.
In other words, do all the editing and formatting that Unit G guides you through.
Your worksheet should end up looking like the one on page 159.
2. Skills Review of pages 163-165.
It will end up looking like Figure G-23 of page 165.
The Total column cells are formulas.
The totals row uses Sum functions.
3. Independent Challenge 3 on page 167-168. Including the ACE.
It will end up looking like Figure G-24 of page 168,
plus with an H column.
The Total Investment and Profit columns are formulas.
The Total row uses Sum functions.
4. Visual Workshop on page 170.
The June and July Total Revenue columns are formulas.
The Totals row and the Total Weeks and Total Revenue cells
use Sum functions.
Not making the formulas or not using functions defeats the purpose
of using an electronic spreadsheet.
Most or all of the spreadsheets we do will fit the width of the printed
paper if landscape is used, and narrow the margins, and decrease the font.
Ones that are more than one page, double-sidethe printing.