PassEveryTest
Svenska

Microsoft Office Specialist: Excel Exam Preparation: Perform operations by using formulas and functions

Temaquiz utan tidsgräns: 20 frågor om Perform operations by using formulas and functions, med en förklaring efter varje svar. Frågor och svar blandas varje gång.

  • Kurs
  • Kanada
  • 90 frågor
  • Kontrollerad 13 oktober 2026
  • Faktagranskad 13 oktober 2026
Börja med lektionernaMicrosoft Office Specialist: Excel Exam Preparation: Lessons: cirka 300 minuters läsning. Alla provfrågor tas upp i lektionerna.

Temaquiz 4: Perform operations by using formulas and functions

  1. Fråga 1 av 20

    Which function counts the cells in a range that are not empty, including cells with text?
    Visa svar

    Svar: C. COUNTA

    COUNT counts only numbers. Use COUNTA to count any cell that is not empty, such as text, numbers or errors.

  2. Fråga 2 av 20

    What does =SUM(B2:B6) return?
    AB
    1DayCalls
    2Mon14
    3Tue9
    4Wed17
    5Thu11
    6Fri20
    Visa svar

    Svar: B. 71

    SUM adds every number in the range: 14 + 9 + 17 + 11 + 20 = 71.

  3. Fråga 3 av 20

    D2 contains =B2*C2. You copy D2 down to D3. What formula is in D3?
    Visa svar

    Svar: C. =B3*C3

    Relative references change by the same number of rows and columns as the move. One row down, B2 and C2 become B3 and C3.

  4. Fråga 4 av 20

    The tax rate is in B1. C4 contains =B4*$B$1. You copy C4 to C5. What formula is in C5?
    Visa svar

    Svar: D. =B5*$B$1

    B4 is relative, so it becomes B5. $B$1 is absolute, so it stays the same.

  5. Fråga 5 av 20

    You type =A1 and, with A1 selected in the formula, press F4 twice. What reference do you get?
    Visa svar

    Svar: B. A$1

    F4 cycles through $A$1, A$1, $A1 and back to A1. The second press gives A$1 (row locked).

  6. Fråga 6 av 20

    What does =AVERAGE(B2:B7) return? (B4 is empty.)
    AB
    1WeekHours
    2Wk 18
    3Wk 26
    4Wk 3
    5Wk 410
    6Wk 50
    7Wk 66
    Visa svar

    Svar: D. 6

    AVERAGE ignores empty cells but counts zeros: 30 ÷ 5 = 6.

  7. Fråga 7 av 20

    What does =MAX(B2:B7)-MIN(B2:B7) return?
    AB
    1GuardRounds
    2Ari42
    3Bo57
    4Cy38
    5Di61
    6Ed45
    7Flo50
    Visa svar

    Svar: A. 23

    MAX finds 61 and MIN finds 38; 61 − 38 = 23.

  8. Fråga 8 av 20

    What does =COUNT(B2:B9) return?
    AB
    1ClientAvgift
    2C125
    3C2N/A
    4C3
    5C40
    6C540
    7C6
    8C715
    9C8TBD
    Visa svar

    Svar: B. 4

    COUNT counts only cells with numbers (25, 0, 40 and 15), so the result is 4. Text such as N/A and empty cells are not counted.

  9. Fråga 9 av 20

    What does =COUNTBLANK(B2:B9) return?
    AB
    1ClientAvgift
    2C125
    3C2N/A
    4C3
    5C40
    6C540
    7C6
    8C715
    9C8TBD
    Visa svar

    Svar: B. 2

    COUNTBLANK counts empty cells only. B4 and B7 are empty; the 0 in B5 is a value, so it is not counted. The result is 2.

  10. Fråga 10 av 20

    D2 contains =IF(C2>=B2,"Met","Short") and is filled down to D5. Who gets "Short"?
    ABCD
    1NameTargetActualResult
    2Ali5052
    3Bo4040
    4Cy4544
    5Di3036
    Visa svar

    Svar: A. Cy

    IF returns "Met" when Actual is greater than or equal to Target. Only Cy (44 against 45) is below target; Bo is equal, so Bo is Met.

  11. Fråga 11 av 20

    In a table, a formula reads =[@Hours]*[@Rate]. What does [@Hours] refer to?
    Visa svar

    Svar: B. The Hours cell in the same row as the formula

    The @ sign means "this row", so [@Hours] is the Hours value in the formula's own row.

  12. Fråga 12 av 20

    What does =SUM(Shifts[Hours]) add up?
    Visa svar

    Svar: D. The data cells in the Hours column of table Shifts

    Table[Column] refers to the data cells of that column; the header and total row are not included.

  13. Fråga 13 av 20

    B2 contains =$A2*B$1. You copy B2 to D4. What formula is in D4?
    Visa svar

    Svar: A. =$A4*D$1

    $A2 keeps column A but its row moves down 2 (A4). B$1 keeps row 1 but its column moves right 2 (D$1).

  14. Fråga 14 av 20

    A2 contains CAL-2041-N. What does =MID(A2,5,4) return?
    Visa svar

    Svar: C. 2041

    MID starts at character 5 and returns 4 characters. Characters 1–4 are "CAL-", so the result is 2041.

  15. Fråga 15 av 20

    A2 contains Bow River Patrol. What does =LEN(A2) return?
    Visa svar

    Svar: D. 16

    LEN counts every character, including the two spaces, so the result is 16.

  16. Fråga 16 av 20

    A2 contains Priya and B2 contains Sandhu. What does =CONCAT(LOWER(LEFT(A2,1)),".",LOWER(B2)) return?
    Visa svar

    Svar: D. p.sandhu

    LEFT(A2,1) takes "P", LOWER makes the parts lower case, and CONCAT joins them in order with the full stop between: p.sandhu.

  17. Fråga 17 av 20

    A2:A5 hold Ana, (empty), Raj and Li. What does =TEXTJOIN(", ",TRUE,A2:A5) return?
    Visa svar

    Svar: A. Ana, Raj, Li

    TEXTJOIN puts the delimiter (comma and space) between items. TRUE tells it to skip empty cells, so no extra comma appears.

  18. Fråga 18 av 20

    D2 contains =SORT(A2:B6,2,-1). Which name appears in D2?
    ABCD
    1NameScore
    2Ivy72
    3Jon88
    4Kai65
    5Lea91
    6Max80
    Visa svar

    Svar: D. Lea

    Sort index 2 sorts by the Score column, and -1 means descending, so the highest score (91, Lea) comes first.

  19. Fråga 19 av 20

    How many values does =UNIQUE(A2:A9) return?
    A
    1Site
    2North
    3South
    4North
    5East
    6West
    7South
    8North
    9East
    Visa svar

    Svar: A. 4

    UNIQUE returns each distinct value once: North, South, East, West. (Only with exactly_once set to TRUE would it return just West.)

  20. Fråga 20 av 20

    You enter =UNIQUE(A2:A40) in C2. It should return 8 names, but C5 already contains text. What does C2 show?
    Visa svar

    Svar: C. #SPILL!

    UNIQUE and SORT spill their results into the cells below. The 8 results need C2:C9, and C5 is not empty, so the formula shows #SPILL! until you clear C5.

Relaterade prov