{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This preview shows pages 1–2. 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: 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.
Image of page 1

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

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