8405728
Descrição
Quiz por Jatin Banga, atualizado more than 1 year ago
|
Criado por Jatin Banga
mais de 7 anos atrás
|
|
Questão 1
Questão
Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?
Responda
-
Use conditional formatting
-
Use a comment
-
Use a data validation input message
-
None of these
Questão 2
Questão
How is an array formula identified in the formula bar in an Excel worksheet?
Responda
-
Chevron braces <>
-
Curly braces {}
-
Parentheses ()
-
Square brackets []
Questão 3
Questão
Sparklines are tiny charts that fit into one cell
Responda
-
TRUE
-
FALSE
Questão 4
Questão
Which function would you use to find the largest number of a selected range?
Responda
-
MAXIMUM
-
MAX
-
LARGE
-
LARGEST
Questão 5
Questão
Which wildcard character represents a single character?
Responda
-
*
-
?
-
!
-
&
Questão 6
Questão
You can create your own shortcuts in Excel
Responda
-
Yes
-
No
Questão 7
Questão
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?
Responda
-
First
-
Second
-
Third
-
Fourth
Questão 8
Questão
Which of the following statements about Excel macros is false?
Responda
-
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.
Questão 9
Questão
Is it possible to create pivot from multiple Excel Sheets?
Responda
-
Yes
-
No
Questão 10
Questão
How many arguments does the Sumifs function have?
Responda
-
1
-
2
-
3
-
N
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.