Excel Workshop Jul 2023

What is the shortcut key to save an Excel file?

• Ctrl+S
• Ctrl+X
• Ctrl+C
• Ctrl+V

Which function is used to calculate the average of a range of cells in Excel?

• SUM
• MAX
• AVERAGE
• COUNT

Which formula is used to add up the values in cells A1 and B1?

• "=A1-B1"
• "=A1*B1"
• "=A1/B1"
• "=A1+B1"

In Excel, which function is used to find the largest value in a range of cells?

• AVERAGE
• MAX
• MIN
• COUNT

What does the CONCATENATE function do in Excel?

• Adds two numbers together
• Combines text from multiple cells into one cell
• Finds the largest value in a range of cells
• Calculates the average of a range of cells

Which of the following is an example of a logical function in Excel?

• SUM
• AVERAGE
• IF
• COUNT

Which Excel feature is used to organize and summarize large amounts of data?

• Pivot Table
• VLOOKUP
• Conditional Formatting
• Goal Seek

Which function is used to count the number of cells that contain numerical values in a range?

• COUNT
• AVERAGE
• MAX
• MIN

What is the purpose of the SUM function in Excel?

• To find the smallest value in a range of cells
• To calculate the average of a range of cells
• To add up the values in a range of cells
• To count the number of cells in a range

Which Excel function is used to round a number to the nearest whole number?

• ROUND
• CEILING
• FLOOR
• TRUNC