skip to Main Content

The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

I’m working on a Excel project and need support to help me learn.Here are some quick video Tips to help refresh your ‘Excel Memory.’ Excel 1 Rubric F20Excel 1 Rubric F20CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeProject matches the assignment instructions ( or cannot be graded).0.0 ptsFull Marks0.0 ptsNo Marks0.0 ptsThis criterion is linked to a Learning OutcomeMUSIC: Data correct, 1) titles wrapped even when column width expanded, 2) Sorted Correctly (BR4018…. 21 units sold in 2015)1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeMUSIC: Data correct, 1) Conditional formatting – Selling price >=9 green fill, 2) Named Range = MusicData1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeLOOKUP: 1) IFERROR used correctly (TEST: BU6009, “Code Not Found” and “15%” is all that should be displayed), 2) Worksheet protected correctly (no password)1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeLOOKUP: 1) Title w/borders & CURRENT date (uses formula) & comment, 2) arrow shape / color1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeLOOKUP: 1) Vlookup correct with 2) absolute cell reference & named range1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeCALCULATIONS: 1) Gross Margin correct and Markup % Correct, 3) 2016 Goal correct & INT used. Check with BU6005: $3.05, 93.8%, 711.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeIF: 1) Units to meet goal correct, 2) Goal met message or nothing displayed. Check with BU6005: 40, no message AND EU7006: 0, Message displayed1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeCHART: 1) correct format & data values displayed, 2) Gradient used & title changes1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomePIVOTS: Pivot 1) Event Name / Ave Selling Price : $7.46, Pivot 2) Grade / Units Sold 7,839 and 3,499 w/chart and 3) student designed pivot table w/textbox explanation1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeFILTERS: Filter 1) CFP and brass, 4 records displayed, Filter 2) Grade 4 & 5 and Tubas, 5 records displayed and 3) student designed filter worksheet w/textbox explanation1.0 ptsFull Marks0.5 pts1 part missing or incorrect0.0 ptsNo Marks1.0 ptsThis criterion is linked to a Learning OutcomeNOTE: this project is only worth 10 points, Excel 2 will be graded in more detail.0.0 ptsFull Marks0.0 ptsNo Marks0.0 ptsTotal Points: 10.0PreviousNext

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don't hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®