Scribd
Upload
80 views3 pages

MS Excel MCQ Questions and Answers

The document discusses Microsoft Excel multiple choice questions and answers related to computer fundamentals. It covers topics like activating previous cells, adding up series of numbers, buttons visible in the formula bar when active, copying and applying formatting between cells and ranges, and types of selections that can be made in a worksheet.

Uploaded by

Boss Europe
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
80 views3 pages

MS Excel MCQ Questions and Answers

The document discusses Microsoft Excel multiple choice questions and answers related to computer fundamentals. It covers topics like activating previous cells, adding up series of numbers, buttons visible in the formula bar when active, copying and applying formatting between cells and ranges, and types of selections that can be made in a worksheet.

Uploaded by

Boss Europe
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

([Link]

com/) Login
([Link]
/login
/?url=https
%3A%2F
%[Link].c
fundamentals%2Fprac
mcq-question-
on-ms-
excel%2F
%3Fsection%3D2%26

Home ([Link] Aptitude ([Link]

English ([Link]

Reasoning ([Link]

DI ([Link]

GK ([Link]

Current Affairs ([Link] Interview ([Link] Computer

Programming Engineering More Ask Question ([Link]

Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental


Home ([Link] / Computer Fundamentals ([Link] / MS Excel

Section 1 ([Link]

Section 2 ([Link]

Section 3 ([Link]

51. To activate the previous cell in a pre-selected range, press

A. The Alt key

B. The Tab key


C. The Enter key

D. None of the above

Answer & Solution Discuss in Board ([Link] Save for Later

Answer & Solution

Answer: Option D
Solution:
To go to previous cell we use Go To function Ctrl + G.

52. Which button do you click to add up a series of numbers?

A. The autosum button

B. The Formula button

C. The quicktotal button

D. The total button

Answer & Solution Discuss in Board ([Link] Save for Later

53. When the formula bar is active, you can see

A. The edit formula button

B. The cancel button

C. The enter button

D. All of the above

Answer & Solution Discuss in Board ([Link] Save for Later

Answer & Solution

Answer: Option D
Solution:

Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar. When the formula bar is active, we can

see all.
54. To copy formatting from one area in a worksheet and apply it to another area you would use:

A. The Edit > Copy Format and Edit>Paste Format commands form the menu

B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C. There is no way to copy and apply formatting in Excel – You have to do it manually

D. The Format Painter button on the standard toolbar

Answer & Solution Discuss in Board ([Link]

Save for Later

Answer & Solution

Answer: Option D
Solution:
The Format Painter copies formatting from one place and applies it to another.
The Format Painter button on the standard toolbar in Excel 2003 and earlier version.
Home tab, in the Clipboard group, click Format Painter in 2007 and higher version.

55. In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

Answer & Solution Discuss in Board ([Link] Save for Later

([Link]

Login (https://www.examved /login /?url=https %3A%2F %2Fwww.examveda.c fundamentals%2Fprac mcq-question- on-ms- excel%2F %3F
Answer & Solution Discuss in Board (https://www.examveda.com/to-activate-the-previous-cell-in-a-pre-selected-range-press-8537
(https://www.examveda.com:443/computer-fundamentals/practice-mcq-question-on-ms- 54. To copy formatting from one area in a w

You might also like