Application software

Operating system (OS)

Binary system

CPU

Dual processor

Horizontal-market application

Vertical-market application

Virus

Access

Database

Field

File

Table

Primary key

Part II: Case Study Analysis:

Read case study How Reliable Is Big Data? at the end of Chapter 6 and answer the questions that follow.

6-13.

6-14.

6-15.

6-16.

Part III: Application Exercise Using Excel:

Figure 4-1 shows an Excel spreadsheet that the resort bicycle rental business uses to value and analyze its bicycle inventory. Examine this figure to understand the meaning of the data. Now use Excel to create a similar spreadsheet. Note the following:

Make the top heading in 20-point Arial font. Center across the spreadsheet and merge cells A1 through H1

Make the second heading, Bicycle Inventory Valuation, in 18-point Arial, italics. It is centered in cells A2 through H2, which have been merged.

Set column headings in 11-point Arial, bold. Center headings in their cells and wrap text in the cells.

a) Make the first two rows of your spreadsheet similar to that in figure 4-1. Choose your own colors for background and type, however.

b) Place the current date so that it is centered in cells C3, D3, and E3, which must be merged.

c) Outline the cells as shown in the figure.

d) Use formulas throughout to perform all calculations (no formulas = no credit)

e) Format the cells in the columns as shown.

f) Give three examples of decisions that management of the bike rental agency might make from this data.