Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?

Use a data validation input message

Which of the following statements about Excel macros is false?

A macro name can include alphabetic and special characters.

A macro is stored in a macro-enabled workbook.

A macro can contain viruses or malicious code.

A macro is a sequence of commands.

Quiz

Jatin Banga 10 Fragen 1.002 Aufrufe

Quiz starten

Dieses Quiz hat ein Zeitlimit und öffnet sich deshalb im gewohnten Player.

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
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 []
3Sparklines are tiny charts that fit into one cell
1. ATRUE
2. BFALSE
4Which function would you use to find the largest number of a selected range?
1. AMAXIMUM
2. BMAX
3. CLARGE
4. DLARGEST
5Which wildcard character represents a single character?
1. A*
2. B?
3. C!
4. D&
6You can create your own shortcuts in Excel
1. AYes
2. BNo
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
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.
9Is it possible to create pivot from multiple Excel Sheets?
1. AYes
2. BNo
10How many arguments does the Sumifs function have?
1. A1
2. B2
3. C3
4. DN