Q PC Users PC users with Office 2013 or 365 follow directions in Excel Chapter 1 Creating a Worksheet and Charting Data to create Project 1A. Office 2016 users do not need to create PDF file of selection. No data file needed for this assignment. Project: 1A_Quarterly_Sales Task Points Enter accurate data per instructions 2 Enter a title and a subtitle into a new worksheet, merge cells and center 1 Apply Title style to cell A1, Heading 1 style to cell A2, Heading 4 style to Column and Row titles 1 Enter row titles in the first column, enter month names in the range B3:D3 1 Adjust column A width to 120 pixels 1 Center range B3:D3 1 Sum values in B8:E8 and E4:E7 4 Apply Accounting Number Format to B4:E4 and B8:E8; apply Comma Style to range B5:E7; apply Total style to B8:E8 2 Change Workbook theme to Retrospect 1 Insert first recommended Clustered Column chart using correct data in range A3:D7 1 Update Chart Title, apply Style 6 from Chart Style gallery to chart, apply Color 3 variation, reposition chart 1 Based on the data in B4:D7, insert sparklines with markers in F4:F7; format sparklines with Sparkline Style Accent 4, Darker 25% 1 Page layout in Portrait orientation and centered horizontally 2 Add footer/properties as instructed 1 Total Points 20 Copyright © 2014 Pearson Education, Inc. Publishing as Prentice Hall Mac Users Mac users with Office 2016 2011 or 365 follow directions in Excel Chapter 1 Creating a Worksheet and Charting Data to create Project 1A. No data file needed for this assignment. Project: 1A_Quarterly_Sales Task Points Enter accurate data per instructions 3 Adjust column widths per instructions 1 Sum values in B8:E8 and E4:E7 4 Merge and center title and subtitle 2 Apply cell styles per instructions 1 Embed column chart using correct data 3 Change chart title to 1st Quarter Sales 1 Use month names as categories 1 Insert sparklines with markers 1 Remove unused worksheets 1 Page layout in Portrait orientation and centered horizontally 1 Insert footer with file name and add document properties with name and keywords 1 Total Points 20 Copyright © 2013 Pearson Education, Inc. Publishing as Prentice Hall PreviousNext

View Related Questions