Highlight the name of the sales rep, who had total sales greater than $1,250. (You have to use conditional formatting). You can select any format you want to make it look clear and visible
engineering
Description
HOMEWORK 1
·
Due Date:
September 26th, Thursday, 11:59 pm.
·
Max point
is 100. Each question is worth 20 points.
·
Solve
these questions on Excel.
·
Each
question has to be solved in a separate worksheet. (not workbook)
·
Each
worksheet has to be named by the question number.
·
Only one
Excel document will be submitted to D2L named as yourname_assignment 1
·
Label all
solutions clearly. Any calculation without a label in front of it or on top of
it will be ignored from grading.
Grading Rubric for each Question:
|
Criteria |
Needs Significant Improvement |
Competent |
Excellent |
Row Total |
|
Compliance
to Question-Specific Instructions |
1 |
5 |
8 |
/8 |
|
Accuracy
of Results |
1 |
5 |
8 |
/8 |
|
Clarity
of Work |
1 |
2 |
4 |
/4 |
|
|
|
|
TOTAL |
/20 |
The instructor can deduce or add any
additional points case by case.
Question-1
Create the following
spreadsheet by following the instructions.
Instructions
1)
Type in all text and numbers shown in the spreadsheet.
2)
Format all numbers as a currency.
3)
Center the spreadsheet heading 'Sales for the Month' across the spreadsheet.
4)
Format all text as Times New Roman, size 11.
5)
Define it as a table.
6)
Create formula's to display a total for each sales rep.
7)
Create formula's to display a total for each product.
8)
Create a formula to calculate the total sales for all sales rep's for the
month.
9)
Sort the table according to sales rep totals (high to low).
10)
Highlight the name of the sales rep, who had total sales greater than $1,250. (You have to use conditional formatting). You
can select any format you want to make it look clear and visible.
11)
Add a column to show the sales total in Euro currency. Find the current Euro to
US dollar rate online. Use absolute addressing for the conversion.
