Question

The following are a set of named spreadsheets with the indicated column headings. Use these spreadsheets to answer exercises 1.30 through 1.32.

A. Name of Spreadsheet: EQUIPMENT Column Headings: (Number; Description, AcquisitionDate, AcquisitionPrice)
B. Name of Spreadsheet: COMPANY Columns Headings: (Name, IndustrvCode, Gross Sales, OfficerName, OfficerTitle)
C. Name of Spreadsheet: COMPANY Columns Headings: (Name, IndustrvCode, Gross Sales, NameOfPresident)
D. Name of Spreadsheet: COMPUTER Columns Headings: (SerialNumber, Make, Model, DiskTpe, DiskCapacityj
E. Name of Spreadsheet: PERSON Columns Headings: (Name, DateOfHire, DeptName. DeptManager, ProjectlD, NumHours, ProjecthManager)

Answer 1

There are five work sheets in this excel file, they are equipment, company, company, person and computer. Excel worksheets are made up of cells, with the columns labelled alphabetically and the rows numbered.

Step-by-step explanation:

The columns of a worksheet is called a field while row are called records. They are used to locate a cell in the worksheet. There are so many statistical, mathematical and engineering functions in excel. It is used to display the analysis of data.