SQA Spreadsheets Exam Q&A (2025/2026, 40+ Questions) | Charts, Formulas, Functions, Errors | Business & Computing

This document contains 40+ fully solved exam-style questions and definitions for the SQA Spreadsheets 2025/2026 curriculum, designed for students in business, ICT, or computing-related programs. It is a comprehensive revision guide ideal for learners preparing for practical spreadsheet exams, internal assessments, or certification tasks using Microsoft Excel or equivalent spreadsheet software. The resource clearly explains all key spreadsheet components and functions, including: Spreadsheet structure: cell, row, column, active cell, cell reference, workbook, worksheet Mathematical operators: addition (+), subtraction (-), multiplication (*), division (/), and range (:) Key formulas and functions: =SUM, =MAX, =MIN, =AVERAGE Syntax and usage examples with ranges (e.g., =AVERAGE(A15:A37)) Formula errors and messages: ###### (column too narrow) #NAME? (incorrect formula syntax) It also covers data presentation tools, including: Charts: pie chart, bar chart, line chart (with explanations on when to use each) Design elements: borders, shading, merge cells Pivot tables for summarizing data efficiently This document is especially useful for: Students in Higher Business, ICT, Administration, or Computing courses requiring spreadsheet skills Learners preparing for practical spreadsheet-based exams or coursework tasks Educators or tutors looking for a concise, example-driven Q&A tool for exam preparation Keywords: spreadsheets, SQA spreadsheets, Excel formulas, spreadsheet functions, cell reference, active cell, workbook, worksheet, SUM function, AVERAGE function, MIN, MAX, pivot table, pie chart, bar chart, line chart, formula errors, merge cells, shading, borders, spreadsheet exam, ICT skills, business technology, formula bar