CP102 Lecture Notes - Spreadsheet, Pie Chart
Document Summary
Cells and cell addresses: spreadsheet divided into rows and columns, cell is intersection of row and column, address of cell= column letter + row number (ex. B7: active cell- cell available to be edited at given time. Contents of cells: label- provides descriptive text info about entries in spreadsheet, value- actual number that is entered into cell, displayed value- what is displayed in cell. Ranges: group of one or more adjacent cells occurring in rectangular shape. Password protection can prevent anyone from making changes to. Planning the spreadsheet: create sketch of spreadsheet (show labels/data should appear, specify any formulas/functions needed. Making first draft: type column/row headings, enter data into cells, enter/test formulas. Changing spreadsheet: change value in one cell, affects other cells. Formatting and printing: format labels, sales numbers as currency, borders, cell shadings. Creating graph from spreadsheet data: graph created based on data in spreadsheet.