COMPSCI 1BA3 Study Guide - Lookup Table, Dialog Box, Pivot Table
5 Dec 2013
School
Department
Course
Professor
Document Summary
Look at visual overview in the text book pg 4. Spreadsheet software: computer program used to enter, analyze and present quantitative data. A collection of text and numbers lay out in a rectangular grid. It organises and allows to perform a what-if analysis" change values and assess the effects. A workbook can have 2 different types of sheets: worksheets & chart sheets. Each cell is identified with a cell reference- where rows and columns intersect. Chat sheet: excel chart that provides a visual representation of worksheet data. Include a documentation sheet to describe your workbook. Button: f1 brings up the help function to search for shortcuts. Text: letters, numbers and symbols = form words & sentences. Truncated = when text entry gets hidden when cell is too small in numbers it comes out like. To enter lines within same cell = alt+enter. Editings: click f2, double click, or in formula bar. Enter when done, esc to exit without changes.
