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?