Excel Essentials for Beginners

How do you enter the number '10' into a cell in Excel?

• Type '10' and press the 'Enter' key

• Write '10' on the screen with a stylus

• Say 'ten' out loud to the computer

• Draw the number '10' on a piece of paper and scan it

What do you click on to change the background color of a cell in Excel?

• The 'File' menu

• The 'Home' tab and then the 'Fill Color' button

• The 'Insert' tab

• The 'Data' tab

How do you make the text in a cell bold in Excel?

• Yell the text loudly when typing

• Click on the 'B' button in the 'Home' tab

• Shake the computer

• Use a bold marker to write on the monitor

If you want to add the numbers in cell A1 and B1, which formula should you use in Excel?

• A1 + B1

• =A1 + B1

• ADD(A1, B1)

• SUM(A1, B1)

Which function in Excel gives you the sum of a range of cells?

• =ADD()

• =TOTAL()

• =SUM()

• =PLUS()

How do you calculate the average of numbers in cells A1, A2, and A3 in Excel?

• =AVERAGE(A1:A3)

• =AVG(A1, A2, A3)

• =SUM(A1:A3)/3

• =MEAN(A1, A2, A3)

What is the first step to create a chart in Excel?

• Select the 'Insert' tab and then choose a chart type

• Draw the chart on paper and upload it

• Close your eyes and wish for a chart

• Yell "Chart!" at the screen

If you want to make a pie chart in Excel, which data should you select?

• Only the data values

• Only the data labels

• Both the data values and their corresponding labels

• Random cells in the spreadsheet