Spreadsheet Exercises Index Page
The following spreadsheet exercises are designed to
help you practice the skills you learned in the lab, as well as
show you some new features and functions
Exercise #1
This exercise explains formulas and functions.
Objectives:
- Practice in creating formulas.
- Practice in creating functions.
- Learn that the same result may be generated by different formulas.
Please click here
to start the first exercise.
Exercise #2
This exercise is a simple spreadsheet to help you practice using
spreadsheets and using the IF function.
Objectives:
- More practice in formatting.
- More practice in entering and copying formulas.
- To use the IF function in a spreadsheet.
Please click here
to start the second exercise.
Exercise #3
This exercise will take you through the steps neccessary to complete
a spreadsheet.
Objectives:
- Format text by changing size and color.
- Enter data into specific cells.
- Format the entered data as currency
- Enter formulas using both absolute and relative references.
- Enter a function and set it up with the required information.
Please click here
to start the third exercise.
Practice Spreadsheet Lab Test
This exercise is complex and is similar in style to a lab test.
Objectives:
- To use a wide variety of formulas and functions in a spreadsheet.
- To practice with absolute and relative references.
- To prepare for the Spreadsheet Lab Test
Please click here to start Practice Spreadsheet Lab Test.