Google Sheets Fundamentals Course：Formulas, functions and references

1. 第1题，共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 (+)
   显示答案

   答案: B. An equal sign (=)

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

2. 第2题，共17题

   Which operator multiplies two numbers in a formula?

   • A&
   • B*
   • C^
   • Dx
   显示答案

   答案: B. *

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

3. 第3题，共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
   显示答案

   答案: A. Priya Shah

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

4. 第4题，共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
   显示答案

   答案: C. 29.5

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

5. 第5题，共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
   显示答案

   答案: C. 25.5

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

6. 第6题，共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
   显示答案

   答案: 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. 第7题，共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
   显示答案

   答案: B. 4

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

8. 第8题，共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
   显示答案

   答案: 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. 第9题，共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
   显示答案

   答案: 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. 第10题，共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
    显示答案

    答案: C. 7.5

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

11. 第11题，共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
    显示答案

    答案: B. 0

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

12. 第12题，共17题

    What does =ROUND(15.567,2) return?

    • A15.56
    • B15.57
    • C15.6
    • D16
    显示答案

    答案: 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. 第13题，共17题

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

    • A1900
    • B1870
    • C1874.6
    • D1800
    显示答案

    答案: 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. 第14题，共17题

    What does =ROUND(2.5) return?

    • A#N/A
    • B2
    • C3
    • D2.5
    显示答案

    答案: 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. 第15题，共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
    显示答案

    答案: 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. 第16题，共17题

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

    • ACtrl+~
    • BF2
    • CF4
    • DCtrl+D
    显示答案

    答案: C. F4

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

17. 第17题，共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
    显示答案

    答案: 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.

键盘：按1–4作答，按 Enter 进入下一题。