Problem 1
For Exercises 1-20, mark the answers true or false as follows: A. True B. False A cell in a spreadsheet can contain only raw data.
Problem 7
A spreadsheet is useful for performing what-if analysis.
Problem 8
What-if analysis can affect only one value at a time in a spreadsheet.
Problem 14
A database table is a collection of records, and a record is a collection of fields.
Problem 19
E-commerce is the process of keeping financial records, such as accounts payable, online.
Problem 21
For Exercises 21-25, match the solution to the question. A. dynamic D. range B. function E. schema C. circular F. field A spreadsheet is ____ in that it responds to changes in the data by immediately updating all affected values.
Problem 22
A spreadsheet formula may operate on a ____ of cells, such as C4..C18.
Problem 35
What is a spreadsheet circular reference? Why is it a problem?
Problem 38
Name some what-if analysis questions that you might ask if you were using a spreadsheet to plan and track some stock purchases. Explain how you might set up a spreadsheet to help answer those questions.
Problem 38
What is what-if analysis?
