# Complete 2 Excel Short Assignments

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

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.
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
8. Adjust the size of your line chart and move it so that the chart fits in cells A12:H20.
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:
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.
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

attachment

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.

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.

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?

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

Proceed with the payment

Choose the payment system that suits you most.

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.

## 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.