GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

MS Excel Pre-Assessment Test

Jatin Banga 10 questions 1,002 views

Take the quiz

This quiz has a time limit, so it opens in the usual player.

Questions in this quiz (10)

  1. 1 Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?
    1. AUse conditional formatting
    2. BUse a comment
    3. CUse a data validation input message
    4. DNone of these
  2. 2How is an array formula identified in the formula bar in an Excel worksheet?
    1. AChevron braces <>
    2. BCurly braces {}
    3. CParentheses ()
    4. DSquare brackets []
  3. 3Sparklines are tiny charts that fit into one cell
    1. ATRUE
    2. BFALSE
  4. 4Which function would you use to find the largest number of a selected range?
    1. AMAXIMUM
    2. BMAX
    3. CLARGE
    4. DLARGEST
  5. 5Which wildcard character represents a single character?
    1. A*
    2. B?
    3. C!
    4. D&
  6. 6You can create your own shortcuts in Excel
    1. AYes
    2. BNo
  7. 7If we have the following function: VLOOKUP($N13,$I$13:$L$20,2,FALSE); Which column of the source table are we trying to extract?
    1. AFirst
    2. BSecond
    3. CThird
    4. DFourth
  8. 8Which of the following statements about Excel macros is false?
    1. AA macro is stored in a macro-enabled workbook.
    2. BA macro can contain viruses or malicious code.
    3. CA macro name can include alphabetic and special characters.
    4. DA macro is a sequence of commands.
  9. 9Is it possible to create pivot from multiple Excel Sheets?
    1. AYes
    2. BNo
  10. 10How many arguments does the Sumifs function have?
    1. A1
    2. B2
    3. C3
    4. DN

Information

Description
Your MS Excel learning journey starts here
Language
English
Views
1,002
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?