Which of the following shortcut keys extends the selection below?
A. Ctrl + Down
B. Shift + Down
C. Alt + Down
D. None of these
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
The Shift + Down Arrow extends the current selection downward, cell by cell, in Excel. It is useful for selecting large datasets in a way that does not need a mouse.
Which of the following features of MS Excel quickly completes a series of data:
A. Ctrl + $
B. = Fill
C. Auto Fill
D. None of these
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
Auto filling lets you automatically fill the cells with a chain. This series may include numbers, dates or days. You can pull the fill handle to apply a pattern to adjacent cells.
What is the default file name in MS Excel?
A. Book1
B. Book
C. File1
D. None of these
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
When a new workbook is opened in Excel, a predetermined name as Book1 is assigned. As new work books open, Excel names them Book2, Book3, etc.
A formula starts with ___ In Microsoft Excel.
A. =
B. –
C. +
D. None of These
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
Formulas in Microsoft Excel start with an equal sign (=). This sign tells Excel to do a calculation. For example, =A1+B1 adds values from those two cells.
In Microsoft Excel, you use the ___ function to count the number of cells within a range.
A. COUNT
B. COUNTIF
C. COUNTTHEN
D. None of These
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
The count returns the number of numerical values in a range of cells. Excludes empty or non -numerical cells from total counting.
What do we call sorting from A to Z?
A. Ascending
B. Descending
C. Constant
D. None of These
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
Sorting data in ascending order means arranging it from A to Z. This method is often used for names or classification numbers in alphabetical order.
We call the arrangement of data in a logical sequence?
A. Arranging
B. Sorting
C. Organizing
D. None of These
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
Sorting orders data by criteria such as alphabet, date, or number. It helps make large datasets easier to read and analyze.
How many types of document views are there in MS Word?
A. 3
B. 5
C. 4
D. None of These
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
MS Word offers five types of document views: Print Layout, Web Layout, Outline, Draft, and Read Mode. Each view serves a different purpose for writing, reviewing, or printing.
Microsoft Word is a/an?
A. Virus software
B. Application software
C. Gaming software
D. None of These
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
MS Word is a word processing application used for creating documents, letters, reports, and more. It is part of the Microsoft Office Suite.
What is the Short key for slideshow in Microsoft PowerPoint?
A. F5
B. F2
C. F6
D. None of these
Note: PPSC – Data Entry Operator (BS-12) – (31-05-2025)
Pressing F5 in PowerPoint starts the slideshow from the beginning. It’s a quick way to preview your entire presentation.
