Working with Advanced Functions

What are the common functions used in Excel?

• DIVIDE, MAX, MIN

• ADD, SUBTRACT, MULTIPLY

• SORT, FILTER, SEARCH

• SUM, AVERAGE, COUNT

What is the formula template for the IF function in Excel?

• =IF([text to display if true], [comparison], [text to display if false])

• =IF([text to display if false], [text to display if true], [comparison])

• =IF ([comparison]), [text to display if true], [text to display if false])

• =IF([text to display if false], [comparison], [text to display if true])

What is the purpose of the AutoSum function in Excel?

• To find the sum of numbers in a column including blanks

• To find the average of numbers in a row

• To sort data in ascending order

• To calculate the product of numbers in a range

What does the VLOOKUP function in Excel do?

• Finds the average of selected rows

• Calculates the total of selected columns

• Performs a horizontal lookup in rows

• Performs a vertical lookup in columns

What is the formula for the SUMIF function in Excel if you want to sum numbers greater than 80?

• =SUMIF(Al:A5,"!=80")

• =SUMIF(Al:A5,">80")

• =SUMIF(Al:A5,"<80")

• =SUMIF(Al:A5,"=80")

What does the IF function in Excel do?

• Performs conditional decision making based on data entered

• Calculates the square root of a number

• Converts text to uppercase

• Rounds a number to the nearest integer

What is the purpose of the HLOOKUP function in Excel?

• Finds the maximum value in a row

• Performs a horizontal lookup in rows

• Counts the number of cells in a range

• Performs a vertical lookup in columns

How can you copy a formula to multiple cells in Excel?

• Press Ctrl+C and Ctrl+V

• Drag the little green box on the lower right corner of the active cell

• Right-click and select Copy, then Paste

• Double-click on the cell with the formula

What is the purpose of the AVERAGEIF function in Excel?

• Calculates the average of selected cells based on a condition

• Counts the number of cells with specific criteria

• Finds the maximum value in a range

• Sorts data in descending order

What are relational operators used for in Excel formulas?

• Create hyperlinks in cells

• Change the font style of text

• Merge cells in a range

• Compare values in specified cells