PassEveryTest
Français

Excel for Beginners Course: Formulas and basic functions

Quiz thématique sans limite de temps : 18 questions sur Formulas and basic functions, avec une explication après chaque réponse. Les questions et les réponses sont mélangées à chaque fois.

  • Formation
  • Canada
  • 100 questions
  • Vérifié le 13 octobre 2026
  • Vérifié (faits) le 13 octobre 2026
Commencez par les leçonsExcel for Beginners Course: Lessons : environ 120 minutes de lecture. Chaque question du test est traitée dans les leçons.

Quiz thématique 3 : Formulas and basic functions

  1. Question 1 sur 18

    What character must every Excel formula start with?
    Voir la réponse

    Réponse: B. =

    Excel formulas always begin with the equal sign (=).

  2. Question 2 sur 18

    Which operator multiplies two numbers in a formula?
    Voir la réponse

    Réponse: B. *

    Excel uses the asterisk (*) to multiply. The ^ sign raises a number to a power and & joins text.

  3. Question 3 sur 18

    What does the formula =4+6*2 return?
    Voir la réponse

    Réponse: B. 16

    Excel multiplies before it adds: 6*2 = 12, then 4 + 12 = 16.

  4. Question 4 sur 18

    In the timesheet below, what does =SUM(B2:B5) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: A. 29

    SUM adds every number in B2:B5: 8 + 6 + 7 + 8 = 29 hours worked on Monday.

  5. Question 5 sur 18

    In the timesheet below, what does =SUM(B2:F2) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: A. 29.5

    B2:F2 is Ana's row: 8 + 7.5 + 8 + 0 + 6 = 29.5 hours.

  6. Question 6 sur 18

    You select the empty cell under a column of numbers. Which keyboard shortcut inserts a SUM formula with AutoSum?
    Voir la réponse

    Réponse: D. Alt+=

    Alt+= is the AutoSum shortcut. You can also select AutoSum on the Home tab or the Formulas tab and press Enter.

  7. Question 7 sur 18

    In the timesheet below, what does =MAX(C2:C5) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: C. 8

    MAX returns the largest number in the range. The Tuesday hours are 7.5, 8, 7 and 8, so the largest is 8.

  8. Question 8 sur 18

    In the timesheet below, what does =MIN(F2:F5) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: B. 4

    MIN returns the smallest number in the range. Friday's hours are 6, 4, 8 and 8, so the smallest is 4.

  9. Question 9 sur 18

    In the timesheet below, cell D4 is empty. What does =COUNT(B4:F4) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: B. 4

    COUNT counts only cells that contain numbers. Empty cells are not counted, so the answer is 4.

  10. Question 10 sur 18

    In the timesheet below, cell D4 is empty. What does =AVERAGE(B4:F4) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: A. 7.375

    AVERAGE ignores empty cells. It adds 7 + 7 + 7.5 + 8 = 29.5 and divides by 4 numbers, giving 7.375.

  11. Question 11 sur 18

    In the timesheet below, Ana has 0 hours on Thursday. What does =AVERAGE(B2:F2) return?
    ABCDEF
    1EmployeeMonTueWedThuFri
    2Ana87.5806
    3Ben68884
    4Chen777.58
    5Dana88888
    Voir la réponse

    Réponse: D. 5.9

    AVERAGE includes cells that contain zero. It divides 29.5 by 5 numbers, giving 5.9.

  12. Question 12 sur 18

    In the attendance sheet below, P means present and A means absent. What does =COUNTIF(B2:F6,"A") return?
    ABCDEF
    1NameMonTueWedThuFri
    2AmritPPAPP
    3BellaPAAPP
    4CarlosPPPPP
    5DivyaAPPP
    6ErinPPPAP
    Voir la réponse

    Réponse: A. 5

    COUNTIF counts the cells in the range that match the criteria. There are 5 cells that contain A.

  13. Question 13 sur 18

    In the attendance sheet below, Divya's Thursday cell (E5) is empty. What does =COUNTA(B5:F5) return?
    ABCDEF
    1NameMonTueWedThuFri
    2AmritPPAPP
    3BellaPAAPP
    4CarlosPPPPP
    5DivyaAPPP
    6ErinPPPAP
    Voir la réponse

    Réponse: D. 4

    COUNTA counts cells that are not empty, whether they hold text or numbers. E5 is empty, so the answer is 4.

  14. Question 14 sur 18

    In the sheet below, what does =SUM(A2:C2) return?
    ABC
    1MonTueWed
    28N/A7
    Voir la réponse

    Réponse: D. 15

    SUM ignores text in the cells it refers to, so it adds only 8 and 7 and returns 15.

  15. Question 15 sur 18

    In the sheet below, what does =A2+B2+C2 return?
    ABC
    1MonTueWed
    28N/A7
    Voir la réponse

    Réponse: D. #VALUE!

    When you add cells with + and one of them holds text, Excel returns the #VALUE! error. SUM would ignore the text instead.

  16. Question 16 sur 18

    In the sheet below, C2 contains =IF(B2>=32,"Full","Part") and is copied down to C5. How many cells in C2:C5 show "Full"?
    ABC
    1EmployeeHoursStatus
    2Ana29.5
    3Ben34
    4Chen31.5
    5Dana40
    Voir la réponse

    Réponse: A. 2

    IF shows "Full" only when the hours are 32 or more. Ben (34) and Dana (40) meet the test, so 2 cells show "Full".

  17. Question 17 sur 18

    What does =ROUND(1234.567,-2) return?
    Voir la réponse

    Réponse: B. 1200

    A negative num_digits rounds to the left of the decimal point. -2 rounds to the nearest hundred, so the result is 1200.

  18. Question 18 sur 18

    In the sheet below, C2 is empty. What does =B2/C2 return?
    ABC
    1ÉlémentCostUnits
    2Gloves84
    Voir la réponse

    Réponse: A. #DIV/0!

    Excel shows #DIV/0! when a number is divided by zero or by an empty cell. A formula like =IF(C2,B2/C2,0) avoids the error.

Tests associés