1. Home
  2. Computers and IT
  3. MS Excel MCQs

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

61
How do you change column width to fit the contents?

62
Charts tips can

63
When integrating Ms-Word and Excel, Word is usually the

64
To insert three columns between columns D and E you would

65
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

66
When you use the fill effects in the format data series dialog box, you can not

67
Which of the following describes how to select all the cells in a single column?

68
Got functions? No? You need the insert function dialog box. How do you get it?

69
What term refers to a specific set of values saved with the workbook?

70
Which of the following setup options cannot be set in the page setup dialog box?

71
Which of the following methods cannot be used to edit the content of cell?

72
Which of the following will not set text in selected cells to italics?

73
Which of the following methods cannot be used to enter data in a cell?

74
When creating a vertical page break

75
Concatenation of text can be done using

76
A numeric value can be treated as a label value if it precedes with

77
Tab scrolling button

78
Getting data from a cell located in a different sheet is called?

79
A worksheet range is a

80
The Chart wizard term data categories refers to;

81
The chart wizard term data series refers to

82
Which of the following is not an example of a value?

83
A worksheet can have a maximum of _____ Number of rows

84
How many characters can be typed in a single cell in Excel?

85
A typical worksheet has _____ Number of columns

86
Which of the following formulas is not entered correctly?

87
Which symbol must all formula begin with?

88
Which of the following is an absolute cell reference?

89
The default header for a worksheet is

90
which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?


Categories

Random Posts

Bank of Baroda Office Assistant Recruitment 2025 Notification Out – Apply for 500 Posts

BHEL Recruitment 2025: Apply for Engineer and Supervisor Trainee Positions

Himachal Pradesh TGT Trainee Recruitment 2025 – 937 Teaching Jobs @ hprca.hp.gov.in

SNAP 2025 Exam: Dates, Registration, Syllabus, Pattern & More

Rajasthan Police Constable Recruitment 2025 – 10000 Vacancies, Apply Online