Mastering Excel: Rows and Columns

What is the main purpose of using rows and columns in an Excel spreadsheet?

• To create a colourful design

• To organise and display data in a structured way

• To make the text bold

• To add pictures

How do you add two numbers in Excel?

• By using the formula =ADD(A1, B1)

• By using the formula =A1 + B1

• By using the formula =SUM(A1, B1)

• By using the formula =A1 * B1

Which Excel feature allows you to display text on multiple lines within a single cell?

• Text Colour

• Text Alignment

• Text Wrapping

• Text Highlighting

What is the result of multiplying the values in cells A1 and B1 using Excel?

• =A1 + B1

• =A1 / B1

• =A1 - B1

• =A1 * B1

What is the purpose of a footer in an Excel spreadsheet?

• To add a title to the spreadsheet

• To display information at the bottom of each printed page

• To change the background colour

• To insert a chart

Which of the following is a correct way to sum the values in cells A1 through A5 in Excel?

• =SUM(A1:A5)

• =ADD(A1:A5)

• =A1 + A5

• =TOTAL(A1:A5)

If you want to multiply the values in cells C1 and D1, which formula would you use?

• =C1 + D1

• =C1 * D1

• =C1 - D1

• =C1 / D1

How can you change the width of a column in Excel?

• By dragging the column border

• By double-clicking the cell

• By changing the font size

• By using the 'Insert' menu

What is the shortcut to wrap text in a cell in Excel?

• Ctrl + W

• Alt + Enter

• Ctrl + T

• Shift + Enter

Which of the following is NOT a valid Excel formula?

• =A1 + B1

• =A1 * B1

• =A1 - B1

• =A1 & B1