Excel

What is the default file extension of an Excel workbook in recent versions?

• .xls

• .xlsx

• .csv

• .docx

What is the maximum number of rows in an Excel 2021 worksheet?

• 65,536

• 1,048,576

• 10,000,000

• Unlimited

Which function counts both alphabetic and numerical values in a range?

• COUNT

• COUNTA

• COUNTIF

• DCOUNT

Which chart is best for showing trends over time?

• Line Chart

• Pie Chart

• Scatter Plot

• Bar Chart

The difference between VLOOKUP and HLOOKUP is:

• HLOOKUP is faster

• VLOOKUP searches rows ; HLOOKUP searches columns

• VLOOKUP is for numbers, HLOOKUP is for text

• VLOOKUP searches columns; HLOOKUP searches rows

What is Power Pivot used for in Excel?

• Managing large Multiple datasets

• Creating macros

• Formatting cells

• Removing duplicates

What does the MATCH function do?

• Finds the position of a value in a range

• Finds the Value of a position in a range

• Sorts data in ascending order

• Counts the number of unique values

What is Power Query used for?

• Data extraction and transformation

• Formatting numbers

• Sorting columns

• Creating pivot charts

What is the purpose of a macro in Excel?

• Format text automatically

• Automate repetitive tasks

• Sort data alphabetically

• Create charts

Which is Faster?

• Vlookup

• Hlookup

• INDEX MATCH

• MACRO