Google Sheets Fundamentals Course: Formulas, functions and references

1. Question 1 sur 17

   What must you type first to start a formula in a cell?

   • AA dollar sign ($)
   • BAn equal sign (=)
   • CAn at sign (@)
   • DA plus sign (+)
   Voir la réponse

   Réponse: B. An equal sign (=)

   To start a formula, type an equal sign (=) in a cell and then the function or calculation you want.

2. Question 2 sur 17

   Which operator multiplies two numbers in a formula?

   • A&
   • B*
   • C^
   • Dx
   Voir la réponse

   Réponse: B. *

   The asterisk (*) is the multiplication operator. Google's MULTIPLY function is described as equivalent to the * operator.

3. Question 3 sur 17

   In the sheet below, what does =A2&" "&B2 return?

   	A	B
   1	First	Last
   2	Priya	Shah
   3	Marco	Rossi

   • APriya Shah
   • BPriya&Shah
   • C#VALUE!
   • DPriyaShah
   Voir la réponse

   Réponse: A. Priya Shah

   The & operator joins (concatenates) values. Joining Priya, a space and Shah gives "Priya Shah".

4. Question 4 sur 17

   In the schedule below, what does =SUM(B2:F2) return?

   	A	B	C	D	E	F
   1	Staff	Mon	Tue	Wed	Thu	Fri
   2	Priya	8	8	6	0	7.5
   3	Marco	7		7.5	8	8
   4	Lena	6.5	7	7	7	6
   5	Tom	4	5		8	8

   • A37.5
   • B5.9
   • C29.5
   • D28
   Voir la réponse

   Réponse: C. 29.5

   SUM adds Priya's hours: 8 + 8 + 6 + 0 + 7.5 = 29.5.

5. Question 5 sur 17

   In the schedule below, what does =SUM(B2:B5) return?

   	A	B	C	D	E	F
   1	Staff	Mon	Tue	Wed	Thu	Fri
   2	Priya	8	8	6	0	7.5
   3	Marco	7		7.5	8	8
   4	Lena	6.5	7	7	7	6
   5	Tom	4	5		8	8

   • A6.375
   • B29.5
   • C25.5
   • D21.5
   Voir la réponse

   Réponse: C. 25.5

   B2:B5 is the Monday column: 8 + 7 + 6.5 + 4 = 25.5.

6. Question 6 sur 17

   In the schedule below, Priya worked 0 hours on Thursday. What does =AVERAGE(B2:F2) return?

   	A	B	C	D	E	F
   1	Staff	Mon	Tue	Wed	Thu	Fri
   2	Priya	8	8	6	0	7.5
   3	Marco	7		7.5	8	8
   4	Lena	6.5	7	7	7	6
   5	Tom	4	5		8	8

   • A7.5
   • B29.5
   • C5.9
   • D7.375
   Voir la réponse

   Réponse: C. 5.9

   AVERAGE divides the sum by the number of values. The 0 is a number, so it counts: 29.5 ÷ 5 = 5.9.

7. Question 7 sur 17

   In the schedule below, cell C3 is empty. What does =COUNT(B3:F3) return?

   	A	B	C	D	E	F
   1	Staff	Mon	Tue	Wed	Thu	Fri
   2	Priya	8	8	6	0	7.5
   3	Marco	7		7.5	8	8
   4	Lena	6.5	7	7	7	6
   5	Tom	4	5		8	8

   • A30.5
   • B4
   • C5
   • D6
   Voir la réponse

   Réponse: B. 4

   COUNT returns the number of numeric values. Marco's row has four numbers; the empty cell C3 is not counted.

8. Question 8 sur 17

   In the schedule below, cell C3 is empty. What does =AVERAGE(B3:F3) return?

   	A	B	C	D	E	F
   1	Staff	Mon	Tue	Wed	Thu	Fri
   2	Priya	8	8	6	0	7.5
   3	Marco	7		7.5	8	8
   4	Lena	6.5	7	7	7	6
   5	Tom	4	5		8	8

   • A6.1
   • B7.5
   • C7.625
   • D30.5
   Voir la réponse

   Réponse: C. 7.625

   AVERAGE uses only the values in the range. Marco's four numbers add to 30.5, and 30.5 ÷ 4 = 7.625.

