What is the correct formula to calculate the average of the values in the range B1 to B10 in Excel?

• =AVG(B1:B10)

• MEAN(B1:B10)

• =AVERAGE(B1:B10)

• =MID(B1:B10)

What is the correct formula to round the number 3.14159 to 2 decimal places in Excel?

• =ROUND(3.14159, 2)

• =ROUND(3.14159. 2)

• =ROUND(3.14159 2)

• =ROUND(3.14159; 2)

Which function in Excel finds the smallest number in a specified range?

• =MINIMUM(C1:C10)

• =MIN(C1:C10)

• =LEAST(C1:C10)

• =SMALL(C1:C10)

Which function in Excel finds the largest number in a specified range?

• =MAXIMUM(D1:D10)

• =MAX(D1:D10)

• =LARGE(D1:D10)

• =GREATEST(D1:D10)

What does the VLOOKUP function do in Excel?

• Searches for a value in the first row and returns a value in the same column from a specified row

• Searches for a value in the left-most column and returns a value in the same row from a specified column

• Searches for a value in a specified column and returns a value in the same row from the first column

• Searches for a value in the first column and returns a value in the same row from a specified column

What does the HLOOKUP function do in Excel?

• Searches for a value in the left-most column and returns a value in the same row from a specified column

• Searches for a value in the first row and returns a value in the same column from a specified row

• Searches for a value in a specified column and returns a value in the same row from the first column

• Searches for a value in the first column and returns a value in the same row from a specified column

What does the XLOOKUP function do in Excel?

• Searches for a value in the left-most column and returns a value in the same row from a specified column

• Searches for a value in the first row and returns a value in the same column from a specified row

• Searches for a value in the first row and returns a value in the same column from a specified row

• Searches for a value in a specified range and returns a corresponding value from another specified range

What is the purpose of a PivotTable in Excel?

• To visualize data with charts and graphs

• To summarize and analyze data by rearranging it into rows and columns

• To filter data based on certain conditions

• o perform complex calculations and data analysis

What is the primary use of a PivotChart in Excel?

• To create a visual representation of a PivotTable

• To filter and sort data

• o find the maximum and minimum values in a dataset

• To calculate averages and sums

Which Excel feature allows you to display only the data that meets certain conditions?

• Sort

• Filter

• PivotTable
  

• Lookup