spreadsheet revision

Which two of the following functions are advantages of spreadsheets installed on a desktop computer?

• No internet connect is required

• The user has control over the data they store

• Back up's happen only when the user performs them

• Updates have to be carried out by the user on a regular basic

Which formula would you use to create the total number of representation in all districts?

• =B2+B3+B4+B5+B6

• =SUM(B2:B6)

• =sum(B2+B3+B4+B5+B6)

• =COUNT(B2:B6)

Which one of the following functions could be used to find the highest value in a column?

• MIN

• Average

• Max

• SUM

Which one of the following changes can the user make 2 a spreadsheet to make column heading stand out

• Spell check

• MAX

• Make the cell wider

• Bold, Underline, change the font colour, italics

• Add images

Why might you use relative cell referencing in a spreadsheet formula?

• If the formula has an error

• So it will change accordingly to its position in the spreadsheet

• So that a different function is used

What is the purpose of a pivot table?

• To copy and move data in a spreadsheet

• Allow the user to select data from a spreadsheet to make a report

• To delete data in a spreadsheet

What is a computer model?

• A program which attempts to predict a real life situation

• A program which attempts to control a real life situation

• A program which attempts to change a real life situation

• A computer which walks down a cat walk

Give two examples of real-life situations or systems where computer models are used

• bridge building, Britains got talent winners

• Financial modelling, weather forecasting

• financial modelling, what I should get from KFC

• Bridge building, UEFA champions league champions

What are the advantages of using computer models?

• quick and easy

• Can be used to predict likely outcomes of certain decisions

• Can try out different scenarios to see what gives the best results

• cheap and don't need a good computer

When we write formulas, which sign do we start with?

• Subtraction sign

• Equal Sign

• Addition sign

• Division sign