Home > Middle School > Quizzes > Grades 6, 7 and 8 - Computer Science - Middle School - Models
Grades 6, 7 and 8 - Computer Science - Middle School - Models
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 0% Most missed: “The formulae in the models act as .......”

Spreadsheets are a type of model in computer science. In the field of computer science, modeling is an important topic. Starting in the mid 1990s continuing through the present, Microsoft Excel has dominated the commercial electronic spreadsheet market. You will often see formulae in computer models. Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made.

Grades 6, 7 and 8 - Computer Science - Middle School - Models
Time left 00:00
25 Questions

1. Spreadsheets are good at answering what-if questions.
2. The formulae can create output as charts and graphs.
3. A spreadsheet model might be tested by .......
4. A cell can contain a 'formula'. A formula is .......
5. Spreadsheet models use ....... to represent rules.
6. Spreadsheets are good at doing ....... analysis of data.
7. A model rule is: profit = number sold x saleprice - cost.
8. Each cell may contain .......
9. Typical uses of spreadsheets would not include .......
10. What do we call a cell being worked on?
11. A formula in a cell usually begins with a .......
12. Why are computer models sometimes unreliable?
13. The work space is divided into rectangles called .......
14. Cells are organized in rows and .......
15. A cell contains the characters Total. This is called a .......
16. Predictions made by models are usually .......
17. A formula is not normally displayed in a cell. It is found .......
18. Which is not an advantage of using models?
19. Which of these is not a formula?
20. Models often include many rules because .......
21. A cell is identified by the row and column it is in. They are .......
22. Models represent real life situations using .......
23. Which of these is not a commonly used function?
24. A cell contains a number or date. This is called a .......
25. Functions are pre-programmed formulae which .......