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

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

Home Furnishing Sales by Store and Month State Store Jan Feb Mar Washington 359,000 250,000 313,000 444,000 295,000 368,000 295,000 187,000 232,000 246,000 180,000 218,000 323,000 219,000 262,000 309,000 206,000 267,000 286,000 215,000 255,000 353,000 246,000 317,000 288,000 202,000 273,000 Oregon 325,000 228,000 281,000 373,000 275,000 334,000 319,000 197,000 301,000 377,000 231,000 305,000 338,000 227,000 292,000 432 West Fern Street Tacoma, WA 98444 (253) 555-3491 603 Street James Way Seattle, WA 98117 (206) 555-4325 618 Lewis Avenue Kennewick, WA 99337 (509) 555-3991 990 Waterside Street Spokane, WA 99208 (509) 555-9369 916 Cermak Avenue Renton, WA 98055 (425) 555-728 446 Hadley Lane Everett, WA 98201 (425) 555-8654 251 Pulaski Avenue Bremerton, WA 98337 (360) 555-9913 51 Merrimac Lane Vancouver City, WA 98662 (360) 555-8483 792 Winnemac Avenue Yakima, WA 98901 (509) 555-3947 250 3rd Street Salem, OR 97301 (503) 555-7661 104 Pacific Lane Portland, OR 97233 (503) 555-6026 31 Shore Avenue Corvallis, OR 97333 (541) 555-5657 960 Mount Lane Hillsboro, OR 97123 (503) 555-5976 943 Stark Street Gresham, OR 97030 (503) 555-2478

Apr May Jun Jul Aug 283,000 337,000 285,000 329,000 352,000 379,000 363,000 421,000 444,000 399,000 253,000 277,000 280,000 288,000 291,000 223,000 236,000 249,000 274,000 281,000 250,000 284,000 299,000 332,000 310,000 276,000 295,000 298,000 285,000 308,000 249,000 250,000 277,000 279,000 293,000 306,000 307,000 324,000 342,000 334,000 262,000 276,000 312,000 304,000 277,000 270,000 298,000 324,000 331,000 303,000 336,000 362,000 356,000 311,000 408,000 300,000 296,000 334,000 298,000 292,000 289,000 295,000 348,000 345,000 358,000 306,000 284,000 332,000 328,000 319,000

259,000 271,000 300,000 307,000 281,000 251,000 262,000 306,000 290,000 321,000 374,000 372,000 367,000 411,000 402,000 267,000 293,000 318,000 317,000 318,000 214,000 236,000 259,000 267,000 267,000 182,000 177,000 206,000 240,000 221,000 5,529,000 5,771,000 6,195,000 6,322,000 6,335,000

270,000 267,000 312,000 397,000 277,000 257,000 334,000 374,000 355,000 362,000 464,000 485,000 321,000 251,000 323,000 407,000 228,000 207,000 251,000 298,000 193,000 202,000 240,000 282,000 5,837,000 5,585,000 6,760,000 7,879,000

328,500 397,417 271,250 249,417 301,083 291,333 275,000 328,750 285,667 306,250 352,583 303,333 334,250 317,750