What will be the output of the MS Excel formula =MATCH(30, {10, 20, 30, 40}, 0)? MCQ with Answer and Explanation

What will be the output of the MS Excel formula =MATCH(30, {10, 20, 30, 40}, 0)?
A. 2
B. 3
C. #N/A
D. 30
Answer: Option B
Solution (By JKSSB Mock Tests)
The MATCH function searches for a specified value in an array and returns its relative position. In the array {10, 20, 30, 40}, the lookup value 30 is at position 3.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Excel, which function is used to join text from multiple cells with a delimiter (Excel 2019/365)?
A. CONCATENATE()
B. JOIN()
C. TEXTJOIN()
D. CONCAT()

Correct Answer: Option C


Explanation:
TEXTJOIN has a delimiter argument. CONCAT does not have delimiter.

This question belongs to: Computer Microsoft Office
Question #2
In MS Access, what do you call a field that contains unique data values across all rows and is used to uniquely identify each record in a table?
A. Composite reference field
B. Foreign Key
C. Lookup Index column
D. Primary Key

Correct Answer: Option D


Explanation:
A Primary Key is a designated field that uniquely identifies each record or row inside a database table, and it cannot contain null values.

This question belongs to: Computer Microsoft Office
Question #3
What is the keyboard shortcut to apply a hanging indent to a selected paragraph block in MS Word?
A. Ctrl + Shift + H
B. Ctrl + T
C. Ctrl + M
D. Ctrl + H

Correct Answer: Option B


Explanation:
Ctrl + T applies a hanging indent to the selected paragraph. Pressing Ctrl + Shift + T removes or reduces the hanging indent. Ctrl + M applies a standard left indent.

This question belongs to: Computer Microsoft Office