NP_EX_2_Sales_CameronWright_Report_1

Cameron Wright GE ver. 17.0.1-rc0000 1. To format the company name 0/2 In the Documentation worksheet, cell A2 should be formatted using a 16 point font size. To change the font color of the company name and slogan 2/2 2. To change the font and fill colors in the Documentation sheet 0/2 To change the tab color of the Documentation sheet 0/2 In the Documentation worksheet, the worksheet tab should be formatted using the Gold, Accent 4 tab color. To add a background image to the Documentation sheet 2/2 3. To calculate Bristol Bay's sales and profit/loss 2/2 To calculate the per-store statistics 0/2 In the Sales Report worksheet, cell C16 should contain the formula C7/C22 and display the value 1078900. To calculate the net and percent changes 0/2 In the Sales Report worksheet, one or more cells in the range E7:E9 contains an incorrect formula. To calculate different subtotals of the gross sales 0/2 In the Sales Report worksheet, one or more cells in the range P27:P45 contains an incorrect formula. 4. To format the gross sales in the Accounting format 2/2 To decrease the number of decimal places in the report 2/2 To format the percent change values as percentages 0/2 In the Sales Report worksheet, the range F6:F9 should be formatted using two decimal places. To format the date in the Long Date format 2/2 5. To left-align the date and center the column titles 2/2 To indent the expense categories 0/2 In the Sales Report worksheet, the range B7:B8 should be indented two times. To add borders to the sales statistics data 0/2 To format the monthly sales data 2/2 To merge the state name cells 2/2 To rotate the state names 2/2 6. To use the Format Cells dialog box to format the column titles 2/2 To format the row titles 3/3 7. To calculate the average monthly sales for each store 0/3 In the Sales Report worksheet, cell R25 does not contain the expected text. To add a double border to the state results 0/3 8. To apply cell styles to the Sales Report worksheet 0/3 In the Sales Report worksheet, cell A24 should be formatted using the Title cell style. To create the Bristol Bay Title custom cell style 3/3 9. To use the Format Painter to copy and paste a format 0/3 To copy and paste multiple formats in the sales statistics data 0/3 10. To find and replace the street abbreviations 0/3 To replace all occurrences of "Ave." and "Ln." 3/3 11. To change the workbook's theme 3/3 12. To highlight negative values in red 3/3 To edit the Top 10% conditional formatting rule 3/3 To document the top 5% conditional formatting rule 0/3 13. To set the print area of the Sales Report worksheet 3/3 To remove the automatic page breaks and insert manual page breaks 0/3 The Sales Report worksheet should include a page break at cell O23. To set the print titles 0/3 In the Sales Report worksheet, print titles should span rows 1 to 2 and columns A to B. To rescale the printout 0/3 The Sales Report worksheet should be printed on four pages. To set up the page header 0/3 The Sales Report worksheet should have a first page header that contains the file name and date. To create the page footer 0/3 To set the left margin 0/3 The Sales Report worksheet should be formatted using a 1" left margin. SUBMISSION #1 | SCORE IS: 43 OUT OF 100 Formatting Cell Text Working with Fill Colors and Backgrounds In the Documentation worksheet, the range B4:B6 should be formatted using the White, Background 1 fill color. Using Functions and Formulas with Sales Data Formatting Numbers Formatting Worksheet Cells In the Sales Report worksheet, cells in the range B11:F11 should be formatted using a top and bottom cell border. Exploring the Format Cells Dialog Box Calculating Averages In the Sales Report worksheet, cells in the range A26:N34 should be formatted using a double outline cell border. Applying Cell Styles Copying and Pasting Formats In the Sales Report worksheet, cell A1 should be formatted using a 28 point font size and the Light Blue fill color. In the Sales Report worksheet, the range B14:F14 should be formatted using a bottom cell border. (Hint: This step will be marked correct when the theme is changed in Step 11.) Finding and Replacing Text and Formats In the Sales Report worksheet, cell B27 should contain the text "603 St. James Way Seattle, WA 98117 (206) 555-4325". Working with Themes Highlighting Data with Conditional Formats In the Sales Report worksheet, cells M23:N24 should employ text and color to indicate that the green cells in the range C26:N45 represent the Top 5% in Sales. Formatting a Worksheet for Printing The Sales Report worksheet should have a footer that contains the page number in the center section on all pages after the first page. New Perspectives Excel 365/2021 | Module 2: Textbook Project

Your Value Store Author Cameron Wright Date Friday, October 20, 2023 Purpose Bristol Bay To summarize sales data in the Home Furnishing department from 20 stores in the Northwest region

Bristol Bay Your Value Store Home Furnishing Sales (Northwest Region) Category Current Year Previous Year Net Change Gross Sales $ 72,676,000 $ 70,531,000 $ 2,145,000 Cost of Sales 21,578,000 22230000 -652000 Operating Expenses 45850000 43150000 2700000 Net Profit/Loss $ 5,248,000 5151000 97,000 Items Sold 1,400,800 1360400 40,400 Average Home Furnishing Sales per Store (Northwest Region) Category Current Year Previous Year Net Change Gross Sales 3633800 3712157.89474 -78357.894737 Cost of Sales 2292500 1170000 -91100 Operating Expenses 2271052.63158 21447.36842 Net Profit/Loss 262400 271105.263158 -8705.26316 Items Sold 70040 71600 -1560 Stores 20 19

% Change 3% -3% 6% 2% 3% % Change -0.0211084488 -0.07786325 0.009443801 -0.03211027 -0.0217877095