8405728
Beschreibung
Quiz von Jatin Banga, aktualisiert more than 1 year ago
|
Erstellt von Jatin Banga
vor etwa 7 Jahre
|
|
Frage 1
Frage
Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?
Antworten
-
Use conditional formatting
-
Use a comment
-
Use a data validation input message
-
None of these
Frage 2
Frage
How is an array formula identified in the formula bar in an Excel worksheet?
Antworten
-
Chevron braces <>
-
Curly braces {}
-
Parentheses ()
-
Square brackets []
Frage 3
Frage
Sparklines are tiny charts that fit into one cell
Antworten
-
TRUE
-
FALSE
Frage 4
Frage
Which function would you use to find the largest number of a selected range?
Antworten
-
MAXIMUM
-
MAX
-
LARGE
-
LARGEST
Frage 5
Frage
Which wildcard character represents a single character?
Antworten
-
*
-
?
-
!
-
&
Frage 6
Frage
You can create your own shortcuts in Excel
Antworten
-
Yes
-
No
Frage 7
Frage
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?
Antworten
-
First
-
Second
-
Third
-
Fourth
Frage 8
Frage
Which of the following statements about Excel macros is false?
Antworten
-
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.
Frage 9
Frage
Is it possible to create pivot from multiple Excel Sheets?
Antworten
-
Yes
-
No
Frage 10
Frage
How many arguments does the Sumifs function have?
Antworten
-
1
-
2
-
3
-
N
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.