Chapter 13-15 Study guide (CPSC 110) QUESTIONS WITH COMPLETE SOLUTIONS

Cell entries in spreadsheets can be formatted similarly to formatting in word processors correct answer: True Spreadsheets can only be sorted in ascending order correct answer: False Spreadsheets can only display military time? correct answer: False Hidden columns cannot be referenced in a formula? correct answer: False Because there are two dimensions in spreadsheets- columns and rows- there are actually two ways a formula can be relative correct answer: True The basic unit of a spread sheet is a: correct answer: Cell A range of cells can include: correct answer: All of the above A spreadsheet feature that allows the user to enter a series of numbers or dates into a range of cells is called a correct answer: series fill An examples of conditional formatting is: correct answer: Applying a font color to values over 500 We can see spreadsheet results graphically by creating: correct answer: Charts Summary of information should be placed at the top of a spreadsheet: correct answer: False Fonts should be clear in a spreadsheet and possibly differentiated for headings and data correct answer: True