spreadsheets are an arrangement of cells in columns or rows, used to organize, analyze, calculate, and report information, usually in numerical form. Spreadsheets are used to balance checkbooks, calculate car loans, calculate student grades, and household budgets. Businesses use spreadsheets for payroll, and financial statements ( profit/loss).
workbook is a file which contains one or more s
Designing a Spreadsheet
Cell – individual locations on a spreadsheet
(intersection of a row and column)
§Column— identified by letters of the alphabet (vertical)
§Column A refers to all of the contents in a vertical range of cells in the first column of the spreadsheet.
§Row— identified by numbers (horizontal)
§Row 3 refers to all of the contents in a horizontal range of cells on Row 3