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 121–140 of 430

Q121.Default file name in MS Excel is?

Easy
A Book
B Book1
C File1
D None of these
Excel Interface PPSC 2025

Correct Answer: B

Q122.In MS Excel, a formula starts with__?

Easy
A +
B -
C =
D None of These
Formulas PPSC 2025

Correct Answer: C

Q123.In MS Excel, the __ function is used to count the number of cells within a range?

Easy
A COUNT
B COUNTIF
C COUNTTHEN
D None of These
Excel Interface PPSC 2025

Correct Answer: B

Q124.For making flow chart and presentation which is used?

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

Correct Answer: A

Q125..ppt is file extension of?

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

Correct Answer: A

Q126.Which of the following is a database management system ?

Easy
A MS Access
B MS Excel
C MS Word
D None of These
Excel Interface PPSC 2025

Correct Answer: A

Q127.Which is use for database?

Easy
A MySQL
B Word
C Excel
D None of These
Excel Interface PPSC 2025

Correct Answer: A

Q128.Which software is used for projects management and tasks?

Easy
A MS word
B Ms excel
C Ms Powerpoint
D ASANA
Excel Interface PPSC 2025

Correct Answer: D

Q129.How to remove border from Excel?

Easy
A Home>Border>no border
B Home>Computer> Insert
C Home >Insert>Go To
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q130.Average B3 to E5 will be written in Excel?

Easy
A 1
B Avg(B3E5)
C
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q131.What is indentation in MS Excel?

Easy
A horizontal shift of text with in a cell
B Vertical shift of text with in a cell
C Both
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q132.Vector graphics is related to?

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

Correct Answer: A

Q133.Which function is used to add today date in excel:

Easy
A date()
B Today()
C Date
D None of these
Excel Interface PPSC 2025

Correct Answer: B

Q134.Short key used to start a new line in an excel cell:

Easy
A Alt+ enter
B Shift+ enter
C Ctl+ enter
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q135.Which file extension is used for excel: .

Easy
A .xlsx
B .xls
C .xlX
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q136.In excel count () function denotes:

Easy
A to count the number of cell in a range
B to count the number of cell
C to count the number of cell in a row only
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q137.In excel: (A20:A30) means:

Easy
A range of cell from cell A20 to cell A30
B range of rows from A20 to A30
C cells name A20 and A30 only
D None of these
Excel Interface PPSC 2025

Correct Answer: A

Q138.Excel formula for addition:

Easy
A Sum()
B Add ()
C Both
D None of these
Formulas PPSC 2025

Correct Answer: A

Q139.Cell reference in excel shows in:

Easy
A Formula Bar
B Comments
C Tab bar
D None of these
Formulas PPSC 2025

Correct Answer: A

Q140.By Default, how many worksheets in excel:

Easy
A 0
B 1
C 2
D 3
Excel Interface PPSC 2025

Correct Answer: B