Spreadsheet Assignments

Abstract

By completing the spreadsheet assignments, students will demonstrate the ability to:

• 1 LOAD a spreadsheet program

• 2 LOAD a spreadsheet model

• 3 ENTER text

• 4 ENTER numeric data

• 5 EDIT entries

• 6 INSERT columns and rows

• 7 DELETE columns and rows

• 8 GENERATE formulae

• 9 APPLY formulae

• 10 REPLICATE formulae

• 11 AMEND formulae

• 12 CHANGE cell sizes

• 13 GENERATE ‘what … if?’ projections

• 14 SAVE a spreadsheet model

• 15 PRINT data

• 16 PRINT model with formulae

• 17 EXIT from a spreadsheet program