Excel Skills for Grade 7

What formula would you use to add two numbers in Excel?

• =A1 * B1

• =TOTAL(A1, B1)

• =ADD(A1, B1)

• =SUM(A1, B1) or =A1 + B1

How do you create a pie chart in Excel?

• Select your data, go to 'Insert' > 'Pie Chart', and choose a style.

• Highlight your data, click on 'Data' > 'Chart Options', and select 'Bar Chart'.

• Select your data, go to 'File' > 'New Chart', and choose a type.

• Right-click on the data, choose 'Create Chart', and select 'Line Chart'.

Which function would you use to find the average of a set of numbers?

• mean

• total

• mode

• median

What is the formula for subtracting one cell from another?

• =A1 * B1

• =A1 + B1

• =A1 - B1

• =A1 / B1

How can you change the chart type in Excel?

• Select the chart, go to 'Chart Design' > 'Change Chart Type', and choose a new type.

• Use the 'Insert' tab to add a chart without changing the type.

• Click on 'File' > 'New' to create a new chart.

• Right-click the chart and select 'Delete' to remove it.

What function would you use to count the number of cells with numbers?

• AVERAGE

• SUM

• COUNT

• MAX

How do you create a bar chart in Excel?

• Select data, go to 'Insert' tab, click 'Scatter Chart', choose layout.

• Select data, go to 'File' tab, click 'Pie Chart', choose style.

• Highlight data, go to 'Home' tab, click 'Line Chart', choose color.

• Select data, go to 'Insert' tab, click 'Bar Chart', choose style.

What is the formula to multiply two cells in Excel?

• =A1/B1

• =MULTIPLY(A1,B1)

• =A1+B1

• =A1*B1

Which function can be used to find the maximum value in a range?

• AVERAGE

• MIN

• MAX

• SUM

How do you insert a line chart in Excel?

• Select data, go to 'Insert' tab, click 'Line Chart', choose style.

• Select data, go to 'View' tab, click 'Chart Wizard', choose 'Pie Chart'.

• Select data, go to 'File' tab, click 'New Chart', choose type.

• Highlight data, right-click, select 'Insert Chart', pick 'Bar Chart'.