In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)? MCQ with Answer and Explanation

Question

Share Report Error

In MS Excel, what is the value returned by the formula =MID(COMPETITIVE, 4, 3)?

A. COMP

B. PET

C. ETI

D. PETI

Answer: Option B

Solution (By JKSSB Mock Tests)

The MID function extracts characters from the middle of a text string. Starting at position 4 of COMPETITIVE ('P') and extracting 3 characters yields PET.

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

In Excel, which function joins text from multiple ranges with a delimiter? (Available in Excel 2019/365)

A. CONCAT()

B. TEXTJOIN()

C. JOIN()

D. CONCATENATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
TEXTJOIN combines text with a delimiter and can ignore empty cells. CONCATENATE and CONCAT do not have delimiter parameter.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, which tool captures precise rehearsed presentation loops, recording how long slides run to help automate slide presentation delivery timelines?

A. Rehearse Timings

B. Animation Painter tool

C. Presenter Coach dashboard

D. Slide Sorter setup

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Rehearse Timings feature launches full-screen slide delivery with an on-screen timer to track slide durations, saving those timestamps to automate future playback.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

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

A. 3

B. #N/A

C. 2

D. 30

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
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

Explore All Microsoft Office MCQs