BIS155_Final_Exam_Study_Guide

BIS155_Final_Exam_Study_Guide - BIS155 Final Exam Study...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
BIS155 Final Exam Study Guide The Final Exam has a total of five essay questions. The focus of the exam is to evaluate your ability to select and apply appropriate tools/concepts based on descriptions of common business situations. Topic Question Type Number of Questions Points Possible TCO 1 through 9: Excel Essay 4 160 TCO 10: Database Concepts Essay 1 40 TOTAL 5 200 POINTS TCO 1 – 2: Spreadsheet Development 1. Basic steps/tasks involved in spreadsheet development. 2. Appropriate cell references required in various situations (relative, mixed, or absolute). 3. Appropriate formatting for titles, column headings. 4. When to use ranges and how to meaningfully name cell ranges. 5. Simple formula creation using constants and/or cell references 6. When and how to use the functions covered in this class, including but not limited to PMT, VLOOKUP, HLOOKUP, MIN, MAX, SUM, IF, COUNT, COUNTIF, AVERAGE, and MEAN. 7. How to add comments to a worksheet. 8. Various options for print documentation of spreadsheet values and formulas, including page headers and footers. TCO 3, 4, and 9: Data Manipulation and Analysis 1. Types of files that can be imported to Excel, and the import operation. 2. Tools available to “clean” data and prepare it for analysis; how and when to use each. 3. How to effectively plan and set up a spreadsheet “list” to store company records, and to facilitate efficient data entry and retrieval. 4. Select and apply appropriate sorts and filters based on a business information need. 5. Application of conditional formatting to highlight based on criteria. 6. Analysis of data via use of group subtotals, various “What-If” tools, and pivot tables/charts. 7.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/13/2011 for the course BIS 155 taught by Professor Mitchell during the Spring '11 term at DeVry Addison.

Page1 / 2

BIS155_Final_Exam_Study_Guide - BIS155 Final Exam Study...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online