1. This is not a function category in excel.
a. Data Series
b. Text
c. Financial
d. Logical
2. True or False. Home Tab contains all the formula and functions.
a. TRUE
b. FALSE
3. The result is a value either TRUE or FALSE.
a. Logical
b. Arithmetic
c. Algorithm
d. Logarithm
4. Which of the following is an example of comparison operator?
a. *
b. +
c. =
d. ^
5. The result of a formula in a cell is the.
a. Displayed value
b. Value
c. Range
d. Label
6. How many categories of function were included in Excel 2010?
a. 9
b. 11
c. 12
d. 13
7. Which of the following data formats stores integers values?
a. Date
b. Number
c. Currency
d. Text
8. Janice wanted to know the absolute value of -25, which of the following functions will she use?
a. SUM
b. COUNTA
c. ABS
d. OR
9. Suppose you want to count the number cells without values in range, what function will you include in your formula?
a. COUNTTEXT
b. ISBLANK
c. COUNTBLANK
d. COUNTIF
10. The user typed "LOVE" in cell A1, he used the function ISTEXT in his formula on cell B1 testing the value in Cell A1. Which of the following values will be displayed upon pressing ENTER?
a. TRUE
b. LOVE
c. FALSE
d. ISTEXT
11. Which function is used to determine the day of the week for a date?
a. TODAY()
b. WEEKDAY ()
c. DATE()
d. DAY()
12. Which of the following returns the arithmetic mean of values in a selected range?
a. SUM
b. INT
c. MEAN
d. AVERAGE
13. Which of the following best explains the benefit of using function in excel?
a. Easy to write a formula.
b. Complex calculations become easy
c. Shorter formula
d. More accurate calculations
14. What is the AND function does in Excel?
a. It is a logical function
b. Its adds data or numeric values
c. Sorts data automatically in increasing order
d. Check whether the output will be TRUE or False
15. Which of the following is written correct?
a. =TODAY()
b. TODAY()
c. =()TODAY
d. =(TODAY)


patulong po... brainliest ko po makakasagot ng Tama.​