Prepare a Microsoft Excel spreadsheet

Assignment Help Basic Computer Science

Reference no: EM131895380

Assignment -

Prepare a Microsoft Excel spreadsheet saved under the following naming convention: LastnameFirstnameW3-1. Using student John Doe as an example: DoeJohnW3-1. The spreadsheet must contain the following:

Cell Values, Formula Contents and Charts:

Row 1: Enter text "Business Budget"

Row 2: Enter text "Income", and enter the number 25000 in the next cell

Row 3: Enter text "Rent", and enter the number -4000 in the next cell

Row 4: Enter text "Utilities", and enter the number -2000 in the next cell

Row 5: Enter text "Insurance", and enter the number -500 in the next cell

Row 6: Enter text "Advertising", and enter the number -2000 in the next cell

Row 7: Enter text "Product Development", and enter the number -600 in the next cell

Row 8: Enter text "Net Amount", and use the SUM function in the next cell to calculate the total for all the values

Row 9: Enter text "Avg Expense Amt", and use the AVERAGE function in the next cell to calculate the average for all the expenses

Use the Freeze Panes option to freeze only Row 1.

Insert a Pie Chart that displays only the Income in Row 2, and each Expense in Rows 3-7.

Reference no: EM131895380

Questions Cloud

Calculate the molar mass of the metal : Write the molecular, total ionic, and net ionic equations for the reaction and calculate the molar mass of the metal and identify the element.

How many ionizable h atoms are present in the molecule : How many ionizable H atoms are present in the molecule? Then write the molecular, total ionic, and net ionic equations for the reaction.

Define ethical implications of social media interactions : Prior to beginning work on this discussion, read the required article by Appel and Kim-Appel (2010) and watch the Episode: 118 - Inside Out: An Introduction.

What is the mass of carbon dioxide produced : The combustion of butane can be represented by the following equation:__C4H10 (g) + __O2(g) ? __CO2(g) + __H2O(g)

Prepare a Microsoft Excel spreadsheet : Prepare a Microsoft Excel spreadsheet saved under the following naming convention: LastnameFirstnameW3-1. Using student John Doe as an example

Find an article that focus on educational strategies : The content of the article must focus on educational strategies for students with ADHD or autism.

What is the percent yield : In a given experiment, 1.89 g of copper was heated with excess sulfur to yield 1.76 g of copper(I) sulfide. What is the percent yield?

Balanced equation for the combustion of isooctane : Write the balanced equation for the combustion of isooctane (C8H18) to produce carbon dioxide and water. Use the smallest possible integers

Why did some women fight so hard to be granted right to vote : Why did some women fight so hard to be granted the right to vote? What/Who were the major obstacles to achieving this reform?

User Account

All Pages