Complete the exercises on the following pages. The Spreadsheet is similar to the layout and operation of the Database, except that the Spreadsheet is designed to deal with numerical values. Virtually any kind of ordinary problem in arithmetic can be solved with the Spreadsheet, and a surprising array of complex mathematical and statistical problems as well. Spreadsheets consist of a collection of data organized into rows and columns, and generally are used for manipulating and calculating numerical values. A spreadsheet program is a computer program that is used to create spreadsheets and manipulate data within these spreadsheets.
Text consists of headings, labels, and explanatory text.
Values consist of numbers that are typed directly into spreadsheet cells and include numbers, dates, or times. Formulas consist of equations that calculate new values from existing values. Text and numbers are also known as constant values. Excel uses workbooks, which consist of several worksheets. Tabs at the bottom of the workbook allow you to access the different worksheets.