Computer Mock Test 7 – Full Syllabus Practice…

🏆 Scholarship test ✓ Free Class 10 Computer

About this test

Spreadsheet questions are mostly about knowing the right function and the right cell reference, and this test checks both. You will work through SUM, AVERAGE, MAX and COUNT, then the IF function (आईएफ फंक्शन) for conditions and VLOOKUP for searching a table. Several questions test relative and absolute references (रिलेटिव और एब्सोल्यूट रेफरेंस), which many students mix up. The paper also covers sorting (सॉर्टिंग), filtering (फ़िल्टरिंग), charts, pivot tables and freeze panes. Attempt it after practising in a real sheet, and use the explanations (व्याख्या) to fix any formula you got wrong.

25Questions

180Minutes

50Marks

What this test covers

Basic functions: SUM, AVERAGE, MAX, COUNT (फंक्शन)
IF function and logical tests
Relative and absolute cell references ($ sign) (सेल रेफरेंस)
VLOOKUP: searching a value in a table
Sorting data in ascending and descending order (सॉर्टिंग)
Filtering rows by condition (फ़िल्टरिंग)
Charts and graphs: bar graph, pie chart (चार्ट)
Pivot table: summarising large data
Freeze panes and cross-sheet references
What-If Analysis

Questions students ask

Which function adds a range of cells?

The SUM function adds all the numbers in the selected range.

What is the difference between relative and absolute reference?

A relative reference changes when you copy the formula, while an absolute reference with $ signs stays fixed.

What does the IF function do?

It checks a condition and gives one result if it is true and another if it is false.

What is VLOOKUP used for?

It searches for a value in the first column of a table and returns a matching value from another column.

What is the difference between sorting and filtering?

Sorting arranges the data in order, while filtering shows only the rows that match a condition and hides the rest.

What is a pivot table?

It is a tool that summarises and reorganises a large amount of data quickly.

More tests for Class 10

Bihar Board Class 10 ENGLISH Full Paper Set 10 2027 Bihar Board Class 10 ENGLISH Full Paper Set 9 2027 Bihar Board Class 10 ENGLISH Full Paper Set 8 2027 Bihar Board Class 10 ENGLISH Full Paper Set 7 2027 Bihar Board Class 10 ENGLISH Full Paper Set 6 2027 Bihar Board Class 10 ENGLISH Full Paper Set 5 2027 All tests →

Merit Spring App install karein

App Theme