PROFESSIONAL ACADEMIC STUDY RESOURCES WEBSITE 
+1 813 434 1028 
proexpertwritings@hotmail.com
PowerPoint 1A State Sales
Description
In this Project, you will export Access data into an Excel workbook, and then you will copy and paste Word data into the Excel workbook. In Excel, you create a chart based on the data and then copy the chart into a PowerPoint presentation.
Steps to Perform:
| Step | Instructions | Points Possible |
| 1 | Open the PowerPoint file Student_i01A_Sales_Presentation.pptx downloaded with this project. If necessary, click Enable Editing. | 0 |
| 2 | Minimize the PowerPoint presentation, and then open the Access file i01A_Store_Locations.accdb downloaded with this project. If necessary, click Enable Content. In the Navigation Pane, double-click the Managers table. At the bottom of the table, select First, type Office and then press TAB to select Last. Type Student and then press ENTER. | 3 |
| 3 | In the Navigation Pane, double-click the query Store Locations by Manager, and then be sure that Office Student displays four times. On the External Data tab, in the Export group, click Excel. In the Export – Excel Spreadsheet dialog box, click Browse. Navigate to the location where you are storing your files for this Project. Using your own name, type the File name Lastname_Firstname_1A_Sales_Chart and click Save. (my name is Zachary Krauss Use this for all future lastname and firstname prompts, Thank you) | 3 |
| 4 | In the Export – Excel Spreadsheet dialog box, be sure that the File format is Excel Workbook (*.xlsx). In the Export – Excel spreadsheet dialog box, click OK. In the dialog box, be sure that the Save export steps check box is not selected, and then click Close. Close Access. | 0 |
| 5 | Open the Excel file you just created with your name, Lastname_Firstname_1A_Sales_Chart. From the Page Layout tab, apply the Office theme. Click cell A1. On the Insert tab, in the Tables group, click Table. In the Create Table dialog box, under Where is the data for your table?, be sure that the range is =$A$1:$E$21 and that the My table has headers check box is selected. In the Create Table dialog box, click OK. | 6 |
| 6 | With the columns selected, on the Home tab, in the Cells group, click Format, and then click AutoFit Column Width. Click cell E1, click the Filter arrow, and then click Sort A to Z to sort the entire table alphabetically by City name. | 6 |
| 7 | With cell E1 as the active cell, on the Design tab, in the Table Style Options group, select the Total Row check box. Click cell E22. To the right of cell E22, click the arrow and then click None. Click cell C22. To the right of cell C22, click the arrow and then click Sum. Click cell A1. Save your workbook but do not close it. | 6 |
| 8 | Select the range A1:E22. On the Home tab, in the Clipboard group, click Copy. From the taskbar, display the open the PowerPoint presentation Student_i01A_Sales_Presentation.pptx. Select Slide 3. On the Home tab, in the Slides group, click the New Slide arrow, and then click Blank. On the Home tab, in the Clipboard group, click the Paste arrow, and then click the Keep Source Formatting (K) option. | 3 |
| 9 | From the files downloaded with this Project, open the Word document i01A_State_Sales.docx. If necessary, click Enable Editing, and then using your own name, Save the file in your storage location as Lastname_Firstname_1A_State_Sales. Click anywhere in the table at the bottom of the page. On the Table Tools Layout tab, in the Table group, click Select, and then click Select Table. On the Home tab, in the Clipboard group, click Copy. Leave the Word document open. From the taskbar, display your Lastname_Firstname_1A_Sales_Chart.xlsx Excel file. At the bottom of the worksheet, click New sheet to insert a new blank worksheet. Right-click the Sheet1 worksheet tab, and then click Rename. Type Sales and press ENTER. | 0 |
| 10 | Click cell A3 to make it the active cell. On the Home tab, in the Clipboard group, click the upper portion of the Paste button. In cell F3, type Total Sales and press ENTER. | 3 |
| 11 | Select columns A:F. On the Home tab, in the Cells group, click Format, click Column Width, type 14 and then click OK. | 3 |
| 12 | With the columns still selected, in the Font group, click the Borders button arrow, and then click No Border. | 4 |
| 13 | Select rows 3:15. On the Home tab, in the Cells group, click Format, click Row Height, type 15 and then click OK. | 3 |
| 14 | In cell A1, type Ultimate Action Sports Gear and then press ENTER. In cell A2, type Sales by State and then press ENTER. Apply Merge & Center to the range A1:F1 and then apply the Title cell style. Apply Merge & Center to the range A2:F2 and then apply the Heading 1 cell style. | 4 |
| 15 | Select the range A3:F3, apply the Heading 3 cell style, and then apply Center. | 4 |
| 16 | Click cell F4. On the Home tab, in the Editing group, click AutoSum, and then on the Formula Bar, click Enter. Copy the formula down through cell F15. | 4 |
| 17 | Click cell A16, type Total and then press TAB. With cell B16 selected, in the Editing group, click AutoSum, and then on the Formula Bar, click Enter. Copy the formula across to cell F16. | 5 |
| 18 | Select the non-adjacent ranges B4:F4 and B16:F16, and then from the Cell Styles gallery apply the Currency [0] number format. Select the range B16:F16 and apply the Total cell style. Click cell A1. With the Sales worksheet displayed, save your workbook but do not close it. | 4 |
| 19 | From the taskbar, display the open the PowerPoint presentation Student_i01A_Sales_Presentation.pptx. With Slide 4 displayed, on the Home tab, in the Slides group, click the New Slide arrow, and then click Blank. With Slide 5 displayed, on the Insert tab, in the Text group, click Object. Click the Create from file option. Click Browse, and navigate to and select your saved Excel workbook Lastname_Firstname_1A_Sales_Chart.xlsx. Confirm that the Display as icon option is not selected, and then click OK. | 3 |
| 20 | Leave the PowerPoint presentation open. From the taskbar, display your Lastname_Firstname_1A_Sales_Chart.xlsx file. On the Sales worksheet, select the range A3:E15. On the Insert tab, in the Charts group, click the Insert Column or Bar Chart arrow, and then under 2-D Bar, click the first chart—Clustered Bar. On the Design tab, in the Location group, click Move Chart. In the Move Chart dialog box, click the New sheet option button, type Merchandise Chart and then click OK. | 6 |
| 21 | In the chart, click the text Chart Title, type Retail Sales by State and press ENTER. Click in a blank area of the chart to deselect the chart title. | 3 |
| 22 | To the right of the chart, click Chart Styles. In the Style gallery, scroll down, and then by using the ScreenTips, locate and click Style 10. Click outside of the chart to deselect it. | 3 |
| 23 | Click the Sales worksheet tab. Select the range B3:E3, press and hold CTRL, and then select the range B16:E16. On the Insert tab, in the Charts group, click the Insert Pie or Doughnut Chart arrow, and then under 2-D Pie, click Pie. On the ribbon, on the Chart Design tab, in the Location group, click Move Chart. In the Move Chart dialog box, click the New sheet option button, type State Sales Chart and then click OK. | 6 |
| 24 | To the right of the chart, click Chart Styles. In the Style gallery, scroll down, and then by using the ScreenTips, locate and click Style 9. Press ESC to close the gallery. | 3 |
| 25 | In the chart, click the text Chart Title, type STATE SALES and then press ENTER. Click outside of the chart to deselect it. | 3 |
| 26 | On the Home tab, in the Clipboard group, click the Dialog Box Launcher button to display the Clipboard pane. In the Clipboard pane, click Clear All and then close the Clipboard pane. Click the border of the pie chart to select the chart. On the Home tab, in the Clipboard group, click Copy. Click the Merchandise Chart sheet tab, and then click the border of the bar chart to select the chart. In the Clipboard group, click Copy. Save and close Excel. From the taskbar, display your Word document, Lastname_Firstname_1A_State_Sales.docx. Press CTRL+END to move the insertion point to the end of the document. Press CTRL+ENTER to create a new page. | 0 |
| 27 | With the insertion point at the top of Page 2, type In the chart below, our state sales managers can view their sales results. (include the period). Press ENTER. | 0 |
| 28 | On the Home tab, in the Clipboard group, click the Dialog Box Launcher button to display the Clipboard pane. In the Clipboard pane, click the bar chart to paste it into the Word document and then close the Clipboard pane. Save your Word document, and then Close Word. | 0 |
| 29 | From the taskbar, display the open the PowerPoint presentation Student_i01A_Sales_Presentation.pptx. Display Slide 2. On the Home tab, in the Slides group, click the New Slide button arrow, and then from the Slides gallery, click Blank. On the Home tab, in the Clipboard group, click the Dialog Box Launcher button. In the Clipboard pane, click the bar chart to paste the chart into Slide 3 of the presentation. | 3 |
| 30 | On the Home tab, in the Slides group, click the New Slide button arrow, and then from the Slides gallery, click Blank. In the Clipboard pane, click the pie chart. Close the Clipboard pane. | 3 |
| 31 | Click Slide 2 to make it the active slide. Click in the placeholder containing the names of the managers, and then click the dotted line surrounding the names to make it a solid line indicating the entire placeholder is selected. On the Home tab, in the Paragraph group, click Convert to SmartArt. In the SmartArt gallery, in the first row, click the fourth layout—Target List. If the Text Pane displays to the left of the SmartArt placeholder, click Close. | 6 |
| 32 | Save your PowerPoint presentation and close PowerPoint. |