BIS155_Final_Exam_Study_Guide - . / Topic...

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. (Grauer Pp.73-4) 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/2010 for the course BIS 155 taught by Professor Gampi during the Spring '10 term at DeVry Colorado Springs.

Page1 / 4

BIS155_Final_Exam_Study_Guide - . / Topic...

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