Excel Functions and Formulas
Shared by a Veda learner · Generated with Veda AI
What you'll study, topic by topic
Excel Functions and Formulas
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...
Sample questions with model answers
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.
Show answer outline
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?
Show answer outline
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.
Show answer outline
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.
Show answer outline
Functions are pre-defined formulas; mathematical: SUM(), PRODUCT(); text: CONCAT(), TEXTJOIN().
The full exam-length answer is in the app.
Study it properly — free, 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.