Module 2 Formatting a Worksheet - Independent Challenge 1

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 cell A1 over columns A1:I1.
k. Resize column widths as necessary, using AutoFit or by dragging, so that all columns are wide enough to display the data and labels.
l. Use the Format Painter to copy the date format in the Inv. Date column to the values in the Inv. Due column.
m. Change the fill color of the sales tax information in the range J1:K1 to the Light Turquoise, Background 2 color (first row, third column from the left).
n. Change the font color of the sales tax information in the range J1:K1 to the Dark Teal, Text 2 color (first row, fourth column from the left).
o. Add a bottom border to the column labels.
p. Use conditional formatting to apply blue gradient data bars to the Total column data. Do not include the total in cell H38 at the bottom of the column.
q. Add the 3 Arrows (Colored) (first set in the Directional group) icon set to the Quantity column to illustrate the relative differences between quantities. Do not include the total in cell E38 at the bottom of the column in this format.
r. Rename Sheet3 to Budget and rename Sheet1 to Actual. Change the color of the Budget sheet to Red in the Standard colors. Change the color of the Actual sheet to Purple in the Standard colors.
s. Move Sheet2 to the right of the Budget sheet.
t. Activate the Actual Sheet and spell check the worksheet. Correct any spelling errors.
u. Using Find and Select, replace all instances of Maxi on the worksheet with ACE.
v. Delete Sheet2, enter your name in the center section of the Actual worksheet header, enter the sheet name in the center section of the worksheet footer, then save the file.
w. Preview the Actual worksheet in Backstage view. Compare your worksheet to FIGURE 2-28.
x. Submit your work to your instructor as directed, close the workbook, then close Excel.

Comments

Post a Comment

Popular posts from this blog

Module 1 Getting Started with Excel - Independent Challenge 1

download The CFO at Riverwalk Medical Clinic has hired you to help him analyze departmental insurance reimbursements. He also would like to see what quarterly revenues would look like with a 20% increase in quarterly reimbursements. You’ve been given a worksheet for this project that contains some but not all of the data. a. Open IL_EX_1-3.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Reimbursements. b. Enter the data shown in TABLE 1-4 in the range E4:E11. c. Type your name in cell A17. d. Move the label in cell F2 to cell A15. e. Use the Clipboard to copy and paste the label in cell F3 to cell A12. f. Use the formula bar to correct the spelling error in the label in cell A6. (Hint: The correct spelling is Immunology.) g. Edit cell A8 to correct the spelling error in the label. (Hint: The correct spelling is Ophthalmology.) h. Type Quarter 1 in cell B3, then use Auto Fill to enter Quarter 2, Quarter 3, and Quarter 4 in the range C3...
Read more

Module 1 Creating Documents with Word - Visual Workshop

download Create the letter shown in FIGURE 1-34. Before beginning to type, click the No Spacing button in the Styles group on the Home tab. Type the letter before formatting the letterhead and applying the theme. To format the letterhead, change the font size of the first line of text to 40 point and apply the Gradient Fill: Blue, Accent 5, Reflection WordArt style. Change the font color of the address line to Blue, Accent 5. Add the bottom border to the letterhead. When the letterhead is formatted, change the font size of the body text to 12 point, apply the Organic theme, then change the font color of the letterhead text to Green, Accent 1. Save the document as IL_WD_1-SakuraDoksa to the location where you store your Data Files, submit the letter to your instructor, then close the document and exit Word.
Read more

Module 1 Creating Documents with Word - Independent Challenge 1

download You work at the Riverwalk Medical Clinic, a large outpatient medical facility staffed by family physicians, specialists, nurses, and other allied health professionals. Your boss has drafted an information sheet to help seasonal allergy sufferers and asks you to edit and format it so that it is eye catching and attractive.  a. Open the file IL_WD_1-5.docx from the drive and folder where you store your Data Files, save it as IL_WD_1_AllergyInfo, then read the document to get a feel for the content. FIGURE 1-32 shows how you will format the info sheet. FIGURE 1-32 Riverwalk Medical Clinic Advice for Seasonal Allergy Sufferers b. Show the rulers in your document window if they are not already visible. c. Accept or ignore all suggested spelling and grammar changes in the document. d. Insert the Riverwalk Medical Clinic logo file Support_IL_WD_1-6.jpg at the top of the document. Change the height of the logo to 1", then position the logo in the bottom right with...
Read more