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.


Reference no: EM13952297

Plan to target expansion on a global level

The global strategies are the plan to target expansion on a global level that will expand the business on a very large scale. These types of strategies require that the comp

Temperature and c is the celsius temperature

The formula for converting a temperature from Celsius to Fahrenheit is F = 9/5 * C + 32 where F is the Fahrenheit temperature and C is the Celsius temperature. Your program

Determining the finding and fixing vulnerabilities

Because modern applications are complex, it is not practical to think about finding and fixing vulnerabilities by simply inspecting the code. Instead, a wide variety of sour

Implications of improperly-incompletely documenting

Suggest three (3) key reasons why documenting solutions to network issues is an important best practice. Speculate on the implications of improperly / incompletely documenti

How can you tell that this table holds table percentages

How many were G-rated? e) An editorial about the movies noted, "More than three-quarters of the movies made today can be seen only by patrons 13 years old or older." Does th

Describe history of portfolio design in graphics design

Describe the history of portfolio design in the graphics design industry, and role of a graphic designer. Discuss current trends in portfolio design, and the possible future t

Explain in your own words the power of if function in excel

Explain in your own words the power of the IF function in Excel, and indicate at least one way in which a person could utilize this function in work or personal life. Provid

Compute the cosine distance between each pair of users

Then, construct from the original matrix of Fig. 9.8 a new matrix whose rows correspond to users, as before, and whose columns correspond to clusters. Compute the entry for


Write a Review

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