Microsoft Office Tutorials and References
In Depth Information
Introduction to Excel
Here’s another example. Suppose you’re a teacher who wants to construct a spreadsheet that
calculates students’ averages across five exams. For starters, your spreadsheet might assume this form,
shown in Figure 1–3:
Figure 1–3. Student grades for five exams
Now, that’s a perfectly lucid and serviceable read on the data, complete with an alphabetical sort
of student names. But with a bit of formatting derring-do and a jot of number-crunching savvy, you
coul d come up wi th some thi n g l i k e Fi g ur e 1 – 4 :
Figure 1–4. The same grades, this time formattted to highlight the highest grade in each exam. Each set of
student grades is also charted.
Search JabSto ::




Custom Search