EECS 1520 Study Guide - Midterm Guide: Discrete Event Simulation, Bar Chart, Trigonometric Functions

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: John Hofbauer

Document Summary

Matrix of cells is called a sheet. Cells are arranged by columns (letters) and rows (number) Sheets can be added, renamed by double clicking, collection of sheets is called worksheet. Absolute cell references do not change, you can specify this by a $ sign before the row number, putting the $ before a row or column will change the other but not the one with $ in front. Go under numbers under home; you can select percentage, decimal numbers etc. You need to explicitly enter * in excel, not brackets. If there is a fraction exponent, put that in brackets. Sum: adding range of numbers, start with equal sign, you can drag the numbers you want to add. Named ranges: meant to make formulas more understandable. First select the range, then enter a name in the name box, or go to formula and click define name. Mean, median, mode, sd (stdev function), square root.