Excel Quiz

1

Instructions For Quiz

This Mock Test has 10 Questions
Each Question is of 1 marks so total 10 marks
Multiple Choice Questions(MCQ) with only ONE valid answer

2

1) What is the short cut key for applying the percentage format with no decimal place in Excel 2013?* This field is required.

Cntrl+Shift+%

Cntrl+%

Shift+%

Cntrl+Shift+/

3

2) Mention what does the LEN formula used for in Excel 2013?* This field is required.

Counts the total sum of the numbers

Count only the numbers

Count number of character excluding spaces

Count number of characters including spaces

4

3) What are the reports available in Excel?* This field is required.

Compact

Report

Tabular

All of the above

5

4) It is not possible to display the text in the data area of Pivot Table?* This field is required.

TRUE

FALSE

6

5) Mention what is the use of AND formula?* This field is required.

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

7

6) Mention what is the use of Rept formula?* This field is required.

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

8

7) What is the use of Not formula?* This field is required.

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

9

8) What does the Npv formula is used for?* This field is required.

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

10

9) What is the syntax of Rand formulas?* This field is required.

rand()

rand;

rand= ( )

rand'

11

10) What is the use of Round formula?* This field is required.

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