Sunday CS12
Wednesday, April 30, 2014
Friday, April 25, 2014
Sunday, April 6, 2014
Sunday, March 30, 2014
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
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
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/
=(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/
Subscribe to:
Posts (Atom)