Unit 5:Introduction to FP&A: Excel Funcs and Form Investigation

What is the difference between a formula and a function in Excel?

• A formula is a predefined calculation, while a function is a user-created equation.

• A function is a predefined calculation, while a formula is a user-created equation.

• Both are the same and used interchangeably.

• A function can only be used for financial analysis.

Which symbol must be used at the beginning of every Excel formula?

• +

• -

• =

• /

What does the SUM() function do in Excel?

• Multiplies a range of numbers

• Adds a range of numbers

• Finds the highest value in a range

• Sorts numbers in ascending order

How do you reference a cell in Excel when writing a formula?

• By typing the word "Cell" followed by the number

• By using the letter and number of the cell (e.g., A1, B2)

• By using only the number (e.g., 1, 2, 3)

• By selecting the formula bar and pressing Enter

What is the purpose of the MIN() and MAX() functions in Excel?

• They find the lowest and highest values in a selected range.

• They add all values together.

• They calculate the percentage change.

• They sort data in ascending order.

Which Excel feature allows users to quickly apply formulas to multiple cells?

• AutoFill

• Conditional Formatting

• Data Validation

• Text to Columns

A(n) _________ is a prewritten formula that is built into EXCEL. 

• function
• problem
• equation
• equal sign