Excel Quiz
Start
Congratulations - you have completed Excel Quiz.
You scored %%SCORE%% out of %%TOTAL%%.
Your performance has been rated as %%RATING%%
You scored %%SCORE%% out of %%TOTAL%%.
Your performance has been rated as %%RATING%%
Your answers are highlighted below.
Question 1 |
What is the short cut key for applying the percentage format with no decimal place in Excel 2013?
A | Cntrl+Shift+% |
B | Cntrl+% |
C | Shift+% |
D | Cntrl+Shift+/ |
Question 2 |
Mention what does the LEN formula used for in Excel 2013?
A | Counts the total sum of the numbers |
B | Count only the numbers |
C | Count number of character excluding spaces |
D | Count number of characters including spaces |
Question 3 |
What are the reports available in Excel?
A | Compact |
B | Report |
C | Tabular |
D | All of the above |
Question 4 |
It is not possible to display the text in the data area of Pivot Table?
A | TRUE |
B | FALSE |
Question 5 |
Mention what is the use of AND formula?
A | Give the sum of two number joined by AND |
B | Counts blank cells in a given cell |
C | Checks whether all conditions are passed or not |
D | Finds the largest number in a list |
Question 6 |
Mention what is the use of Rept formula?
A | It repeats a particular text n number of times |
B | It removes the unnecessary space from the text |
C | It finds the maximum of a given list of numbers |
D | It finds the minimum of a given list of numbers |
Question 7 |
What is the use of Not formula?
A | To find the number in the list |
B | To count character without spaces |
C | Check whether condition pass is true or not |
D | To negate a logical value |
Question 8 |
What does the Npv formula is used for?
A | Calculates the outstanding payment amount |
B | Calculates net present value from a series of future payments |
C | Calculates how much you should pay for your mortgage |
D | Finds out how much a series of payment is worth in future |
Question 9 |
What is the syntax of Rand formulas?
A | rand() |
B | rand; |
C | rand= ( ) |
D | rand' |
Question 10 |
What is the use fo Round formula?
A | Always give the round value without decimal |
B | Gives the exact decimal value you specify |
C | Rounds a number to nearest decimal you specify |
D | 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.
← |
List |
→ |
Return
Shaded items are complete.
1 | 2 | 3 | 4 | 5 |
6 | 7 | 8 | 9 | 10 |
End |
Return
You have completed
questions
question
Your score is
Correct
Wrong
Partial-Credit
You have not finished your quiz. If you leave this page, your progress will be lost.
Correct Answer
You Selected
Not Attempted
Final Score on Quiz
Attempted Questions Correct
Attempted Questions Wrong
Questions Not Attempted
Total Questions on Quiz
Question Details
Results
Date
Score
Hint
Time allowed
minutes
seconds
Time used
Answer Choice(s) Selected
Question Text
All done
Need more practice!
Keep trying!
Not bad!
Good work!
Perfect!