Exploring Microsoft Excel 2003 Comprehensive
For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.
Results 1-3 of 29
Cell E3, for example, does not contain the number 88 (Adams's average for the
semester), but rather the formula to compute the average from the exam grades.
Indeed, it is the existence of the formula that lets you change the value of any cell
PRACTICE WITH EXCEL Click m H4 and enter formula to compute Semester
Average (divide Total Points by Point Threshold) Wrap Text option is selected for
B3:H3 Click in G4 and enter formula to compute Total Points Point Threshold 1.
Enter the formula to compute the student's test average in cell H4, which is based
on the exam weights in row 24. Copy this formula to the remaining ... Click in cell
K4 and enter the formula for the semester average. Use a VLOOKUP function in ...
What people are saying - Write a review
What Is a Spreadsheet?
The File Menu
A Better Grade Book
16 other sections not shown