MS Excel

430 questions available

FILTER BY SUBTOPIC

All Excel Interface 218 Workbook & Worksheet 1 Rows & Columns Cells & Ranges 39 Formulas 123 Functions 1 Charts 34 Sorting & Filtering 12 Data Formatting 1 File Extensions 1
Showing 421–430 of 430

Q421.Which Microsoft Excel feature locks specific rows and columns so they remain visible on screen while you scroll through the sheet?

Easy
A Freeze Panes
B Hide Rows/Columns
C Lock Cells
D Split Window
Cells & Ranges PPSC

Correct Answer: A

The 'Freeze Panes' command (under the View tab) keeps specified rows or columns static while scrolling, preserving headers.

Q422.Which software program is the industry standard widely utilized for professional digital photo editing and manipulation?

Easy
A Microsoft Word
B Adobe Photoshop
C Google Chrome
D Excel
Excel Interface PPSC

Correct Answer: B

Adobe Photoshop is the standard application used by designers and photographers to edit, retouch, and manipulate digital images.

Q423.By default, what is the standard alignment of text and numerical values entered into a Microsoft Excel cell?

Easy
A Text is right-aligned; numbers are left-aligned
B All cell contents are centrally aligned
C Text is left-aligned; numbers are right-aligned
D None of these
Cells & Ranges PPSC

Correct Answer: C

Excel automatically left-aligns text entries (for reading order) and right-aligns numerical values (to easily align decimals and place values).

Q424.What is the primary method used to protect specific data columns, rows, or worksheets in Microsoft Excel?

Easy
A Lock the whole sheet
B Lock the cells
C Lock the columns and Rows
D None of these
Cells & Ranges PPSC

Correct Answer: B

To protect sheet structures from being edited, users select specific cells, lock them under Cell Format settings, and then turn on worksheet protection.

Q425.What visual element appears when you hover the mouse pointer over a chart object in Microsoft Excel?

Easy
A Key Tip
B Screen Tip
C Chart Tip
D Chart Key
Charts PPSC

Correct Answer: B

Hovering over chart elements displays a small Screen Tip (or Tooltip) showing specific values, coordinates, or data series labels.

Q426.Which of the following can be used to zoom or adjust the magnification of an Excel worksheet?

Easy
A The mouse pointer in Print Preview
B The zoom button on the Print Preview toolbar
C The zoom command on the View menu
D All of these
Excel Interface PPSC

Correct Answer: D

Excel provides multiple ways to zoom worksheets, including the View menu zoom command, Print Preview zoom tools, and mouse interaction.

Q427.How is a currently selected or active cell visually indicated in an MS Excel worksheet?

Easy
A Dotted line
B Double line
C Wide bold line
D Single line
Cells & Ranges PPSC

Correct Answer: C

The active cell in Microsoft Excel is highlighted with a wide, bold border (cell cursor) to distinguish it from the rest of the grid.

Q428.In Microsoft Excel, what is the evaluated result of the mathematical formula '=5 + 2 * 3'?

Easy
A 1
B 10
C 11
D 21
Formulas PPSC

Correct Answer: C

According to mathematical operator precedence (PEMDAS), the multiplication '2 * 3 = 6' is executed first, followed by the addition '5 + 6 = 11'.

Q429.In MS Excel, what is the correct menu selection to add mathematical symbols that can be typed from a keyboard?

Easy
A Insert => Special Character
B Insert => Symbol
C View => Special Character
D View => Symbol
Excel Interface PPSC

Correct Answer: B

Users can insert custom symbols, equations, and mathematical signs by choosing Symbol under the Insert tab.

Q430.In Microsoft Excel, what utility should be used to sort or fill in a user-defined custom order?

Easy
A Auto Fill Options
B Fill Series
C Custom List
D None of these
Sorting & Filtering PPSC

Correct Answer: C

A Custom List allows Excel users to populate or sort ranges of cells using customized, user-defined progressions.