To Do:

  • Visual Benchmark 1, 2
  • Performance Assessment 1 (The file RSRHelpDesk.xlsx is in the folder EL2U1)

CMR 282 Module 5 textbook assignmentsPreview the document

Submit the following files:

(1) 2-BillableHrsOct4to8.xlsx
(2) 2-WPMCCardioCosts.xlsx
(3) U1-RSRHelpDesk.xlsx
(4) Add a chart to one of the worksheet

Pick one of the homework assignments and add a chart to it. Be sure that the chart fits the kind of data being reported. Be sure your chart is complete with a title, a legend, and axis labels.

required excel files are attached in zip folder

Module 5, Chapter 2

Module 5, Chapter 2
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeVB1: Range names created
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeVB1: VLOOKUP correct
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeVB1: Total and Average fees correct
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeVB2: Surgery fee formula
3.0 pts

Full Marks

0.0 pts

No Marks

 

3.0 pts
This criterion is linked to a Learning OutcomeVB2: Total cost formulas
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeVB2: Conditional Lookup formula
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeA1: Conditional formatting
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeA1: Custom format
2.0 pts

Full Marks

0.0 pts

No Marks

 

2.0 pts
This criterion is linked to a Learning OutcomeAdd a chart to a spreadsheet
3.0 pts

Chart fits the kind of data being reported. Chart is complete with a title, a legend, and axis labels.

0.0 pts

No Marks

 

3.0 pts
Total Points: 20.0
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *