Spreadsheet Modelling: What If? Quiz

What is a spreadsheet primarily used for?

• To browse the internet

• To write and edit text documents

• To manipulate and perform calculations on data

• To create graphics and animations

What is a 'formula' in the context of spreadsheets?

• A type of software used for graphic design

• A simple piece of arithmetic used to perform calculations

• A tool for sending emails

• A method for creating presentations

How can a company use a spreadsheet to predict future trends?

• By browsing social media

• By creating artistic designs

• By adjusting data to answer 'what if?' questions

• By writing essays

What happens when you change the value in the price column of a spreadsheet model?

• The spreadsheet creates a new document

• The data in the income from sales column is automatically recalculated

• The spreadsheet crashes

• The spreadsheet sends an email

Why is it important for companies to answer 'what if?' questions using spreadsheets?

• To write novels

• To design websites

• To create video content

• To predict future trends in income and outgoings

What is the plural of 'formula'?

• Formulas

• Formuli

• Formulae

• Formulums

What type of software is a spreadsheet considered?

• Security software

• Network software

• System software

• Applications software

What is an example of a 'what if?' question a company might ask using a spreadsheet?

• What if we change our office location?

• What if we hire more employees?

• What if we reduce the price of our product?

• What if we change our logo?

How can spreadsheets assist in financial forecasting?

• By sending text messages

• By analyzing historical data and projecting future outcomes

• By editing photos

• By creating music playlists

What is a common feature of spreadsheet software?

• Tool for drawing sketches

• Function to stream live TV

• Ability to play video games

• Capability to perform complex calculations using formulas