Excel for Accountants Masterclass - Afternoon

What is a key difference between Pivot Charts and Standard Charts in Excel?

• Pivot Charts can only display numerical data.

• Standard Charts are better for summarising large datasets.

• Pivot Charts are interactive and dynamically linked to PivotTables.

• Standard Charts offer more chart types and formatting options.

What is a limitation of Pivot Charts compared to Standard Charts in Excel?

• Pivot Charts cannot be customised in terms of chart type.

• Pivot Charts cannot display data from external sources.

• Pivot Charts are not suitable for presenting data in meetings.

• Pivot Charts may have limited formatting options.

What is the primary benefit of using keyboard shortcuts in Excel for accountants?

• They make your spreadsheets more visually appealing.

• They allow for faster and more efficient navigation and data entry.

• They automatically perform complex calculations.

• They enable real-time collaboration with colleagues.

Why do accountants use charts in Excel?

• To automatically calculate financial ratios.

• To make financial data more visually appealing.

• To create pivot tables.

• To format cells and apply styles.

In Excel, what is a scenario?

• A financial statement template.

• A way to organise worksheets.

• A what-if analysis tool to explore different sets of data.

• A summary chart.

How can you create multiple versions of a worksheet within the same Excel workbook?

• By saving different workbooks for each version.

• By using scenarios.

• By inserting new worksheets.

• By applying conditional formatting.

Which Excel feature is used to compare two or more scenarios side by side in a worksheet?

• Goal Seek

• Scenario Manager

• Conditional Formatting

• Pivot Tables

In Excel, what does "implicit intersection" refer to?

• A method to combine multiple worksheets into one.

• The process of automatically calculating subtotals.

• A feature that allows you to avoid errors in formulas.

• The way Excel handles cell references when they intersect with a formula.

Which symbol is used to indicate implicit intersection in Excel formulas?

• $

• @

• #

• !

What is the primary purpose of the Goal Seek tool in Excel for accountants?

• To create pivot tables.

• To format cells and apply styles.

• To perform what-if analysis by finding the input value needed to achieve a desired result.

• To generate financial statements.