Welcome to your Microsoft Excel Class 4 (Final)
1.
What Excel function is used to search for a value in the first column of a table and return a value in the same row from another column?
2.
Which Excel function is used to search for a value in the top row of a table or array of values and return a value in the same column from a row you specify?
3.
Which Excel function is designed to replace both VLOOKUP and HLOOKUP and can search in both vertical and horizontal directions?
4.
What Excel feature is used to summarize and analyse data in a spreadsheet quickly and efficiently?
5.
What Excel feature provides a visual representation of data from multiple sources, allowing users to monitor and analyse key performance indicators (KPIs)?
6.
Which of the following is NOT a function but a tool used to visualize data in Excel?
7.
What is the primary purpose of using VLOOKUP in Excel?
8.
Which Excel function is commonly used for financial modelling and forecasting?
9.
What type of data is best suited for analysis using Pivot Tables?
10.
Which Excel feature allows users to group and summarize large amounts of data dynamically?
11.
What Excel function is used to perform approximate or exact matches by looking up data in
12.
In Excel, what function should you use to retrieve data from a table by matching criteria horizontally?
13.
What Excel function can be used to search a range or table for specific criteria and return a corresponding value?
14.
Which Excel feature allows users to create interactive visualizations and reports?
15.
In Excel, what function is commonly used to retrieve data based on a unique identifier?
16.
What Excel feature is used to analyse large datasets and summarize them into a concise format?
17.
Which function should you use in Excel to search for data across rows and return a corresponding value from a column?
18.
What Excel function can be used to search for specific data within a range and return a corresponding value?
19.
What feature in Excel allows users to create interactive and dynamic reports based on data?
20.
In Excel, what function is used to search for a value in a table or range and return a corresponding value?
Leave a Reply