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 201–220 of 430

Q201.Columns in MS Excel are called?

Easy
A Fields
B Chart
C Both
D Letters
Charts PPSC

Correct Answer: D

Columns in MS Excel run vertically and are identified by Letters (A, B, C, ... AA, AB, etc.), while horizontal rows are identified by Numbers.

Q202.B2:B6 in MS Excel represents the ______?

Easy
A Range of cell
B Cell column
C Cell Row
D None of these
Cells & Ranges PPSC

Correct Answer: A

B2:B6 represents a cell range from cell B2 to B6. A colon (:) is the range operator in Excel.

Q203.In an MS Excel worksheet, the default alignment of a numeric value is?

Easy
A Left alignment
B Right alignment
C Center alignment
D None of these
Excel Interface PPSC

Correct Answer: B

MS Excel automatically right-aligns numeric data by default, while text data is left-aligned, ensuring clear mathematical alignment.

Q204.In MS Excel, we can add a chart from which tab?

Easy
A File
B Chart
C Insert
D None of these
Charts PPSC

Correct Answer: C

Charts are added to worksheets from the Insert tab in Excel, which includes various visual chart styles (Bar, Pie, Line, Area).

Q205.In MS Excel, which formula is used to calculate the average of values from B1 to B5?

Easy
A
B
C
D
Formulas PPSC

Correct Answer: B

The AVERAGE function is used to calculate the arithmetic mean of the specified cells (=AVERAGE(B1:B5)).

Q206.In Microsoft Excel, what is the function of the F11 key?

Easy
A Opens the Save As dialog box
B Creates a chart on a new chart sheet
C Inserts a new worksheet
D None of these
Formulas PPSC

Correct Answer: B

F11 is an Excel shortcut that instantly creates a standard chart using selected cell data on a separate, dedicated chart sheet.

Q207.What does the Excel formula =AVERAGE(B1:B5) calculate?

Easy
A Sum of values
B Maximum value
C Arithmetic Mean
D None of these
Formulas PPSC

Correct Answer: C

The =AVERAGE(B1:B5) formula calculates the arithmetic mean of the data values located in cells B1 through B5.

Q208.In MS Excel, to insert a sum formula in a cell?

Easy
A
B
C
D
Formulas PPSC

Correct Answer: A

To sum values in Excel, the correct formula is =SUM(range), starting with the equals sign (=) and valid cell names like A1:A2.

Q209.Which of the following is not a correct method of editing the contents of a cell in MS Excel?

Easy
A Double clicking the cell
B Press the Alt key
C Pressing the F2 key
D Clicking the formula bar
Formulas PPSC

Correct Answer: B

Pressing the Alt key alone is used for window shortcut navigation, not for editing active Excel cells (which is done via F2, double-clicking, or clicking the Formula Bar).

Q210.Which function calculates the largest value in a set of numbers in Excel?

Easy
A Average
B Count
C Minimum
D Maximum
Formulas PPSC

Correct Answer: D

The MAX (Maximum) function in MS Excel compares a set of numerical values in a range and returns the highest/largest value.

Q211.Which formula is used to find the number of numerical cells in a range of cells in Excel?

Easy
A COUNTIF
B COUNT
C COUNTA
D None of these
Formulas PPSC

Correct Answer: B

The COUNT function in Microsoft Excel counts only the cells that contain numbers within a specified range.

Q212.Microsoft Excel is an electronic software package?

Easy
A Docoment
B Spreadsheet
C Presentation
D Database
Excel Interface PPSC

Correct Answer: B

Microsoft Excel is an electronic spreadsheet application used to record, calculate, analyze, and format numerical and textual data.

Q213.Mail Merge is a feature of which software?

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

Correct Answer: A

Mail Merge is a powerful feature of MS Word used to generate bulk personalized letters, labels, envelopes, and emails by merging a template document with a data source.

Q214.How do you start numbering from a specific number in MS Excel?

Easy
A By entering the starting number and using the Fill Handle
B By changing the font size
C By deleting the worksheet
D None of these
Excel Interface PPSC

Correct Answer: A

To start a custom numbering series in Excel, type the initial starting values and drag down using the Fill Handle (bottom-right cell square).

Q215.In MS Excel, the 'IF' function is used to?

Easy
A Sort data
B Perform conditional logic
C Calculate averages
D None of these
Formulas PPSC

Correct Answer: B

Excel's logical IF function evaluates a specified condition, returning one result if the test is TRUE, and another if it is FALSE.

Q216.In MS Excel, 'HLOOKUP' searches for a value in?

Easy
A A pivot table
B A vertical column
C A horizontal row
D None of these
Excel Interface PPSC

Correct Answer: C

HLOOKUP (Horizontal Lookup) searches for a key value across the first horizontal row of a dataset and returns data from a cell in the same column.

Q217.In MS Excel, which function counts only non-empty cells in a range?

Easy
A COUNTA()
B COUNT()
C COUNTIF()
D None of these
Formulas PPSC

Correct Answer: A

The COUNTA function counts all cells containing values (text, numbers, formulas, or errors) in a specified range, ignoring only blank cells.

Q218.Which of the following is a virtual voice assistant?

Easy
A Notepad
B Siri
C Photoshop
D Excel
Excel Interface PPSC

Correct Answer: B

Siri is a voice-controlled virtual assistant developed by Apple that relies on voice recognition and natural language processing.

Q219.What is MS Excel primarily used for?

Easy
A Creating and editing presentations
B Creating and editing spreadsheets / Data Calculations
C Creating and editing images
D None of these
Excel Interface PPSC

Correct Answer: B

Microsoft Excel is a spreadsheet program primarily used to organize, calculate, and analyze numerical data using formulas, charts, and tables.

Q220.Which model is mainly used for generating images from text prompts?

Easy
A DALL•E
B Excel
C MySQL
D PowerPoint
Excel Interface PPSC

Correct Answer: A

OpenAI's DALL·E is a generative AI system designed to synthesize highly detailed images and artwork directly from written prompts.