Excel Functions and Formulas Quiz

What is Excel?

• A spreadsheet software developed by Microsoft

• A word processing software

• A database management system

• A presentation software

What is a formula in Excel?

• A predefined calculation

• An expression that operates on values

• A type of chart

• A function library

What does the SUM function do?

• Adds the values of cells

• Calculates the average

• Counts the number of cells

• Finds the maximum value

What is the first step in creating a formula?

• Select a cell that will contain the formula

• Type the mathematical operator

• Press enter

• Type the cell address

What is the purpose of the Filter feature in Excel?

• To sort data

• To eliminate irrelevant entries

• To create charts

• To format cells

What is a Column Chart?

• A vertical chart used to represent data

• A horizontal chart

• A type of pie chart

• A chart that shows trends over time

What is the function of the 'Insert Function' feature?

• To insert pre-built functions/formulas

• To create charts

• To format cells

• To sort data

What does the AVERAGE function do?

• Calculates the average of values

• Counts the number of cells

• Finds the maximum value

• Adds the values of cells

What is the purpose of sorting in Excel?

• To arrange data in a specific order

• To eliminate irrelevant data

• To create charts

• To format cells

What is a Pie Chart used for?

• To compare proportions

• To show trends over time

• To represent data in vertical bars

• To display numerical data