Your exam will consist of exercises from past chapters. You will need to complete the exercises without any outside assistance. You will choose 3 out of the four exercises, with the database exercise being required. The exercises will focus on the following topics:
Spreadsheets:
1
Creating an workbook, entering data, and applying formatting such as shading, borders and text style (bold, italics, etc...)
Using a formula to do a basic calculation, such as net income.
Creating a header and adding gridlines, displaying formulas when printing.
2
Creating a workbook, entering data, and using multiple sheets
Using formulas that use data from multiple sheets to calculate totals using cell references
Creating a header and adding gridlines, displaying formulas when printing.
3
Use an existing spreadsheet, and sort items by alphabetical order
Use a choose function to determine a value based on a criterion (1=60%, 2=50%, etc...)
Create and use a VLOOKUP function
Create header, display formulas
Databases:
4*(Required)
Create a relational database with three tables, and use the lookup wizard to link the tables
Create three forms and use them to enter data into the tables
Print the tables