Advanced Excel

What is MS Excel primarily used for?

• Graphic design

• Analyzing and visualizing data

• Word processing

• Creating presentations

Which function in Excel is used to search for a value in a table and return a corresponding value?

• SUM

• AVERAGE

• VLOOKUP

• ROUND

What type of chart is best suited for showing the distribution of data and highlighting relative sizes of different categories?

• Column Chart

• Bar Chart

• Pie Chart

• Area Chart

Which AI feature in Excel uses pattern recognition to automate repetitive data entry tasks?

• Data from picture

• Flash Fill

• Analyze data

• AI Functions

Which AI function in Excel can be used to format values such as date, time, and currency?

• AI.ASK

• AI.TABLE

• AI.EXTRACT

• AI.FORMAT

What is the key element of a Pie Chart in Excel?

• Vertical bars of varying heights

• Data points connected by lines

• Circular graph divided into slices

• Horizontal bars

What type of chart is best suited for visualizing trends and patterns over time?

• Column Chart

• Pie Chart

• Bar Chart

• Line Chart

Which Excel feature uses AI to provide automated pivot tables, charts, and summaries?

• Data from picture

• Analyze data

• Flash Fill

• Power Automate

What is the main purpose of an Analytical Dashboard in Excel?

• To forecast performance and track KPIs

• To analyze current and future trends

• To identify market trends

• To monitor operations and activities

Which AI function in Excel can be used to list the top requirements for a specific role?

• AI.LIST

• AI.EXTRACT

• AI.TABLE

• AI.ASK