Microsoft Excel (MS Excel) Multiple Choice Questions (MCQs)

We have compiled a list of 100+ questions with answers from Microsoft Excel (MS Excel) that help you to check your basic knowledge of MS Excel and prepare for competitive exams. These Microsoft excel multiple choice questions with answers are prepared by the subject experts from authentic resources. Attempt all the questions and check your MS Excel knowledge online.

This category includes the topics such as concept of electronic spreadsheets, types, organization of spreadsheet applications, cells, rows, columns, worksheets, workbooks and workspaces, creating opening and saving workbooks, screen elements, editing copying moving and delete cell contents, cell formatting, using formulas, relative absolute and mixed cell references, basic functions, generating series, default options, sorting filtering data, summarizing and sub totals, charts, header footer, speller, customizing menu and toolbar, import export data, pivot table, goal seek, scenario and audit, page setting, preview and printing.

Following are the important multiple choice questions with answers from the Microsoft Excel (MS Excel) section. You can choose the correct answer from option A, B, C and D.

MS Excel MCQs Practice MCQ Question and Answer

31

Merge cells option can be applied from

A. Format Cells dialog box Alignment Tab

B. Formatting toolbar

C. Both of above

D. None of above

32

Special category of Number tab in Format Cells dialog box can be used to apply formats like

A. Zip Code

B. Phone Number

C. Both of above

D. None of above

33

Which function will you use to enter current time in a worksheet cell?

A. =TODAY()

B. =NOW()

D. =currentTime()

34

What is entered by the function =today()

A. The date value for the day according to system clock

B. The time value according to system clock

C. Today's date as Text format

D. All of above

35

Formatting a cell in Number format you can't set

A. Decimal Places

B. Use 1000 separator

C. Negative numbers

D. Currency Symbol

36

Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

37

Which of the following is not an option in the spelling dialog box?

A. Edit

B. Ignore

C. Ignore all

D. Change

38

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

A. Formula

B. Field

C. Data

D. Query Correct Answer:

39

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

A. Format Report

B. Pivot Table

C. Refresh Data

D. Show Detail

40

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

A. F3

B. F5

C. F7

D. F11

41

If you press _____, the cell accepts your typing as its contents.

A. Enter

B. Ctrl + Enter

C. TAB

D. Insert

42

To copy cell contents using drag and drop, press the

A. End key

B. Shift key

C. Esc key

D. None of above

43

Which of the following is not a worksheet design criterion?

A. Efficiency

B. Auditability

C. Description

D. Clarity

44

To protect a worksheet, you can choose Protection and the Protect Sheet from the _____menu

A. Edit

B. Format

C. Tools

D. Data

45

You can quickly change the appearance of your work by choosing Auto Format from the _____ Menu

A. Edit

B. View

C. Format

D. Tools

46

You can open the Highlight Changes dialog box by choosing Track Changes from the _____ Menu.

A. Edit

B. Insert

C. Format

D. Tools

47

What function displays row data in a column or column data in a row?

A. Hyperlink

B. Index

C. Transpose

D. Rows

48

A function inside another function is called a _____function.

A. Nested

B. Round

C. Sum

D. Text

49

You can print only an embedded chart by

A. Moving the chart to a chart sheet before you print.

B. Formatting the chart before you print

C. Selecting the chart before you print

D. a and c

50

How are data organized in a spreadsheet?

A. Lines and spaces

B. Layers and planes

C. Rows and columns

D. Height and width

51

Which types of charts can excel produce?

A. Line graphs and pie charts only

B. Only line graphs

C. Bar charts, line graphs and pie charts

D. Bar charts and line graphs only

52

You can open the consolidate dialog box byt choosing Consolidate from the ______menu?

A. Insert

B. Format

C. Tools

D. Data

53

Macros are 'run' or executed from the _____Menu.

A. Insert

B. Format

C. Tools

D. Data

54

Except for the______function, a formula with a logical function shows the word 'TRUE' or 'FALSE' as a result

A. IF

B. AND

C. OR

D. NOT

55

When you insert an Excel file into a Word document, the data are

A. Hyperlinked

B. Placed in a word table

C. Linked

D. Embedded

56

Which function calculates your monthly mortage payment?

A. PMT (payments)

B. NPER (number of periods)

C. PV (present value)

D. All of above

57

To drag a selected range of data to another worksheet in the same workbook, use the

A. Tab key

B. Alt key

C. Shift key

D. Ctrl key

58

