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 4

        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. A chapter must always begin on a fresh page. Which keys insert a manual page break at the cursor?

          1. Shift+Enter
          2. Ctrl+Enter
          3. Alt+Enter
          4. Ctrl+Shift+Enter
        2. With Regular expressions ticked in Writer's Find & Replace, which search term finds empty paragraphs?

          1. $^
          2. \n
          3. .*
          4. ^$
        3. To indent only the first line of every paragraph in a letter by 1.25 cm, which box do you set under Format > Paragraph > Indents & Spacing?

          1. First line
          2. Before text
          3. Above paragraph
          4. After text
        4. How do you add a header that repeats at the top of every page that uses the Default Page Style?

          1. Draw a text box at the top of page 1
          2. Insert > Header and Footer > Header > Default Page Style
          3. Type the text on the first line and press Ctrl+1
          4. Insert > Field > Page Number on the first line
        5. To give the heading row of a Writer table a light grey fill (shading), which tab of Table > Properties do you use?

          1. Borders
          2. Background
          3. Text Flow
          4. Columns
        6. You must send the same letter to 200 customers, each copy with that customer's name and address taken from a Calc sheet. Which Writer feature does this?

          1. AutoText
          2. Edit > Track Changes
          3. File > Templates > Save As Template
          4. Tools > Mail Merge Wizard
        7. You want to change part of a long formula in the selected cell without retyping all of it. Which key opens the cell for editing?

          1. F2
          2. F4
          3. F9
          4. F7
        8. A cell that holds a large number suddenly shows ### instead of the value. What does this mean?

          1. The formula divides by zero
          2. The column is too narrow for the value
          3. A function name in the formula is spelt wrongly
          4. A referenced cell was deleted
        9. How many cells are in the range B2:D5?

          1. 8
          2. 9
          3. 6
          4. 12
        10. B2 contains 40. What does the formula return?

          =IF(B2>=40;"Pass";"Fail")

          1. Fail
          2. Pass
          3. TRUE
          4. 40
        11. You type 0.25 in a cell and press Ctrl+Shift+5. What does the cell show?

          1. 0.25%
          2. 25.00%
          3. 2500.00%
          4. 250.00%
        12. You copy cells that contain formulas and want to paste only their current results somewhere else. What do you use?

          1. Ctrl+V
          2. Ctrl+Shift+V, then the Values Only preset
          3. Ctrl+Shift+V, then the Formats Only preset
          4. Ctrl+Shift+V, then the Transpose All preset
        13. C2 contains =$B$1*A2. You copy C2 and paste it into D5. Which formula is in D5?

          1. =$C$4*B5
          2. =$B$1*A5
          3. =$B$1*B5
          4. =$B$1*A2
        14. B2:D6 holds marks in three columns and row 7 is empty. You select B2:D6 and choose Sum from the Select Function icon (the AutoSum button) on the Formula Bar. Where do the results go?

          1. In E2 to E6, one total per row
          2. In B7 only, one total of all 15 cells
          3. In B7, C7 and D7, one total per column
          4. In the cell that was active before selecting
        15. Which view shows small thumbnails of all slides so you can rearrange them by dragging?

          1. Slide Sorter
          2. Outline
          3. Notes
          4. Normal
        16. You want to place a short video clip on a slide. Which menu command do you use in Impress?

          1. Insert > Image
          2. Insert > Chart
          3. Insert > Audio or Video
          4. Slide Show > Slide Show Settings
        17. Where do you change how the title and content placeholders are arranged on a slide, for example to have two content boxes side by side?

          1. View > Master Slide
          2. Format > Paragraph
          3. Slide Show > Slide Show Settings
          4. Slide > Layout
        18. A student asks a question mid-show and you want the screen to go black until you continue. Which key do you press?

          1. W
          2. P
          3. E
          4. B
        19. Which Impress feature saves a named selection of slides, in your own order, that you can run as a shorter show from the same file?

          1. Slide Sorter
          2. Rehearse Timings
          3. Custom Slide Show
          4. Master Slide
        20. You want the footer and slide number on every slide except the title slide. What do you do in Insert > Header and Footer?

          1. Hide slide 1 with Slide Show > Show/Hide Slide
          2. Select slide 1 and click Apply
          3. Delete the footer boxes from View > Master Slide
          4. Tick Do not show on first slide, then click Apply to All

        What this set covers

        • Word processing6 questions
        • Spreadsheets8 questions
        • Presentations6 questions

        Next: Word processing, spreadsheets and presentations, set 5

        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 320 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.