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
