Advanced ICT Concepts Exam Reviewer

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

• Select where you want the PIVOT CHART to appear

• Select a cell in your table

• Select the fields to display in the menu

• Select INSERT and choose PIVOT CHART

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

• The cell formatting options

• The What-If Analysis toolset

• The Recalculation engine

• Pivot Tables

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

• Tables

• Conditional Formatting

• Charts

• Data Validation

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

• MAX

• SUM

• AVERAGE

• COUNT

What is the purpose of the VLOOKUP function in Excel?

• To create a chart from data

• To sum a range of cells

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

• To format cells based on their values

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?

• Data Tables

• Pivot Charts

• Scenario Manager

• 
  Goal Seek

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

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

• A tabular presentation of formula outputs based on two changing variables.

• A formula that is too complex for standard calculation.

• A calculated output value needed to achieve a profit goal.

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

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

• The data must be manually refreshed by the user.

• The results are only updated when the worksheet is closed and reopened.

• The data becomes static and cannot be changed after creation.

A Pivot Table’s purpose is best described as summarization and analysis. What specific capability allows it to show different data perspectives (e.g., totals, averages, counts)?

• Its reliance on external databases.

• Its function to rearrange fields.

• Its use of Conditional Formatting.

• Its ability to sort data in alphabetical order.

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

• Unknown or impossible to achieve.

• A value of zero.

• The result of a complex statistical model.

• Known or predefined by the user.