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

Question Report Error

In Excel, to name a range, you can:

A. Insert -> Name

B. Formulas -> Define Name

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

D. Both A and B

Answer: Option D

Solution (By JKExamLibrary)

Both methods work.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1 Report Error

In MS Access, a 'Navigation form' is used to:

A. Create tables

B. Enter data

C. Provide a menu system to open forms and reports

D. Print reports

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Navigation form acts as a switchboard.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In Word, which of the following is used to create a column layout?

A. Home > Columns

B. Insert > Columns

C. Layout > Columns

D. Design > Columns

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Columns are under the Layout tab (Page Setup group). In newer versions it's Layout > Columns.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS PowerPoint, which transition effect causes the current slide to be replaced by the next slide with a vertical or horizontal wipe?

A. Split

B. Push

C. Wipe

D. Fade

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Wipe transition reveals the new slide with a moving edge (horizontal or vertical). Push pushes the old slide out, Fade is gradual, Split uses two edges.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs