Hardware_Exam_Study_Guide - Hardware Exam Study Guide...

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

View Full Document Right Arrow Icon
Hardware Exam Study Guide Chapters: Spreadsheets 1. Spreadsheet Design Goals a. Define each goal including: Clear, concise, logical presentation of data- it has to make sense. Keeping like things together. Overall pleasing appeal. Keep one idea per row or column. Draw attention to important things. Efficiency – having the comp do all possible math. Easy data entry. (Macros, etc.) Flexibility- being able to adapt to change later on. Auditability- the formulas are easy to check and accurate. Make it hard for user to enter bad data. Accurate Formulas- yeah b. Provide examples of how you can use Excel to achieve each of these goals. 2. What is a workbook, worksheet and cell? There are 3 worksheets in a WB. 3. What is the purpose of each of Excel’s features including: Formula Bar- where you insert the formulas Sort – including primary keys and secondary keys –Can be descending or ascending by numbers, letters, date, etc. If something is the same, it goes to secondary keys (ex. Jones, Tim then Jones, Xena.) Freeze Panes- Allows certain rows/columns to stay on the screen no matter where you scroll. Print Titles- Titles on the top of the page. Headers and Footers- ok Comments – To clarify contents of certain cells. Range Names- Giving a name to a block of cells. Data Validation- limits the range of values someone can put into a cell Worksheet Protection- prevents people viewing your SS from changing it. 4. Formulas a. Relative vs Absolute Compare relative and absolute cell referencing. Relative lets Excel change the cell reference but making it absolute, Excel doesn’t change the row or column, which ever you specify (with a $). Describe how to determine whether relative, absolute or mixed cell references are required in any given situation. If you don’t want the column to change, put $ before the letter ($A8). But for the row not to change, put before number (A$8). Be able to determine the result if a given formula is copied to a new cell. b. Logical Functions What is the purpose of an IF function? To give a solution if an instance is true. What is the purpose of a VLOOKUP function? Looks in a specified table for data. Used for more 2 or more choices. ACIS 1504 -5107122.doc Page: 1 of 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
What are the rules for setting up a Lookup table? First column must contain value that is being looked up. Must be in ascending order. Give entire table a range name. Columns are referred to as consecutive numbers starting with 1. Be able to use IF and VLOOKUP functions properly. c. Order of Operations What is the order of operations? Parenthesis, exponents, percents, multiplication, division, addition, subtraction Be able to solve formulas based on these rules. d.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This test prep was uploaded on 04/09/2008 for the course ACIS 1504 taught by Professor Jmlacoste during the Fall '07 term at Virginia Tech.

Page1 / 7

Hardware_Exam_Study_Guide - Hardware Exam Study Guide...

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

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