What does ‘=SUM (A1:A4, B1)’ means?
A1, A4 and B1 cells to be added.
A1, A4 cells to be added and value stored in B1.
A1, A2, A3, A4, B1, B2, B3, B4 cells to be added.
A1, A2, A3, A4 and B1 cells to be added.
Which one's example is COUNT() in MS Excel?
Constant
Functions
Operators
Data
How can we begin the formulas?
Greater than sign
Equal sign
Smaller than sign
Plus sign
Which of the following is used to perform calculations in MS Excel?
Formula
Textbox
Table
What is an excel workbook?
Workbook
Worksheet
Documents
Formulas
Which of the following have the examples as SUM, AVERAGE, IF, COUNT etc?
Arguments
Which of the following displays the result after performing the formula calculations in MS Excel?
Formula bar
Selected Cell
Unselected Cell
Tool bar
Which of the following function tells you the number of numeric entries in a selected cells?
Count
Maximum
Minimum
Average
Which formula is used to add two cells (D1 and D2) together?
=D1 + D2
=Add(D1+D2)
= total(D1:D2)
D1 + D 2
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)
