Middle School: 6th, 7th and 8th Grade - Computer Science - Models 2 Solution - MCQGeeks.com

Q.1.

Which of these is not a formula?

0%
=C3+F2*H5
0%
=C3-F2*$H5
0%
-C3/F2*H5
0%
=C3*F2*H5

Q.2.

Models represent real life situations using .......

0%
data and analysis
0%
data and intuition
0%
data and rules
0%
data and statistics

Q.3.

Spreadsheet models use ....... to represent rules.

0%
cells
0%
conditional formatting
0%
formulae
0%
symbols

Q.4.

The values in the spreadsheet cells act as .......

0%
information
0%
input
0%
macros
0%
reports

Q.5.

The formulae in the models act as .......

0%
enquiries
0%
calculations
0%
data
0%
processes

Q.6.

The formulae can create output as charts and graphs.

0%
Charts and graphs are the only form of output possible
0%
Charts and graphs are vital to understand predictions
0%
Charts and graphs can improve understanding of results
0%
Charts and graphs make the output more accurate

Q.7.

Spreadsheets are good at doing ....... analysis of data.

0%
how-why
0%
what-else
0%
what-if
0%
why-when

Q.8.

A model rule is: profit = number sold x saleprice - cost.

0%
A suitable formula might be: =D5x(C5-B5)
0%
A suitable formula might be: =D5x(C5/B5)
0%
A suitable formula might be: =D5*(C5-B5)
0%
A suitable formula might be: =D5^(C5-B5)

Q.9.

Models often include many rules because .......

0%
a single formula can only handle simple rules
0%
real world situations are often very complicated
0%
results can be achieved much quicker with more rules
0%
the more rules used, the more accurate the results

Q.10.

Predictions made by models are usually .......

0%
approximate
0%
correct
0%
exact
0%
wrong