Complete 2 Excel Short Assignments

PLEASE COMPLETE EACH ASSIGNMENT…YOU SHOULD UPLOAD TWO SEPARATE DOCUMENTS ONCE COMPLETE…LABEL THEM ASSIGNMENT 5 AND ASSIGNMENT 6ASSIGNMENT 5:In this assignment, you will begin to enter and manipulate data using Excel spreadsheets. You will insert a simple SUM function and format numbers.In order to complete this assignment, first you must download and save the document “Unit 5 Excel,” attached above. This will give you the basic spreadsheets.Once you have done that, open the file titled “CIS112 Unit 5 Assignment and Rubric” and complete all of the tasks listed there.Save your work, and submit the updated file you created to Blackboard by Sunday at Midnight.ASSIGNMENT 6:This assignment will take you further into Excel and covers the material in this unit.In order to complete this assignment, first you must download and save the document “Unit 6 Charting,” attached above. Once you have done that, open the file titled “CIS112 Unit 6 Assignment and Rubric” and complete all of the tasks listed there.Save your work, and submit the updated file you created to Blackboard by Sunday at Midnight.
cis112_unit_5_assignment_and_rubric_rev1.pdf

unit_5_excel1.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
Complete 2 Excel Short Assignments
Just from $13/Page
Order Essay

cis112_unit_6_assignment_and_rubric_rev1.pdf

unit_6_charting.xlsx

Unformatted Attachment Preview

CIS 112 – Intro to Computing
MS Excel Assignment 1
Due: Midnight Sunday.
In this assignment, you will format a worksheet on the number of pens purchased by students. You will
also format the worksheet and insert appropriate formulas. Please remember to save your work as you
go through the steps.
The requirements for your assignment are:
1. Open the Unit 5_Excel1.xlsx document;
2. Save the document as Your First Initial LastName_Pen_Sales.xlsx (For example:
SBrown_Pen_Sales.xlsx);
3. The “Students” worksheet will contain the following data:
4. On the “Students” worksheet, do the following:
a
b
c
d
e
f
5.
Insert your first and last name in cell A1.
Italicize your name in cell A1
Select all the values in Column B. Using the Increase Decimal option, format the
purchased pens in Column B to have 2 decimal places.
In cell B15, use the AutoSum function to get the Total of all pens purchased;
Using the Increase Decimal option, format the sum in cell B15 to have two
decimal places;
Change the cell Background Color in cell B15 to Yellow
Save your work and submit the completed worksheet in Blackboard.
Refer to the grading rubric below for the grading criteria.
Students: Be sure to read the criteria, by which your paper/project will be evaluated,
before you write, and again after you write.
Evaluation Rubric for Unit 5 Assignment
Criteria
Name
SUM of Pens
Formatting
Excel document
name
Below Expectations
Needs Improvement
Meets Expectations
0-18 points
19-26 points
27-30 points
Name has not been
entered in correct
cell.
Name has been
Name is entered in
entered, but text is not correct cell, and text is
Italicized.
Italicized.
0-18 points
19-26 points
27-30 points
Function not entered
to SUM pens
purchased, and
background color of
the cell has not been
changed.
Autosum used to sum
pens purchased.
Value does not have
two decimal places.
Background color of
the cell has been
changed.
Autosum used to
determine sum of pens
purchased, and value
has two decimal places
using increase decimal
option. Background
color of cell has been
change
0-18 points
19-26 points
27-30 points
All pens purchased
values have not been
formatted to contain
two decimal places.
Some pens purchased
values have been
formatted with two
decimal places.
All pens purchased
values have been
formatted to contain
two decimal places.
0-5 points
6-8 points
9-10 points
File name has not
been changed.
File name has been
changed, but is not
correct.
File name has been
changed to correct
name.
Student Name
Page, Lisa
Martinez, Mary
Dawson, Jonathan
Chan, Eric
Pratt, Erik
Garcia, Joe
Wiggins, Frank
Tanner, Timothy
Chase, Troy
Perez, Maria
White, Daniel
Holland, Donald
SUM of Pens Purchased
Pens Purchased
55
87
82
93
61
67
75
81
79
95
75
99
CIS 112 – Intro to Computing
MS Excel Assignment 2
Due: Midnight Sunday
In this assignment, you will format a worksheet and insert appropriate formulas, and formatting.
Please remember to save your work as you go through the steps.
The requirements for your assignment are:
1. Open the Unit 6 Charting.xlsx document;
2. Save the document as Your Initials_Unit 6_Charting.xlsx (i.e. SB_Unit6_Charting.xlsx);
3. Select Column Q on the worksheet and hide the entire column Q;
4. Format the values in cells B3:M6 as a Number format with 2 decimal points;
5. Select cell A7 and enter the text “Total”;
6. Using the SUM function, calculate the Totals for each month. Your worksheet should look
like the following:
7. Select cells A2:M6 and create a Line chart for the data; Your Line chart should look like the
following:
Note: If your chart does NOT look like the chart above, but looks like the chart below, you
should choose the Switch Row/Column
Option, which is located under the Chart
Tools Menu.
8. Adjust the size of your line chart and move it so that the chart fits in cells A12:H20.
9. Add a legend to the bottom of your line chart;
10. Add the following title to the chart: “Sales by Month by Region”. Your chart with the legend
and title should like the following:
11. Below is how your completed worksheet should look:
12. Save your document and upload into Blackboard.
Students: Be sure to read the criteria, by which your paper/project will be evaluated, before you
write, and again after you write.
Evaluation Rubric for Unit 6 Assignment
Criteria
Below Expectations
0-18 points
Hidden Column
Sales
Worksheet
Line Chart
Worksheet
19-26 points
Column Q has not been
A column has been hidden
hidden on the worksheet. on the worksheet, but it is
not the correct column.
Meets Expectations
27-30 points
Column Q has been hidden
correctly on the worksheet.
0-18 points
19-26 points
27-30 points
No Total calculations and
no formatting has been
completed.
Total calculations using the
SUM function completed
correctly, but number
formatting has not been
completed.
Total calculations using the
SUM function completed
correctly and the number
formatting has also been
completed correctly.
0-18 points
19-26 points
27-30 points
Line Chart has not been
created.
0-5 points
Excel
document name
Needs Improvement
File is named incorrectly.
Line Chart has been created. Line chart has been created
Problem with legend and/or correctly. Legend and chart
title of the chart.
have both been added
correctly.
6-8 points
File name is correct. File
saved in improper format.
9-10 points
File is named correctly, and
saved in proper format.
NE
NW
SE
SW
Sales by Month by Region
Jan Feb Mar Apr May Jun Jul Aug
131 197 251 198 193 261 272 256
84 62 84 107 143 129 109 142
100 56 62 81 89 79 53 86
156 236 182 186 222 198 201 221
Sep
206
127
134
233
Oct
272
133
140
219
Nov
248
146
195
216
Dec
299
156
202
244
Month
Month
Month
Month
Month
Month
Month
Month
Month
Jan
Febr
Mar
Apr
May
Jun
Jul
Aug
Sep
$
$
$
$
$
$
$
$
$
Total
880,300
1,559,442
2,039,874
2,380,838
4,581,935
5,831,815
4,950,794
5,964,321
6,543,218

Purchase answer to see full
attachment

GradeAcers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.

Order your essay today and save 15% with the discount code DISCOUNT15