Enjoy the best grades that will raise your GPA.

Category: Excel (Page 1 of 4)

The Table and instructions are in the uploaded file. MS Project only. One-page p

The Table and instructions are in the uploaded file. MS Project only. One-page paper on a word document
Submit one MS Project file showing the project outlined below and its associated Gantt chart, as well as one word document answering the following three questions:
What date is the stadium scheduled to be completed based on the assumptions described below?
How many days will the project take to complete?
What is the critical path (name the actual activity names of the critical path, in order)?
Mortenson Construction is preparing a bid to build a new 19,400 seat soccer stadium. The construction must start July 3, 2017.

It’s easy to get smarter about your money when you have a head start. In this

It’s easy to get smarter about your money when you have a head start.
In this assignment, you will use Excel to create a household budget to help maintain control over your finances and see how your money is being used.
Conduct a short internet job search for the type of position you will be applying for once you have completed your education. Consider your work experience in this search. For example, if you have no experience in field, please search for entry level positions or the type of position someone with your background could reasonably qualify for. Look for three positions that include wage/salary information. Once you have found 3 job ads that include salary information, determine the average starting salary and use this as the basis for your household budget.
Create an Excel spreadsheet of your own design to breakdown your household budget. List monthly expenses and monthly income. You will need to list your expenses for 12 months (so you should have columns for each month). Remember your expenses are not always the same every month (for instance your electric bill could fluctuate based on how hot it is). Be sure to format the expenses and income as currency using one of the formatting options in Excel. Do NOT use an online template. The designs must be easy and logical to read. You should start from a blank, clean, Excel document.
Requirements of the assignment
Title your spreadsheet with a meaningful title, in bold, at least 16 point size, centered above your spreadsheet content and is centered over more than 3 columns. Use “Merge & Center” provided in Excel. The rest of the document should be in 12 point font. All data that represents money is formatted as currency.
Write your job title and the city and state you will live in
Include 3 job titles, locations, and starting salaries from the job search you performed. Find the average starting salary (using the AVERAGE function) Calculate and label your monthly income by dividing the annual income cell (reference the cell) by 12. Please make sure that your salary realistically and accurately matches your skill set (for instance, you will not start an engineering job making 90,000 a year).
Include at least 8 expense items such as electricity, telephone, gas, groceries, rent/mortgage, car payment, student loan payments, credit card payments, entertainment allowance, clothing allowance, etc.
Make all negative numbers appear in red using automatic formatting or conditional formatting provided in Excel. Choosing RED as the choice for the font color is not correct. Apply this formatting to the entire worksheet. You must have a negative somewhere in your calculations
For the following items, you MUST use an Excel function. You cannot calculate the values and enter a number. Excel functions include SUM, AVERAGE, MIN, MAX, etc. You must choose the correct Excel function and then use it properly to get full credit.
Using an Excel function, calculate the average of each type of expense category for the months you have listed. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate a subtotal for each expense category, using a function provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate a subtotal for each month, then a grand total of all the months, using functions provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate your monthly income after expenses. For each month, subtract the monthly expenses from the monthly income. Use an absolute reference to reference the cell of the monthly income. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Include a pie chart to display the breakdown of expenses. Use the expense categories you have listed and the monthly totals you have calculated to create your pie chart. Put the pie chart on its own worksheet labeled “Chart”. Please note, the chart values should be from the budget page of the worksheet. Do not copy the values into the new worksheet.
Make sure your spreadsheet is clearly organized and well formatted. For example, no values should display as ##### so make sure your columns are of the correct width for the data.
Check your spelling
Create a footer displaying the filename.
Save your completed file with the filename formatted as Excel_Budget_yourfirstname_yourlastname.xls. An Excel document should be uploaded to D2L.

This image appears when a project instruction has changed to accommodate an upda

