%%FORM%%Congratulations - you have completed Excel Quiz.You scored %%SCORE%% out of %%TOTAL%%.Your performance has been rated as %%RATING%%
Your answers are highlighted below.
What is the short cut key for applying the percentage format with no decimal place in Excel 2013?
Mention what does the LEN formula used for in Excel 2013?
Counts the total sum of the numbers
Count only the numbers
Count number of character excluding spaces
Count number of characters including spaces
What are the reports available in Excel?
All of the above
It is not possible to display the text in the data area of Pivot Table?
Mention what is the use of AND formula?
Give the sum of two number joined by AND
Counts blank cells in a given cell
Checks whether all conditions are passed or not
Finds the largest number in a list
Mention what is the use of Rept formula?
It repeats a particular text n number of times
It removes the unnecessary space from the text
It finds the maximum of a given list of numbers
It finds the minimum of a given list of numbers
What is the use of Not formula?
To find the number in the list
To count character without spaces
Check whether condition pass is true or not
To negate a logical value
What does the Npv formula is used for?
Calculates the outstanding payment amount
Calculates net present value from a series of future payments
Calculates how much you should pay for your mortgage
Finds out how much a series of payment is worth in future
What is the syntax of Rand formulas?
rand= ( )
What is the use fo Round formula?
Always give the round value without decimal
Gives the exact decimal value you specify
Rounds a number to nearest decimal you specify
All of the above
Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results
There are 10 questions to complete.
Shaded items are complete.
You have completed
Your score is
You have not finished your quiz. If you leave this page, your progress will be lost.
Final Score on Quiz
Attempted Questions Correct
Attempted Questions Wrong
Questions Not Attempted
Total Questions on Quiz
Answer Choice(s) Selected
Need more practice!