Excel Basics Quiz for Students

Which formula would you use in Excel to add the values in cells A1 and B1 together?

• =A1+B1

• =A1*B1

• =A1/B1

• =A1-B1

What is the correct formula to find the average of the numbers in cells A1 to A5?

• =SUM(A1:A5)

• =AVERAGE(A1:A5)

• =COUNT(A1:A5)

• =MIN(A1:A5)

Which of the following will make the text in a cell bold?

• Pressing Ctrl + I

• Pressing Ctrl + U

• Pressing Ctrl + B

• Pressing Ctrl + S

If you want to change the background colour of a cell, which Excel feature should you use?

• Font Colour

• Fill Colour

• Conditional Formatting

• Data Validation

Which formula would you use to multiply the values in cells C2 and D2?

• =C2+D2

• =C2-D2

• =C2*D2

• =C2/D2

How can you quickly copy the formatting from one cell to another in Excel?

• Use the Format Painter tool

• Use the Fill Handle

• Use the Sort tool

• Use the Filter tool

Which formula would you use to find the highest value in the range B1:B10?

• =MIN(B1:B10)

• =MAX(B1:B10)

• =SUM(B1:B10)

• =COUNT(B1:B10)

What does the formula =SUM(A1:A4) do?

• Multiplies all values from A1 to A4

• Adds all values from A1 to A4

• Finds the average of A1 to A4

• Finds the minimum value from A1 to A4

Which option would you use to centre the contents of a cell horizontally?

• Align Left

• Align Right

• Centre

• Justify

If you want to display numbers as pounds sterling (£) in a cell, which formatting option should you use?

• Percentage

• Currency

• Date

• Fraction