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