Computer science

Excel Assignment No. 2: Create a spreadsheet to display the sales for your five main products for the last four weeks.

Element #
1. Place a title for your worksheet (e.g. Last Month’s Sales) at the top of the spreadsheet. Center it over your table using the “Merge and Center” button on the toolbar (near the alignment buttons). See help if necessary. Use a size 16 font for your labels and the default font size for your data. Use any color except black for your labels.
2. Create a spreadsheet that lists products down the left column and Weeks 1 through 4 across the top row. Enter fictitious data for sales for each week by product. Make the product names and the week names bold. Do not bold the data.
3. Use the Sum function to add the totals for each week for all products (at the bottom) and the Sum function to add the totals for each product for all four weeks (right side).
4. In the row beneath the sum function for the product totals, use the Average Function to calculate the average sales per week. You do not need to calculate the average for each product on the right side.
5. Format the data to Currency with decimal points to two places (e.g. $365.43) for all data, totals, and products of the functions. In other words, everything.
6. Set each column width to 12. Set all row heights to 20.
7. In page setup, create a footer that has your name and the date the sheet was created, choose landscape, and center horizontally and vertically.
8. Set the print area to include all the data in the table you have created.
9. Using the chart command, chart the data (be careful not to include the totals or averages in your range) using a bar chart. Choose the option that places the chart in your spreadsheet and not as a separate sheet. Your chart should show all five products together grouped by weeks. This should happen automatically.
10. Follow project “Internet Café” theme. Spell and grammar check your work and save the file with your initials at the beginning of the name (e.g. AN_P2.xlsx).
PowerPoint Assignment No. 3: Create a presentation for your new business to explain to lenders why they should loan you money to expand your business.

Element #
1. Your presentation should consist of five slides, including the title slide, two bullet slides, one graph slide, and one bulleted summary slide.
2. Choose and use a design template for your presentation.
3. Insert clip art on at least four of the slides.
4. Place: 1) a logo, 2) page numbers and 3) a date in the master slide (see PowerPoint help if necessary).
5. Create a graph (bar chart or line chart) on one slide to show increasing sales over the last year. You can use the charting function inherent in PowerPoint or embed the chart created for assignment 2 (Excel) (copy and paste) from Microsoft Excel (Unit C).
6. Create speaker notes on each of the slides using the notes function in PowerPoint.
7. Use at least two colors for your fonts, at least two font styles, and at least two different font sizes.
8. Set the preset timings and create transitions for each slide for the online presentation mode.
9. Omit the background from the graph chart only, and change its background to a solid color (other than white) of your choice.
10. Follow project “Internet Café” theme. Spell and grammar check your work and save the file with your initials at the beginning of the name (e.g. AN_P3.pptx)