Excel_02_SA_Debt_HW_Instructions.docx - Grader Instructions Excel 2019 Project Excel_02_SA_Debt_HW Project Description In this project you will format

• jenny.17
• 2

This preview shows page 1 - 2 out of 2 pages.

Grader - Instructions Excel 2019 Project Excel_02_SA_Debt_HW Project Description: In this project, you will format numbers and create formulas using absolute cell references. You will insert statistical functions. You will also create and format charts, and add WordArt to a worksheet. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named Student_Excel_02_SA_Debt_HW.xlsx file. Save the file as Last_First_Excel_02_SA_Debt_HW . 0 2 Add the file name field to the worksheet’s left footer and the sheet name field to the right footer. Return to Normal view. 4 3 Fill the text in B2 as a series in C2:G2. Select the range A2:I2 and apply the Wrap Text and Middle Align alignments. AutoFit the column widths of columns B:I. Select range, Home tab, Cells group, Format. 10 4 In the range B8:H8, insert the column totals. In the ranges B3:H3 and B8:H8, display no decimals. Format the range B4:H7 with no decimals.

• Spring '17
• elmo

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern