Excel Quiz

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Start

Congratulations - you have completed Excel Quiz.
You scored %%SCORE%% out of %%TOTAL%%.
Your performance has been rated as %%RATING%%

Your answers are highlighted below.

Return

Shaded items are complete.

1	2	3	4	5
6	7	8	9	10
End

Return

A	Cntrl+Shift+%
B	Cntrl+%
C	Shift+%
D	Cntrl+Shift+/

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

A	Compact
B	Report
C	Tabular
D	All of the above

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

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

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

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

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

A	TRUE
B	FALSE

A	rand()
B	rand;
C	rand= ( )
D	rand'