Back to the full dot-point answer
ScotlandApplications of MathematicsQuick questions
Mathematical Modelling
Quick questions on Spreadsheets for modelling - SQA Higher Applications of Maths
2short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What is q1?Show answer
Cell B2 holds a price and cell B3 should show the price after a discount. Write the formula for B3. [1 mark]
What is q2?Show answer
A tax rate is held in cell G1. Write a formula in C2 for the tax on an amount in B2 that can be filled down the column. [2 marks]
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.