Accy 2258
Accountancy 2258
Exam 2 Study Guide
Spring 2014
Exam 2 is scheduled to be a computerized exam through SAM. The exam will consist of multiple-choice questions and tasks/problems you will be asked to complete to demonstrate your understanding and efficiency with various Excel features, formulas, and functions. The exam will require you to be knowledgeable of the Excel features, formulas, and functions discussed in class and/or described in Chapters 4-5 of your Microsoft Excel 2010 Comprehensive textbook.
To properly prepare for the exam, you should read Chapters 4-5 in your Microsoft Excel 2010 Comprehensive textbook, work through the exercises in the textbook, and review the labs we worked through together in class. You are responsible for all material in Chapters 4-5 of your textbook. Here is a summary of the key areas covered in these chapters:
Chapter 4 – Financial Functions, Data Tables, and Amortization Schedules
Know the bold-faced words
Apply a different theme to a worksheet
Add custom borders to a cell or range of cells
Use Create from Selection to name cells using the values in adjacent cells
Use the PV, FV, and PMT financial functions
Create a new Conditional Formatting rule
Set up and run a One-Variable Data Table and a Two-Variable Data Table
Unlock cells and protect a worksheet
Create an amortization table
Chapter 5 – Creating, Sorting, and Querying a Table
Know the bold-faced words
Create and manipulate a table
Add calculated columns to a table
Apply Conditional Formatting using icon sets
Use the VLOOKUP function
Add records to a table
Delete records from a table
Sort a table on one field
Sort a table on multiple fields
Query a table using AutoFilter
Query a table using Advanced Filter
Use database functions (DSUM, DCOUNT, DAVERAGE)
Use the SUMIF and COUNTIF functions
You will not be asked to use the MATCH or INDEX functions
Display automatic subtotals for a table
Use the Group and Outline features to
Exam 2 Study Guide
Spring 2014
Exam 2 is scheduled to be a computerized exam through SAM. The exam will consist of multiple-choice questions and tasks/problems you will be asked to complete to demonstrate your understanding and efficiency with various Excel features, formulas, and functions. The exam will require you to be knowledgeable of the Excel features, formulas, and functions discussed in class and/or described in Chapters 4-5 of your Microsoft Excel 2010 Comprehensive textbook.
To properly prepare for the exam, you should read Chapters 4-5 in your Microsoft Excel 2010 Comprehensive textbook, work through the exercises in the textbook, and review the labs we worked through together in class. You are responsible for all material in Chapters 4-5 of your textbook. Here is a summary of the key areas covered in these chapters:
Chapter 4 – Financial Functions, Data Tables, and Amortization Schedules
Know the bold-faced words
Apply a different theme to a worksheet
Add custom borders to a cell or range of cells
Use Create from Selection to name cells using the values in adjacent cells
Use the PV, FV, and PMT financial functions
Create a new Conditional Formatting rule
Set up and run a One-Variable Data Table and a Two-Variable Data Table
Unlock cells and protect a worksheet
Create an amortization table
Chapter 5 – Creating, Sorting, and Querying a Table
Know the bold-faced words
Create and manipulate a table
Add calculated columns to a table
Apply Conditional Formatting using icon sets
Use the VLOOKUP function
Add records to a table
Delete records from a table
Sort a table on one field
Sort a table on multiple fields
Query a table using AutoFilter
Query a table using Advanced Filter
Use database functions (DSUM, DCOUNT, DAVERAGE)
Use the SUMIF and COUNTIF functions
You will not be asked to use the MATCH or INDEX functions
Display automatic subtotals for a table
Use the Group and Outline features to