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 221–240 of 430

Q221.What is the default file name of a newly created MS Excel file?

Easy
A Book1
B Document 1
C File 1
D All of these
Excel Interface PPSC

Correct Answer: A

New spreadsheets in Microsoft Excel are automatically named 'Book1' by default.

Q222.In Excel, We use the _____ start date and end date function to return the number of whole days between start_date and end_date.

Easy
A DATEDIF()
B DATEDIFF
C DAYSBETWEEN
D INTERVAL
Formulas PPSC

Correct Answer: A

The DATEDIF() function in Excel calculates the difference between two dates. For whole days, it uses the 'D' unit.

Q223.The Function ________ in Excel is used to look up information in a table and extract the corresponding data.

Easy
A FETCH
B GET
C VLOOKUP
D DATA
Formulas PPSC

Correct Answer: C

VLOOKUP stands for Vertical Lookup, used to find data in a column.

Q224.Which of the following is not a valid option to insert a hyperlink in Excel, which can link to?

Easy
A Link to home
B Existing file or web page
C Place in this document
D Create new document
Excel Interface PPSC

Correct Answer: A

Insert Hyperlink options include Existing File/Web Page, Place in this Document, Create New Document, and Email Address, but not 'Link to home'.

Q225.How do you freeze panes in Excel?

Easy
A View the tab and go to Freeze Panes
B Home tab and go to Freeze Panes
C Review tab and go to Freeze Panes
D None of these
Excel Interface PPSC

Correct Answer: A

To freeze panes, go to the View tab and click Freeze Panes.

Q226._____ is a feature of MS excel and can also be used in PowerPoint.

Easy
A Function
B Chart
C Merge cells
D None of these
Formulas PPSC

Correct Answer: B

Charts can be created in Excel and easily inserted or used in PowerPoint presentations.

Q227.In MS Excel, VLOOKUP is _____?

Easy
A Logical function
B Lookup and reference function
C Mathematical function
D None of these
Formulas PPSC

Correct Answer: B

VLOOKUP is categorized under Lookup and Reference functions in Excel.

Q228.Define a name for a cell or a range in Excel provides a ______ reference to that cell or reference.

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

Correct Answer: A

Defining a name for a cell or range acts as an absolute reference to those cells.

Q229.In MS Excel, if B3 ids the address of a cell then B is it's _____?

Easy
A Row number
B Column number
C Cell address
D None of these
Cells & Ranges PPSC

Correct Answer: B

Letters (like B) represent columns, while numbers (like 3) represent rows. So B is the column identifier.

Q230.Which Excel feature allows filtering data based on specific criteria without deleting rows?

Easy
A Sort
B Filter
C Freeze Panes
D None of these
Sorting & Filtering PPSC

Correct Answer: B

The Filter feature in Excel displays only rows that meet specific criteria, temporarily hiding the rest without deleting any data.

Q231.Which Excel feature allows creating dynamic drop-down lists based on cell values?

Easy
A Data Validation
B Conditional Formatting
C Flash Fill
D None of these
Cells & Ranges PPSC

Correct Answer: A

Data Validation can restrict entries in a cell and is commonly used to create drop-down lists from a range of cell values.

Q232.Which Excel feature allows automatically filling a series like dates or numbers by dragging the mouse?

Easy
A Track Changes
B Conditional Formatting
C Fill Handle
D None of these
Excel Interface PPSC

Correct Answer: C

The Fill Handle (dragging the small square at the bottom-right of a cell) automatically fills continuous series like dates, months, or numbers.

Q233.How to add a filter in Excel?

Easy
A Go to Home → Paste
B Go to Data → Filter
C Right-click → Format Cells
D Insert → Chart
Charts PPSC

Correct Answer: B

Filters help display only the data you need in a table. To add a filter: Select your data → Data tab → Filter. Small dropdown arrows appear in the header row of your table.

Q234.Which menu can be used to split windows into two in MS Excel or Word?

Easy
A Window > Split
B Review > Window
C View > Window > Split
D None of these
Excel Interface PPSC

Correct Answer: C

To split windows or document panes into two in applications like Excel or Word, use the View > Window > Split menu option. This command divides the active document window into separate panes.

Q235.Another name for a pre-programmed formula in Excel is _____?

Easy
A Cell
B Graph
C Function
D Range
Formulas PPSC

Correct Answer: C

An Excel function is a predefined formula that performs calculations using specific values (arguments) in a particular order.

Q236.Which function is used to display both the current date and time in MS Excel?

Easy
A DATE()
B TODAY()
C YEAR()
D NOW()
Formulas PPSC

Correct Answer: D

The NOW() function returns the current system date and time, updating automatically whenever the worksheet is calculated.

Q237.Which function converts text to uppercase in MS Excel 2016?

Easy
A UPPER
B UPPERCASE
C TOPPER
D None of these
Formulas PPSC

Correct Answer: A

The UPPER function converts all lowercase letters in a text string to uppercase.

Q238.What type of chart is useful for showing trends or changes over time in Excel?

Easy
A Pie chart
B Column chart
C Line chart
D Dot chart
Charts PPSC

Correct Answer: C

A Line Chart displays data points connected by straight lines, making it perfect for representing continuous trends over time.

Q239.What type of chart is useful for comparing values over categories in MS Excel?

Easy
A Line Chart
B Pie Chart
C Column Chart
D None of these
Charts PPSC

Correct Answer: C

A Column Chart uses vertical bars to clearly represent and compare numerical values across different categories.

Q240.Which of the following uniquely identifies a cell in MS Excel 2016?

Easy
A Address
B Formula
C Label
D None of these
Formulas PPSC

Correct Answer: A

Each cell in Excel has a unique cell address consisting of its column letter followed by its row number (e.g., A1).