Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        CCC online test: Word processing, spreadsheets and presentations, set 3

        20 questions on word processing, spreadsheets and presentations at the real exam's pace: 18 min on the clock, or none if you want to study. Pass at 10 correct.

        A desktop computer with a spreadsheet, a keyboard and a notebook for CCC practice.
        Questions
        20
        Time
        18 min
        To pass
        10 (50%)
        Part
        Word processing, spreadsheets and presentations
        Mode
        Timed or untimed
        Access
        Exam pass

        The practice test needs JavaScript. These are its questions:

        1. You are typing an address and want the next line to start directly below without starting a new paragraph. Which keys do this?

          1. Ctrl+Enter
          2. Enter
          3. Ctrl+Shift+Enter
          4. Shift+Enter
        2. Which key opens the Spelling dialog in Writer, starting at the cursor position?

          1. F5
          2. F11
          3. F7
          4. Ctrl+F7
        3. A report uses the Heading 1 paragraph style for 15 chapter titles. You want all of them in dark blue. What is the most efficient way?

          1. Select each title in turn and change its font colour
          2. Change the font colour in the Heading 1 style itself
          3. Use Replace All to replace each title with itself
          4. Click in each title and press Ctrl+M
        4. Your document must start at page number 12. Following LibreOffice Help, you click in the first paragraph and then use which setting?

          1. Insert > Field > Page Number, then type 12 over the field
          2. Format > Paragraph > Text Flow: Insert, With Page Style, Page number
          3. Format > Page Style > Page tab, then choose 12 in the page number format list
          4. Tools > Options > LibreOffice Writer > General, then set the first page to 12
        5. You select three adjacent cells in the top row of a Writer table and want them to become one wide title cell. Which command?

          1. Table > Split Cells
          2. Table > Merge Table
          3. Table > Size > Optimal Column Width
          4. Table > Merge Cells
        6. With Tools > Automatic Spell Checking turned on, what does a red wavy underline under a word mean?

          1. The word is a hyperlink
          2. The word will print in red
          3. The word may be misspelt
          4. The word was typed in Overwrite mode
        7. A paragraph has bold, a colour and a bigger size applied by hand. Which shortcut removes this direct formatting so the text follows its paragraph style again?

          1. Ctrl+Z
          2. Ctrl+0
          3. Ctrl+M
          4. Ctrl+Alt+Shift+V
        8. Cells A1 to A5 contain 12, 8, 15, 5 and 10. What does the formula return?

          =SUM(A1:A5)

          1. 40
          2. 45
          3. 38
          4. 50
        9. You have selected a table of sales figures in Calc. Which menu command starts the Chart Wizard?

          1. Data > Pivot Table
          2. Sheet > Insert Sheet
          3. Insert > Chart
          4. Format > Cells
        10. C1:C8 holds 5, "Ravi", 12, an empty cell, 7.5, "absent", 0 and an empty cell. What does the formula return?

          =COUNT(C1:C8)

          1. 6
          2. 4
          3. 8
          4. 3
        11. You want rows 1 and 2 and column A to stay visible while you scroll. Which cell do you select before choosing View > Freeze Rows and Columns?

          1. B3
          2. A3
          3. B2
          4. C3
        12. You are typing an address in one Calc cell and want "Pune" on a new line inside the same cell. Which keys insert the line break?

          1. Ctrl+Enter
          2. Alt+Enter
          3. Shift+Enter
          4. Enter
        13. A2 contains 74.5. What does the formula return?

          =IF(A2>=75;"A";IF(A2>=50;"B";"C"))

          1. B
          2. A
          3. C
          4. FALSE
        14. In Calc's default formula syntax (Calc A1), how do you refer to cell C4 on a sheet named Sales?

          1. =Sales!C4
          2. =Sales.C4
          3. =Sales:C4
          4. =C4@Sales
        15. Which key starts the slide show from the first slide?

          1. Shift+F5
          2. F7
          3. Ctrl+Shift+F5
          4. F5
        16. Which key ends a running slide show straight away?

          1. B
          2. Home
          3. Esc
          4. End
        17. You want the company logo to appear on every slide, in the same place, in one step. What do you do?

          1. Place the logo once in View > Master Slide
          2. Copy the logo and paste it onto each slide
          3. Choose a different layout in Slide > Layout
          4. Type the company name in Insert > Header and Footer
        18. Which Start option runs an animation effect as soon as the previous effect has finished, without a click?

          1. After previous
          2. With previous
          3. On click
          4. Automatic preview
        19. You want to keep a backup slide in the file but skip it during the show. What do you do?

          1. Slide Show > Show/Hide Slide
          2. Choose Slide > Delete Slide
          3. Drag it to the end in Slide Sorter
          4. Set its transition to No Transition
        20. For a kiosk, each slide must stay up for 10 seconds and the show must start again after the last slide. Which combination does this?

          1. Advance automatically after 10 s for all slides, plus Loop and repeat after
          2. Loop and repeat after in Slide Show Settings, nothing else
          3. Rehearse Timings, nothing else
          4. Disable automatic change of slide in Slide Show Settings

        What this set covers

        • Word processing7 questions
        • Spreadsheets7 questions
        • Presentations6 questions

        Next: Word processing, spreadsheets and presentations, set 4

        More practice for this exam

        1. Word processing, spreadsheets and presentations, set 120 questions · 18 min
        2. Word processing, spreadsheets and presentations, set 220 questions · 18 min
        3. Word processing, spreadsheets and presentations, set 420 questions · 18 min
        4. Word processing, spreadsheets and presentations, set 520 questions · 18 min
        5. Mock test 1100 questions · 1 h 30 min
        6. Mock test 2100 questions · 1 h 30 min
        7. Mock test 3100 questions · 1 h 30 min
        8. 50-question test50 questions · 45 min
        9. 30-question test30 questions · 27 min
        10. 20-question test20 questions · 18 min
        11. 10-question test10 questions · 9 min

        All practice for the CCC

        Independent practice. The Work Gym isn't affiliated with NIELIT, and these aren't official exam questions.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Change your plan

        Checking the price

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.