Excel Certification Success Practice Questions 2023 - Part 8

1. Which of the following is an example of a chart type in Excel?

A) Lookup function
B) Conditional formatting
C) Scatter plot
D) VLOOKUP function



2. What is the difference between Scenario Manager and Data Tables in Excel?

A) Scenario Manager is used to create charts while Data Tables are used for forecasting
B) Data Tables allows users to analyze multiple scenarios while Scenario Manager is used to perform one specific calculation
C) Both Scenario Manager and Data Tables are used for what-if analysis
D) Scenario Manager allows users to analyze multiple scenarios while Data Tables are used to perform one specific calculation



3. Which Excel tool allows you to create a chart that shows the proportion of each data series in relation to the whole?

A) Line chart
B) Bar chart
C) Scatter chart
D) Pie chart



4. What is the purpose of Goal Seek in Excel?

A) To create a chart or graph
B) To identify relationships between variables
C) To analyze trends in data
D) To find a specific result by adjusting one input value



5. What is the purpose of using a data table in Excel?

A) To create custom charts and graphs based on large data sets.
B) To compare multiple scenarios side-by-side based on different inputs.
C) To display a range of calculated results based on varying inputs.
D) To perform what-if analysis and forecast future trends.