Sunday, March 30, 2014

HW
Ch 1 on Windows 7
Ch 1 on Office Fundamentals
Ch 1-2 on Word
Ch 1-4 on Excel

practice and mid-level exercises
winscp download and install
read about HTML on w3schools
joshwaxman@gmail.com

quiz next week on
Excel mult choice ch 3, 4
Word mult choice ch 2

Sunday, March 23, 2014

notes

Word ch 2 hands-on exercise 1
pg 169 in the book
C:\WORD

w02h1simserv

Font face
Serif vs Sans Serif fonts
point size
a point = 1 / 72 of an inch

Fixed width vs proportional
Wi
ii

snopes.com

($200.00)
$23,924

Sunday, March 16, 2014

Practice Exams for Excel

Updated  to include exam instructions. See below.
Updated to include exam file downloads. See below.

Lab Exam 2 Study Guide.

The first step to study for the Microsoft Excel Lab Exam is to read through the Excel Review Presentation:
Excel Review Presentation.
The second step to study for the Microsoft Excel Lab Exam and to get an idea of the format of the Microsoft Excel Lab Exam is taking the Practice Excel Exams:
Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.

File downloads:
Practice Excel 1
Practice Excel 2
Practice Excel 3
Practice Excel 4
Practice Excel 5

lecture notes

in cell I8:
=(SUM(B8:H8)-MIN(B8:H8))/(COUNT(B8:H8)-1)

in cell T8:
=SUM(J8:S8)

in cell W8:
=AVERAGE(U8:V8)

in cell Y8
=I8*$B$40+T8*$B$41+W8*$B$42+X8*$B$43

VLOOKUP:
#1: value you are looking for on the table
(this will be usually on the same row as you)
#2: table you are looking at to try to find that value
#3: once you have the row, what column?
#4: range lookup? TRUE

=VLOOKUP(Y8,Grades,2,TRUE)

=IF(Y8>=Passing,"Enroll in CS 202","RETAKE CS 101")

Student Rank
=RANK(Y8,$Y$8:$Y$30)

http://eniac.cs.qc.cuny.edu/~svitak/cs12/