Google Sheets Fundamentals Course: Entering and formatting data

1. Pytanie 1 z 16

   Cell B3 already holds a value. How do you start changing what is in it?

   • ADouble-click the cell
   • BPress Ctrl+Home
   • CRight-click the column letter
   • DDrag the small blue box in its corner
   Pokaż odpowiedź

   Odpowiedź: A. Double-click the cell

   Click an empty cell to type in it, or double-click a cell that already has content to edit it.

2. Pytanie 2 z 16

   Which keyboard shortcut enters today's date in the selected cell?

   • ACtrl+K
   • BCtrl+D
   • CCtrl+Shift+;
   • DCtrl+;
   Pokaż odpowiedź

   Odpowiedź: D. Ctrl+;

   Ctrl+; inserts the date. Ctrl+Shift+; inserts the time, and Ctrl+D fills down.

3. Pytanie 3 z 16

   Where do you find the number formats, such as currency, percent and date?

   • AView, then Freeze
   • BData, then Data validation
   • CFormat, then Number
   • DInsert, then Function
   Pokaż odpowiedź

   Odpowiedź: C. Format, then Number

   Select the cells, then select Format, then Number, and choose a format. The toolbar also has buttons for currency, percent and decimal places.

4. Pytanie 4 z 16

   Which keyboard shortcut formats the selected cells as currency?

   • ACtrl+Shift+1
   • BCtrl+Shift+5
   • CCtrl+Shift+4
   • DCtrl+Shift+3
   Pokaż odpowiedź

   Odpowiedź: C. Ctrl+Shift+4

   Ctrl+Shift+4 formats as currency (4 is the $ key). Ctrl+Shift+5 is percent, Ctrl+Shift+3 is date and Ctrl+Shift+1 is decimal.

5. Pytanie 5 z 16

   Cell C2 holds 0.25. You format it as a percent with no decimal places. What does C2 show?

   • A250%
   • B2.5%
   • C0.25%
   • D25%
   Pokaż odpowiedź

   Odpowiedź: D. 25%

   A percent format shows the value times 100 with a % sign, so 0.25 shows as 25%. The value stored in the cell is still 0.25.

6. Pytanie 6 z 16

   You want long notes in column E to show on several lines inside each cell. Which toolbar option helps?

   • AAdd or edit cell borders
   • BCopy formatting (the paint format button)
   • CMerge cells
   • DThe text wrapping option
   Pokaż odpowiedź

   Odpowiedź: D. The text wrapping option

   The toolbar has an option to change how text wraps or to rotate text. Wrapping keeps long text inside the cell on several lines.

7. Pytanie 7 z 16

   You want one title cell to stretch across A1:F1. Which menu do you use?

   • AFormat, then Merge cells
   • BView, then Freeze
   • CInsert, then Checkbox
   • DData, then Sort range
   Pokaż odpowiedź

   Odpowiedź: A. Format, then Merge cells

   Select the cells, then select Format, then Merge cells, and pick how you want them merged.

8. Pytanie 8 z 16

   Which keyboard shortcut pastes only the values, without the formatting or formulas?

   • ACtrl+Alt+V
   • BCtrl+Shift+C
   • CCtrl+V
   • DCtrl+Shift+V
   Pokaż odpowiedź

   Odpowiedź: D. Ctrl+Shift+V

   Ctrl+Shift+V is Paste values only. Ctrl+V pastes everything, including formatting.

9. Pytanie 9 z 16

   A customer changed their company name. Which shortcut opens Find and replace so you can fix it everywhere at once?

   • ACtrl+H
   • BCtrl+R
   • CCtrl+E
   • DCtrl+F
   Pokaż odpowiedź

   Odpowiedź: A. Ctrl+H

   Ctrl+H opens Find and replace. Ctrl+F only finds text, and Ctrl+R fills right.

10. Pytanie 10 z 16

    A column is too narrow for its contents. What is a quick way to make it fit the data?

    • ASelect View, then Freeze, then 1 column
    • BSelect the cells, then Format, then Merge cells
    • CSelect the column and press Ctrl+\ to clear it
    • DDouble-click the right edge of the column letter
    Pokaż odpowiedź

    Odpowiedź: D. Double-click the right edge of the column letter

    Double-click the edge of a row or column to fit it to the data. You can also right-click the column letter, choose Resize column, and pick Fit to data.

11. Pytanie 11 z 16

    In the sheet below, you select A2:A3 and drag the small blue box in the corner down to A6. What appears in A6?

    	A
    1	Step
    2	5
    3	10
    4
    5
    6

    • A25
    • B6
    • C15
    • D10
    Pokaż odpowiedź

    Odpowiedź: A. 25

    5 and 10 form a series that goes up by 5, so the series continues 15, 20, 25. A6 is the fourth cell after A2, so it shows 25.

12. Pytanie 12 z 16

    In the sheet below, A2 says Day and A3 says Night. You select A2:A3 and drag the fill box down to A6. What appears in A6?

    	A
    1	Shift
    2	Day
    3	Night
    4
    5
    6

    • ADay
    • BNight 2
    • CNothing; the cell stays empty
    • DNight
    Pokaż odpowiedź

    Odpowiedź: A. Day

    When the starting cells do not form a series, the values repeat: Day, Night, Day, Night, Day. So A6 shows Day.

13. Pytanie 13 z 16

    You type 457 into a cell with the custom number format 0000. What does the cell show?

    • A457.0
    • B4570
    • C457
    • D0457
    Pokaż odpowiedź

    Odpowiedź: D. 0457

    In a custom number format, 0 is a digit placeholder that shows insignificant zeros. 0000 always shows four digits, so 457 shows as 0457.

14. Pytanie 14 z 16

    A cell holds 1234.5 and uses the custom number format #,##0.00. What does it show?

    • A1,234.50
    • B1,235
    • C1234.5
    • D1,234.5
    Pokaż odpowiedź

    Odpowiedź: A. 1,234.50

    The comma adds a thousands separator and 0.00 always shows two decimal places, so 1234.5 shows as 1,234.50.

15. Pytanie 15 z 16

    A custom number format has four parts separated by semicolons. Which part controls how negative numbers look?

    • AThe second part
    • BThe third part
    • CThe fourth part
    • DThe first part
    Pokaż odpowiedź

    Odpowiedź: A. The second part

    The four parts are in this order: positive; negative; zero; non-numeric (text). The second part is for negative numbers.

16. Pytanie 16 z 16

    A cell uses the custom number format 0.00;[Red]-0.00. How does the value -12 look?

    • A12.00 in red
    • B-12.00 in red
    • C(12) in black
    • D-12.00 in black
    Pokaż odpowiedź

    Odpowiedź: B. -12.00 in red

    The second part of the format is for negative numbers, and [Red] colours that part. So -12 shows as -12.00 in red.

Klawiatura: 1–4, aby odpowiedzieć, Enter – następne pytanie.