homework

download You assist the office manager at Riverwalk Medical Clinic, a large outpatient medical facility that provides a wide range of medical and health services and programs to community members. One of the programs trains young volunteers to assist with patient care. You have collected data about two volunteer programs from 2016 to 2021 in an Excel workbook. Now you need to prepare the workbook for distribution at an upcoming meeting of management staff at the clinic who are inter-ested in expanding the programs. You want to include text in the workbook that you have stored in a Word document. a. Start Excel, open IL_INT_1-9.xlsx from the location where you store your Data Files, then save it as IL_INT_1_RiverwalkClinicVolunteerProgram. b. Start Word, open IL_INT_1-10.docx from the location where you store your Data Files, save it as IL_INT_1_VolunteerInformation, then close it. c. In a blank area of the Excel worksheet, insert the Volunteer Information file as an embedded ...

download As a member of the Beaver Island Arts Commission in Washington State, you are responsible for compiling the minutes of the commission’s quarterly meetings. You have already written most of the text required for the minutes. Now you need to insert data from Excel that shows how much money was raised from various fund-raising activities. a. Start Word, open IL_INT_1-11.docx from the location where you store your Data Files, save it as IL_INT_1_BeaverIslandArtsCommissionMinutes, start Excel, open IL_INT_1-12.xlsx from the location where you store your Data Files, then save it as IL_INT_1_BeaverIslandData. b. In Excel, open the Clipboard pane, clear all items if necessary, then copy the photograph and cell A2. c. In Word, open the Clipboard pane, paste the photograph at the top of the Word document, change the text wrapping of the picture to Square, then position the photograph to the right of the first paragraph, keeping within the green guidelines. d. Click to the le...

download Using the Data Files IL_INT_1-13.xlsx and IL_INT_1-14.docx, create the price list shown in FIGURE 1-14. Use formulas to calcu-late the prices for two-packs and four-packs. Save the workbook as IL_INT_1_GardenGourmetPriceList, and save the Word document as IL_INT_1_GardenGourmetInformation. Embed the Word document into the Excel worksheet, position the inserted file and the price list in Excel as shown in FIGURE 1-14, then format the embedded Word object as shown in FIGURE 1-14. (Hint: The indentation on both sides of the text is .3, and the font size is 12 point.) Add your name to the Excel worksheet in the cell indicated, save all files, submit them to your instructor, then close all files.

download As an accountant for Riverwalk medical clinic, you have been asked to review the expenses for the emergency room. You’ve organized the data in an Excel workbook, and now you want to format the data to improve its readability and highlight trends in expenses. a. Start Excel, open IL_EX_2-3.xlsx from the location where you store your Data Files, then save it as IL_EX_2_Riverwalk. b. Format the values in the Total column in the Accounting number format with two decimal places. c. Format the values in the % of Total column as Percent format with two decimal places. d. Format the values in the Inv. Date column with the Date format 14-Mar. e. Apply bold formatting to the column labels and increase the font size of the labels to 12. f. Italicize the inventory Type items in column A. g. Change the font of the Sales Tax label in cell K1 to Calibri. h. Apply the Title cell style to cell A1. i. Delete column I, then delete row 13. j. Merge and center the title in c...

download You are assisting the head of business operations at First Financial Services. You have been asked to format a worksheet showing the first-quarter business services for the company’s five branches. As part of this effort, you want to illustrate service trends among the branches. a. Start Excel, open IL_EX_2-4.xlsx from the location where you store your Data Files, then save it as IL_EX_2_FinancialServices. b. Enter a formula in cell B8 for the Main total, then copy the formula to the range C8:F8. c. Enter a formula in cell G3 for the Credit card processing total, then copy the formula to the range G4:G8. d. Apply the Title cell style to cell A1, apply the Heading 4 cell style to the column headings in row 2, and apply the Total cell style to the range A8:G8. e. Merge and center the title in cell A1 across the range A1:G1. f. Format the range B3:G8 using the Accounting number format. AutoFit the widths of all columns and format the range with no decimal places. g....

download Open IL_EX_2-5.xlsx from the location where you store your Data Files, then save it as IL_EX_2_EngineeringServices. Use the skills you learned in this module to format the worksheet so it looks like the one shown in FIGURE 2-30. (Note that cell A1 is selected in the figure.) Use the blue gradient fill for the data bars in the Total column. Use the Title cell style for the company name in cell A1, the Heading 1 cell style for the column labels in row 2, and the Total cell style for the total values in the last row. The font color for the service packages listed in column A is Dark Blue in the standard colors. (Hint: A row has been deleted from the worksheet.) Enter your name in the upper-left section of the header, check the spelling on the worksheet, save your changes, then submit your work to your instructor as directed.

download 1. Format values. a. Start Excel, open IL_EX_2-2.xlsx from the location where you store your Data Files, then save it as IL_EX_2_Investments. b. Format the range B3:B7 using the Accounting number format. c. Change the format of the date in cell B9 so it appears as 18-Jun. d. Increase the number of decimals in cell D1 to 1, using a button in the Number group on the Home tab. e. Save your work. 2. Change font and font size. a. Select the range A3:A7. b. Change the font of the selection to Calibri. c. Increase the font size of the selection to 11 point. d. Increase the font size of the label in cell A1 to 11 point. e. Save your changes. 3. Change font styles and alignment. a. Apply the Heading 2 cell style to cell A1. b. Use the Merge & Center button to center the label in cell A1 over columns A and B. c. Apply the italic and bold font formats to the label in cell C1. d. Use the Format Painter to copy the format in cell C1 to the label in c...