Define the term using between 50 and 100 words. Cite the reference you use for your definition. Share an actual application for the function.

For each of the functions identified below, perform the following:

1. Define the term using between 50 and 100 words. Cite the reference you use for your definition (web site, blog, etc.) by using URL or page.

2. Share an actual application for the function. You can copy and paste something you find online (provide the reference) or create your own example using Excel or Access.

Excel Chapter 2

Exercise 1

• Relative cell reference
• Absolute cell reference
• Mixed cell reference

Exercise 2

• Sum function
• Average function
• Median function
• Min, max, count function
• Today function

Exercise 3

• VLookup function
• PMT function
• IF function

Excel Chapter 3

Exercise 1

• Clustered column chart
• Bar chart
• Pie chart
• Combo chart

Exercise 2

• Format chart titles
• Add and format axis titles and format axes
• Add and format data labels
• Format chart area

Exercise 3

• Apply chart style
• Apply chart filter
• Insert and customize sparklines

Excel Chapter 4

Exercise 1

• Freeze rows and columns
• Display and change page breaks
• Set and clear a print area
• Print titles

Exercise 2

• Create a table
• Rename the table
• Add and delete fields in table
• Add records in table
• Remove duplicate rows in table
• Apply table style

Exercise 3

• Create a structured reference in a formula in a table
• Sort one field in a table
• Sort multiple fields in a table
• Create a custom sort in a table
• Apply text filters in a table
• Apply a number filter in a table
• Apply a date filter in a table

Exercise 4

• Add a total row in a table
• Apply highlight cell rules in a table
• Specify top/bottom rules in a table
• Display data bars in a table

Access Chapter 1

Exercise 1

• Open, save, and enable content in a database
• Recognize database object types
• Modify data in table datasheet view
• Add records to a table
• Delete records from a table
• Use database utilities

Exercise 2

• Use a selection filter to find exact matches
• Use a selection filter to find records containing a value
• Use filter by form
• Sort table data
• View relationships

Exercise 3

• Create a database using a template
• Add records to a download desktop database
• Explore the database objects in a downloaded desktop database template

Access Chapter 2

Exercise 1

• Create a table in datasheet view
• Delete a field and set a table’s primary key
• Work with field properties
• Create a new field in design view
• Modify the table in datasheet view
Exercise 2

• Import Excel data
• Import data from an Access database
• Modify an imported table’s design
• Add data to an imported table
• Establish table relationships
• Enforce referential integrity

Exercise 3

• Use the query wizard
• Specify query criteria and sort order
• Change query data and run, copy, and modify a query

Exercise 4

• Add additional tables to a query
• Create a multitable query
• Modify a multitable query
• Summarize data using a multitable query

Last Completed Projects