# CEHE APP110 Week 4 Assessment Latest 2019 December

Question # 00616492
Course Code : APP110
Subject: Computer Science
Due on: 09/11/2020
Posted On: 09/11/2020 09:10 AM
Tutorials: 1
Rating:
4.9/5
Question

Week 4 Assessment

Microsoft Excel

Learning Objectives Covered:

LO 06.04 – Demonstrate how to create tables and graphs in Microsoft Excel including the use of formulas

Career Relevancy

Segment of a slide ruleIf you've seen the movie Hidden Figures, you may have noticed one of the manual calculating tools used in the movie was a slide rule (a segment is pictured here). Luckily, we do not have to use slide rules for our calculations today. For quick calculations, we can grab the calculator programmed into our phone. For more complex calculations and calculations that have to be done repetitively, we can program our spreadsheet to do the work for us using formulas. The use of formulas in a spreadsheet improve work effectiveness and efficiency in these ways:

Multiple similar calculations can be done quickly without error

The spreadsheet with formulas can be easily used by different people with consistent results

The spreadsheet formulas can be used over and over without having to do the manual calculations again simply because one or more pieces of input have changed

Tables and graphs are ways to display data so it makes sense to us. You have used tables and graphs most of your life—they have become increasingly common in media and on social media as well as in the professional world.

Background

Tables

You have already created tables if you have completed the Week 4 Assignment. A table is nothing more than data organized in rows and columns. Rows go down, columns go across. The individual spots where data is held are called cells.

To make a table more useful, we can add labels. Let's use a simple example from the business world. You are the supervisor of a small sales team. You need to track the weekly sales of your team members, Ash, Kourtney, Sherra, and Tamika. Here is the raw data:

Ash sold \$1,050 in week 1, \$1,125 in week 2, and \$976 in week 3

Kourtney sold \$1,245 in week 1, \$1,175 in week 2, and \$1,480 in week 3

Sherra sold \$1,090 in week 1, \$890 in week 2, and \$1,115 in week 3

Tamika sold \$1,205 in week 1, \$1,225 in week 2, and \$1,330 in week 3

That's a pretty confused way to look at it, so let's put together a table listing the weeks across the top and the sales people on the left side.

Ash        Kourtney             Sherra   Tamika

Week 1

Week 2

Week 3

This is not a pretty table, but it works. We can do the same thing in Excel. It is easier to make the table work for us in Excel than on the course page. Here is the basic table in Excel.

The basic table in Excel

Now, let's add in the sales numbers.

Table with basic sales data

This is pretty easy to read compared to what we had before, but we want it to look a little clearer. We can apply some simple formatting—like you did in the Word assignments. More importantly, we can set up these cells to display the numbers as currency. Because we have a few other pieces we'll add when we put in the formulas, we'll set more than just our active cells to show numbers as currency. Start by selecting cell B2 and then, while keeping the mouse or right click active, select through cell G5. (If you struggle to make the full selection, you can also do it one cell at a time or by a smaller selection.) Your selection will look something like this:

Selection of money cells

Formulas

Your table should now look good and it is readable, but it would be nice to know what we are selling per week and how much each salesperson has sold. It would also be good to know our grand total. We can find out all of this by adding in new labels and then putting in some formulas. First, the labels. We're going to add a label for weekly totals, one for salesperson totals, and one for the grand total.

