Google Sheets Fundamentals Course: Entering and formatting data

1. السؤال 1 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 2 من 16

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

   • ACtrl+K
   • BCtrl+D
   • CCtrl+Shift+;
   • DCtrl+;
   أظهر الإجابة

   الإجابة: D. Ctrl+;

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

3. السؤال 3 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 4 من 16

   Which keyboard shortcut formats the selected cells as currency?

   • ACtrl+Shift+1
   • BCtrl+Shift+5
   • CCtrl+Shift+4
   • DCtrl+Shift+3
   أظهر الإجابة

   الإجابة: 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. السؤال 5 من 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%
   أظهر الإجابة

   الإجابة: 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. السؤال 6 من 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
   أظهر الإجابة

   الإجابة: 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. السؤال 7 من 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
   أظهر الإجابة

   الإجابة: A. Format, then Merge cells

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

8. السؤال 8 من 16

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

   • ACtrl+Alt+V
   • BCtrl+Shift+C
   • CCtrl+V
   • DCtrl+Shift+V
   أظهر الإجابة

   الإجابة: D. Ctrl+Shift+V

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

9. السؤال 9 من 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
   أظهر الإجابة

   الإجابة: A. Ctrl+H

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

10. السؤال 10 من 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
    أظهر الإجابة

    الإجابة: 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. السؤال 11 من 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
    أظهر الإجابة

    الإجابة: 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. السؤال 12 من 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
    أظهر الإجابة

    الإجابة: A. Day

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

13. السؤال 13 من 16

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

    • A457.0
    • B4570
    • C457
    • D0457
    أظهر الإجابة

    الإجابة: 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. السؤال 14 من 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
    أظهر الإجابة

    الإجابة: 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. السؤال 15 من 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
    أظهر الإجابة

    الإجابة: 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. السؤال 16 من 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
    أظهر الإجابة

    الإجابة: 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.

لوحة المفاتيح: 1–4 للإجابة، وEnter للسؤال التالي.