Final Excel Revision Test

Pivot Tables are used to:

• A. Sort data only

• B. Create charts

• C. Summarize and analyze large datasets

• D. Format data

In a Pivot Table, the “Values” field is typically used to:

• A. Filter data

• B. Format text

• C. Perform calculations like sum or average

• D. Create headings

What is a Slicer used for in a Pivot Table?

• A. To delete rows

• B. To edit formulas

• C. To filter Pivot Tables visually

• D. To create graphs

What does Conditional Formatting help with?

• A. Converting data types

• Visual data insights (like highlighting top performers)

• C. Creating pivot tables

• D. Changing font type

What does =IF(A1>100, "High", "Low") return when A1 = 120?

• A. 100

• B. TRUE

• C. Low

• D. High

What is the output of =IF(5=5, “Yes”, “No”)?

• Maybe
• Yes
• Absolutely not
• Definitely

What does VLOOKUP do?

• A. Looks horizontally

• B. Looks vertically

• C. Calculates totals

• D. Counts rows

What is the correct syntax of VLOOKUP?

• A. VLOOKUP(range, column, value, FALSE)

• B. VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• C. VLOOKUP(table, value, FALSE)

In which direction does HLOOKUP search?

• A. Looks horizontally
  

• B. Looks vertically
  

• C. Calculates totals
  

• D. Counts rows

What feature allows charts to update dynamically with filtered data?

• A. Freeze Panes

• B. Table Format

• C. Slicers

• D. Goal Seek