Excel

What symbol is used to indicate the start of a formula in Excel?

• @
• $
• =
• *

Answer explanation

In Excel, formulas always begin with the equals sign (=).

How can you quickly sum a column of numbers in Excel?

• Manually type the sum
• Use the AutoSum function
• Use the Count function
• Use the Average function

Answer explanation

The AutoSum function is a quick way to sum a range of cells in Excel.

What is the purpose of freezing panes in Excel?

• To prevent unauthorised users from accessing the worksheet

• To keep certain rows or columns visible while scrolling

• To convert data into a fixed format

• To hide sensitive information in the workbook

Which of the following is NOT a valid chart type in Excel?

• Bar chart
• Line chart
• Pie chart
• Text chart

Answer explanation

Excel does not have a built-in chart type specifically for text data.

In Excel, what is the intersection of a column and a row called?

• Square
• Cell
• Intersection
• Block

Answer explanation

The intersection of a column and a row in Excel is referred to as a cell.

What function would you use to find the largest number in a range of cells?

• MAX
• MIN
• LARGE
• BIG

Answer explanation

The MAX function in Excel returns the largest value from a range of cells.

Why would you use Conditional Formatting?

• To create a chart

• To add the contents of cells together

• To change the appearance of cells in a range based on specified conditions

• To make the contents of cells a different colour so that people can see them better

Which of the following formatting options in Excel allows you to change the appearance of cell borders?

• Font
• Alignment
• Number
• Border

Answer explanation

The Border formatting option in Excel allows you to change the appearance of cell borders.

What is the purpose of the VLOOKUP function in Excel?

• To display the average of a range of cells

• Don't know

• To count the number of cells that meet a specified condition

• To search for a value in a vertical range and return a corresponding value from the same row

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

• Dragging the column boundary
• Right-clicking on the column and selecting "Format Column Width"
• Using the AutoFit option
• All options

Answer explanation

You can change the width of a column in Excel by dragging the column boundary.