Appears to the left of the formula bar

Microsoft Excel Questions with Answers for Competitive Exams | Page 15

Microsoft Excel questions with answers are frequently asked in campus placements and government exams to test candidates’ data-handling and analytical abilities. As part of programming questions and answers, Excel is not only a spreadsheet tool but a mini-programming environment through its formulas, macros, and data functions. Mastering Excel helps in automating tasks, analyzing large datasets, and building reports efficiently. This topic covers essential Excel MCQs focusing on functions like VLOOKUP, pivot tables, charts, conditional formatting, and data analysis tools. Whether you’re preparing for TCS, Infosys, or SSC exams, practicing Excel questions enhances your technical aptitude and boosts your problem-solving efficiency.

Showing 10 of 255 questions

Per page:

Q141

In Excel when integrating word and excel, word is usually the

A Server
B Destination
C Client
D Both (A) and (C)

Answer: Option D

Q142

In Excel when a label is too long to fit within a worksheet cell, you typically must

A Shorten the label
B Increase the column width
C Decrease the column width
D Adjust the row height

Answer: Option B

Q143

In Excel name box

A Shows the location of the previously active cell
B Appears to the left of the formula bar
C Appears below the status bar
D Appears below the menu bar

Answer: Option B

Q144

In Excel comments put in cells are called

A smart tip
B Cell tip
C Web tip
D Soft tip

Answer: Option B

Q145

In Excel you can use the horizontal and vertical scroll bars to

A Split a worksheet into two panes
B View different rows and columns edit the contents of a cell
C Edit the contents of a cell
D View different worksheets

Answer: Option B

Q146

In Excel Multiple calculations can be made in a single formula using

A Standard formula using
B Array formulas
C Complex formulas
D Smart formula

Answer: Option B

Q147

Excel to Select several cells or ranges that are not touching each other, you would ..........while selecting

A hold down the Ctrl key
B hold down the Shift key
C hold down the Alt key
D Hold down Ctrl + Shift key

Answer: Option A

Q148

In Excel a certain spreadsheet shows in page Break Preview that cells in Rows 1-25 have white background. the cells in row 26 that contain data have a dark grey background, when you click the print button

A Nothing will print because some cells with data have been omitted
B Only the cells with gray background will print
C the whole sheet will print
D Only the cells with white background will print

Answer: Option D

Q149

In Excel constant is another name for this type of data

A number
B Equation
C Formula
D Description

Answer: Option A

Q150

In Excel the view that puts a blue a blue line around each page that would be printed is the

Microsoft Excel Questions and Answers

📚 More from Computer Science & Engineering(CSE)

Computer Science & Engineering(CSE)

Other Subjects

Microsoft Excel Questions and Answers

📚 More from Computer Science & Engineering(CSE)

Computer Science & Engineering(CSE)

Other Subjects

Report a Problem