Spreadsheets L5 - REVISION

Enter the letter, which identifies merging cells

(a)  

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

(a)  

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

(a)  

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?

(a)  

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 =

(a)  

How much did Daniel sell on Wednesday?

(a)  

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

(a)  

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.