Scribd Logo
Upload

Welcome to Scribd!

  • 290 views

    Computer Applications, Business Accounting and Multilingual DTP (Caba-Mdtp)

    Uploaded by

    parveez
    National Council for Promotion of Urdu Language document contains questions related to computer applications, business accounting, and multilingual desktop publishing. The first section contains multiple choice and true/false questions testing knowledge of basic IT concepts like hardware components, software types, file management, spreadsheets, and databases. The second section asks students to define key computer and IT terms, explain functions like mail merge and operating systems, and solve problems using formulas in a sample Excel worksheet involving student data. Questions cover topics like basic computer models, operating systems, internet applications, email advantages, PowerPoint slide masters, Excel functions, database concepts, and setting up relationships between tables with primary and secondary keys.

    Copyright:

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

    Computer Applications, Business Accounting and Multilingual DTP (Caba-Mdtp)

    Uploaded by

    parveez
    290 views5 pages
    National Council for Promotion of Urdu Language document contains questions related to computer applications, business accounting, and multilingual desktop publishing. The first section contains multiple choice and true/false questions testing knowledge of basic IT concepts like hardware components, software types, file management, spreadsheets, and databases. The second section asks students to define key computer and IT terms, explain functions like mail merge and operating systems, and solve problems using formulas in a sample Excel worksheet involving student data. Questions cover topics like basic computer models, operating systems, internet applications, email advantages, PowerPoint slide masters, Excel functions, database concepts, and setting up relationships between tables with primary and secondary keys.

    Original Title

    M1-IT-Tools

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    National Council for Promotion of Urdu Language document contains questions related to computer applications, business accounting, and multilingual desktop publishing. The first section contains multiple choice and true/false questions testing knowledge of basic IT concepts like hardware components, software types, file management, spreadsheets, and databases. The second section asks students to define key computer and IT terms, explain functions like mail merge and operating systems, and solve problems using formulas in a sample Excel worksheet involving student data. Questions cover topics like basic computer models, operating systems, internet applications, email advantages, PowerPoint slide masters, Excel functions, database concepts, and setting up relationships between tables with primary and secondary keys.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    290 views5 pages

    Computer Applications, Business Accounting and Multilingual DTP (Caba-Mdtp)

    Uploaded by

    parveez
    National Council for Promotion of Urdu Language document contains questions related to computer applications, business accounting, and multilingual desktop publishing. The first section contains multiple choice and true/false questions testing knowledge of basic IT concepts like hardware components, software types, file management, spreadsheets, and databases. The second section asks students to define key computer and IT terms, explain functions like mail merge and operating systems, and solve problems using formulas in a sample Excel worksheet involving student data. Questions cover topics like basic computer models, operating systems, internet applications, email advantages, PowerPoint slide masters, Excel functions, database concepts, and setting up relationships between tables with primary and secondary keys.

    Copyright:

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

    National Council for Promotion of Urdu Language

    Ministry of HRD, Department of Higher Education, Govt. of India

    COMPUTER APPLICATIONS, BUSINESS ACCOUNTING AND MULTILINGUAL DTP (CABA-MDTP)

    Name of the Center…………………………………………………Centre Code……………….

    Name of the Candidate………………………………..Son Daughter/Wife of…………………..

    Registration No………………………………………..Invigilator’s Signature………………….

    First Semester Module Paper


    M1-IT TOOLS & BUSINESS SYSTEMS
    Time: 2 Hrs M.Marks: 70

    SECTION-I
    A) Answer the following multiple choice questions (1 to 10) 1x10=10

    Note: For each question, four choices are given, out of which one Choice is correct. ( )

    a) CD-ROM stands for


    a. Compactable Read Only Memory b. Compact Data Read Only Memory
    c. Compactable Disk Read Only Memory d. Compact Disk Read Only Memory( )

    2. Software, such as Explorer and Firefox, are referred to as __________.


    a. Systems software b. Utility software
    c. Browsers d. Internet tools ( )

    3 The arranging of data in a logical sequence is called:


    a. Sorting b. classifying
    c. reproducing d. summarizing ( )

    4 The input unit of a computer


    a. feeds data to the CPU or memory b. retrieves data from CPU
    c. directs all other units d. All of the above ( )

    5. What digits are representative of all binary numbers?


    a. 0 b. 1
    c. Both (a) and (b) d. 3 ( )

    6. _______ unit coordinates the sequencing of events within the central processor of a computer.
    a. Logic unit. b. Arithmetic unit.
    c. Storage unit. d. Control unit. ( )

    1
    7. MS-EXCEL can be used to automate
    a. Financial statements, Business forecasting b. Transaction registers, inventory control
    c. Accounts receivable, accounts payable d. Any of the above ( )

    8. Not included in Window Accessories


    a. Calculator b. Microsoft Office
    c. Notepad d. Paint ( )

    9. The default number of worksheets in workbook of MS-Excel is


    a. 2 b. 3
    c. 4 d. 1 ( )

    10. The Database Language That Allows You To Access Or Maintain Data In A Database

    A) DCL B) DML
    C) DDL D) None Of Above ( )

    B) Fill in the blanks with appropriate words given below: 1x10=10

    A. Workbook B. Absolute Addressing C. File D. Ctrl +I E. Workarea


    F. Send Email G. Machine-language H. Windows XP I. Cell J. Ctrl+B
    K. RDBMS L. Byte M.High-level N.ORDBMS
    Language

    A. The Language that the computer can understand is called _______________.

    B. _______________ Keyboard shortcut is used for bold a text.

    C. A Folder can contain _______________.

    D. _______________ is used to measures computer memory which is equal to eight bits.

    E. Referring to the value in a cell rather than the position of the cell is called____________.

    F. _______________ is the name of operating system.

    G. The internet allows you to ______________.

    H. Excel work is a collection of ________________.

    I. Each box in a spreadsheet is called a _______________.

    J. Microsoft Access Is A________________________________

    2
    C) State which of the following is True or False: 1x10=10

    1 MAX () function is used to find largest value. ( )

    2 Inserted pictures cannot be edited. ( )

    3 A byte has 8 bits. ( )

    4 Mail Merge option is under Insert Tab. ( )

    5 Once chart is created, chart type cannot be changed. ( )

    6 By default Page Orientation is Landscape in Word. ( )

    7 You can delete files by dragging them to the Recycle Bin on the desktop. ( )

    8 Header is inserted at the top of the page ( )

    9 Ctrl+U selects the bold style for the selected text in MS-WORD. ( )

    10 In Excel numeric is by default right aligned. ( )

    3
    D) Match the following: 1x10=10

    Column A Column B Answer


    1.Slide sorter a) It is default name of the document when Word is 1.
    loaded.
    2. Scanner b) Current date/time. 2.
    3. Header & Footer c) Concatenate cells 3.
    4. Document 1 d) Helps PowerPoint slides to be rearranged for a 4.
    presentation
    5. NOW() e) Find 5.
    6. Merge Cells f) Input Device 6.
    7. Ctrl + F g) Output Device 7.
    8. CPU h) Printed on every page 8.
    9. Monitor i) F5 9.
    10. Slide show j) Brain of Computer 10.

    4
    SECTION II

    1) 5*3=15
    a) What is Computer? Define its Basic model and Components of computer?
    b) What is Difference between RAM and ROM?
    c) What is Operating System? Difference between Window and Linux Operating System?
    d) What is Internet? Explain its applications
    e) What is meant by the term e-mail? What are its advantages?

    2) 3*5=15
    a) What is mail merge? Write the steps to be followed in mail merge?
    b) What is the purpose of using Microsoft PowerPoint? Explain Slide Master in detail. .
    c) Answer the questions based on the following worksheet:

    a) Write the formula to find total marks obtained by each student


    b) Write the formula to find result: Insert "P" if total marks >125 else "F"
    c) Steps to sort data according to names (A to Z)
    d) Write the formula to count the number of students whose total marks are greater than 240.
    e) Write the formula to count the number of male (M) students.
    f) Explain the difference between pie chart and line chart.
    OR

    a) What is Relational Database Management System and Define Advantages and disadvantages?

    b) What is primary key, Secondary Key, Unique key and Null key?
    c) Make a Data table with Primary key and define its relationship with another table by secondary
    key with suitable example?

    You might also like