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

MAKE UP ASSIGNMENTS
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

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