Scribd Logo
Upload

Welcome to Scribd!

  • 2K views

    Epp 6 Ict Summative Test 2

    Uploaded by

    Mary Jane Acierto-cuello
    The document contains an ICT quiz with multiple choice, true/false, and identification questions about Excel functions. The multiple choice section tests knowledge of functions like SUM, PRODUCT, MOD, POWER, QUOTIENT, ROUND, SUMSQ, SUMIF, and SUMSPRODUCT. The true/false questions cover functions like AVERAGE, COUNT, COUNTA, MAX, MIN, RANK.AVG, and MEDIAN. The identification questions ask which function performs tasks like converting text to lowercase, returning the length of text, concatenating text, and using logical operators like IF, OR, and AND.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Epp 6 Ict Summative Test 2

    Uploaded by

    Mary Jane Acierto-cuello
    2K views2 pages
    The document contains an ICT quiz with multiple choice, true/false, and identification questions about Excel functions. The multiple choice section tests knowledge of functions like SUM, PRODUCT, MOD, POWER, QUOTIENT, ROUND, SUMSQ, SUMIF, and SUMSPRODUCT. The true/false questions cover functions like AVERAGE, COUNT, COUNTA, MAX, MIN, RANK.AVG, and MEDIAN. The identification questions ask which function performs tasks like converting text to lowercase, returning the length of text, concatenating text, and using logical operators like IF, OR, and AND.

    Original Description:

    summative epp 6

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains an ICT quiz with multiple choice, true/false, and identification questions about Excel functions. The multiple choice section tests knowledge of functions like SUM, PRODUCT, MOD, POWER, QUOTIENT, ROUND, SUMSQ, SUMIF, and SUMSPRODUCT. The true/false questions cover functions like AVERAGE, COUNT, COUNTA, MAX, MIN, RANK.AVG, and MEDIAN. The identification questions ask which function performs tasks like converting text to lowercase, returning the length of text, concatenating text, and using logical operators like IF, OR, and AND.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2K views2 pages

    Epp 6 Ict Summative Test 2

    Uploaded by

    Mary Jane Acierto-cuello
    The document contains an ICT quiz with multiple choice, true/false, and identification questions about Excel functions. The multiple choice section tests knowledge of functions like SUM, PRODUCT, MOD, POWER, QUOTIENT, ROUND, SUMSQ, SUMIF, and SUMSPRODUCT. The true/false questions cover functions like AVERAGE, COUNT, COUNTA, MAX, MIN, RANK.AVG, and MEDIAN. The identification questions ask which function performs tasks like converting text to lowercase, returning the length of text, concatenating text, and using logical operators like IF, OR, and AND.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    EPP VI ICT QUIZ 2

    I. Choose the letter of the correct answer.

    _____ 1. It adds all the numbers in a range of cells.


    a. SUM c. QUOTIENT
    b. PRODUCT d. POWER

    _____ 2. It returns the remainder after a number is divided by a divisor.


    a. PRODUCT c. MOD
    b. SUM d. ROUND

    _____ 3. It multiplies all the numbers given as arguments.


    a. MOD c. SUM
    b. PRODUCT d. ROUND

    _____ 4. It returns the result of a number raised to a power.


    a. ROUND c. PRODUCT
    b. SUM d. POWER

    _____ 5. It returns the integer portion of a division.


    a. QUOTIENT c. POWER
    b. SUMPRODUCT d. ROUND

    _____ 6. It rounds a number to a specified number of digits.


    a. SUMPRODUCT c. QUOTIENT
    b. ROUND d. SUMIF

    _____ 7. It returns the sum of the squares of the arguments.


    a. SUMSQ c. SUMIF
    b. SUMSPRODUCT d. SUMIFS

    _____ 8. It adds the cells specified by a given set of conditions or criteria.


    a. SUMSQ c. SUMIF
    b. SUMSPRODUCT d. SUMIFS

    _____ 9. Adds the cells specified by a given condition or criteria.


    a. SUMSQ c. SUMIF
    b. SUMSPRODUCT d. SUMIFS

    _____ 10. It returns the sum of the products of corresponding ranges or arrays.
    a. SUMSQ c. SUMIF
    b. SUMSPRODUCT d. SUMIFS
    II. True or False: Write T if the statement is true and F if it is not.

    _______ 1. AVERAGE function returns the average of its arguments.


    _______ 2. COUNT Function finds the average of all the cells in a range that meet a given
    Criteria.
    _______ 3. COUNTA counts how many values are in the list of arguments.
    _______ 4. MAX Returns the maximum value in a list of arguments
    _______ 5. MIN Returns the maximum value in a list of arguments
    _______ 6. COUNTIF Returns the minimum value in a list of arguments
    _______ 7. RANK.AVG Returns the rank of a number in a list of numbers; its size
    relative to other values in the list; if more than one value has the same
    rank, the average.

    _______ 8. MODE.SNGL Returns the median of the given numbers


    _______ 9. AVERAGE Counts how many values are in the list of arguments
    _______ 10. MEDIAN Returns the median of the given numbers.

    III. Identify what is asked in each item. Choose your answer inside the box.

    CONCATENATE LEN LOWER

    UPPER LEFT RIGHT

    AND IF OR

    _____________ 1. Converts all letters in a text string to lowercase.


    _____________ 2. Returns the rightmost characters from a text value.
    _____________ 3. Returns TRUE if any argument is TRUE.
    _____________ 4. Returns the number of characters in a text string.
    _____________ 5. Converts all letters in a text string to uppercase.
    _____________ 6. Returns the rightmost characters from a text value.
    _____________ 7. Checks whether a condition is met and returns one value if TRUE, otherwise
    returns another value.
    _____________ 8. Joins several text strings into one text string.
    _____________ 9. Returns the leftmost characters from a text value.

    Prepared by:

    JAIFE E. MACARAEG
    DON PEDRO ELEMENTARY SCHOOL / MALASIQUI II

    You might also like