Excel

Which of the following is the correct formula to calculate the weighted average score?

• =SUMPRODUCT(C2:C5,B2:B5)

• =SUMPRODUCT(C2:C4,B2:B4)

• =AVERAGE(C2:C4)

• =AVERAGE(C2/4)

Which of the following features cannot be found in the Data ribbon?

• What-If Analysis

• PivotTable

• Data Validation

• Text to Columns

###### means:

• You've entered a number wrong.

• You've misspelled something.

• The cell is not wide enough.

• The formula is incorrect.

Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

• Count

• Average

• Sum

• Sumif

The formula = ((A2+B5)*5% is valid.

• True

• False

How many rows does an excel application has?

• 1,048,576 rows

• 2,048,576 rows

• 548,576 rows

• 5,048,576 rows

How many column does an excel application has?

• 15,384 columns

• 16,384 columns

• 16,000 columns

• 18,384 columns

Which of the following is the correct formula using nested if function?

• =NESTEDIF(B2>=80, "A", IF(B2>=60, "B", IF(B2>=45, "C", IF(B2 >=30, "D", "Fail" ) ) ) )

• =IF(80, "A", IF(60, "B", IF(45, "C", IF(30, "D", "Fail" ) ) ) )

• =IF(B2>=80, "A", IF(B2>=60, "B", IF(B2>=45, "C", IF(B2 >=30, "D", "Fail" ) ) ) )

• =IF(B2>=80, "A", IF(B2>=60, "B", IF(B2>=45, IF(B2 >=30, "Fail" )

Which of the following is the correct formula to count values that is greater that 70?

• =If(B2:I2, ">= 70")

• =Count(B2:I2, ">= 70")

• =CountIf(B2:I2, "= 70")

• =CountIf(B2:I2, ">= 70")