Advanced ICT Concepts Exam Reviewer

Front

What is the first step in the provided list for creating a Pivot Chart in Excel?

Back

Select a cell in your table

Front

Which specific element of Conditional Formatting changes the visual appearance of cells, such as adding data bars, color scales, or icons, based on rules?

Back

The cell formatting options

Front

What feature in Excel allows users to visually represent data trends over time using a graphical format?

Back

Charts

Front

In Excel, which function would you use to calculate the average of a range of cells?

Back

AVERAGE

Front

What is the purpose of the VLOOKUP function in Excel?

Back

To find a value in the first column of a table and return a value in the same row from a specified column

Front

Which What-If Analysis tool is used to save and easily switch between a 'best-case' and a 'worst-case' financial outcome on a single worksheet?

Back

Scenario Manager

Front

In the context of What-If Analysis, what is a Scenario?

Back

A set of values that Excel saves and can substitute automatically in cells.

Front

What advantage do Data Tables offer regarding data freshness if automatic recalculation is enabled for the workbook?

Back

The data immediately recalculates, ensuring users always have fresh data.

Front

What specific capability allows a Pivot Table to show different data perspectives (e.g., totals, averages, counts)?

Back

Its function to rearrange fields.

Front

The Goal Seek feature helps determine the input value needed when the desired output (result) of a formula is already what?

Back

Known or predefined by the user.