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

Question

Share Report Error

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

A. 30

B. 2

C. #N/A

D. 3

Answer: Option D

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.

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

Share Report

What is the function of the keyboard shortcut Ctrl + M when working inside an active document in MS Word?

A. Opens the Mail Merge configuration helper pane

B. Inserts a new manual page break line split

C. Applies a strikethrough character formatting layout

D. Indents the paragraph from the left margin boundary

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + M increases the left indent of the selected paragraph, moving it inward from the margin. Pressing Ctrl + Shift + M removes or reduces the left indent.

This question belongs to: Computer Microsoft Office