Preview

01 - Introduction to Spreadsheets

 1. A spreadsheet is a piece of ________ for handling and manipulating numbers.

  RAM

  CPU

  hardware

  software

 2. Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns

  TRUE

  FALSE

 3. The best part about a spreadsheet is - you don't have to do any __________________! The programme will make the process of adding automatic.

  saving

  entering in of numbers

  typing

  adding up yourself

 4. The only thing (and the main thing) that a spreadsheet can do is add up several numbers.

  TRUE

  FALSE

 5. Which of the following options on the list can a spreadsheet do?
handle financial calculations, 
model statistical information, 
do complex trigonometry. 
make pretty graphs

  No 2 only

  No 1 and 4

  No 1 only

  All of the listed items are valid

 6. You could think of a spreadsheet, at its heart, as a glorified _______________.

  calculator

  animation

  website

  remote control

 7. A household budget (as shown below) could be added up manually, but a spreadsheet allows you to use __________ which automate the process.
Monthly Income: £1000

Travel: 100
Electricity: 100
Phone: 50
Food: 350
Mortgage/Rent: 900
Car: 130

Total: £______
Leftover: £______

  remotes

  formulas

  links

  sheets

 8. Microsoft Excel is not the only spreadsheet software. There is also google sheets, OpenOffice (free) and Lotus 1-2-3.
openoffice_spreadsheet_alternatives.png

  TRUE

  FALSE

 9. A spreadsheet file is made up of one workbook and multiple _________. __________ appear as tabs at the bottom of a workbook. They can be reordered and renamed.

  worksheets

  fillers

  webpages

  banks

 10. Google docs is an example of spreadsheet software that ___________________________.

  can only work offline

  is much more powerful than any other type of spreadsheet

  does not actually work

  runs in the browser