Hardware_Exam_Study_Guide

# Hardware_Exam_Study_Guide - Hardware Exam Study Guide...

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

Hardware Exam Study Guide Chapters: 3, 6 & 10, Excel A-H and Lectures 9/29 – 10/27 except 10/25 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

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

View Full Document
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.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern