eQuizShow
Spreadsheet Review
Terms
Question: A set of columns and rows
Answer: What is a spreadsheet?
Question: A vertical set of cells
Answer: What is a column?
Question: A horizontal set of cells
Answer: What is a row?
Question: One box in a spreadsheet where numbers for formulas may be entered
Answer: What is a cell?
Question: A spreadsheet is made up of one or more of these
Answer: What is a worksheet?
Formulas
Question: The symbol used to add two values
Answer: What is a plus sign (+)?
Question: The symbol used to multiply two values
Answer: What is an asterisk/star (*)?
Question: The function used to add a range of data values
Answer: What is sum?
Question: The name for a set of cells used in a formula
Answer: What is a range?
Question: The function used to find an average of a range of cells
Answer: What is average?
Labels
Question: The cell that appears at the intersection of Row 3 and Column D
Answer: What is D3?
Question: The cell at the intersection of column AA and row 10
Answer: What is AA10?
Question: The symbols used to label columns
Answer: What are letters?
Question: The symbols used to label rows
Answer: What are numbers?
Question: The area of the screen where you change the sheet name
Answer: What is the lower left corner?
Theory
Question: A spreadsheet program
Answer: Possible answers...
What is
-Google Docs
-Calc
-Excel
Question: A title entered at the top of a column of data
Answer: What is a header?
Question: The result is that the whole row is highlighted?
Answer: What is the result of clicking on a column or row label?
Question: Data with a context in a spreadsheet
Answer: What is information?
Question: When spreadsheets are used to simulate a business situation or possible scenario
Answer: What is computer modelling?
Miscellaneous
Question: One attribute of a cell that can be changed
Answer: Possible answers:
What is a ...
-font
-color
-border?
Question: The name for a number in a cell
Answer: What is the value?
Question: The name for an expression in a cell involving other cell and mathematics
Answer: What is a formula?
Question: Changing the way a cell looks is called __________ that cell
Answer: What is formatting?
Question: The result of typing "=5*4-3+2*1" into a cell and pressing enter
Answer: What is 19?