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 341–360 of 430

Q341.What does the coordinate notation 'C7:C9' indicate in a Microsoft Excel worksheet?

Easy
A All cells spanning from C7 through C9
B Only cell C7 and cell C9 exclusively
C A formula division operation
D None of these
Formulas PPSC

Correct Answer: A

The colon (:) represents a continuous range of cells, meaning C7:C9 selects cells C7, C8, and C9.

Q342.Which category of Excel functions is used to calculate asset depreciation, future investment values, and loan payments?

Easy
A Financial
B Logical
C Math & Trigonometry
D None of these
Formulas PPSC

Correct Answer: A

Financial functions (such as FV, PV, PMT, and SLN) handle calculations regarding loans, investments, interest rates, and depreciation.

Q343.In MS Excel 2016 one has to go to _____ option for setting or clearing print area.

Easy
A Insert
B Page Layout
C Data
D Review
Excel Interface PPSC

Correct Answer: B

The 'Print Area' options (set and clear) are located in the Page Setup group under the Page Layout tab in Excel.

Q344.In MS Excel 2016 Print Title option is available in ___ menu?

Easy
A Review
B View
C Insert
D Page layout
Excel Interface PPSC

Correct Answer: D

The 'Print Titles' command is located in the Page Setup group on the Page Layout tab in Excel 2016.

Q345.Which one is not a Function in MS Excel?

Easy
A SUMB
B AVG
C MAX
D MIN
Formulas PPSC

Correct Answer: B

AVG is not a valid Excel function; Excel uses the full word AVERAGE to calculate the mean of values.

Q346.A worksheet in Excel is divided into _____?

Easy
A Height & Width
B Layers & Planes
C Columns & Rows
D Lines & Spaces
Excel Interface PPSC

Correct Answer: C

An Excel worksheet is structured into vertical columns and horizontal rows.

Q347.Move to the next cell in the row in MS Excel _____?

Easy
A Tab
B Shift
C Space
D None of these
Cells & Ranges PPSC

Correct Answer: A

Pressing the Tab key moves the cursor horizontally to the next cell in the active row.

Q348.The valid data type in MS Excel is _____?

Easy
A Boolean
B Tupal
C Dictionary
D None of these
Excel Interface PPSC

Correct Answer: A

Boolean (TRUE/FALSE) is a valid, native logical data type inside Excel cells.

Q349.In an MS Excel sheet, how is the active cell visually indicated?

Easy
A By a dotted border
B By a dark wide border
C By a blinking border
D None of these
Cells & Ranges PPSC

Correct Answer: B

The active, currently selected cell in an Excel worksheet is bounded by a thick, dark green/black border.

Q350.In MS Excel, which bar is specifically used for writing, editing, and displaying formulas and cell data?

Easy
A Menu bar
B Title bar
C Formula bar
D None of these
Formulas PPSC

Correct Answer: C

The Formula Bar allows users to input, edit, and view complex mathematical equations or long text values contained in the active cell.

Q351.In MS Excel, a formula that looks for a value in the leftmost column of a table and returns a corresponding value from the same row in another specified column is called ______?

Easy
A Horizontal Lookup
B Vertical Lookup
C Average
D None of these
Formulas PPSC

Correct Answer: B

VLOOKUP (Vertical Lookup) searches vertically down the first column of a table to retrieve values from specified columns.

Q352.To fix a cell reference in Microsoft Excel so that it remains constant when copied, we use which type of reference?

Easy
A Relative Reference
B Mixed Reference
C Absolute Reference
D None of these
Cells & Ranges PPSC

Correct Answer: C

An Absolute Cell Reference uses dollar signs ($A$1) to freeze row and column coordinates, preventing them from shifting when copied.

Q353.Which of the following is NOT a recognized type of chart in MS Excel?

Easy
A T-graph
B Pie-chart
C Area chart
D None of these
Charts PPSC

Correct Answer: A

Pie-charts and Area charts are built-in visualization tools in Excel. A T-graph (T-chart) is a simple graphic organizer used for comparisons.

Q354.Which Microsoft Office application includes a basic built-in photo editor to adjust pictures on slides?

Easy
A MS PowerPoint
B MS Word
C MS Excel
D None of these
Excel Interface PPSC

Correct Answer: A

MS PowerPoint includes picture-editing tools on its Picture Tools contextual tab, allowing cropping, brightness adjustments, and basic filters.

Q355.In spreadsheet programs like Excel, sorting can be executed based on which criteria?

Easy
A Date and time
B Alphabetical order
C Numerical values
D All of these
Sorting & Filtering PPSC

Correct Answer: D

Excel supports sorting data rows based on multiple field types, including alphabetical text, numeric values, and chronologically by dates.

Q356.Which of the following is NOT an Excel 'What-If Analysis' tool?

Easy
A Auto Outline
B Goal seek
C Scenario manager
D None of these
Excel Interface PPSC

Correct Answer: A

What-If Analysis tools in Excel include Goal Seek, Scenario Manager, and Data Tables. Auto Outline is used for grouping and structuring data.

Q357.How are horizontal rows labeled in a Microsoft Excel worksheet?

Easy
A Using numbers (1, 2, 3, etc.)
B Using coordinate cell values (A1, A2, etc.)
C Using letters (A, B, C, etc.)
D None of these
Cells & Ranges PPSC

Correct Answer: A

Worksheets are divided into grids where vertical columns are labeled alphabetically (A, B, C) and horizontal rows numerically (1, 2, 3).

Q358.In Microsoft Windows operating systems, the default application used for file management is called ______?

Easy
A Windows Explorer (or File Explorer)
B MS Word
C Device driver
D MS Excel
Excel Interface PPSC

Correct Answer: A

Windows Explorer (now File Explorer) is the built-in file manager application providing a graphical user interface to browse files.

Q359.What is the actual grid-based workspace area inside Microsoft Excel where data is typed?

Easy
A Workbook
B Worksheet
C Note sheet
D Notebook
Excel Interface PPSC

Correct Answer: B

An Excel file is a Workbook, which is a collection of individual grid pages called Worksheets where calculations are performed.

Q360.What is the quickest way in Microsoft Excel to view a comment that has been added to a specific cell?

Easy
A Click the edit comment command on the insert menu
B Position the mouse pointer (hover) over the cell
C Click the display comment command on the window menu
D None of these
Cells & Ranges PPSC

Correct Answer: B

Cells with comments feature a tiny red indicator. Simply hovering the mouse cursor over the cell automatically pops up the comment box.