In Excel, to quickly sum a range of numbers, use the shortcut: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, to quickly sum a range of numbers, use the shortcut:

A. Alt + =

B. Alt + Shift + =

C. Ctrl + +

D. Ctrl + Shift + $

Answer: Option A

Solution (By JKSSB Mock Tests)

Alt + = inserts the AutoSum function.

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

In Word, which of the following is used to create a mail merge?

A. Review > Mail Merge

B. Insert > Mail Merge

C. Mailings > Start Mail Merge

D. References > Mail Merge

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Mail Merge is under the Mailings tab.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, the 'Selection Pane' shows:

A. Slide thumbnails

B. Animation timeline

C. A list of all objects on the slide, allowing you to hide, rename, reorder them

D. Transition settings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Selection Pane (Home -> Select -> Selection Pane) manages objects.

This question belongs to: Computer Microsoft Office

Question #3

In Access, which of the following is a valid way to set a primary key?

A. Both A and B

B. Set in Datasheet View

C. Use the Primary Key button in Design View

D. Right-click the field in Design View and select Primary Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
You can set primary key by right-clicking or clicking the Primary Key button in Design View.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs