Excel 2021 In Practice - Ch 5 Independent Project 5-4 | Excel 2021 - Ch 5 Independent Project 5-4 скачать в хорошем качестве

Excel 2021 In Practice - Ch 5 Independent Project 5-4 | Excel 2021 - Ch 5 Independent Project 5-4

#Excel2021InPracticeCh5IndependentProject5_4,#InPracticeCh5IndependentProject5_4,#ExcelCh5IndependentProject5_4,#IndependentProject5_4,#In_Practice_Ch5_Independent_Project_5-4,#Excel_Ch5_Independent_Project_5_4,#Excel_2021_In_Practice_Ch5_Independent_Project_5_4,#Independent_Project_5_4 Contact me for your assighnments and full course: Email : mylabcommunity@gmail.com WhatsApp : +923017351754 WhatsApp Direct Chat : https://tinyurl.com/4e2emedu Independent Project 5-4 : 1. Open the WilsonHome-05 start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Group, edit, and format sheets. a. Click the Rockford sheet tab, press Shift, and click the CashFlow tab. The Rockford sheet is visible so that you will be able to see format changes. The Vendors sheet is not part of the group. b. Click the launcher in the Page Setup group [Page Layout tab] and click the Margins tab. c. Choose Horizontally from the Center on page list and click OK. d. Edit the contents of cell A10 to read Cash paid for marketing. 3. Format values for negative number display. a. Select cells B4:B25 and click the Number launcher [Home tab, Number group]. b. Select Currency as the Category. c. Choose 0 decimal places. d. Confirm or select $ as the Symbol. e. Select the option to display negative numbers in red with parentheses. f. Click OK. 4. Insert formulas on grouped sheets. a. Select cell B13 and click the AutoSum button [Home tab, Editing group]. b. Reselect the range B4:B12 and press Enter. c. Select cell B22 and sum cells B15:B21. d. Select cell B23. The formula adds cell B13 and B22. e. Select cell B24. This value is manually entered on each location sheet. f. Select cell B25. The formula adds cell B23 and B24. g. Select cell A1 and ungroup the sheets. 5. Build three static data consolidations for the Cash Flow sheet. a. Click the CashFlow sheet and select cells B4:B12. b. Use Sum to consolidate the data from the Peoria, Champaign, and Rockford sheets. c. Select cells B15:B21 and consolidate data from the location sheets. For this command, you will need to delete the existing references in the Consolidate dialog box. d. Select cell B24 and consolidate the cash balances from the location sheets. 6. Insert a picture from a file. a. Delete the contents of cell A1 on the CashFlow sheet. b. Set the row height for row 2 at 35. c. Click cell D2 and insert the Wilson picture file from downloaded from the Resources link. d. Click the Height box [Picture Format tab, Size group]. e. Change the height to .75″. f. Position the image to cover cells B1:B2 7. Insert and copy a hyperlink. a. Click cell C3 on the Peoria worksheet. b. Create a hyperlink that displays Total Cash Flow and switches to cell A1 on the Cash Flow worksheet c. Right-click cell C3 (the hyperlink) and choose Copy from the menu. d. Select the Champaign sheet tab and paste the hyperlink in cell C3. e. Select the Rockford sheet tab and paste the hyperlink in cell C3 f. Select the Peoria sheet, and press Esc to remove the copy marquee if it is still visible. g. Select cell C5 and then click the cell to test the hyperlink. 8. Assign the Stocks data type. a. Click the Vendors sheet tab. b. Select cells A4:A9. c. Click the Stocks button [Data tab, Data Types group]. The company names are located and linked to online data. Capitalization is not consistent. ALTERNATE INSTRUCTION: Delete and copy a worksheet. a. Select and delete the Vendors worksheet. b. Open the WilsonHome-05Supplement workbook from your downloaded from the Resources link. c. Copy the Vendors worksheet in WilsonHome-05Supplement to be the rightmost tab in [your name]- WilsonHome-05. d. Close the WilsonHome-05Supplement workbook without saving it. e. Select the Vendors sheet in [your name]-WilsonHome-05. The data was sourced from linked data types and does not display current prices. Capitalization is not consistent but reflects data type origination. 9. Format data as a table and add columns. a. Select cells A4:A9 and format the cells as a table with White, Table Style Medium 1. The data does not have headers. b. Select cell A5 for AMD and click its Add Column button. The Insert Data button becomes the Add Column button when the data is formatted as a table. c. Select the High field to insert a column. d. Click the Insert Column button again and choose Low for the next column. e. Insert the Price field as the next column. f. Edit the label in cell A4 to Name, Exchange, and Ticker. g. AutoFit column A