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. Ctrl + Shift + $

B. Alt + Shift + =

C. Alt + =

D. Ctrl + +

Answer: Option C

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

Share Report

Which of the following functions in MS Excel searches for a specific value in the leftmost column of a table array and returns a value in the same row from a specified column?

A. HLOOKUP

B. VLOOKUP

C. LOOKUP

D. MATCH

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
VLOOKUP stands for Vertical Lookup. It searches down the leftmost column of a range for a key and returns a value from the specified column in that row.

This question belongs to: Computer Microsoft Office