Year 9 Spreadsheet End of Unit Assessment - Term 3a

1. What does every formula in Excel begin with?

• +

• -

• /

• =

1. Which key combination applies bold formatting in Excel?

• 1. CTRL + I

• 1. CTRL + B

• 1. CTRL + U

• 1. CTRL + L

1. What is a cell in Excel?

• 1. A column of data

• 1. A group of formulas

• 1. A box where a row and column meet

• 1. A tab on the ribbon

1. Which formula calculates the total range from A1 to A5?

• 1. =ADD(A1:A5)

• 1. =TOTAL(A1:A5)

• 1. =SUM(A1:A5)

• 1. =A1+A5

1. What does =AVERAGE(B1:B5) do?

• 1. Counts the cells

• 1. Finds the maximum value

• 1. Adds the numbers

• 1. Finds the average

1. What does =MAX(C1:C10) return?

• 1. The average

• 1. The sum

• 1. The smallest value

• 1. The largest value

1. What is the output of =ROUND(4.567, 2)?

• 1. 4.56

• 1. 4.5

• 5

• 1. 4.57

1. What function counts only the cells with numbers?

• 1. COUNTIF

• 1. COUNTA

• 1. COUNT

• 1. COUNTBLANK

1. What is a legend in a chart?

• 1. The graph title

• 1. Labels on axes

• 1. Key explaining symbols

• 1. Chart type

1. What is a data range in Excel?

• 1. A type of chart

• 1. A single cell

• 1. A group of selected cells

• 1. A bold section