J836 Starter Questions 15/02/2024

What function would you use to calculate the sum of a range of cells in Excel?

• `AVERAGE()`

• `SUM()`

• `COUNT()`

• `MAX()`

Which feature in Excel allows you to find the input value that will produce a desired result in a single cell?

• Conditional Formatting

• Data Validation

• Goal-Seek

• Solver

What is a Pivot Table used for in Excel?

• To combine text from two or more cells into one cell

• To calculate the total across a row or down a column

• To summarize, analyze, explore, and present summary data

• To change the font and style of text in cells

Which type of cell reference changes when it is copied to another cell?

• Absolute

• Mixed

• Relative

• External

How can you create a chart or graph in Excel?

• Insert > Picture

• Insert > Chart

• Format > Chart

• Data > Chart

What function can be used to count the number of cells in a range that contain numbers?

• `COUNT()`

• `SUM()`

• `AVERAGE()`

• `COUNTIF()`

In Excel, what does the `VLOOKUP()` function do?

• Looks up text that contains "V"

• Finds the value in a cell vertically

• Searches for a value in the first column of a table and returns a value in the same row from a specified column

• Validates the data in selected cells

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

• Pie Chart

• Bar Chart

• Spider Chart

• Line Chart

What does the `$` symbol in a cell reference signify in Excel?

• The cell reference is relative

• The cell reference is mixed

• The cell reference is absolute

• The cell is locked for editing

When using Goal-Seek, which of the following must you know beforehand?

• The formula that will be used

• The desired result of a formula

• The cell that contains the formula

• All of the above