IT Workshop - B.Tech 1st Semester Examination, 2024

2024•Semester 2•Civil-CA•End Semester
Bihar Engineering University, Patna
B.Tech 1st Semester Examination, 2024

IT Workshop

Time: 03 HoursCode: 100113Full Marks: 70

Instructions:

  1. The marks are indicated in the right-hand margin.
  2. There are NINE questions in this paper.
  3. Attempt FIVE questions in all.
  4. Question No. 1 is compulsory.
Q.1 Choose the correct answer of the following (Any seven questions only):[2×7=14]

  1. What does RAM stand for?

    1. Read All Memory
    2. Random Access Memory
    3. Run Access Memory
    4. Read And Modify

  2. Which of the following is NOT an operating system?

    1. Windows
    2. Android
    3. Linux
    4. MS Word

  3. What is the shortcut key to copy selected text in MS Word?

    1. Ctrl + V
    2. Ctrl + X
    3. Ctrl + C
    4. Ctrl + P

  4. Which view is used to run a PowerPoint presentation?

    1. Slide Sorter
    2. Normal View
    3. Slide Show
    4. Outline View

  5. Which function is used to calculate the average in Excel?

    1. =TOTAL()
    2. =AVG()
    3. =SUM()
    4. =AVERAGE()

  6. What is the full form of URL?

    1. Uniform Read Line
    2. User Resource Locator
    3. Uniform Resource Locator
    4. Uniform Retrieve Line

  7. Which of these file types is associated with PowerPoint?

    1. .doc
    2. .pptx
    3. .txt
    4. .xlsx

  8. What type of memory is RAM?

    1. Permanent
    2. Notional
    3. Read-only
    4. Non-volatile

  9. What is a spreadsheet made up of?

    1. Pages
    2. Rows and Columns
    3. Slides
    4. Charts

  10. What is the intersection of a row and column called?

    1. Box
    2. Field
    3. Cell
    4. Section
Q.2 Solve both questions :[7+7=14]

  1. What are input and output peripherals of a computer? Identify any four input and four output devices with examples?

  2. Explain the functions of motherboard?

Q.3 Solve both questions :[7+7=14]

  1. Explain the fundamental components of computer system?

  2. Write the function of the following Linux commands: ls, pwd, cd, mkdir, rm, cp, and mv.

Q.4 Solve both questions :[7+7=14]

  1. What is meant by "surfing the web"? Explain any four types of web surfing and working of surfing in details.

  2. What is antivirus software? Name and describe the types of antivirus programs available for protecting a computer.

Q.5 Solve both questions :[7+7=14]

  1. Explain the features of MS Word in details?

  2. Write down the steps to insert image and table in MS Word in details?

Q.6 Solve both questions :[7+7=14]

  1. Create a project certificate using Microsoft Word?

  2. How can MS Word be used to create Newsletter and Resume?

Q.7 Solve both questions :[7+7=14]

  1. What is a Formula in Excel? Give a simple example of an Excel formula that performs a calculation.

  2. Write the steps to create column chart and pie chart with example?

Q.8 Solve both questions :[7+7=14]

  1. Describe two simple ways you can insert images into a PowerPoint slide.

  2. Write the steps to add Table and Photograph in Ms Power Point?

Q.9 Write short notes on any two of the following:[7×2=14]
    • Web browser
    • Pop-up blocker
    • Mail Merge in MS-word
    • LaTeX vs. MS Word