Spring Term 2 Assessment - Spreadsheet Skills

A spreadsheet is primarily used for organising and analysing data, allowing users to perform calculations, create charts, and manage information efficiently. The other options do not align with its main purpose.

Microsoft Excel is a common spreadsheet software used for data organization and analysis, while Microsoft Word is a word processor, Adobe Photoshop is for image editing, and Google Chrome is a web browser.

A 'cell' in a spreadsheet refers to a single box where you can enter data, such as text, numbers, or formulas. This distinguishes it from other options like groups of boxes or types of formulas.

In spreadsheets, formulas always begin with the '=' symbol. This indicates to the program that the following text is a formula to be calculated, making '=' the correct choice among the options provided.

The correct formula to add values in cells A1 and A2 is '=A1 + A2'. This formula uses the equal sign to indicate a calculation, while 'A1 + A2' lacks it, and 'SUM(A1, A2)' is valid but not the simplest form. 'ADD' is not a valid function.

The purpose of a graph in a spreadsheet is to display data visually. This allows users to easily interpret trends and patterns in the data, making it more accessible than raw numbers.

A line graph is best for showing trends over time because it connects data points with lines, making it easy to visualize changes and patterns across a continuous time scale.

The SUM function in a spreadsheet is used to add numbers together. It calculates the total of a range of cells, making it essential for performing addition operations.

The correct formula to find the average of numbers in cells B1 to B5 is =AVERAGE(B1:B5). This function directly calculates the mean of the specified range, making it the most efficient choice.

The correct answer is 'Text chart' because it is not a standard chart type in most spreadsheet software. Line, Bar, and Pie charts are commonly used to visualize data.