Microsoft Excel MCQs for Competitive Exams

1491

What is the primary purpose of protecting a worksheet in Excel?

A No cell in a worksheet can be changed B Saving the workbook in a hidden folder C No additional change can be made to a worksheet D To lock cells in the worksheet so that a user cannot inadvertently change them

Answer & Solution Discuss Save Report

1492

What is the primary function of the PROPER(text) function in spreadsheet software?

A Capitalize the first letter in a text string B Capitalize the last letter in a text string C Capitalize all letters in a text string D None of these

Answer & Solution Discuss Save Report

1493

What is the most efficient way to adjust a column's width to automatically fit its contents?

A Double-click the boundary to the right of the column heading B Double-click the boundary to the left of the column heading C Single-click the boundary to the right of the column heading D Single-click the boundary to the left of the column heading

Answer & Solution Discuss Save Report

1494

When performing a search operation in Excel using character criteria, how does the application typically match the fields?

A Alphabetical order B Capitalization C Exact match D Wildcard characters

Answer & Solution Discuss Save Report

1495

What is the primary function of the horizontal and vertical scroll bars in an Excel worksheet?

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

Answer & Solution Discuss Save Report

1496

In Microsoft Excel, what components constitute a worksheet?

A Rows B Columns C Both A & B D None of these

Answer & Solution Discuss Save Report

1497

What functionalities are available to the user when utilizing the Page Break Preview mode in Microsoft Excel?

A View exactly where each page break occurs B Add or remove page breaks C Change the print area D All of the above

Answer & Solution Discuss Save Report

1498

What is the term used to describe a contiguous group of selected cells in a spreadsheet application?

A Automatic B Half-duplex C Full-duplex D Range

Answer & Solution Discuss Save Report

1499

Which key should be pressed to finalize and enter data into an Excel cell?

A Shift B Ctrl C Enter D Tab

Answer & Solution Discuss Save Report

1500

In Microsoft Excel 2016, which menu path allows a user to split the active worksheet window into multiple panes?

A Format > Window > Split B View > Window > Split C Data > Window > Split D Page Layout > Split

Answer & Solution Discuss Save Report