Excel Certification Success Practice Questions 2023 - Part 6

1. What is the purpose of a pivot chart?

A) To display the results of a pivot table visually
B) To filter and sort data
C) To perform calculations on data
D) To create custom formulas



2. What is the function used to find the largest value in a range?

A) AVERAGE
B) MIN
C) COUNT
D) MAX



3. What is the purpose of statistical functions in Excel?

A) To format cells and data
B) To sort and filter data
C) To perform mathematical and statistical calculations on data
D) To create validation rules for data entry



4. What is the difference between VLOOKUP and HLOOKUP functions in Excel?

A) VLOOKUP searches for values vertically while HLOOKUP searches horizontally
B) VLOOKUP is used for sorting while HLOOKUP is used to validate data
C) VLOOKUP searches for values horizontally while HLOOKUP searches vertically
D) VLOOKUP is used to validate data while HLOOKUP is used for sorting



5. What is the keyboard shortcut to apply conditional formatting to a selected cell or range of cells?

A) Alt + H + L + N
B) Alt+H+L
C) Ctrl+Shift+C
D) Ctrl+Alt+C