Order from us for quality, customized work in due time of your choice.
Hide Folder Information
Instructions
For a demonstration, see https://www.youtub
Hide Folder Information
Instructions
For a demonstration, see https://www.youtube.com/watch?v=knmOmEuFO1k&t=86s
Lab7 starter file is attached
Lab 7 Purpose
To demonstrate Microsoft Excel, including formulas, functions, graphs, autofill, autosum, graphs, header, etc.
l
Lab 7 Criteria
File zipped with proper name (5%)
Zip contains folder (5%)
Folder has proper name (5%)
Folder contains xlsx file with proper name (5%)
File contains completed introductory activities at the top of the sheet (5%)
File contains proper months (5%)
File contains completed income row (5%)
File contains completed income totals (5%)
File contains completed expense rows (5%)
File contains completed expense totals, by month and grand total (10%)
File contains a formula to take income and subtract from it expenses for each month (10%)
File contains a chart based, on just income-expenses (10%)
File contains proper header (5%)
Appropriately saved and submitted (20%)
BONUS
Select sheet2; create your own budget.
Make sure to have at least two kinds of income
total by month and by income type
Make sure to have at least four kinds of expenses
total by month and by income type
Take each months total income and subtract from it each month’s total expenses
Make a chart based on the monthly profit
Add a header
Remove my instructions from sheet2
Change the format colors
When finished with sheet2, File>Save As>yourname-my-budget.xlsx in the lab7 folder
Refer to sheet1 if you can’t remember how to do any of the steps.
Close excel
Browse to the lab7 folder, right click and compress, naming it yourname-lab7.zip
Submit
You will may wind up with 2 files, yourname-budget.xlsx and yourname-my-budget.xlsx;
Zip the folder that contains those two files, and rename the zip yourname-lab7.zip
Help with D2L, updated
Order from us for quality, customized work in due time of your choice.