In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from: MCQ with Answer and Explanation

Question
In Excel, the formula =INDEX(A1:C3, 2, 3) will return the value from:
A. Cell B2
B. Third row, second column
C. Second row, third column of the range A1:C3
D. An error
Answer: Option C
Solution (By JKSSB Mock Tests)
INDEX(array, row_num, col_num) returns the value at intersection. 2nd row, 3rd column is cell C2.
This question belongs to: Computer Microsoft Office
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In Excel, what does the 'HLOOKUP' function stand for?
A. Height Lookup
B. High Lookup
C. Hierarchical Lookup
D. Horizontal Lookup
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
HLOOKUP stands for Horizontal Lookup, used to search for a value in the top row of a table and return a value from a specified row.
This question belongs to: Computer Microsoft Office
Question #2
Which of the following is a built-in Excel tool to perform what-if analysis by changing multiple inputs?
A. Data Table
B. Scenario Manager
C. Goal Seek
D. Solver
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Scenario Manager stores sets of input values. Goal Seek changes one variable to reach target, Solver optimizes, Data Table shows results of one or two variables.
This question belongs to: Computer Microsoft Office
Question #3
In Excel, what does the 'ROUND' function do?
A. Rounds down to the nearest integer
B. Rounds up to the nearest integer
C. Rounds a number to a specified number of digits
D. Rounds to the nearest multiple
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
ROUND rounds a number to a specified number of decimal places. ROUNDUP rounds up, ROUNDDOWN rounds down, MROUND rounds to a multiple.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?