19 Spreadsheets

1 Which one of these is a cell range reference? (1)

A G1J1

B G1 to J1

C G1 --> J1

D G1:J1

D G1:J1

2 Explain why named ranges are useful in a spreadsheet. (2)

Named ranges in spreadsheets improve clarity and readability by assigning descriptive names to cell ranges, simplifying complex formulas and reducing the chance of errors, while also enabling efficient data analysis and facilitating collaboration among multiple users.

3 Explain why absolute referencing is used in spreadsheets. (4)

Absolute referencing is utilized in spreadsheets to prevent cell references from changing when a formula is copied or filled. It is particularly valuable when user need to maintain a constant reference to a specific cell or range, regardless of where the formula is applied. By using the dollar sign ($) before the column letter, row number, or both in a cell reference, user can lock that specific component and ensure it remains unchanged. This enables user to create accurate calculations, preserve consistent formatting, and establish reliable connections to crucial data in his spreadsheet.

4 Which one of these functions would you use to calculate the addition of a range of cells? (1)

A SUM

B COUNTIF

C COUNT

D PRODUCT

A SUM

5 List three types of chart that you could use to represent data. (3)

a) Bar charts use bars to compare different categories or groups.

b) Line charts display trends over time or a continuous interval.

c) Pie charts represent the composition or distribution of categorical data using slices of a circle.

6 Describe how a VLOOKUP works. (4)

VLOOKUP is a function in spreadsheets used to search for a value in the leftmost column of a table and retrieve a corresponding value from a specific column. It follows a specific syntax, where user provide the lookup value, the table range, the column index, and an optional range lookup parameter. VLOOKUP is particularly useful for data analysis, such as retrieving data based on specific criteria or performing data validation. It allows user to efficiently extract information from large datasets and streamline data retrieval tasks in a spreadsheet.

7 State the most appropriate chart type to show the correlation between two sets of data values. (1)

The most appropriate chart type to show the correlation between two sets of data values is scattergram.

8 State the most appropriate chart type to represent values as a proportion of a whole. (1)

The most appropriate chart type to represent values as a proportion of a whole is a pie chart.

9 State the most appropriate chart type to compare values between different categories or groups. (1)

The most appropriate chart type to compare values between different categories or groups is bar or column chart.

10 Describe how a trend line can be used with a series of data to make predictions. (2)

A trend line, created through regression analysis, represents the general direction of a series of data points and can be extended beyond the available data to make predictions. However, the accuracy of these predictions depends on the quality of the data, underlying assumptions, and the stability of the observed trend, requiring caution and consideration of other factors.

11 State the advantage of using formulae in a spreadsheet to perform a calculation, rather than working out the answer and manually entering the result. (1)

The advantage of using formulae in a spreadsheet to perform a calculation, rather than manually entering the result, is that formulas are dynamic and automatically update when input value change.

12 Which one of these would evaluate to TRUE? (1)

A 9>11

B 9-(5+4)

C 9<5

D 9>-10

B 9-(5+4)