Hardware_Exam_Study_Guide

Hardware_Exam_Study_Guide - Hardware Exam Study Guide...

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

View Full Document Right Arrow Icon
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
Image of page 1

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern