Spreadsheets L5 - REVISION

Enter the letter, which identifies merging cells

Enter the letter, which allows you to change the cell background colour (shading)

Enter the letter, which allows you to apply £ currency to cells

What is the orange arrow pointing at?

• The formula bar - where you can see the formula/function used in a cell

• Review tab in the Excel ribbon so that you can spell check the document

• The shading tool, so that a colour can be applied to the cell

• The worksheet that we are working on

Which of the following tasks would a spreadsheet model be best used for?

• Designing a logo
• Writing a novel
• Budgeting and financial predictions

• Creating a website layout

What is the cell reference for the selected cell?

I want to ADD the cell that contains 17 to the cell that contains 193. Write out the WHOLE formula. Remember that formulas start with =

How much did Daniel sell on Wednesday?

What function word would you use to find the Total Sales for Alby in cell I9?

If a business wants to make more profit, how could you use a spreadsheet to predict the impact on revenue?

• Reduce marketing efforts to save costs.
• Ignore seasonal trends in sales data.
• Use a random number generator for pricing adjustments.
• Adjust pricing or sales estimates in the spreadsheet to forecast revenue changes.

Answer explanation

• Adjusting amounts such as increasing price per unit
• Use of basic formulas such as =Price per unit * unit sales and =SUM(...) to calculate total revenue/costs.
• Give a clear example with accurate explanation

Example answer:
• A business can put its prices and sales in a spreadsheet and use it to see how much money they will make.
• If they change the price or sell more, they can change the numbers to see the new total.
• They might also use SUM to add up all their sales.