Microsoft Excel Quiz

What is the primary purpose of Microsoft Excel?

• Graphic design

• Word processing

• Data entry and analysis

• Web development

Which function is used to search for a value in the first column of a table?

• Aunty

• SUMIF

• VLOOKUP

• HLOOKUP

What is the syntax for the VLOOKUP function?

• =LOOKUP(value, table, index)

• =VLOOKUP(value, table, index, range)

• =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• =VLOOKUP(lookup_value, table, index)

What does the HLOOKUP function do?

• Searches vertically in a table

• Searches horizontally in a table

• Calculates the average of a range

• Sorts data in ascending order

Which of the following is NOT a built-in function in Excel?

• SUM

• AVERAGE

• VLOOKUP

• CALCULATE

What is the purpose of Conditional Formatting in Excel?

• To freeze panes

• To format cells based on specific conditions

• To sort data

• To create charts

What does the CONCATENATE function do?

• Joins two or more text strings together

• Counts the number of cells in a range

• Calculates the sum of a range

• Finds the maximum value in a range

In the context of Excel, what is a Pivot Table used for?

• To summarize and analyze data

• To create charts

• To enter formulas

• To format cells

What is the purpose of the CHOOSE function in Excel?

• To create a chart

• To sort data

• To calculate the average of a range

• To select a value from a list based on an index number

Which of the following is an example of a logical function in Excel?

• IF

• SUM

• COUNT

• AVERAGE