GCSE Intermediate Spreadsheet Skills

You have a list of numbers in column A (from A2 to A10). Write a formula to calculate the sum of these numbers.

• `=SUM(A1:A10)`

• `=SUM(A2:A10)`

• `=A1:A10`

• `=TOTAL(A2:A10)`

Which function would you use to find the average value of a range of cells B3:B8?

• `=AVERAGE(B3:B8)`

• `=MEAN(B3:B8)`

• `=MEDIAN(B3:B8)`

• `=SUM(B3:B8)/COUNT(B3:B8)`

If you want to count the number of cells in a range D4:D20 that contain numbers, which function should you use?

• `=COUNT(D4:D20)`

• `=COUNTNUM(D4:D20)`

• `=COUNTIF(D4:D20, ">0")`

• `=NUMBERCOUNT(D4:D20)`

What type of chart would be best to compare the sales data of different products in a single year?

• Line chart

• Pie chart

• Bar chart

• Scatter plot

How would you write a formula to calculate the compound interest in cell C10, given the principal amount in A10, the rate in B10, and the time in years in C9?

• `=A10*(1+B10)^C9`

• `=A10*(1+B10*C9)`

• `=A10*B10*C9`

• `=A10*((1+B10)^C9)`

Which function can be used to conditionally sum values in a range A1:A20 that are greater than 50?

• `=SUMIF(A1:A20, ">50")`

• `=SUM(A1:A20, ">50")`

• `=TOTALIF(A1:A20, ">50")`

• `=ADDIF(A1:A20, ">50")`

In a spreadsheet, you want to find the lowest number in the range E1:E15. Which function should you use?

• `=MIN(E1:E15)`

• `=SMALLEST(E1:E15)`

• `=LOWEST(E1:E15)`

• `=MINIMUM(E1:E15)`

What formula would you use to calculate the percentage of a total, if the part is in cell B4 and the total is in cell B5?

• `=(B4/B5)*100`

• `=B4/B5`

• `=PERCENTAGE(B4, B5)`

• `=(B5/B4)*100`

If you want to display the current date in a cell, which function should you use?

• `=DATE()`

• `=NOW()`

• `=TODAY()`

• `=CURRENTDATE()`

You have a column of dates in column A and a column of sales figures in column B. You want to find the total sales figures for a particular month. Which function will help you achieve this?

• `=SUMIF(A:A, "January", B:B)`

• `=SUMIFS(B:B, A:A, ">=1/1/2023", A:A, "<=1/31/2023")`

• `=TOTALMONTH(B:B, "January")`

• `=SUMBYMONTH(A:A, B:B, "January")`