CSci 105

Introduction to Computers

 

Laboratory Assignment # 4


Introduction to Spreadsheets

The purpose of this exercise is to become familiar with the concept of spreadsheets, how to format spreadsheets, and how to create graphs using spreadsheet data.

1.  Open MS-Excel and build the spreadsheet for Gina's Lemonade 4th Quarter Sales Report shown in Figure 5 of p. 377 of your text. Print out this initial spreadsheet.

2.  Correct the error Jean discovered in cell D6 and print out the corrected spreadsheet as shown in Figure 6 of p.378.

3. Format the spreadsheet as indicated on p. 379.

4.  Create the simple Pie Chart just below the spreadsheet and print out the results shown in Figure 7 on p. 379 and below.