Back to the full dot-point answer
ScotlandAdministration & ITQuick questions
IT Solutions for Administrators: Spreadsheets
Quick questions on Spreadsheet functions and formulae - SQA Higher Administration and IT
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
Write an IF formula that displays "Pass" if cell C2 is 50 or more and "Fail" otherwise. [2 marks]
What is q2?Show answer
Explain why an absolute cell reference would be used for a VAT rate in a spreadsheet. [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.