Excel Functions and Features Assessment

This video tutorial covers essential Excel expert skills, including using the Fill Series feature, lookup functions like HLOOKUP and VLOOKUP, creating macros, and working with pivot tables. It also explains how to manage Excel settings, use advanced conditional formatting, and work with dates and charts. The tutorial aims to help viewers master these skills to pass Excel expert exams or enhance their proficiency.

What is the purpose of the Fill Series feature in Excel?

• To automatically fill cells with a sequence of numbers or dates

• To sort data in ascending order

• To format cells with specific colors

• To create a chart from selected data

Which function is used for horizontal lookup in Excel?

• VLOOKUP

• HLOOKUP

• INDEX

• MATCH

What is a macro in Excel?

• A method to sort data

• A tool to create charts

• A function to calculate averages

• A feature to automate repetitive tasks

How can you group values in a pivot table?

• By using the Format feature

• By using the Group feature

• By using the Filter feature

• By using the Sort feature

What setting should you change to prevent Excel from automatically recalculating formulas?

• Change the Calculation option to Manual

• Disable all macros

• Enable the Trust Center

• Use the Data Validation feature

What is the purpose of the AVERAGEIFS function?

• To calculate the average of a range based on multiple criteria

• To sum values based on a single condition

• To find the maximum value in a range

• To count the number of cells that meet a condition

How can you fix a formula error in Excel?

• By using the Error Checking feature

• By changing the cell color

• By using the Data Validation feature

• By sorting the data

What is a slicer in Excel?

• A tool to create charts

• A function to calculate averages

• A visual way to filter data in tables and pivot tables

• A method to sort data

What must you do before adding subtotals to a worksheet?

• Create a pivot table

• Convert the data range to a table

• Ensure the data is sorted and not in a table format

• Apply conditional formatting

What is a combo chart in Excel?

• A chart that automatically updates with new data

• A chart that only shows line graphs

• A chart that displays data in a 3D format

• A chart that combines two different chart types on the same axis