We can make this much clearer by drawing in thicker lines or changing the color of the cells. Experiment a bit with the look. (If you're stuck on how to do that, a simple Google search will give multiple ideas with instructions.)

A note about formulas, you do need to get the format correct for the formulas, but there are different ways to do them as well. For this task, we are going to go with the most basic way to help explain it, but we will show a simple way to make life easier.

First, go to the cell you want to put the formula in. We'll start with cell A1, then click on Formulas from your menu tabs. As you will see, there are several classifications of formulas available to you. Explore the formulas by clicking on the financial drop-down menu and hover over the formulas to view a description. The description provides details for when to use the formula.

Excel image - Financial

Graphs

Once your data set is complete, you can create a chart, otherwise known as a graph, to provide a visual representation of the data. The chart tool allows you to create a visual presentation of the data in your table. You can select a format that fits your goal and data set. Your options are a Area, Bar, Column, Waterfall, Pie, Line, Scatter, Surface, or Radar charts. With Excel, it is easy to create a chart by simply selecting your data set and then click Insert, then the type of chart you prefer.

Chart image

Prompt

For this assessment, we're going to create an Excel spreadsheet making a useful table, create a graph from it, and use formulas to help understand the data better.

Assessment instructions:

Step 1: Add employee name data and column and row names

Add the employee name information from the data set to a blank excel file. Be sure to properly name your columns and rows for each category.

Step 2: Create additional employee data and arrange names alphabetically

Add five additional employees to the "Employee" column. You will now need to arrange your employees in alphabetical order. Select all the names in your "Employee" column and then click on the data tab. Locate the "Sort & Filter" group and click on the sort A to Z icon. This will arrange all your names alphabetically and you are ready to move on to the next step.

Step 3: Add remaining data into coordinating fields

Now that you've arranged your employees in alphabetical order you can add the absence information for each employee to the correlating month.

Create a new column titled "Total days missed" at the end of the data set. Click on cell N2, then click the formulas tab. In the formulas tab click Autosum, then click Sum. The row data should now be encased in a green colored box. Hit the enter key. Click back into cell N2 and drag the green square down to N18. The sums will now be calculated for each employee.

Take a minute to review the days missed for each employee and think about how this data could be useful.

Step 5: Format as a table

Use the short key code of CRTL + A to select the data set. Click Format as table and select a table format. Next, click the My table has headers.

Step 6: Insert a Graph

Select your table, then click the Insert tab. Under the insert tab select Column or Bar chart, then 2D Stacked column. The chart will appear on the screen. In order to make it easier to view the data set and chart you will need to move the chart below the table by right-clicking on the chart and dragging to the desired location.

Step 7: Save file

Save your file as an excel file using App110_lastname_week4_assessment

Posted By :
Questions: 3706 Tutorials: 3600
Tutorials for this Question

#### CEHE APP110 Week 4 Assessment Latest 2019 December

Tutorial # 00615147
Posted On: 09/11/2020 09:10 AM
Feedback Score: Not rated yet!
Purchased By: 2
Posted By:
Questions:
3706
Tutorials:
3600
Tutorial Preview
The solution of CEHE APP110 Week 4 Assessment Latest 2019 December...
Attachments
APP110_Week_4_Assessment_Microsoft_Excel.xlsx (24.44 KB)

Great! We have found the solution of this question!

Tags:
Related Questions
CEHE APP110 Week 1 Assignment Latest 2019 December
APP 110 Business Computer Fundamentals Week  1 Assignment   Week 1 Assignment - Preparing Your Computer for Online Class Learning Objectives Covered LO 02.01 - Create an effi …
CEHE APP110 Week 3 Live Lecture Quiz Latest 2019 December
APP 110 Business Computer Fundamentals Week 3 Live Lecture Quiz Question 1 The first keyword phrase used in the lecture was?   design theme   party theme   page theme …
CEHE APP110 Week 2 Live Lecture Quiz Latest 2019 December
APP 110 Business Computer Fundamentals Week 2 Live Lecture Quiz Question 1 The first keyword used in the lecture was?   plagiarism   pontification   proof check &n …
CEHE APP110 Week 4 Live Lecture Quiz Latest 2019 December
APP 110 Business Computer Fundamentals Week 4 Live Lecture Quiz Question 1 The first keyword phrase used in the lecture was?   Excel templates   Excel stencils   Adob …
CEHE APP110 Week 1 Live Lecture Quiz Latest 2019 December
APP 110 Business Computer Fundamentals Week 1 Live Lecture Quiz Question 1 The first keyword phrase used in the lecture was?   Email   Website   Computer Skills &n …
CEHE APP110 Week 2 Discussion (dq1+dq2) Latest 2019 December
APP 110 Business Computer Fundamentals Week 2 Discussion    DQ 1 Academic Referencing Learning Objectives Covered LO 04.02 – Demonstrate the use of Microsoft Word for c …
CEHE APP110 Week 2 Assignment Latest 2019 December
APP 110 Business Computer Fundamentals Week  2 Assignment Learning Objectives Covered LO 04.01 – Create a new Microsoft Word document utilizing a template Career Relevancy T …
CEHE APP110 Week 1 Assessment Latest 2019 December
APP 110 Business Computer Fundamentals Week 1 Assessment Week 1 Assessment - Microsoft Office Ribbon Question 1 How many total tabs are there on the Microsoft Excel ribbon?   11 …
CEHE APP110 Week 4 Assignment Latest 2019 December
APP 110 Business Computer Fundamentals Week  4 Assignment Learning Objectives Covered: LO 06.02 – Create a Microsoft Excel spreadsheet LO 06.03 – Apply formatting to a Mi …
CEHE APP110 Week 4 Assessment Latest 2019 December
APP 110 Business Computer Fundamentals Week 4 Assessment Microsoft Excel Learning Objectives Covered: LO 06.04 – Demonstrate how to create tables and graphs in Microsoft Excel includ …
Recent Questions
Ethnopsychology & Individual Final Exam Latest 2024
Ethnopsychology & Individual Final Multiple Choice Exam 2024  QUESTION 1 1. "All individuals are, in some respects, like all other individuals" illustrates which level of the …
NCU MSW6103 All Assignments Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 1 Assignment Analyze Practice Standards in the Health Care Field Instructions For this week’s assignment, utiliz …
NCU MSW6103 Week 8 Assignment Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 8 Signature Assignment Evaluate the Social Worker’s Role in a Medical Setting to Improve Practice Effectiveness Instruct …
NCU MSW6103 Week 7 Assignment Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 7 Assignment Create a Discharge Plan Template to Assist VA Patients & Their Families Instructions A key role a social w …
NCU MSW6103 Week 6 Assignment Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 6 Assignment Capture "A Day in the Life" Instructions Your assignment for this week requires you to locate and in …
NCU MSW6103 Week 5 Assignment Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 5 Assignment Determine a Treatment Plan Instructions Refer to the case study from Week 4’s assignment.  You have …
NCU MSW6103 Week 4 Assignment Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 4 Assignment Engage and Assess a Patient in a Medical Setting Instructions Review the fictitious case study below. You are …
NCU MSW6103 Week 3 Assignment Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 3 Assignment Document a Strategy to Improve a Health Behavior Instructions This week, you learned about theories of he …
NCU MSW6103 Week 2 Assignment 2 Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 2 Assignment 2 Examine Your Personal Reaction Instructions For the second assignment this week, schedule a meeting with yo …
NCU MSW6103 Week 2 Assignment 1 Latest 2024
MSW6103 v4: Advanced Social Work in Medical Practice  Week 2 Assignment 1  Analyze State Regulations and Legislation Instructions Social workers understand the value base …