Data Science-Spreadsheet Functions

Which formula is used to find the average of a set of numbers in Excel?

• =SUM(A1:A10)

• =MIN(A1:A10)

• AVERAGE(A1:A10)

• =AVERAGE(A1:A10)

The formula =IF(A1>50, "Pass", "Fail") will return "Pass" if:

• A1 contains the text 'Pass'.
• A1 contains a number greater than 50.
• A1 is empty or contains no value.
• A1 contains a number less than 50.

Which function is used to round a number to two decimal places?

• =TRUNC(A1,2)

• =ROUND(A1,2)

• ROUND(A1,2)

• =RND(A1,2)

What does the $ symbol do in a cell reference, such as $A$1?

• The $ symbol makes the cell reference relative, allowing it to change when copied.
• The $ symbol is used to format the cell as currency.
• The $ symbol indicates a formula error in the cell reference.
• The $ symbol makes the cell reference absolute, preventing it from changing when copied.

What formula is used to calculate the sum of a range of cells in Excel?

• =SUMIF(A1:A10)

• =TOTAL(A1:A10)

• =SUM(A1:A10)

• =ADD(A1:A10)

In Excel, which formula returns the highest value in a range?

• =MIN(A1:A10)

• MAX(A1:A10)

• =MAX(A1:A10)

• =SUM(A1:A10)

Which function can be used to find the rank of a number in a list?

• =RANK(A1,A1:A10)

• RANK(A1,A1:A10)

• =MATCH(A1,A1:A10,0)

• =INDEX(A1:A10,3)

How can you use conditional formatting to highlight cells that contain values greater than 90?

• Use conditional formatting to highlight cells greater than 90 by creating a new rule with the condition 'greater than 90'.
• Create a rule to highlight cells with values between 80 and 90.
• Use conditional formatting to highlight cells equal to 90.
• Highlight cells that contain values less than 90.

Which formula would count the number of cells in a range that contain numbers?

• =SUM(A1:A10)
  
  

• COUNT=(A1:A10)
  
  

• =COUNT(A1:A10)
  
  

• =AVERAGE(A1:A10)
  
  

In a pivot table, which area is used to add the values you want to summarize?

• Rows area
• Columns area
• Values area
• Filters area