EECS 1520 Study Guide - Final Guide: Hard Disk Drive, Telnet, Hypertext

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: Steven Castellucci

Document Summary

Columns are letters; rows are numbers (ex. Whatever is typed will appear in an area that is called the formula bar . Functions : function name (argument list: this list represents a range of cells, other functions that have more than one argument are separated by columns. Parameters worksheet contains constant qualities and placed on a separate worksheet where they are easily changeable. Trajectory worksheet contains a column of values for the initial angle and calculated distance. Nested functions: distance = velocity 2*sine (2*angle)/g. Two functions nested into the other =v*v*sin(2*angle*pi( )/180)/g. Sin function is expressed in radians =pi/180. Pi( ) doesn"t have any arguments, as indicated by the empty parentheses just produces the value of pi. Values from another worksheet used in a function in different worksheet is called an inter- worksheet formula. Cell reference is prefixed by the worksheet name sheetname! Specifying a cell/range coming from a particular worksheet is part of the syntax of excel formulas.