Class 7 Computer Science: MS Excel Formulas and Functions
This worksheet will help students practice identifying and using basic formulas and functions in MS Excel.
Class 7CBSEComputer ScienceeasyPractice
Preview · 10 questions
- Q1. Which symbol must all formulas in MS Excel begin with?
- #
- =
- &
- $
- Q2. Which of the following is an example of a cell address in Excel?
- A1
- Sheet1
- ColumnA
- Row1
- Q3. A predefined formula that performs calculations in Excel is called a _________.
- Q4. Which function is used to add a range of numbers in Excel?
- AVERAGE()
- SUM()
- MAX()
- COUNT()
- Q5. What is the purpose of a formula in MS Excel?
+ 5 more in the printable PDF.