LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
12 views
in General by (54.3k points)
closed by
Which expression is used to know how the numbers in a determined set of cells are calculated in MS Excel?
1. Formula
2. Field
3. Data
4. Query

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
Correct Answer - Option 1 : Formula

The correct answer is Formula.

  • In Excel, a formula is an expression that operates on values in a range of cells or a cell.
  • For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
  • Functions - Functions are predefined formulas in Excel.

Basic Mathematical formulas used in Excel:

  • SUM - Used to add cells or the range of the cell.
  • AVERAGE - Used to find the average of the cells or the range of the cell.
  • MAX - To determine the maximum value to the range of the cells.
  • MIN - To determine the minimum value to the range of the cells.
  • COUNT - used to tell how many cells in a range contain a number.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...