You can add an image to a template by clicking the Insert Picture From File button on the _____ Toolbar.

A. Standard

B. Formatting

C. Drawing

D. Picture

59

Hyperlinks cannot be

A. Special shapes like stars and banners

B. Drawing objects like rectangles ovals

C. Pictures

D. All can be hyperlinks

60

When you work with large worksheets, you may need to

A. size the worksheet to fit on the specific number of pages

B. add and remove page breaks

C. specify only certain print areas

D. all of above

Microsoft Excel (MS Excel) Multiple Choice Questions (MCQs)

MS Excel MCQs Practice MCQ Question and Answer

31 Merge cells option can be applied from

Answer & Solution

32 Special category of Number tab in Format Cells dialog box can be used to apply formats like

Answer & Solution

33 Which function will you use to enter current time in a worksheet cell?

Answer & Solution

34 What is entered by the function =today()

Answer & Solution

35 Formatting a cell in Number format you can't set

Answer & Solution

36 Which of the following is invalid statement?

Answer & Solution

37 Which of the following is not an option in the spelling dialog box?

Answer & Solution

38 What is an expression that tells how the numbers in a determined set of cells are to be calculated?

Answer & Solution

39 What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

Answer & Solution

40 What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

Answer & Solution

41 If you press _____, the cell accepts your typing as its contents.

Answer & Solution

42 To copy cell contents using drag and drop, press the

Answer & Solution

43 Which of the following is not a worksheet design criterion?

Answer & Solution

44 To protect a worksheet, you can choose Protection and the Protect Sheet from the _____menu

Answer & Solution

45 You can quickly change the appearance of your work by choosing Auto Format from the _____ Menu

Answer & Solution

46 You can open the Highlight Changes dialog box by choosing Track Changes from the _____ Menu.

Answer & Solution

47 What function displays row data in a column or column data in a row?

Answer & Solution

48 A function inside another function is called a _____function.

Answer & Solution

49 You can print only an embedded chart by

Answer & Solution

50 How are data organized in a spreadsheet?

Answer & Solution

51 Which types of charts can excel produce?

Answer & Solution

52 You can open the consolidate dialog box byt choosing Consolidate from the ______menu?

Answer & Solution

53 Macros are 'run' or executed from the _____Menu.

Answer & Solution

54 Except for the______function, a formula with a logical function shows the word 'TRUE' or 'FALSE' as a result

Answer & Solution

55 When you insert an Excel file into a Word document, the data are

Answer & Solution

56 Which function calculates your monthly mortage payment?

Answer & Solution

57 To drag a selected range of data to another worksheet in the same workbook, use the

Answer & Solution

58 You can add an image to a template by clicking the Insert Picture From File button on the _____ Toolbar.

Answer & Solution

59 Hyperlinks cannot be

Answer & Solution

60 When you work with large worksheets, you may need to

Answer & Solution

Categories

Random Posts

Social Media

31

Merge cells option can be applied from

32

Special category of Number tab in Format Cells dialog box can be used to apply formats like

33

Which function will you use to enter current time in a worksheet cell?

34

What is entered by the function =today()

35

Formatting a cell in Number format you can't set

36

Which of the following is invalid statement?

37

Which of the following is not an option in the spelling dialog box?

38

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

39

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

40

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

41

If you press _____, the cell accepts your typing as its contents.

42

To copy cell contents using drag and drop, press the

43

Which of the following is not a worksheet design criterion?

44

To protect a worksheet, you can choose Protection and the Protect Sheet from the _____menu

45

You can quickly change the appearance of your work by choosing Auto Format from the _____ Menu

46

You can open the Highlight Changes dialog box by choosing Track Changes from the _____ Menu.

47

What function displays row data in a column or column data in a row?

48

A function inside another function is called a _____function.

49

You can print only an embedded chart by

50

How are data organized in a spreadsheet?

51

Which types of charts can excel produce?

52

You can open the consolidate dialog box byt choosing Consolidate from the ______menu?

53

Macros are 'run' or executed from the _____Menu.

54

Except for the______function, a formula with a logical function shows the word 'TRUE' or 'FALSE' as a result

55

When you insert an Excel file into a Word document, the data are

56

Which function calculates your monthly mortage payment?

57

To drag a selected range of data to another worksheet in the same workbook, use the

58

You can add an image to a template by clicking the Insert Picture From File button on the _____ Toolbar.

59

Hyperlinks cannot be

60

When you work with large worksheets, you may need to