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
