MS Excel Intermediate

Why are Excel formulas important in finance tasks?

• They make spreadsheets colorful

• They automate data entry

• They allow for complex calculations

• They create charts

What is the primary function of basic Excel functions in finance?

• Create pivot tables

• Summarise financial data

• Apply filters to data

• Design charts

What is the role of Pivot Tables in financial analysis?

• Creating charts

• Summarising financial information

• Automating data entry

• Changing cell formats

How can you make Pivot Tables more dynamic in Excel?

• By changing font sizes

• By applying filters and slicers

• By creating charts

• By adjusting cell borders

What is the primary purpose of the VLOOKUP function in Excel?

• To create pivot tables

• To calculate averages

• To retrieve data based on a lookup value

• To change cell formats

When would you use the approximate match scenario with VLOOKUP?

• When searching for an exact match

• When searching for the smallest value less than or equal to the lookup value

• When searching for the largest value less than or equal to the lookup value

• When searching for the largest value greater than the lookup value

What is the primary purpose of the IF function in financial modeling?

• To create charts

• To perform conditional calculations

• To calculate averages

• To retrieve data from tables

How does the IFERROR function help in financial modeling?

• It creates charts

• It handles errors gracefully

• It retrieves data from tables

• It calculates averages

What is the logic behind the AND function in Excel?

• It returns TRUE if any condition is TRUE

• It returns TRUE only if all conditions are TRUE

• It returns TRUE if no condition is TRUE

• It returns TRUE if any condition is FALSE

When might you use the OR function in financial analysis?

• When you want all conditions to be TRUE

• When you want at least one condition to be TRUE

• When you want to create charts

• When you want to calculate averages