Review_Package - Review Package Fall 2009 Overview This...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Review Package Fall 2009 Overview This review package was created by the tutors of CS 100. It is based on all the course material, some of which may have been used in previous assignments. Make sure to study the material before you start on this package. Also, be sure to note that this package is not intended to be a sample or practice exam , but to supplement your own studying. We strongly encourage you to try to complete this package without any outside help. Excel Review Explain the function of VLOOKUP and its four parameters. VLOOKUP: PARAMETERS: 1. 2. 3. 4.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Spreadsheets Exercise Mr. Anderson wants you to create a spreadsheet so that he can track his students’ performance throughout the semester. Look at the Review Worksheet spreadsheet at the end of this question. You are given: 1) First Year Microeconomics: A table containing students’ marks for a midterm and final test. 2) Class Components: A table containing total marks available and weights for each class component. Complete the following chart using the information provided here: (Remember to use flexible formulas, and name where appropriate.) 1) Top Mark: compute the value of the greatest mark final mark 2) Average Mark: compute the average final mark of the class Format the cells within the Grade Calculations Table appropriately: 1) Midterm Test: return the students’ weighted marks 2) Final Test: return the students’ weighted marks 3) Final Mark: the final mark is the total of the midterm and final test. 4)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/04/2011 for the course CS 100 taught by Professor Bb during the Spring '11 term at University of Warsaw.

Page1 / 15

Review_Package - Review Package Fall 2009 Overview This...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online