UGC NET Spreadsheets Previous Year Questions
JRFSmart holds 28 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 28 of the 149 papers analysed (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 |
|---|---|
| Absolute and relative references | 2 |
| MS-Excel cell references | 2 |
| Absolute cell references | 1 |
| VLOOKUP with absolute references | 1 |
| COUNTIFS criteria | 1 |
| SUMIF with a criteria range | 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 28 of 149 papers (19%), which JRFSmart rates as medium frequency.
4 questions use a question template that NTA has set again with a key word changed, so read the changed word carefully.
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…
In the following MS-Excel spreadsheet, you are given a list of 100 customers. Column 'A' represents their names, 'B' is for customer category, 'C' for payment category (0 means discounted price and 1 means full price), 'D' indicates price that customer pays…
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 ?
Showing 8 of 28 questions, without answers. Practise the full set with options, the official answer and JRFSmart's explanations. Every question shows an ID: NTA’s own Question ID where NTA published one, or a JRFSmart ID. It also shows the exam session and date it appeared in. Answers follow NTA’s final answer keys. Quote the ID when you report a mistake, and we fix it and log it on our public corrections page.
Related topics in this unit
Explanations are built from solutions by UGC NET and JRF qualified students and teachers, and edited by JRFSmart. Questions come from NTA papers and are attributed to their session. See how we check and the corrections log. Last updated 18 November 2026.