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 101–120 of 430

Q101.Concatenate in excel is used for ?

Easy
A To join different cells
B To join same cells
C To join three cells
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q102.File extension for MS Excel 2016 is:

Easy
A .xlsx
B .xls
C .xlx
D .xx
Excel Interface PPSC 2025

Correct Answer: A

Q103.In which tab we go to insert Chart in MS Excel:

Easy
A Insert
B Home
C Review
D None of these
Charts PPSC 2025

Correct Answer: A

Q104.Function of VLOOKUP IN Excel is:

Easy
A To look for a specific value in horizontal
B To look for a specific value in the scroll bar
C To look for a specific value in vertical.
D None of these
Excel Interface PPSC 2025

Correct Answer: C

Q105.Function of CONCATENATE in MS Excel:

Easy
A To join two or more text strings
B To join two text strings
C Not To join two or more text strings
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q106.Calculation done in MS excel through:

Easy
A Formulas
B Labels
C Charts
D None of these
Formulas PPSC 2025

Correct Answer: A

Q107.The option for putting equation in Excel is available in which tab:

Easy
A Home
B Review
C Insert
D None of these
Excel Interface PPSC 2025

Correct Answer: C

Q108.What is the purpose of freeze panes in Excel:

Easy
A is to keep specified rows and columns visible at all times, even as you scroll through a large worksheet
B To print the rows on the document
C To delete the document
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q109.Which program is used to make spreadsheet:

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

Correct Answer: B

Q110..txt is file Extension of

Easy
A Word
B Notepad
C Excel
D None of these
Excel Interface PPSC 2025

Correct Answer: B

Q111.In Excel, a formula is started with the?

Easy
A =
B ,
C +
D :
Formulas PPSC 2025

Correct Answer: A

Q112.Which of the following is not a valid zoom percentage in Excel:

Easy
A 400
B 300
C 200
D 500
Excel Interface PPSC 2025

Correct Answer: D

Q113.Which of the following is wrong format for excel formula:

Easy
A 10+15
B 42
C
D 22
Formulas PPSC 2025

Correct Answer: A

Q114.Excel to html change by:

Easy
A internet Assistant Wizard
B internet explorer
C CPU
D None of These
Excel Interface PPSC 2025

Correct Answer: A

Q115.Short cut key to minimize workbook in MS Excel:

Easy
A Ctrl+ F1
B Ctrl+ F9
C Ctrl+ F4
D None of these
Excel Interface PPSC 2025

Correct Answer: B

Q116.Which formula is used in excel to find remainder:

Easy
A MOD ( )
B Avg ()
C REM()
D None of these
Formulas PPSC 2025

Correct Answer: A

Q117.In excel, the cell reference of the active cell, will also appear in ?

Easy
A Name box
B Description box
C Title Box
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q118.The keyword shortcut to minimize an Excel worksheet?

Easy
A Ctrl + F9
B Ctrl + F8
C Ctrl + F7
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q119.How many rows are in one Microsoft Excel sheet?

Easy
A 1048576
B 1100000
C 1000067
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q120.The __ feature of MS Excel quickly completes a series of data :

Easy
A Auto Fill
B
C Ctrl + $
D None of these
Excel Interface PPSC 2025

Correct Answer: A