This image appears when a project instruction has changed to accommodate an update to Microsoft 365 Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.
Open the ClassicGardens-03.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
Create a Clustered Column chart object for cells A4:G9.
Move the chart object so that its top-left corner is at cell A12. Size the bottom of the chart to reach cell H30.
Edit the chart title to display CGL Major Sales Revenue and press Enter to start a new line. On the second line, type Second and Third Quarters.
Apply chart Style 14 to the chart.
Format the first line and the second line of the chart title to a font size of 20 pt.
Apply a 1 pt Black, Text 1 (second column) outline to the chart area.
Verify that the chart is still selected. In the highlighted range in the worksheet, drag the resize pointer to remove the Design Consulting data series from the chart (Figure 3-71).
Figure 3-71 Resize the chart by dragging the resize pointer
Create a 3-D Pie chart sheet for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Design tab, Location group].
Create a 3-D Pie chart sheet for cells A4:A9 and cells H4:H9. Move the chart to its own sheet named Revenue Breakdown. Hint: Use the Move Chart button [Chart Tools Design tab, Location group].
Edit the chart title to display Revenue by Category. Change the font size to 32.
Select the legend and change the font size to 12.
Apply the Woven mat texture fill (first row, fourth column) to the Patio and Furniture slice.
Select the pie shape and add data labels to display in the center of each slice.
Display the Format Data Labels task pane, choose the Accounting format [Label Options button, Number group], and set 0 decimal places.
Change the data label font size to 14 pt and apply bold [Home tab, Font group].
Deselect the chart.
Save and close the workbook (Figure 3-72).
Please note file to be edited is Dayana.Hernandez-ClassicGardens-03.xlsx and file EX2019-IndependentProject-3-4-solution.pdf is an example of finished project.

Before starting this class, many of you probably thought that Excel was simply a

Before starting this class, many of you probably thought that Excel was simply a spreadsheet program used by accountants. In reality, Excel has functions that we can use in our daily lives. For this assignment, draft a two-page essay in which you describe how Excel can be used in each of the following areas of daily life:
home (e.g., saving money, budgeting, tracking expenses, keeping up with maintenance or projects);
work (e.g., creating graphs or charts for presentations); and
school (e.g., tracking classes, time management).
While the examples given may be used in your description, be specific about how you personally can benefit from using Excel in these areas. Also, you are encouraged to think about and describe other ways that Excel can be used in these areas. Since this essay is reflective in nature, outside sources are not required. Use 12-point Times New Roman font, double spacing, and paragraph format for your essay.

All instructions will be in the word doc I will provide. I will also provide a l

All instructions will be in the word doc I will provide. I will also provide a link where you can find the material for the project. This is my final term project and it is worth 60% of my grade. I need someone who is sure he can deliver a good term project. It’s maybe a bit complicated, so I will be here to provide all the things that are needed for you to do your best work. Thank you in advance!
here is the link for the online library: https://www.utoledo.edu/library/virtualexhibitions/DX2009/

Social Media and Free Speech Instructions Develop an effective argument resear

Social Media and Free Speech
Instructions
Develop an effective argument research essay (800 plus words) about the research topic that you have chosen.
Format your paper according to MLA style (Links to an external site.).
Create an interesting title that captures the interest of your reader and focuses your essay.
Begin with a strong introduction that engages your reader and provides a clear thesis at the end of the introduction.
Develop at least three support paragraphs about your perspective.
Include refutation of another perspective in a separate paragraph or within your support paragraphs.
Use evidence from at least FIVE sources to support your opinions and your refutation.
End with a strong conclusion that restates your thesis in a different wording and sums up what the reader should take away from the essay.
Use MLA formatted in-text citation for evidence from your sources.
Add a MLA formatted Works Cited as a separate page at the end of the essay.
Proofread your essay. Check for clear content and accurate sentence mechanics.
Save your rough draft as a Word or Google doc and submit it as a file upload.

It’s easy to get smarter about your money when you have a head start. In this a

