Change the footer to display your name instead of adam smith

Assignment Help Basic Computer Science
Reference no: EM13952297

Click on Expense Report 3, save it on your computer, and open it in Excel. Change the footer to display your name instead of Adam Smith's.

In this exercise you are going to create a chart showing the expenses in the categories listed below. You first need to calculate the data in a summary section of your spreadsheet. Then, you can use that data in that summary section to create the chart. First, in cells K16:K21, enter the following labels (headers): Summary, Travel, Meals, Entertain, Phone, Other. Cells M17 through M21 will hold the data you will add to get the total expense for each category. For example, if you went on a business trip, you would need to enter the amount you spent on travel in one cell, the amount you spent on meals in another cell,and so on. Then you would use the add function to get a total of your expenses for the trip. Next, in cells M17 through M21 , create formulas to calculate the total expenses for each category:
For Travel, include expenses for Ground and Air transportation, Lodging, and Mileage $.
For Meals, include expenses for Brkfast, Lunch, and Dinner.

Finally, in cell M22, enter a function to show the total of M17:M21.You can now use this summary to create the column chart.

Create a column chart to show the graphical representation of the expenses, using the figure below as a guide. Create the chart on its own chart sheet, named Expense Report Chart. Do not include a legend but include the title "Expenses." Include data labels.

Use the Drawing toolbar to add the following Line callouts, as shown in the figure:
Travel consists of Air + Ground + Lodging + Mileage $.
Meals consist of Brkfast + Lunch + Dinner.
Rename the sheet tab for the spreadsheet Expense Report.

Fill in the blank cells in range A8:M11 with numeric values. You may choose to fill those cells with 0s (zeros), or any other number you may choose. Save your finished workbook as Expense Report 4.

Attachment:- exp_rep3.zip

Reference no: EM13952297

Questions Cloud

New trends in foodservice industry : Students are expected to find an article from a scholarly journal, newspaper or industry magazine (NOT AN INTERNET BASED ARTICLE - FROM THE LIBRARY or OTHER SOURCES get instructors approval) related to new trends in foodservice industry, lodging o..
What are the desired ending direct materials in pounds : If the required materials to be purchased are 18,000 pounds, the production needs are three times the direct materials purchases, and the beginning direct materials are three and a half times the direct materials purchases, what are the desired endin..
Five goals of delivering bad news : You are a recent college graduate and are applying for a number of jobs. Unfortunately, you receive two offers on the same day and need to accept one and decline the other. Write a letter to the hiring manager (see below) explaining your acceptanc..
Change the footer to display your name instead of adam smith : Create a column chart to show the graphical representation of the expenses, using the figure below as a guide. Create the chart on its own chart sheet, named Expense Report Chart. Do not include a legend but include the title "Expenses." Include d..
Write the coding for calculating bmi : Write the coding for calculating BMI.
Critically analyse the accounting softwares : You were meant to critically analyse the accounting softwares that are available in the Australian market. The analysis should cover.
What is the projects internal rate of return : Suppose that a project costs $3.5 million. It is expected to generate the following cash flows in the next 5 years: $1 million, 1.2 million, 1.3 million, 1.4 million. What is the project's internal rate of return?
Why were the first spectral lines detected on the sun : Helium is named after the sun, "helios". So, it was discovered on the sun first. Why was it discovered on the sun before we knew about it here on Earth? Do we get our helium from the sun?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Use active directory to establish security group memberships

How would you manage creation of novel user accounts in this organization? Utilizing Active Directory to establish security group memberships or manual creation and security.

  Identify hardware and software needed to secure

Identify hardware and software needed to secure

  An excel spreadsheet with componets names

Physical Networking. We are having to put together an excel spreadsheet with componets names, descriptions, costs, total project costs. We must create a Description of a basement telecommunication and network server space, network equipment tha..

  In a cdma network, two users with codes

In a CDMA network, two users with codes 110110 (user A) and 100101 (user B). What would be the bit sequence for each user in the encoded message "1010"?

  Analyse a packet capture dump file

This assignment question requires that you analyse a packet capture dump file and provide comments explaining each packet. See assignment 1 page of the course website. This pcap file contains a SMTP transaction between a client and server. Your ..

  What is rule of thumb as to when a system should be replaced

All systems eventually grow old and become obsolete. What is the rule of thumb as to when a system should be replaced?

  Calculates the velocity and momentum of an object

Write a program that does the following: Calculates the Velocity and Momentum of an object. The formula for the velocity is V=d/t and the formula for Momentum is m=mass*velocity. Your program should consist of two functions: Passing By Values (..

  Identify the system high and system low

Draw a lattice of a 2-element set ordered by inclusion.

  Specify technical requirements based on inputs

Develop a design plan and schedule detailing your plans for the next 4 weeks in order to deliver the tasks specified. This should cover what design decisions must be made and who should make them; what tasks must be performed and in what order;

  Which function is similar to the find and replace feature

Which function is similar to the Find and Replace feature. In Excel, the Compare and Merge command is located on which of the following tabs

  Convey the meaning of the poem? chat conversation end

Write Poem Analysis essay, Works Cited, and Copy of Poem (with line numbers). Also, copy and paste your entire essay into the body of the thread. Essay: 3 pages in MLA format,use 3-5 in-text (short) citations and 1-2 block (long) quotations. You also..

  Determine the winner of the got talent contest

Write a C++ program to determine the winner of the Got Talent contest. The contest has five judges, each of whom awards a score between 1 and 10 for each of the performers. Fractional scores are not allowed. A contestant's final score is determined b..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd