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 5

        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. In Writer, what is the difference between File > Export As > Export as PDF and Export Directly as PDF?

          1. The first opens PDF Options; the second uses default PDF settings
          2. The first keeps the document open; the second closes it after export
          3. Only the second can export a page range; the first always exports all
          4. The first sends the file to a printer; the second saves it to disk
        2. You typed a heading in small letters and want the characters themselves changed to capitals, not just displayed as capitals. Which command does this?

          1. Format > Text > UPPERCASE
          2. Format > Character > Font Effects > Capitals
          3. Tools > AutoCorrect > While Typing
          4. Format > Paragraph > Alignment
        3. Which shortcut applies the Heading 1 paragraph style to the paragraph containing the cursor?

          1. F1
          2. Ctrl+0
          3. F11
          4. Ctrl+1
        4. What does Insert > Field > Page Number put into a Writer document?

          1. A field showing the number of its page, updating by itself
          2. Plain text "1" that you must retype on each page
          3. A numbered footer on every page of the document
          4. The total number of pages in the document
        5. Inside a Writer table, Tab moves the cursor to the next cell. Which keys insert a tab stop inside the cell instead?

          1. Shift+Tab
          2. Ctrl+Tab
          3. Alt+Enter
          4. Ctrl+Shift+T
        6. While building a form letter you want to drag the "City" column of your address list into the letter. Which shortcut opens the Data Source View in Writer?

          1. Ctrl+Shift+F4
          2. Shift+F4
          3. F5
          4. Ctrl+F2
        7. In the Pages box of the Print dialog, which entry prints pages 3 to 6 plus pages 8 and 10, in the format LibreOffice Help gives?

          1. 3:6;8;10
          2. 3..6+8+10
          3. 3to6;8;10
          4. 3-6;8;10
        8. In Calc, what does the cell address D12 identify?

          1. The cell where row D meets column 12
          2. The cell where column D meets row 12
          3. Cell number 12 on a sheet named D
          4. The range from column D to column L
        9. What does Data > AutoFilter add to a list with a heading row?

          1. A new sheet holding a sorted copy of the list
          2. A command that deletes the rows that do not match
          3. Drop-down arrows to show only matching rows
          4. A total row that adds up each column
        10. With default settings, how many sheets does a brand-new Calc spreadsheet contain?

          1. Three, named Sheet1 to Sheet3
          2. Two, named Sheet1 and Sheet2
          3. One, named Sheet1
          4. None until you add one
        11. D2:D6 contains 45, 72, 38, 90 and 61. What does the formula return?

          =MAX(D2:D6)-MIN(D2:D6)

          1. 45
          2. 34
          3. 128
          4. 52
        12. A staff list has City and Name columns. You want it ordered by City, and by Name within each city. What do you set in Data > Sort?

          1. Sort Key 1 = Name, Sort Key 2 = City
          2. Sort Key 1 = City, Left to Right (Sort Columns)
          3. Data > AutoFilter on City
          4. Sort Key 1 = City, Sort Key 2 = Name
        13. A1 contains 5 and A2 contains 10. You select A1:A2 and drag the fill handle down to A6. What is in A6?

          1. 25
          2. 15
          3. 10
          4. 30
        14. A1 contains the number 7. You drag only A1's fill handle down to A4 without holding any key. What is in A4?

          1. 7
          2. 11
          3. 10
          4. 28
        15. Where do you type speaker notes for a slide that the audience will not see during the show?

          1. In a text box on the slide
          2. In View > Notes
          3. In View > Master Slide
          4. In View > Outline
        16. Which command adds a table with rows and columns to the current slide?

          1. Insert > Chart
          2. Insert > Table
          3. Insert > Image
          4. Insert > Audio or Video
        17. Which view lets you see and edit the titles and bullet text of all slides as one list?

          1. Slide Sorter
          2. Notes
          3. Master Slide
          4. Outline
        18. You want to record how long you speak on each slide while you practise, so the show can later advance with those times. Which command helps?

          1. Slide Show > Custom Slide Show
          2. Slide Show Settings > In a window
          3. Slide Show > Rehearse Timings
          4. The Duration box in the Animation deck
        19. You need printouts for the audience with six slides on each page. What do you choose in File > Print?

          1. Document: Notes, Slides per page: 6
          2. Document: Handouts, Slides per page: 6
          3. Document: Outline
          4. Document: Slides, Original size
        20. While resizing a rectangle by dragging a handle, which key do you hold to keep its proportions?

          1. Shift
          2. Alt
          3. Ctrl
          4. Tab

        What this set covers

        • Word processing7 questions
        • Spreadsheets7 questions
        • Presentations6 questions

        Next: E-mail, e-governance, digital payments and cyber security, set 1

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