Chapter 7 – Statistical Formulas in Excel December 27, 2024 by Satish Dhawale Welcome to your Chapter 7 - Statistical Formulas in Excel Name Email Phone 1. What does the dollar sign ($) do in Excel formulas? Locks the entire formula Locks only the row Locks the reference Locks only the column None 2. Which Excel function is used to sum values with multiple criteria? SUMIF COUNTIF SUMIFS AVERAGEIF None 3. How do you reference an absolute cell in Excel? A1 $A1 $A$1 A$1 None 4. What does the COUNTIFS function do in Excel? Counts all values in a range Counts values based on criteria Sums values based on criteria Averages values in a range None 5. Which of the following is used to apply conditional formatting in Excel? Data Validation Pivot Table Format as Table Conditional Formatting None 6. Which function would you use to look up a value horizontally in Excel? VLOOKUP HLOOKUP INDEX MATCH None 7. How do you remove duplicate values in Excel? Data Validation Conditional Formatting Remove Duplicates Sort and Filter None 8. Which function helps to find the maximum value in a range in Excel? MAX SUM AVERAGE COUNT None 9. What is the default reference style in Excel? A1 Style R1C1 Style Alpha Numeric Style None None 10. What does the formula =IF(A1>10, "Yes", "No") return if A1 is 12? Yes No Error Blank None Time's upTime is Up! Post Views: 3,504
