Gerry Henry surfing, one of the owners of Southside Surf Shop, wants to commission an artist to create new board logos for the company. Mr. Henry has created an Excel workbook that lists the artists and their commission prices. He has also narrowed the field down to four logos and placed them in a PowerPoint presentation. He has asked you to complete both files.
For this assignment, you will need the following files:
You will save your files as:
- Open the file Board Logos.
- Save as Lastname_Firstname_Logos_Board_Logos
- Adjust the column widths so that all data displays and apply a cell style to the title.
- Create a chart to display the Last Name and Commission on a new sheet with an applicable name.
- Format the chart using a chart layout and a chart style.
- Insert at least two comments on the Artists worksheet.
- Rename the data sheet with a descriptive name.
- Insert the your name in the footer of all worksheets.
- Save the file as Lastname_Firstname_Board_Logos
- Open the file Logos_Presentation.
- Save the presentation as Lastname_Firstname_Logos_Presentation.
- Insert the file name in the handouts footer.
- In the presentation, apply a design theme.
- Add titles containing the names of artists to the slides; select any names from the Excel workbook.
- For each logo, adjust the size or add an effect.
- Insert a new slide at the end of the presentation, and then Paste link the Excel chart, and resize it as necessary.
- Insert the your name in the footer.
Upload the completed assignment files in the Assignment area.
- Special Instructions: Use the Supporting Materials below to complete the project.
- Grading: Please review the rubrics for particulars.
You consistently applied the relevant skills.
You mostly applied the relevant skills.
You sometimes, but not always, applied the relevant skills.
You rarely or never applied the relevant skills.
Create and format chart in Board_Logos worksheet
Chart is created, moved to its own sheet, and formatted accurately
Chart is created, but there are two or fewer errors in placement or formatting
Chart is created, but there are more than two errors in placement or formatting
Chart is not created, or it is not moved and formatted
Insert two comments in Board_Logos_worksheet
Two comments are inserted and placed accurately in the worksheet
Two comments are inserted and placed with two or fewer errors
Two comments are inserted and placed with more than two errors
Comments are not inserted in the worksheet
Format Logos_ Presentation
Formatting is applied to the presentation: Design theme, titles added, images resized or formatted accurately
Table is exported and modifications are made, but there are two or fewer errors
Table is exported and modifications are made, but there are more than two errors
Table is not exported and/or modifications are not made
Insert a new slide in Logos_Presentation with link to Excel chart
New slide inserted, and Excel chart is linked to the presentation accurately
New slide inserted, and Excel chart is placed with two or fewer errors
New slide inserted, and Excel chart is placed with more than two errors
New slide is not inserted