Google Sheets Fundamentals Course: Formulas, functions and references

1. Pergunta 1 de 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 (+)
   Mostrar resposta

   Resposta: B. An equal sign (=)

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

2. Pergunta 2 de 17

   Which operator multiplies two numbers in a formula?

   • A&
   • B*
   • C^
   • Dx
   Mostrar resposta

   Resposta: B. *

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

3. Pergunta 3 de 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
   Mostrar resposta

   Resposta: A. Priya Shah

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

4. Pergunta 4 de 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
   Mostrar resposta

   Resposta: C. 29.5

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

5. Pergunta 5 de 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
   Mostrar resposta

   Resposta: C. 25.5

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

6. Pergunta 6 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 7 de 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
   Mostrar resposta

   Resposta: B. 4

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

8. Pergunta 8 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 9 de 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
   Mostrar resposta

   Resposta: 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. Pergunta 10 de 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
    Mostrar resposta

    Resposta: C. 7.5

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

11. Pergunta 11 de 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
    Mostrar resposta

    Resposta: B. 0

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

12. Pergunta 12 de 17

    What does =ROUND(15.567,2) return?

    • A15.56
    • B15.57
    • C15.6
    • D16
    Mostrar resposta

    Resposta: 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. Pergunta 13 de 17

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

    • A1900
    • B1870
    • C1874.6
    • D1800
    Mostrar resposta

    Resposta: 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. Pergunta 14 de 17

    What does =ROUND(2.5) return?

    • A#N/A
    • B2
    • C3
    • D2.5
    Mostrar resposta

    Resposta: 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. Pergunta 15 de 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
    Mostrar resposta

    Resposta: 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. Pergunta 16 de 17

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

    • ACtrl+~
    • BF2
    • CF4
    • DCtrl+D
    Mostrar resposta

    Resposta: C. F4

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

17. Pergunta 17 de 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
    Mostrar resposta

    Resposta: 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.

Teclado: 1–4 para responder, Enter para a pergunta seguinte.