Which of the following is used to perform calculations in MS Excel?
Formula
Data
Textbox
Table
Can you say the meaning of formula ‘= AVERAGE(A1:A4, 25)’?
Cell A1, A2, A3, A4 are added and divided into 25.
Cell A1, A2, A3, A4, 25 are added and divided into 4.
Cell A1, A2, A3, A4, 25 are added and divided into 5.
Cell A1, A4, 25 are added and divided into 3.
Which one's example is COUNT() in MS Excel?
Constant
Functions
Operators
Which of the following displays the result after performing the formula calculations in MS Excel?
Formula bar
Selected Cell
Unselected Cell
Tool bar
How can we begin the formulas?
Greater than sign
Equal sign
Smaller than sign
Plus sign
What value does the formula ‘= MAX (A1:A2)’ returns?
Minimum
Maximum
Number of cell
Both 1 and 2
Which of the following area can be used to enter formulas in MS Excel?
Cells
None of these
Which of the following function tells you the number of numeric entries in a selected cells?
Count
Average
What is an excel workbook?
Workbook
Worksheet
Documents
Formulas
What is the syntax of sum function?
COUNT(select the cell range)
SUM(select the cell range)
Add(select the cell range)
TOTAL(select the cell range)