BCA Semester 1 – Computer Fundamentals and Applications () Questions & Answers | Past TU Exam Papers

Question 1

a) From the following spreadsheet, write the formula to address the following conditions: Given Data: | S.n | Name | Address | Post | Salary | Bonus | Tax | HA | Total | |-----|------|---------|------

Marks: 10

Year: 2019 Final TU FOHSS

Answer a: For Row 2 (Ram): - Bonus (F2): =E215% or =E20.15 - Tax (G2): =IF(D2="Manager",E210%,0) or =IF(D2="Manager",E20.1,0) - HA (H2): =IF(C2<>"Kim",E25%,0) or =IF(C2<>"Kim",E20.05,0) - Total (I2):

Question 2

What is a word processor? Explain the major functions available in the Home tab of a Word document.

Marks: 10

Year: 2019 Final TU FOHSS

Word Processor: A word processor is application software used for creating, editing, formatting, storing, and printing text documents. Examples include Microsoft Word, Google Docs, and LibreOffice Wri

Question 3

a) What is animation? What are the advantages of using Slide Master in PowerPoint? b) Explain the block diagram of a computer and its various components.

Marks: 10

Year: 2019 Final TU FOHSS

Answer a: Animation: Animation is the technique of creating the illusion of motion by displaying a series of images or frames in rapid succession. In presentation software, animation refers to visual

Question 4

Prepare the following spreadsheet: Student Marks Record | A | B | C | D | E | F | G | H | I | J | H | G | H | |---|---|---|---|---|---|---|---|---|---|---|---|---| | SN | Name | CFA | Logic | Math | S

Marks: 10

Year: 2020 Final TU FOHSS

Formulas for Row 2 (Ram): a) Total Marks (Column H, Cell H2): = C2+D2+E2+F2+G2 or = SUM(C2:G2) -- b) Percentage (Column I, Cell I2): = H2/500100 or =(H2/5) (Since total marks = 5 subjects × 100 = 500

Question 5

a) What is mail merge? Explain the major functions available in the Review tab of a Word document. b) What is Photoshop? Write the steps to create an MRP-sized photograph in JPEG format. --

Marks: 10

Year: 2020 Final TU FOHSS

Answer a: Mail Merge: Mail merge is a feature in word processing applications that allows users to create multiple documents from a single template merged with a data source. It is commonly used for c

Question 6

What is a data warehouse? Explain advantages and disadvantages of a data warehouse.

Marks: 5

Year: 2021 Final TU FOHSS

1. What is a Data Warehouse? A Data Warehouse is a large collection of data that is collected from different sources, processed, and stored in a central place for reporting, analysis, and decision mak

Question 7

What is hypermedia? Write down the applications of augmented reality.

Marks: 5

Year: 2021 Final TU FOHSS

1. Hypermedia (Definition) Hypermedia is an advanced form of hypertext in which text, images, audio, video, and animations are connected through links so that users can move from one piece of informat

Question 8

a) What is ambient reality? How does it differ from augmented reality? b) Why is the Healing Brush Tool useful? Describe how to use Photoshop to create your ID-Card.

Marks: 10

Year: 2022 Final TU FOHSS

Topic: Ambient Reality & Photoshop Tools --- a) Ambient Reality vs Augmented Reality 1. Ambient Reality (AmR): - Refers to a digital environment that is seamlessly integrated into the physical worl

Question 9

What is a geographic information system? Describe its elements.

Marks: 5

Year: 2023 Final TU FOHSS

1. Definition of GIS A Geographic Information System (GIS) is a computer-based system used to capture, store, manipulate, analyze, and display geographic or spatial data. - It helps in decision-maki

Question 10

a) Explain memory hierarchy. b) What is layer in Photoshop? What are the main features and tools available in Photoshop?

Marks: 10

Year: 2023 Final TU FOHSS

a) Memory Hierarchy Definition: Memory hierarchy is the arrangement of different types of memory in a computer system based on speed, cost, and capacity. It ensures efficient processing by storing f

Question 11

What is e-commerce? Explain the benefits of e-commerce.

Marks: 5

Year: 2024 Final TU FOHSS

1. What is E-Commerce? Definition: - E-commerce (Electronic Commerce) is the buying and selling of goods and services over the Internet. - It also includes online transactions, electronic payments

Question 12

a) What is computer virus? List the symptoms of a computer virus in a computer system. Also explain the prevention techniques. b) What is the use of mask in Photoshop? Explain different controls avail

Marks: 10

Year: 2024 Final TU FOHSS

a) Computer Virus Definition: A computer virus is a malicious program that can replicate itself and spread from one computer to another, often causing damage or unauthorized access to data. Symptoms

A	B	C	D	E	F	G	H	I	J	H	G	H
SN	Name	CFA	Logic	Math	So Tech	English	Total	Per	Result	Grade	Rank	Remarks
1	Ram	45	56	54	44	45	?	?	?	?	?	?
2	Sham	50	45	53	45	45	?	?	?	?	?	?
3	Hari	46	44	45	46	45	?	?	?	?	?	?

S.n	Name	Address	Post	Salary
1	Ram	Kim	Manager	12000
2	Sham	Pokhara	Accountant	11500
3	Hari	Pokhara	Engineer	10000
Maximum Salary				?