9. Question 9 sur 17

   In the schedule below, cell D5 is empty. What does =COUNTA(A5:F5) return?

   	A	B	C	D	E	F
   1	Staff	Mon	Tue	Wed	Thu	Fri
   2	Priya	8	8	6	0	7.5
   3	Marco	7		7.5	8	8
   4	Lena	6.5	7	7	7	6
   5	Tom	4	5		8	8

   • A4
   • B6
   • C5
   • D25
   Voir la réponse

   Réponse: C. 5

   COUNTA counts all values, including text. Row 5 has the name Tom and four numbers, so it returns 5. The empty cell D5 is not counted.

10. Question 10 sur 17

    In the schedule below, what does =MAX(D2:D5) return?

    	A	B	C	D	E	F
    1	Staff	Mon	Tue	Wed	Thu	Fri
    2	Priya	8	8	6	0	7.5
    3	Marco	7		7.5	8	8
    4	Lena	6.5	7	7	7	6
    5	Tom	4	5		8	8

    • A8
    • B6
    • C7.5
    • D20.5
    Voir la réponse

    Réponse: C. 7.5

    D2:D5 is the Wednesday column: 6, 7.5, 7 and an empty cell. The largest number is 7.5.

11. Question 11 sur 17

    In the schedule below, what does =MIN(B2:F2) return?

    	A	B	C	D	E	F
    1	Staff	Mon	Tue	Wed	Thu	Fri
    2	Priya	8	8	6	0	7.5
    3	Marco	7		7.5	8	8
    4	Lena	6.5	7	7	7	6
    5	Tom	4	5		8	8

    • A6
    • B0
    • C7.5
    • D8
    Voir la réponse

    Réponse: B. 0

    MIN returns the smallest number in the range. Priya's Thursday value is 0, which is smaller than 6.

12. Question 12 sur 17

    What does =ROUND(15.567,2) return?

    • A15.56
    • B15.57
    • C15.6
    • D16
    Voir la réponse

    Réponse: B. 15.57

    ROUND to 2 places looks at the third decimal digit. It is 7, which is 5 or more, so 15.567 rounds up to 15.57.

13. Question 13 sur 17

    What does =ROUND(1874.6,-2) return?

    • A1900
    • B1870
    • C1874.6
    • D1800
    Voir la réponse

    Réponse: A. 1900

    A negative places value rounds to the left of the decimal point. -2 rounds to the nearest hundred, and 1874.6 is closer to 1900.

14. Question 14 sur 17

    What does =ROUND(2.5) return?

    • A#N/A
    • B2
    • C3
    • D2.5
    Voir la réponse

    Réponse: C. 3

    When places is left out it is 0, so ROUND rounds to a whole number. The next digit is 5, which rounds up, giving 3.

15. Question 15 sur 17

    Cell H2 contains =G2*$J$1. You copy H2 down to H4. What formula is in H4?

    • A=G4*J3
    • B=G4*$J$3
    • C=G4*$J$1
    • D=G2*$J$1
    Voir la réponse

    Réponse: C. =G4*$J$1

    G2 is a relative reference, so it moves down 2 rows to G4. $J$1 is absolute because of the dollar signs, so it stays the same.

16. Question 16 sur 17

    While you type a formula, which key switches the selected reference between absolute and relative?

    • ACtrl+~
    • BF2
    • CF4
    • DCtrl+D
    Voir la réponse

    Réponse: C. F4

    F4 switches a reference between absolute and relative while you enter a formula. F2 turns range selection on or off.

17. Question 17 sur 17

    In =ABS(SUM(A1:A7)), which part does Sheets work out first?

    • AWhichever function has fewer letters
    • BABS, the function on the outside
    • CSUM(A1:A7), the inner function
    • DBoth at the same time
    Voir la réponse

    Réponse: C. SUM(A1:A7), the inner function

    In a nested function, Sheets calculates the innermost function first. The result of SUM is then used by ABS.

Clavier : 1–4 pour répondre, Entrée pour la question suivante.