UGC NET Spreadsheets Previous Year Questions
JRFSmart holds 15 previous-year questions on Spreadsheets from UGC NET Paper 1 (Teaching and Research Aptitude), filed under Unit 8: Information and Communication Technology (ICT), drawn from 15 of the 87 exam papers in the bank (2018–2026). Each question can be practised with a full explanation and shows how often NTA has returned to the same idea.
What is asked in Spreadsheets
The questions in this topic fall under these subtopics, ordered by how many previous-year questions each has.
| Subtopic | Questions |
|---|---|
| MS-Excel cell references | 2 |
| Absolute cell references | 1 |
| VLOOKUP with absolute references | 1 |
| COUNTIFS criteria | 1 |
| SUMIF with a criteria range | 1 |
| Absolute and relative references | 1 |
| Excel error messages | 1 |
| SUMIFS with two criteria | 1 |
| Features of spreadsheet software | 1 |
| AVERAGE, SUM and range syntax | 1 |
| SUM syntax and ranges | 1 |
| Absolute references when copying | 1 |
NTA repeat analysis
Spreadsheets appears in 15 of 87 papers (17%), which JRFSmart rates as medium frequency.
Sample previous-year questions
Match the LIST-I with LIST-II in the context of MS-Excel: LIST-I (Cell Reference) | LIST-II (Definition and Feature) A. $E$5 | I. Absolute reference. Column and row are fixed when fill handle is used. B. E$5 | II. Mixed reference. Row is fixed and column is…
A teacher uses the following table in MS-EXCEL in the range A1 : E2 to assign grades based on marks. If a student's marks are entered in cell A10, then which formula should be entered in cell B10 to display the correct grade ? Reference Table (A1 : E2) : Row…
Radha tries different ways to explore the alternative methods of getting the average value of the numbers as indicated in the worksheet below : A B C D 1 12 2 5 3 10 4 Which of the following formulae A-E when entered in cell A4, would given an incorrect…
With reference to the snapshot of MS-EXCEL worksheet given below, which of the following formule A-E when entered into cell A4 can be used to add the values 10, 20 and 30? A B C 1 10 2 20 3 30 4 A. = SUM (A1:A3) B. = SUM (A1, A3) C. =A1+A2+A3 D. =SUM (A1…
Consider the following MS-EXCEL spreadsheet: A B C D E 1 Item Quantity Price Revenue 2 A-11 12 5 60 3 B-32 31 9 279 4 C-44 24 12 288 If the formula = $B$2 * $C$2 is entered into cell E2, and the formula is then copied to cells E3 and E4, then the values in…
Consider the following MS-EXCEL function entered in cell C1: =IF(A1>B1, 1, IF (A1=10, 2, IF(A1<B1, 3, 4))) The above function will return a value of 4 in cell C1 if the values in cell A1 and cell B1 are ____ respectively.
Consider the following snapshot of MS-EXCEL worksheet : A B C 1 90 70 2 60 170 3 150 20 4 30 110 5 50 40 6 130 30 7 What will be the value of the cell C1 containing the formula = SUMIF(A1:A6,">100",B1:B6) in the above worksheet ?
In MS-EXCEL, a formula =B$1 + C$3 + 5 in cell D9 when copied to cell F12 will become: Choose the correct answer from the options given below:
Showing 8 of 15 questions, without answers. Practise the full set with options, the official answer and JRFSmart's explanations.
Practise Spreadsheets
All 15 questions, one topic, with explanations and repeat data. One topic in every unit is free.
Practise this topic