Illustrated Excel 365/2021 | Module 6: SAM Project 1a скачать в хорошем качестве

Illustrated Excel 365/2021 | Module 6: SAM Project 1a

Illustrated Excel 365/2021 | Module 6: SAM Project 1a #illustratedexcel #module6 #samproject1a Contact Me: WhatsApp No:+1(725) 272-9378 Illustrated Excel 365/2021 | Module 6: SAM Project 1a #illustratedexcel #module6 #samproject1a 1. "Kendra Liang is a senior producer at MusicBot, an online source for all types of music. Kendra is using an Excel workbook to analyze sales for the first year of the online service. She asks you to update the workbook and make the data more secure and easier to understand. Go to the Quarter 1 worksheet and then unprotect the worksheet so you can update it." Unprotect a worksheet. 2. "Kendra wants to focus on the Quarter 1 revenue from CDs and vinyl sales, which are the lowest category of sales. Create a custom view as follows: a. Hide rows 3:20 to display only the CDs and Vinyl category of sales. b. Select cell G1 and then create a custom view using CDs_Vinyl as the name." Create a custom worksheet view. 3. Display the Quarter 1 worksheet using the custom view Q1_All_Categories, which Kendra already created, to redisplay all of the data. Apply a custom view to a worksheet. 4. "Kendra hid the Quarter 3 worksheet because she still needs to verify the sales figures. However, she wants to change an unnecessary setting in the worksheet. Update the worksheet as follows: a. Unhide the Quarter 3 worksheet so you can edit it. b. Unfreeze the first column because the worksheet is not wide enough to require horizontal scrolling." Unfreeze rows. 5. "The company recently changed its name from MusicBot Online to MusicBot. Kendra asks you to change the name on all worksheets. Group the Quarter 1, Quarter 2, Quarter 3, Quarter 4, and Current Month worksheets, and then change the company name to MusicBot in merged cell A1." Enter text in a cell. 6. With the worksheets still grouped, format cell A1 using the Orange, Accent 1, Lighter 80% fill color to provide more visual interest to all five worksheets. Change the fill color of cells. 7. With the worksheets still grouped, set a 1" custom margin at the Top of the worksheets to prepare for printing the data. Ungroup the worksheets. Set custom margins for a worksheet. The Quarter 1, Quarter 2, Quarter 3, Quarter 4, and Current Month worksheets should contain a 1" custom margin at the top of the worksheets to prepare for printing the data. 8. "Kendra wants to add a hyperlink to the worksheets to make it easier to navigate. She asks you to add the first hyperlink to show her how it works. She also wants to add a hyperlink to the company website and another to her email address so people reviewing the workbook data can contact her. Add hyperlinks to the Quarter 1 worksheet as follows: a. On the Quarter 1 worksheet, type Quarter 2 in cell A27 to enter the text to use as a hyperlink. b. In cell A27, add a hyperlink that links to cell A1 of the Quarter 2 worksheet in the current workbook. c. Add a ScreenTip using Next Quarter as the ScreenTip text. d. In cell A28, add a hyperlink that links the ""MusicBot website"" text to the www.musicbot.example.com website. e. In cell A29, add a hyperlink that links the ""Contact Kendra Liang"" text to the [email protected] email address." Enter text in a cell. Format text as a hyperlink to a worksheet cell. Set the ScreenTip for a hyperlink. Format text as a hyperlink. In the Quarter 1 worksheet, the hyperlink in cell A28 should link to the web address www.musicbot.example.com . Hyperlink to an email address. In the Quarter 1 worksheet, cell A29 should contain a hyperlink to the email address [email protected]. 9. Use the hyperlink in cell A27 to go to the Quarter 2 worksheet. In cell A3, remove the hyperlink, which Kendra no longer needs. Remove a hyperlink. new perspectives excel 2019 | module 1: end of module project 2,shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 module 1 sam project 1a,new perspectives excel 2019 | module 2: sam project 1a,excel module 8 sam project,module 5: sam project 1a,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 module 2 end of module project 1