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.

Test

Jatin Banga 10 preguntas 1.002 visitas

Hacer el test

Este test tiene tiempo límite, así que se abre en el reproductor de siempre.

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