COMPSCI 1BA3 Chapter Notes -Lookup Table, Pivot Table, Page Layout

43 views20 pages

Document Summary

Order of precedence applies (ooo: to enter a formula: Verify via f2 (which cells are in formula: scaling- fitting pages to print, rows and columns intersect at cells- cell reference. Text: a combination of letters, numbers, and some symbols that form words and sentences. Number: any numerical value that can be used in a mathematical calculation. Date and time: commonly recognized formats for date and time values: the main reason to use excel is to display values calculated. Function wizard: autosum can be used for sum, average, count, minimum, and maximum. Can add a total row to calculate summary functions. Formulas entered in one table cell are automatically copied down. Can create formulas that reference cells in a table using table and column names, rather than cell addresses. Can sort and filter data easily: sorting - columns filtered. Custom sorting lists can be created: filtering. Can be applied to one or more columns.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents