Practice Test GeeksExcel Practice Test
← All Microsoft Excel Flashcard Decks

Formulas Questions and Answers Flashcards

6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Formulas Questions and Answers flashcards as text

  1. What does the SUMPRODUCT function do in Excel?

    Answer: Multiplies corresponding elements in arrays and returns the sum of those products

    SUMPRODUCT multiplies corresponding elements in two or more arrays (ranges of the same size) and then sums those products, making it extremely versatile for conditional calculations.

  2. Which formula correctly calculates the percentage change between an old value in A1 and a new value in B1?

    Answer: =(B1-A1)/A1

    The percentage change formula is (New-Old)/Old, which translates to (B1-A1)/A1 in Excel. Format the result as a percentage.

  3. What is the result of the formula =MOD(17,5)?

    Answer: 2

    MOD returns the remainder after division. 17 divided by 5 is 3 with a remainder of 2, so MOD(17,5) returns 2.

  4. Which formula would you use to combine the text in cells A1 and B1 with a space between them?

    Answer: =A1&" "&B1

    The ampersand (&) operator concatenates text strings in Excel. A1&" "&B1 joins the contents of A1 and B1 with a space character between them.

  5. What does the ROUND function do when the second argument is negative, such as =ROUND(1567,-2)?

    Answer: Rounds to the nearest hundred, returning 1600

    When the num_digits argument is negative, ROUND rounds to the left of the decimal point. -2 rounds to the nearest hundred, so 1567 becomes 1600.

  6. Which formula returns the number of days between two dates in cells A1 and B1?

    Answer: =B1-A1

    Simply subtracting one date from another (=B1-A1) returns the number of days between them, since Excel stores dates as serial numbers.