Spreadsheet Modelling Quiz 1

What is meant by the term "computer model"?

• A physical representation of a computer

• A simulation or representation of a real-world process using a computer

• A type of computer hardware

• A computer programming language

Answer explanation

The term "computer model" refers to a simulation or representation of a real-world process using a computer. This allows for analysis and understanding of complex systems without needing to interact with the actual processes directly.

What type of referencing can be used in spreadsheets?

• Relative and absolute referencing

• Direct and indirect referencing

• Static and dynamic referencing

• Simple and complex referencing

Answer explanation

In spreadsheets, referencing can be either relative or absolute. Relative referencing adjusts based on the position of the cell, while absolute referencing remains constant regardless of where the formula is copied.

What is one of the formatting options available in spreadsheets?

• Insert a graphic

• Create a database

• Develop a game

• Write a novel

Answer explanation

One of the formatting options in spreadsheets is to insert a graphic. This feature allows users to enhance their data presentation visually, making it easier to understand and more engaging.

What are computer models often used for?

• To play video games

• To predict and investigate how real-life devices or processes might behave in different situations

• To browse the internet

• To write documents

Answer explanation

Computer models are primarily used to simulate and analyze real-life systems, helping to predict their behavior under various conditions. This makes the correct choice about investigating how devices or processes behave.

What do weather forecasters use to predict the weather?

• Models of the atmosphere

• Models of the ocean

• Models of the forest

• Models of the desert

Answer explanation

Weather forecasters primarily use models of the atmosphere to predict weather patterns. These models simulate atmospheric conditions, helping to forecast temperature, precipitation, and other weather phenomena.

What are spreadsheets often used for in real-life situations?

• To create artistic designs

• To model real-life situations

• To write stories

• To play games

Answer explanation

Spreadsheets are powerful tools for modeling real-life situations, allowing users to organize data, perform calculations, and analyze trends. This makes them ideal for tasks like budgeting, forecasting, and project management.

What is another example of a "What if" question related to advertising?

• What if I sleep early?

• What if I increase the amount I spend on advertising?

• What if I buy a new car?

• What if I travel to Paris?

Answer explanation

The correct choice, 'What if I increase the amount I spend on advertising?', directly relates to advertising, exploring the potential impact of increased investment in this area.

What do you need to specify to find the letters spelling out a name in the grid?

• The color of the cells

• The cell references (e.g. A1, D4)

• The size of the grid

• The font style

Answer explanation

To find the letters spelling out a name in the grid, you need to specify the cell references (e.g. A1, D4) where the letters are located. This allows you to pinpoint the exact locations of the letters.

What is the purpose of using $B$5 in an Excel formula?

• To change the cell color.

• To keep the reference to cell B5 constant.

• To convert the value to dollars.

• To make the formula dynamic.

Answer explanation

Using $B$5 in an Excel formula makes the reference to cell B5 absolute, ensuring it remains constant when the formula is copied to other cells. This prevents the reference from changing, which is crucial for accurate calculations.

What can you change to adjust the appearance of text in a spreadsheet?

• Font properties

• Cell size

• Sheet name

• Border color

Answer explanation

To adjust the appearance of text in a spreadsheet, you can change the font properties such as font type, size, and style. This directly affects how the text looks, unlike cell size, sheet name, or border color.