Introduction to FP&A: Excel Functions and Formulas Quiz

Which of the following is NOT a function in Excel?

• SUM

• AVERAGE

• MULTIPLY

• MIN

What is the correct formula to add values in cells A1 and A2?

• =A1+A2

• A1+A2

• SUM(A1, A2)

• =SUM(A1:A2)

What will the formula =AVERAGE(10, 20, 30, 40) return?

• 10

• 25

• 40

• 100

What will =ROUND(3.786,2) return?

• 3.79

• 3.78

• 3.8

• 3.7

What is a formula in Excel?

• A built-in command that performs a specific task

• A predefined calculation used to analyze data

• An equation entered by the user to perform calculations

• A formatting tool for numbers

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

Which function rounds a number down to the nearest whole number?

• ROUND

• ROUNDUP

• ROUNDDOWN

• TRUNCATE

Which formula correctly calculates the percentage change between two values in Excel?

• (A1-A2)/A1

• ((A1-A2)/A2) * 100

• (A2-A1)/A1

• (A1*A2)/100

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 a function in Excel?

• A mathematical equation manually created by the user

• A predefined formula that performs calculations using specific values

• A tool for formatting text and numbers

• A feature used only for financial calculations