excel assignment

Powerful Essays
Microsoft Excel
Assignment # 3
November 15, 2013
Formatting Investments
Save your work frequently!
1. Start Excel and open the Unformatted Investments.xls workbook.
2. Save the file as Formatted Investments-Your Initials.xls, where Your Initials are the initials of your name.
3. Merge and Center the contents of cell A1 across columns A through I, increase the Font Size to 12 and make the Font Bold.
4. Insert a blank column to the left of column A.
5. Change the formatting for cells E5 through I5 to Wrap Text. For cells A1 through K15, use the Format Cells dialog box to place a thin line double border as the outline of the cell range.
6. For cells E5 through J14, use the Format Cells dialog box place a thick border as the outline of the cell range. Place single thin lines in the inside portions of the range.
7. Place a Thick Bottom Line border in cells E5 through J5 and E13 through J13.
8. Change the Page setup to center the data on the printed page horizontally. Create a custom footer with Your Name in the left section, the page number in Page 1 of ? format in the center section and the text, “Printed on:”, followed by today’s date using the Date button in the right section. Change the formatting of each section to something different than the default (the default is Arial, Regular, 10 with no special formatting).
9. Align cells C5 through C7 and cell C14 to the left Place a Thick Box Border around the cell ranges B5 through C8 and B11 through C14.
10. Place a thick border as the outline of cell C3 and bold the contents of cell C3.
11. Change the font color of the contents of cell C14 to red.
12. Change the fill color of cells A1 through K1 to Gray-25%. Change the font color of the contents of cell B1 to blue.
13. Change the width of columns A and K to 4.
14. Change the tab color of the Semi-Annual sheet to blue (column 6, row 2), and the tab color of the Monthly sheet to yellow (column 3, row 4).
15. Save your work.
16. Print the worksheet.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Excel Assignment 1

    • 1242 Words
    • 5 Pages

    ------------------------------------------------- Excel Assignment #1 Exercise 1: Student Grade Book (expected time – less than 45 minutes) Please download the spreadsheet Excel Assignment 1.xlsx from Blackboard. Click on worksheet E1 (you may be in Worksheet E1 by default). This spreadsheet keeps track of students’ grades. There are two exams – Exams 1 and Exam 2. Please do the following: (a) Find the total weighted score for the semester based on Exam 1 and Exam 2 and their respective weights…

    • 1242 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    excel assignment 3

    • 421 Words
    • 2 Pages

    Introduction to Investments Finance 340 Excel Assignment #3: Bond Portfolio Immunization Objectives: - Bond portfolio immunization. - Excel ‘Data Table’. The in-class hand-on example is based on Handout exercise 6. Problem: You will be paying $13,159.32 for a Hawaii trip in 7 years. The market interest rate is 4%, so the present value of the obligation is $10,000. 1) Construct a portfolio of two Bonds (Bond1: Coupon payments 3% paid annually, face value $1000 and maturity 5 years…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    FIN320 Excel Assignment

    • 388 Words
    • 4 Pages

    FIN 320 EXCEL SHEET Problems Please solve the problems below using an excel sheet and the excel functions. 1) (15 pts) A firm is considering a project with an initial investment of $170,000 and required return of 12%. The following cash flows are expected over the 8­year life span of the project: Year Cash flows 1 35,300 2 46,200 3 50,000 4 22,620 5 15,100 6 5,200 7 11,740 8 89,300 a) Calculate the Net Present Value (NPV) of the project. Should the…

    • 388 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Week 5 Excel Assignment

    • 397 Words
    • 2 Pages

    Jane Doe 2625 Edmonton Road. Fayetteville,ar 22569 910.476.9046 jdoe@gmail.com Work Experience: * Community Support Technician Excel Personal Development Fayetteville, NC July 7, 2008 through March 28, 2009 Made visits to the homes of assigned youth assessing their environments. Took assigned youth out to certain environments away from the family to aid in the progression towards self-assessment and betterment of attitude. Kept notes on each client marking the progress as well…

    • 397 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Excel

    • 298 Words
    • 2 Pages

    Getting Started in Excel Many of the editing tools that you use in Excel are similar to Word and PowerPoint You will need to become familiar with a few new things for Excel: Rows, Columns, Various Formulas, and Charts just to name a few When you see a reference such as A7, A is the column and 7 is the row, this will give you the particular cell that is being referenced. You will learn that you can click or enter in information when it comes to cells and formulas. Everyone will have their own…

    • 298 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Accounting 309 Excel Assignment 9 You are my teaching assistant for accounting 202 and I’ve asked you to determine and analyze semester grades. a. Use Excel functions, formulas and tools whenever possible. b. I want a template for the Grade Book and Grade Scale worksheets that I can reuse for all future classes and semesters by only changing the student’s personal data and grades. No more than 100 students can be enrolled in any section in any one semester. c. I want formulas…

    • 432 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    3. I found that the MS Excel assignment in week 4, to create an Excel spread sheet, was very helpful to me because I can use this information in my career field. Organizing meetings and balancing a budget is just a couple of many ways I can use Excel as an employee. I can also apply the Excel spread sheet to my everyday life like creating a chore list for my kids and using it to organize my…

    • 79 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Summarizing and Presenting Data If using RES/351 data: Revise the report submitted in Week Two based on the feedback provided by the instructor in the Learning Team assignment, and insight gained by reading. Summarize the data collected using descriptive statistics. Descriptive statistics should be in the forms of frequency distribution table, measures of mean, median, mode, standard deviation, and graphical display of data. Summarize the statistics in relation to the problem selected and…

    • 574 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Excel

    • 877 Words
    • 4 Pages

    What is a Spreadsheet? Honestly, when I first started this assignment, I really didn’t know what a spreadsheet was, etc. So I started at: http://en.wikipedia.org/wiki/Spreadsheet. I read that and got a good base of spreadsheets and the history. First of all, Microsoft Excel is the industry standard in spreadsheets (history on spreadsheets can be accessed at the above website address). With Excel, you can create a shared workbook and place it on a network location where several people can edit,…

    • 877 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    All assignments are group work for maximum 5 per group. Choose your partner wisely. Thank you Assignment 1: Choose 1 Microsoft Word (i) Imagine you are writing a resume for a big company for the job position as the executive engineer. Each person in group must write their own resume. Compile and send them. Write them nicely and convincingly as if you are really applying for the job. (ii) Imagine your company has a magazine. Write a newsletter of any topic. Must be at least 4 pages long…

    • 788 Words
    • 4 Pages
    Powerful Essays