Which shortcut key is used to insert a new worksheet in Excel?
A. Shift + F11
B. Ctrl + F1
C. Alt + F1
D. None of these
Note: PPSC – Data Entry Operator on (31-05-2025)
Shift + F11 is the shortcut to quickly insert a new worksheet in MS Excel. It adds a blank sheet to the left of the current active sheet without going to the ribbon menu.
In Excel, which function returns the largest value in a range?
A. LARGE
B. MIN
C. MAX
D. VALUE
Note: PPSC – Data Entry Operator on (31-05-2025)
The MAX function in Excel returns the highest numeric value in a specified range. It’s helpful when analyzing datasets to find the largest amount, score, or value.
Which shortcut key opens the ‘Find and Replace’ dialog in Excel?
A. Ctrl + R
B. Ctrl + F
C. Ctrl + H
D. Ctrl + Shift + H
Note: PPSC – Data Entry Operator on (31-05-2025)
Pressing Ctrl + H opens the ‘Find and Replace’ dialog box in Excel immediately. This tool helps in replacing values or words in large spreadsheets with speed.
By default, numbers in Excel are aligned to the ___?
A. Left
B. Center
C. Right
D. Justify
Note: PPSC – Data Entry Operator on (31-05-2025)
By default, Excel aligns numbers to the right side of the cell and text to the left. This formatting helps users quickly distinguish between numerical and textual data.
Which symbol anchors a cell reference in Excel formulas?
A. @
B. #
C. $
D. %
Note: PPSC – Data Entry Operator on (31-05-2025)
In Excel, the dollar sign ($) creates absolute cell references, like $A$1. This keeps the reference the same, even when you copy the formula to another cell.
In Excel, the function =NOW() provides the ____?
A. Current Date
B. Current Time
C. Current Date and Time
D. None of these
Note: PPSC – Data Entry Operator on (31-05-2025)
The NOW() function shows the current date and time according to the system clock. It undergoes regular changes, as it receives updates each time the worksheet recalculates.
In Excel, which of the following functions returns the smallest value?
A. SMALL
B. MIN
C. LOWER
D. LOW
Note: PPSC – Data Entry Operator on (31-05-2025)
The MIN function is used to find the lowest numerical value within a set of cells. It’s frequently used to identify the smallest sales amount, scores, or other numbers.
In Excel, where can you find the ‘Sort & Filter’ options in the menu?
A. Insert
B. Page Layout
C. Data
D. Review
Note: PPSC – Data Entry Operator on (31-05-2025)
The Data tab in Excel houses ‘Sort & Filter’ tools for organizing data. You can sort in ascending or descending order and filter specific fields.
Which key combination is used to insert the current date in a cell?
A. Ctrl + ;
B. Alt + ;
C. Shift + ;
D. Ctrl + Shift + ;
Note: PPSC – Data Entry Operator on (31-05-2025)
By pressing Ctrl + ;, you can quickly add the current date to a cell you have selected. This feature is great for automatically adding timestamps to data entries.
In Excel, which key is used to start a new line within a cell?
A. Enter
B. Shift + Enter
C. Alt + Enter
D. Ctrl + Enter
Note: PPSC – Data Entry Operator on (31-05-2025)
Pressing Alt + Enter in Excel lets you add a new line in the same cell. This is handy for entering multiple lines of text, like addresses or notes.
