Hardware study guide

Hardware study guide - Hardware Exam Study Guide Chapters:...

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

View Full Document Right Arrow Icon
Chapters: Spreadsheets 1. Spreadsheet Design Goals a. Define each goal including: Clear, concise, logical presentation of data: Simplicity : one topic per row and one topic per column, you want to compare numbers vertically not horizontally. Unity : keeps things logically put together. Ex: put name and id next to each order, put things in chronologically order, Emphasis : attention where needed. Balance : nice rectangle. Efficiency: All calculations performed by spreadsheet. Easy data entry, data analysis and information output. Flexibility: Spreadsheet can be easily modified as the environment changes. Auditability: Helps users understand contents of workbook and prevent input of bad data. Accurate Formulas: Select correct function, isolate assumptions, choose correct cell ranges, check relative or absolute references and double-check results. b. Provide examples of how you can use Excel to achieve each of these goals. 2. What is a workbook, worksheet and cell? Worksheet: An electronic spreadsheet that you produce when using Excel that contains 256 columns by 65536 rows. Workbook : A collection of related worksheets contained within a single file. Cell : The intersection of a column and row in a worksheet, datasheet or table. 3. What is the purpose of each of Excel’s features including: Formula Bar: Enter and edit data in a cell. Sort – including primary keys and secondary keys: To change the order of records in a list according to one or more fields, such as Last Name. Freeze Panes: To hold in place selected columns or rows when scrolling in a worksheet that is divided in panes Print Titles: In a list that spans more than one page, the field names that print at the top of every printed page. Header: Information that prints at the top of each printed page; on screen, a header is visible only in Print Preview. Footer: Information that prints at the bottom of each printed page; on screen, a footer is visible only in Print Preview. Comments: In a Visual Basic procedure, notes that explain the purpose of the macro or procedure; they are preceded by a single apostrophe and appear in green on a color monitor. Range Names: A range of cells given a meaningful name; it retains its name when moved and can be referenced in a formula. In VLOOKUP. Data Validation: only allows certain things to be put into the cells, never in cells with formulas. Worksheet Protection: locks down cells that are not data entry cells. 4. Formulas a. Relative vs Absolute Compare relative and absolute cell referencing. Relative: A type of cell reference used to indicate a relative position in the worksheet. It allows you to copy and move formulas from one area to another of the same dimensions. Excel automatically changes the column and row number to reflect the new position.
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/11/2009 for the course ACIS 1504 at Virginia Tech.

Page1 / 8

Hardware study guide - Hardware Exam Study Guide Chapters:...

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