10G - Spreadsheets Revision 1

To format a heading to make it expand across more than one cell you need to highlight the cells and then:

• Wrap Text

• Merge Cells

• Align to Middle

Which formula finds the LARGEST number in an range? 

• SUM

• MIN

• MAX

• IF

What type of chart is this?

• Line chart

• Pie chart

• Bar chart

Which formula adds up the TOTAL of a range of numbers?

• VLOOKUP

• IF

• SUM

• AVERAGE

Correct the following formula:

=IF(C3>=G2,'Enter',"No Entry")

• =IF(C3>=G2,'Enter',"No Entry")

• =IF(C3>=$G$2,"Enter","No Entry")

• =IF(C3>=G2,"Enter","No Entry")

What do you use an absolute cell reference for?

Evaluate responses using AI:

OFF

What function in Excel helps you to organise data?

• Sort & Filter

• VLOOKUP

• Borders & Shading

• Font Size

Is this formula correct?

• No

• Yes

Which formula finds the arithmetic MEAN?

• SUM

• MAX

• MIN

• AVERAGE