It’s easy to get smarter about your money when you have a head start.
In this assignment, you will use Excel to create a household budget to help maintain control over your finances and see how your money is being used.
Conduct a short internet job search for the type of position you will be applying for once you have completed your education. Consider your work experience in this search. For example, if you have no experience in field, please search for entry level positions or the type of position someone with your background could reasonably qualify for. Look for three positions that include wage/salary information. Once you have found 3 job ads that include salary information, determine the average starting salary and use this as the basis for your household budget.
Create an Excel spreadsheet of your own design to breakdown your household budget. List monthly expenses and monthly income. You will need to list your expenses for 12 months (so you should have columns for each month). Remember your expenses are not always the same every month (for instance your electric bill could fluctuate based on how hot it is). Be sure to format the expenses and income as currency using one of the formatting options in Excel. Do NOT use an online template. The designs must be easy and logical to read. You should start from a blank, clean, Excel document.
Requirements of the assignment
Title your spreadsheet with a meaningful title, in bold, at least 16 point size, centered above your spreadsheet content and is centered over more than 3 columns. Use “Merge & Center” provided in Excel. The rest of the document should be in 12 point font. All data that represents money is formatted as currency.
Write your job title and the city and state you will live in
Include 3 job titles, locations, and starting salaries from the job search you performed. Find the average starting salary (using the AVERAGE function) Calculate and label your monthly income by dividing the annual income cell (reference the cell) by 12. Please make sure that your salary realistically and accurately matches your skill set (for instance, you will not start an engineering job making 90,000 a year).
Include at least 8 expense items such as electricity, telephone, gas, groceries, rent/mortgage, car payment, student loan payments, credit card payments, entertainment allowance, clothing allowance, etc.
Make all negative numbers appear in red using automatic formatting or conditional formatting provided in Excel. Choosing RED as the choice for the font color is not correct. Apply this formatting to the entire worksheet. You must have a negative somewhere in your calculations
For the following items, you MUST use an Excel function. You cannot calculate the values and enter a number. Excel functions include SUM, AVERAGE, MIN, MAX, etc. You must choose the correct Excel function and then use it properly to get full credit.
Using an Excel function, calculate the average of each type of expense category for the months you have listed. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate a subtotal for each expense category, using a function provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate a subtotal for each month, then a grand total of all the months, using functions provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Calculate your monthly income after expenses. For each month, subtract the monthly expenses from the monthly income. Use an absolute reference to reference the cell of the monthly income. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
Include a pie chart to display the breakdown of expenses. Use the expense categories you have listed and the monthly totals you have calculated to create your pie chart. Put the pie chart on its own worksheet labeled “Chart”. Please note, the chart values should be from the budget page of the worksheet. Do not copy the values into the new worksheet.
Make sure your spreadsheet is clearly organized and well formatted. For example, no values should display as ##### so make sure your columns are of the correct width for the data.
Check your spelling
Create a footer displaying the filename.
Save your completed file with the filename formatted as Excel_Budget_yourfirstname_yourlastname.xls. An Excel document should be uploaded to D2L.
I have included two (2) example budgets for you to review, Budget Example 1, Budget Exampe 2. These are from students from another section of this course. These are meant to be guides and not exemplars. Please note, even though these are PDFs, you are expected to upload a XLS.
Due Date

Social Media and Free Speech Instructions Develop an effective argument resear

Social Media and Free Speech
Instructions
Develop an effective argument research essay (800 plus words) about the research topic that you have chosen.
Format your paper according to MLA style (Links to an external site.).
Create an interesting title that captures the interest of your reader and focuses your essay.
Begin with a strong introduction that engages your reader and provides a clear thesis at the end of the introduction.
Develop at least three support paragraphs about your perspective.
Include refutation of another perspective in a separate paragraph or within your support paragraphs.
Use evidence from at least FIVE sources to support your opinions and your refutation.
End with a strong conclusion that restates your thesis in a different wording and sums up what the reader should take away from the essay.
Use MLA formatted in-text citation for evidence from your sources.
Add a MLA formatted Works Cited as a separate page at the end of the essay.
Proofread your essay. Check for clear content and accurate sentence mechanics.
Save your rough draft as a Word or Google doc and submit it as a file upload.

« Older posts

© 2022 assignmetshive

Theme by Anders NorenUp ↑