Scribd Logo
Upload

Welcome to Scribd!

  • 43 views

    Ict 1 Jendepart

    Uploaded by

    Gen Dee
    This document is a practice test in ICT for students of the Capiz National High School. It contains 31 multiple choice questions testing knowledge of Microsoft Office applications like Excel, Publisher, and general ICT terms. It also contains an assignment to write a formula to calculate the total and average of student grades in various subjects listed in a table.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Ict 1 Jendepart

    Uploaded by

    Gen Dee
    43 views3 pages
    This document is a practice test in ICT for students of the Capiz National High School. It contains 31 multiple choice questions testing knowledge of Microsoft Office applications like Excel, Publisher, and general ICT terms. It also contains an assignment to write a formula to calculate the total and average of student grades in various subjects listed in a table.

    Original Title

    ict1jendepart.docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document is a practice test in ICT for students of the Capiz National High School. It contains 31 multiple choice questions testing knowledge of Microsoft Office applications like Excel, Publisher, and general ICT terms. It also contains an assignment to write a formula to calculate the total and average of student grades in various subjects listed in a table.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    43 views3 pages

    Ict 1 Jendepart

    Uploaded by

    Gen Dee
    This document is a practice test in ICT for students of the Capiz National High School. It contains 31 multiple choice questions testing knowledge of Microsoft Office applications like Excel, Publisher, and general ICT terms. It also contains an assignment to write a formula to calculate the total and average of student grades in various subjects listed in a table.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Department of Education

    Region VI- Western Visayas


    CAPIZ NATIONAL HIGH SCHOOL
    Roxas City

    First Grading Departmental Test in ICT 1

    Name: ______________________________________________________________Grade & Section: ______________

    Direction: Encircle the letter of the correct answer.

    1. Microsoft Publisher is a
    A. Web Browser C. Operating System
    B. Desktop Publisihing Program D. Word Processor
    2. Which of the following should Publisher NOT be used for?
    A. Designing a flyer C. Creating a Holiday Card
    B. Designing a newsletter D. Calculating money
    3. To change page size and orientation, you'll need to go to the __________ Menu Item
    A. Page Tools B. Page Design C. Page Layout D. Page Format
    4. This is one thing you can't create with MS Publisher
    A. brochure B. greeting cards C. spreadsheet D. flyer
    5. Which file extension is correct for MS Publisher?
    A. .pub B. doc. C. ppt. D. xls.
    6. MS Publisher has many pre-created documents that you can edit. These are called....
    A. Edits B. templates C. slides D. images
    7. Statistical calculations and preparation of tables and graphs can be done using
    A. Adobe Photoshop B. Excel C. Notepad D. Power Point
    8. In Excel, Columns are labelled as ___
    A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc.
    9. The process of arranging the items of a column in some sequence or order is known as :
    A. Arranging B. Autofill C. Sorting D. Filtering
    10. In Excel, Rows are labelled as ______
    A. A, B, C, etc B. 1,2,3 etc C. A1, A2, etc. D. $A$1, $A$2, etc.
    11. The basic unit of a worksheet into which you enter data in Excel is called a
    A. cell B. table C. box D. column
    12. How many sheets are there, by default, when we create a new Excel file ?
    A. 1 B. 3 C. 5 D. 10
    13. An Excel file is generally called a / an :
    A. E-Spreadsheet B. Worksheet C. Workbook D. Sheet
    14. What is the most appropriate formula you can put in the C2 cell to calculate a 7% tax?

    A =A2*0.07 B. =A2*7% C. =A2*1.07 D. =A2+(A2*0.07)


    15. Which area in an Excel window allows entering values and formulas?
    A. Title Bar B. Menu Bar C. Formula Bar D. Standard Tool
    16. An Excel Workbook is a collection of …….
    A. Workbooks B. Worksheets C. Charts D. Worksheets and Charts
    17. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
    A. AutoFill B. Auto correct C. Auto sum D. Auto format
    18. Which Chart can be created in Excel?
    A. Area B. Line C. Pie D. All of the above
    19. Which of the following is not a term of MS-Excel?
    A. Cells B. Rows C. Columns D. Document
    20. We can save and protect the workbook by
    A. Write Reservation Password C. Read-only Recommended
    B. Protection Password D. Any of the above
    21. The first cell in EXCEL worksheet is labelled as
    A. AA B. A1 C. Aa D. A0
    22. What is represented by the small, black square in the lower-right corner of an active cell or range?
    A. Copy handle B. Fill handle C. Insert handle D. Border
    23. A __________ is a grid with labelled columns and rows.
    A. Dialog box B. Worksheet C. Clipboard D. Toolbar
    24. The active cell:
    A. is defined by a bold border around the cell. C. Receives the data the user enters
    B. It is the formula bar. D. Only A and B.
    25. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing
    the original one, which command should you use?
    A. New B. Save As C. Edit D. Save
    26. In order to arrange the countries from those with the highest population to those with the lowest, you need to
    sort on the population field in ……………
    A. ascending order B. descending order C. alphabetical order D. random order
    27. In order to perform a calculation in a spreadsheet, you need to use a:
    A. table B. formula C. field D. variable
    28. Which is an example of a formula?
    A. =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)
    29. What is the symbol for multiplying?
    A. > B. / C. ! D. *
    30. What is the symbol for dividing?
    A ./ B. % C. & D. #
    31. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ........... menu
    A. Edit B. Format C. Tools D. All of the above
    Test II. Write the formula and solve the total and average of the following data. (20 pts)

    Example: =D2+E2+F2+G2
    A B C D E F G H I
    FILIPIN SCIENC
      Name of the students ENGLISH MATH TOTAL
    1 O E AVERAGE
    2 1 Almero, Renz William Borres 75 80 80 75    
    3 2 Atordido, Jaymark Arroyo 87 87 81 79    
    4 3 Benitez, Kris Tomme 90 86 81 80    
    5 4 Berry, Jairo Limjoco 87 90 81 86    
    6 5 Biaco, Eric Earl Lawrence B. 96 96 81 70    
    7 6 Boñales, Jay Pee Martinez 88 88 86 80    
    8 7 Clavaton, Junel Bibal 91 78 96 90    
    9 8 Degracia, Mark Yuri Arlante 85 87 87 89    
    10 9 Encina, John Henry Anating 86 82 92 87    
    11 10 Estanislao, Rodjen Villasurca 86 92 82 86    
    =(D2+E2+F2+G2)/4

    Prepared by:

    JENNIFER B. DEQUINA
    Teacher
    Checked by:
    JUDY B. DUNTON
    SSHT V, Science/STE Coordinator

    You might also like