INFT124 -Excel Assessment 19 22 15 24 21 18 5. In cell A8, type the word...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
INFT124 -Excel Assessment 19 22 15 24 21 18 5. In cell A8, type the word "Total" (in Times New Roman 12-point font, bold). 6. To add the total amount in the Numbers column, highlight from B2 to B8, and then select the AutoSum button from the ribbon. 7. After entering the above data, select the data to be graphed (cell range A2:B7). Click on the Insert tab, then click on the charts tab, and click on the dropdown for the pie chart, and select 2-D Pie. 8. Rename the chart title "Student Rosters." Click on the pie chart to highlight it, then click on the chart title three times to highlight it, and type "Student Rosters." 9. Use the Chart Styles option to select a color scheme for your pie chart. 10. Show data inside your pie chart: Click the chart tools, choose Data Labels, and select "Inside End." 2 11. Select the pie chart and drag it up so that it is next to the table. 12. Now, go back to your table, and highlight the data to be graphed (cell range A2:B7). Click on the Insert tab, then click on Recommended Charts, and select the first option, which is a clustered column chart. 13. As you did for the pie chart, change the chart title to "Student Rosters." 14. Use the Chart Styles option to select a color scheme for your column chart. 15. Select the chart, go to Chart Elements, hover over Data Labels, and select Data Callout. 16. Highlight the clustered column chart and drag it so that it appears right below the pie chart. 17. Save your workbook as Student Roster. Once the charts are completed, please submit the Excel spreadsheet in Blackboard to the W5: Excel Assessment submission area. INFT124 - Excel Assessment Criteria Chart Data 20 points 2-D Pie Chart Design 40 points INFT124: Week 5 Excel Assessment Grading Rubric Exceeds Expectations 18-20 points Student includes the following: Correct font formatting applied for Course name, Number, and Total. Correct data entered into Course name and number columns. Auto sum applied to Total. Workbook named and submitted correctly. 36-40 points Student includes the following: Correct pie chart chosen. Correct data range graphed. Chart color scheme applied. Callouts applied properly. Chart title renamed accordingly. Chart located in correct area in spreadsheet. Legend appearing correctly Meets Expectations 14-17 points Student includes 4-5 of the following: Correct font formatting applied for Course name, Number, and Total. Correct data entered into Course name and number columns. Auto sum applied to Total. Workbook named and submitted correctly. 28-35 points Student includes 3-4 of the following: Correct pie chart chosen. Correct data range graphed. Chart color scheme applied. Callouts applied properly. Chart title renamed accordingly. Chart located in correct area in spreadsheet. Legend appearing correctly . 3 Needs Improvement 0-13 points Student includes less than 4 of the following: Correct font formatting applied for Course name, Number, and Total. Correct data entered into Course name and number columns. Auto sum applied to Total. Workbook named and submitted correctly. 0-27 points Student includes less than 3 of the following: Correct pie chart chosen. Correct data range graphed. Chart color scheme applied. Callouts applied properly. Chart title renamed accordingly. Chart located in correct area in spreadsheet. Legend appearing correctly INFT124 - Computing Skills Week 5 Excel Assessment This Assessment is part of the Workplace Assessments category, worth 20% of your grade. Deadline Due by the end of Week 5 at 11:59 pm, ET. Completing this Assessment will help you to meet the following: Course Outcome Create workplace-related documents, spreadsheets, and presentations using Office technology software Institutional Outcome Information Literacy and Communication - Utilize appropriate current technology and resources to locate and evaluate information needed to accomplish a goal, and then communicate findings in visual, written and/or oral formats. Directions In this assessment, you will create two graphs in an Excel spreadsheet: a pie chart and a column chart. You will follow the detailed steps below to organize the provided data and create the graphs. In your career, it's highly likely that you'll need to compile and showcase data for your boss, or while working on a team, or while preparing for a presentation. Learning these skills in Excel will make such tasks much easier. Once completed, please submit the Excel spreadsheet in Blackboard. Create a new Excel spreadsheet and enter the following information: 1. In cell A1 type "Course name" (Font should be Times New Roman 12-point font, bold). If these words are too big for the cell, click twice in between column headings A and B to resize the column. 2. In cell B1 type "Number" (Font should be Times New Roman 12-point font, bold). 3. Starting in cell A2 and working down this column, enter these course names (these can be any type font and size but be consistent, using the same font and size for all): COMM 104 HUSS 125 SOSC 226 PHIL 314 INFT 124 ACCT 210 4. Starting in cell B2 and working down this column, enter these quantities (these can be any type font and size, but again, be consistent): . INFT124 -Excel Assessment 19 22 15 24 21 18 5. In cell A8, type the word "Total" (in Times New Roman 12-point font, bold). 6. To add the total amount in the Numbers column, highlight from B2 to B8, and then select the AutoSum button from the ribbon. 7. After entering the above data, select the data to be graphed (cell range A2:B7). Click on the Insert tab, then click on the charts tab, and click on the dropdown for the pie chart, and select 2-D Pie. 8. Rename the chart title "Student Rosters." Click on the pie chart to highlight it, then click on the chart title three times to highlight it, and type "Student Rosters." 9. Use the Chart Styles option to select a color scheme for your pie chart. 10. Show data inside your pie chart: Click the chart tools, choose Data Labels, and select "Inside End." 2 11. Select the pie chart and drag it up so that it is next to the table. 12. Now, go back to your table, and highlight the data to be graphed (cell range A2:B7). Click on the Insert tab, then click on Recommended Charts, and select the first option, which is a clustered column chart. 13. As you did for the pie chart, change the chart title to "Student Rosters." 14. Use the Chart Styles option to select a color scheme for your column chart. 15. Select the chart, go to Chart Elements, hover over Data Labels, and select Data Callout. 16. Highlight the clustered column chart and drag it so that it appears right below the pie chart. 17. Save your workbook as Student Roster. Once the charts are completed, please submit the Excel spreadsheet in Blackboard to the W5: Excel Assessment submission area. INFT124 - Excel Assessment Criteria Chart Data 20 points 2-D Pie Chart Design 40 points INFT124: Week 5 Excel Assessment Grading Rubric Exceeds Expectations 18-20 points Student includes the following: Correct font formatting applied for Course name, Number, and Total. Correct data entered into Course name and number columns. Auto sum applied to Total. Workbook named and submitted correctly. 36-40 points Student includes the following: Correct pie chart chosen. Correct data range graphed. Chart color scheme applied. Callouts applied properly. Chart title renamed accordingly. Chart located in correct area in spreadsheet. Legend appearing correctly Meets Expectations 14-17 points Student includes 4-5 of the following: Correct font formatting applied for Course name, Number, and Total. Correct data entered into Course name and number columns. Auto sum applied to Total. Workbook named and submitted correctly. 28-35 points Student includes 3-4 of the following: Correct pie chart chosen. Correct data range graphed. Chart color scheme applied. Callouts applied properly. Chart title renamed accordingly. Chart located in correct area in spreadsheet. Legend appearing correctly . 3 Needs Improvement 0-13 points Student includes less than 4 of the following: Correct font formatting applied for Course name, Number, and Total. Correct data entered into Course name and number columns. Auto sum applied to Total. Workbook named and submitted correctly. 0-27 points Student includes less than 3 of the following: Correct pie chart chosen. Correct data range graphed. Chart color scheme applied. Callouts applied properly. Chart title renamed accordingly. Chart located in correct area in spreadsheet. Legend appearing correctly INFT124 - Computing Skills Week 5 Excel Assessment This Assessment is part of the Workplace Assessments category, worth 20% of your grade. Deadline Due by the end of Week 5 at 11:59 pm, ET. Completing this Assessment will help you to meet the following: Course Outcome Create workplace-related documents, spreadsheets, and presentations using Office technology software Institutional Outcome Information Literacy and Communication - Utilize appropriate current technology and resources to locate and evaluate information needed to accomplish a goal, and then communicate findings in visual, written and/or oral formats. Directions In this assessment, you will create two graphs in an Excel spreadsheet: a pie chart and a column chart. You will follow the detailed steps below to organize the provided data and create the graphs. In your career, it's highly likely that you'll need to compile and showcase data for your boss, or while working on a team, or while preparing for a presentation. Learning these skills in Excel will make such tasks much easier. Once completed, please submit the Excel spreadsheet in Blackboard. Create a new Excel spreadsheet and enter the following information: 1. In cell A1 type "Course name" (Font should be Times New Roman 12-point font, bold). If these words are too big for the cell, click twice in between column headings A and B to resize the column. 2. In cell B1 type "Number" (Font should be Times New Roman 12-point font, bold). 3. Starting in cell A2 and working down this column, enter these course names (these can be any type font and size but be consistent, using the same font and size for all): COMM 104 HUSS 125 SOSC 226 PHIL 314 INFT 124 ACCT 210 4. Starting in cell B2 and working down this column, enter these quantities (these can be any type font and size, but again, be consistent): .
Expert Answer:
Answer rating: 100% (QA)
Lets break down the instructions step by step Entering Course Names and Numbers In cell A1 type Cour... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these business communication questions
-
The family of a patient at County General Hospital complained when the patient fell in the hospital and broke her hip. The family was threatening a lawsuit, and there had been some negative publicity...
-
The activities, their durations and precedences for designing, writing and installing a bespoke computer database are shown in Table 16.6. Draw a Gantt chart and a network diagram for the project and...
-
Choose a company or product that you have been noticing or admiring. Develop a plan to advertise this product that involves the United States and at least one other country, and three forms of media....
-
Why does water appear cyan?
-
The actone(1) + chloroform(2) system has an azeotrope at x 1 = 0.38, 248 mmHg, and 35.17C. Fit the Wilson equation, and predict the P-x-y diagram.
-
Bernard Windows plans to sell two different brands of windowsChad and Muskand budgets the following: Calculate the breakeven point for Bernard Windows in terms of (a) the number of units sold and (b)...
-
1. Whats your reaction to these events? Do you think your reaction is influenced by the culture, values, and traditions of the country in which you find yourself? Explain. 2. Look at what Hofstedes...
-
1 - What is beta? 2 - Stock ABC has a beta of 1.25 and Stock XYZ has a beta of 0.55. Which stock would you buy if you knew the stock market was going to drop by 20% over the next month? Also, briefly...
-
Consider the unadjusted trial balance of Burrows Landscaping at December 31, 2023, and the related month-end adjustment data: The following adjustments need to be made on December 31 before the...
-
I. Create an applet that will print the following a. Today is a lovely day b. Today is Sunday. II. Write the corresponding JAVA statements: a) Create two labels, "I love programming", "I am a BSBI...
-
Which method does your selected corporation use to report net cash flows from operating activities? How can you tell?
-
Explain what you learned in this chapter and how its used in accounting?
-
A class needs a 175-inch-long piece of rope for a project. How long is the rope in yards? Use multiplication or division or both to solve the rope problem. Explain your solution.
-
Assume that the Larch City government anticipates $400,000,000 in revenues for the coming year. Naturally the city has many expenses related to fire safety, police, sanitation, health, road repairs...
-
for ulta, Where on the Balance Sheet would you find a Trademark?
-
A sample of Al(SO4)3 contains 17.2 g of oxygen, find the number of moles of Al2(SO4)3 A 0.0583 mol B 1.57 mol 0.0896 mol D) 0.0740 mol
-
Provide a few individual examples who revealed what aspects of emotional intelligence?
-
Quince Corporation has taxable income of $450,000 for its 2012 calendar tax year. Calculate the corporation's income tax liability for 2012 before tax credits. $_________
-
Jason and Mary are married taxpayers in 2012. They are both under age 65 and in good health. For this tax year, they have a total of $41,000 in wages and $500 in interest income. Jason and Mary's...
-
Mark owns his home and has a $250,000 mortgage related to his purchase of the residence. When his daughter went to college in the fall of 2012, he borrowed $20,000 through a home equity loan on his...
-
Which of the following best describes the underlying rationale for a written investment policy statement (IPS)? A. A written IPS communicates a plan for trying to achieve investment success. B. A...
-
Which of the following is least important as a reason for a written investment policy statement (IPS)? A. The IPS may be required by regulation. B. Having a written IPS is part of best practice for a...
-
The section of the investment policy statement (IPS) that provides information about how the policy may be executed, including investment constraints, is best described as the: A. Investment...
Study smarter with the SolutionInn App