|
Create the following Spreadsheet:
-
This spreadsheet will have 7 columns
-
Column 1 - Customer - Data Entry from Table
-
Column 2 - Beginning Balance - Data Entry from Table
-
Column 3 - Credits - Data Entry from Table
-
Column 4 - Payments - Data Entry from Table
-
Column 5 - Purchases - Data Entry from Table
-
Column 6 - Service Charges - Data Entry from Table
-
Column 7 - New Balance - Formula (Beginning Balance +
Purchases + Service Charges - Payments - Credits)
-
This Spreadsheet will have 15 rows
-
Row 1 - Company Title - Center Justification, Large Font, Merge
columns over the entire width of the spreadsheet.
-
Row 2 - Report Name - Center Justification, Medium Font, Merge
columns over the entire width of the spreadsheet.
-
Row 3 - Column Titles as indicated above
-
Row 4 - 1st Customer - Abby Anderson, $803.01, $56.92, $277.02
, $207.94, $15.24, Result of Formula
-
Row 5 - 2nd Customer - Ben Baxter, $285.05, $87.41, $182.11
, $218.22, $0.50, Result of Formula
-
Row 6 - 3rd Customer - Cindy Carter, $411.45, $79.33, $180.09
, $364.02, $4.94, Result of Formula
-
Row 7 - 4th Customer - Doug Dixon, $438.37, $60.90, $331.10
, $190.39, $1.51, Result of Formula
-
Row 8 - 5th Customer - Erica Edwards, $378.81, $48.55, $126.15
, $211.38, $6.63, Result of Formula
-
Row 9 - 6th Customer - Fernando Fontain, $710.99, $55.62, $231.37
, $274.71, $13.78, Result of Formula
-
Row 10 - 7th Customer - Ginger Garcia, $318.86, $85.01, $129.67
, $332.89, $3.39, Result of Formula
-
Row 11 - Column Totals - Use the Sum formula in each column to
sum rows 4 thru 10.
-
Row 12 - Spacer - Leave this row blank
-
Row 13 - Column Highest - Choose the function from the function
menu to extract the highest number from rows 4 thru 10. Fill that
function to the right to the right most cell.
-
Row 14 - Column Lowest - Choose the function from the function
menu to extract the lowest number from rows 4 thru 10. Fill that
function to the right to the right most cell.
-
Row 15 - Column Average - Choose the function from the function
menu to extract the average of the numbers from rows 4 thru 10.
Fill that function to the right to the right most cell.
Format The Sheet
-
Make the title stand out - Use Font, Background Color, and Borders
-
Make the High, Low, Average area stand out
-
Come up with a theme that allows the user to easily understand
which cells are made for data entry and which contain formulas.
-
Use borders to separate logical areas of data on the spreadsheet
|