Excel BI Analytics

Excel Quiz 26

Posted on by Vijay A. Verma

Quiz 26

This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly.

Please fill in your Name & Email to take the Quiz

(Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass)

1 / 10

Select the odd man out

2 / 10

The shortcut to insert a comment is CTRL+F2

3 / 10

Default Excel sorting is case-sensitive

4 / 10

How do you create a table?

5 / 10

If A1 = 24678.56 to nearest 100 is

6 / 10

To format a number, following can be done -

7 / 10

To delete a row

8 / 10

Apart from "=" (without quotes), you can start the formulas with "+" (without quotes) also

9 / 10

To generate an Integer random number between a and b, following formula can be used

10 / 10

To copy a formula down -

Your score is

LinkedIn Facebook Twitter

Exit

1 thought on “Excel Quiz 26”

  1. very interesting quiz.

    4. QUESTION
    Which function key can be used to change the cell?

    what is the mean of change the cell.
    I think that move the cell, and i given the answer F5, because I press F5 than open GO TO and write cell address in reference cell will be move at that address.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *