Shared by a Veda learner · Generated with Veda AI
In Excel, a formula is a user-defined instruction that performs calculations. Cell ranges are groups of selected cells, and cell references help locate data in a worksheet. Functions are pre-defined formulas, with types…
Full explanation, worked examples & memory tricks in the app
Every question in the paper gets a full exam-length answer in the app — organised by marks, the way a topper writes it.
What is a formula? Give an example.
A formula is user-defined instructions for calculations, e.g., A1+A2+B2*5.
The full exam-length answer is in the app.
What is a cell range? How can you create it?
A cell range is a group of selected cells, created by dragging from a starting to an ending cell.
The full exam-length answer is in the app.
What is a cell reference? Mention its types.
A cell reference is the cell's address; types include relative, absolute, and mixed.
The full exam-length answer is in the app.
What is meant by functions? Name two mathematical and two text functions.
Functions are pre-defined formulas; mathematical: SUM(), PRODUCT(); text: CONCAT(), TEXTJOIN().
The full exam-length answer is in the app.
What is mixed reference?
Mixed reference combines relative and absolute reference, e.g., $A1+A$2.
The full exam-length answer is in the app.
Your teacher collected the test score of your class. You want to find the highest and lowest score. What functions can he use?
Use MAX() for highest score and MIN() for lowest score.
The full exam-length answer is in the app.
You have a list of student marks in cell B2 to B10, which formula will calculate the average marks?
=Average(B2:B10)
The full exam-length answer is in the app.
Sujata needs to calculate the total marks of 5 subjects for students where marks are in cell B2:F2, which formula is best?
=Sum(B2:F2)
The full exam-length answer is in the app.
If the formula =A1+B1 is copied from cell D1 to D2, what will be the new formula in D2?
=A2+B2 (relative referencing).
The full exam-length answer is in the app.
Rohan needs to enter the string 'Education'. He wants to count characters in a given string. What function can he use?
Use LEN('Education').
The full exam-length answer is in the app.
The full Veda Bites deck, complete notes, spaced-repetition flashcards, leveled MCQs, tests and games for this kit — plus Daily Facts and the Arena, every day.