13 questionswith explanationsfor RSSB CET Graduation Level
In MS Excel, which feature keeps the top row (for example, the column headings) visible while you scroll down a long sheet?
Answer: (3) Freeze Panes
Explanation
Freeze Panes locks chosen rows or columns so that they stay visible while the rest of the sheet scrolls.
In MS Excel, cells A1 to A5 contain: 12, Jaipur, 7, (blank) and 25. What value will the formula =COUNT(A1:A5) return?
Answer: (2) 3
Explanation
COUNT counts only cells containing numbers (12, 7 and 25), so it returns 3; COUNTA, which counts all non-empty cells, would return 4.
In MS Excel, a formula entered in a cell must begin with which symbol?
Answer: (1) = (equal to)
Explanation
An Excel formula starts with the equal sign (=), for example =SUM(A1:A5); without it Excel treats the entry as text or a number.
In MS Excel, cell C1 contains the formula =$A1+B$1. If this cell is copied and pasted into cell D2, which formula will appear in D2?
Answer: (4) =$A2+C$1
Explanation
Moving one column right and one row down: in $A1 the column is fixed and the row changes to 2 ($A2); in B$1 the row is fixed and the column changes to C (C$1).
The 'Mail Merge' feature of MS Word is mainly used to:
Answer: (3) Make personalised copies of one letter for many people
Explanation
Mail Merge joins a main document (letter, label, envelope) with a data source of names and addresses to produce a personalised copy for each person.
In MS Word, which keyboard shortcut opens the 'Find and Replace' dialog box with the Replace tab?
Answer: (2) Ctrl + H
Explanation
Ctrl + H opens Replace; Ctrl + R, Ctrl + E and Ctrl + J align text right, centre and justified respectively.
In MS PowerPoint, which key starts the slide show from the first slide?
Answer: (4) F5
Explanation
F5 starts the slide show from the beginning (Shift + F5 starts from the current slide); F1 opens Help, F7 spelling check and F12 Save As.
Which view of MS PowerPoint shows all the slides as small thumbnails so that they can be easily rearranged?
Answer: (1) Slide Sorter view
Explanation
Slide Sorter view displays thumbnails of all slides, making it easy to reorder, delete or duplicate them.
In Microsoft Excel for Windows, which of the following keyboard shortcut descriptions is NOT correct?
Answer: (3) Ctrl + T inserts the current date in the active cell
Explanation
Per Microsoft Support, Ctrl + T opens the Create Table dialog box; the current date is entered with Ctrl + ; (a fixed value, unlike the =TODAY() function). The other three are correct: Alt + = gives AutoSum, Ctrl + D is Fill Down and Ctrl + Y repeats the last action. So the statement about Ctrl + T is the incorrect one.
In MS Excel, which of the following formulas does NOT return the value shown against it?
Answer: (4) =INT(-7.4) returns -7
Explanation
INT rounds a number down to the nearest integer, so =INT(-7.4) returns -8, not -7; -7 is what =TRUNC(-7.4) gives, because TRUNC only drops the decimal part. MOD gives the remainder (17 = 3 × 5 + 2), ABS the absolute value and SQRT the positive square root.
Match List-I (LibreOffice application) with List-II (default file extension): List-I A. Writer B. Calc C. Impress D. Draw List-II i. .odp ii. .odg iii. .odt iv. .ods Choose the correct code:
Answer: (2) A-iii, B-iv, C-i, D-ii
Explanation
LibreOffice saves in the OpenDocument Format by default: .odt (text) for Writer, .ods (spreadsheet) for Calc, .odp (presentation) for Impress and .odg (graphics) for Draw. The MS Office equivalents are .docx, .xlsx and .pptx; .odp is not the Draw format.
In an MS Excel sheet, cell B2 contains 72 and cell B3 contains 35. What will the formula =IF(AND(B2>=40,B3>=40),"Pass","Fail") display?
Answer: (2) Fail
Explanation
AND returns TRUE only if both tests are true. B3 (35) is below 40, so AND gives FALSE and IF returns the second result, "Fail". AND itself returns TRUE or FALSE, not text.
In an MS Excel worksheet without frozen panes, which key combination moves the cell pointer to cell A1?
Answer: (2) Ctrl + Home
Explanation
Ctrl + Home goes to the start of the worksheet (A1). Ctrl + End goes to the last used cell, Home goes to the first cell of the current row, and Ctrl + Page Up moves to the previous sheet.