Microsoft Excel Advance Assessment
1 / 15
By default, Excel shows the results of formulas. To show the formula instead of their results, execute one of the following :
2 / 15
The SUMIF sums the values within a range that meet specified criteria
3 / 15
Which Excel menu contains this dialog box?
4 / 15
=Proper(A1) will return the following result
5 / 15
Smart Table is used to automatically capture new value and update the formula range.
6 / 15
Write a formula to calculate average Sales
7 / 15
=IF(A2>80,”A”,IF(A2>70,”B”,IF(A2>60,”C”,IF(A2>40,”D”,”FAILED”)))) can be replaced with
8 / 15
Write a formula to calculate total Sales
9 / 15
Write a formula to calculate count Sales
10 / 15
To add a value of $5000 to a range of numbers, we need to perform paste special function
11 / 15
To create a drop down list , Data Validation is required.
12 / 15
If cells: K1=90, K2=85, K3=80, K4=75, K5=75.What will be your formula if you are going to the average?
13 / 15
Transpose is used to change a horizontal table to a vertical layout
14 / 15
Write a formula to get the remarks in the cell E10 that valued 75 which noted, if the remarks is higher than 74, remarks will be PASSED or else FAILED.
15 / 15
F4 Function Key is used to apply Absolute and Relative References
Your score is
