In Excel, to name a range, you can: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, to name a range, you can:

A. Insert -> Name

B. Both A and B

C. Select range, type name in Name Box and press Enter

D. Formulas -> Define Name

Answer: Option B

Solution (By JKSSB Mock Tests)

Both methods work.

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, the 'Evaluate Formula' feature is found under which tab?

A. Formulas

B. View

C. Data

D. Review

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Evaluate Formula is in Formulas tab, Formula Auditing group.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the correlation between two data sets?

A. PEARSON

B. CORREL

C. All of the above

D. COVARIANCE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
CORREL and PEARSON compute correlation coefficient, and COVARIANCE computes covariance. All are related.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, to apply the same transition to all slides, click:

A. Slide Master -> Transition

B. Apply To All in the Transitions tab

C. Animation Painter

D. Copy transition and paste to all

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Apply To All button sets the selected transition for every slide.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs