Spreadsheets

• Spreadsheet Software


  A computer programme used to organise, manipulate, and analyse data in tabular form, typically comprising rows and columns
• Active Cell


  The currently selected cell in a spreadsheet, usually indicated by a highlighted border. It's the cell where data entry or manipulation actions are performed
• Workbook


  A file containing one or more worksheets or spreadsheets. In spreadsheet software like Microsoft Excel or Google Sheets, a workbook is the entire document
• Formula


  A mathematical expression used to perform calculations or manipulate data in a spreadsheet. Formulas can include mathematical operators, cell references, functions, and constants
• Cell Formatting


  The process of changing the appearance of cells in a spreadsheet, such as adjusting font style, size, color, alignment, and applying borders or cell shading
• Data Type


  The classification or categorisation of data in a spreadsheet, such as text, number, date, time, currency, or boolean (true/false)
• Spreadsheet Template


  A pre-designed spreadsheet layout that serves as a starting point for creating new documents. Templates often include predefined formulas, formatting, and layouts tailored for specific purposes or industries
• Simple Functions


  Built-in operations or calculations performed on data in a spreadsheet. Common simple functions include SUM, AVERAGE, MIN, MAX, and COUNT
• DATE


  A function used to display or manipulate dates in a spreadsheet. It allows users to input specific dates or perform calculations involving dates
• SUM


  A function used to add together the values in a range of cells
• AVERAGE


  A function used to calculate the arithmetic mean of a range of values
• MIN


  A function used to find the smallest value in a range of cells
• MAX


  A function used to find the largest value in a range of cells
• COUNT


  A function used to count the number of cells containing numerical data within a range
• Columns


  Vertical sections in a spreadsheet labelled with letters (A, B, C, etc.), running from top to bottom
• Rows


  Horizontal sections in a spreadsheet labelled with numbers (1, 2, 3, etc.), running from left to right
• IF statement


  A conditional statement used in spreadsheets to perform different actions based on specified conditions. It returns one value if a condition is true and another value if it's false
• Relative Cell Reference


  A cell reference in a formula that adjusts its location when copied or moved to a different cell. It's typically indicated by the absence of dollar signs ($) before the column and row identifiers
• Absolute Cell Reference


  A cell reference in a formula that remains fixed or unchanged when copied or moved to a different cell. It's typically indicated by the presence of dollar signs ($) before the column and row identifiers
• Charts


  Visual representations of data in a spreadsheet, such as bar charts, line graphs, pie charts, or scatter plots. Charts help to illustrate trends, relationships, and comparisons within the data
• Graphs


  Another term for charts, used interchangeably in the context of visual representations of data