Este test está cronometrado.
Tienes 15 minutos para completar 10 preguntas de este test.
Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?
Use conditional formatting
Use a comment
Use a data validation input message
None of these
How is an array formula identified in the formula bar in an Excel worksheet?
Chevron braces <>
Curly braces {}
Parentheses ()
Square brackets []
Sparklines are tiny charts that fit into one cell
TRUE
FALSE
Which function would you use to find the largest number of a selected range?
MAXIMUM
MAX
LARGE
LARGEST
Which wildcard character represents a single character?
*
?
!
&
You can create your own shortcuts in Excel
Yes
No
If we have the following function: VLOOKUP($N13,$I$13:$L$20,2,FALSE); Which column of the source table are we trying to extract?
First
Second
Third
Fourth
Which of the following statements about Excel macros is false?
A macro is stored in a macro-enabled workbook.
A macro can contain viruses or malicious code.
A macro name can include alphabetic and special characters.
A macro is a sequence of commands.
Is it possible to create pivot from multiple Excel Sheets?
How many arguments does the Sumifs function have?
1
2
3
N
