ITI (Trade-COPA) Day- 19

ITI COPA (Computer Operator & Programming Assistant) – Basic Notes

Topic-Advanced Excel Concepts – Theory

1. Introduction to MS Excel (Revision)

Microsoft Excel is a powerful spreadsheet application used for data entry, calculation, analysis, reporting, and visualization. It is widely used in offices, industries, accounts departments, data analysis, and management work. Excel works in the form of rows and columns, which together form cells.

Basic Structure of Excel

Workbook – Excel file
Worksheet – Sheet inside workbook
Rows – Horizontal (1, 2, 3…)
Columns – Vertical (A, B, C…)
Cell – Intersection of row and column (e.g., A1)

Basic Excel Operations (Revision)

1. Rows and Columns

Rows are numbered (1, 2, 3…)
Columns are alphabetically named (A, B, C…)
Maximum rows: 10,48,576
Maximum columns: 16,384 (XFD)

2. Basic Formatting

Formatting makes data readable and presentable.

Formatting options include:

Font style and size
Bold, Italic, Underline
Cell color and font color
Alignment (Left, Center, Right)
Border formatting
Wrap text and merge cells

3. Insert Menu

The Insert Menu is used to insert:

Rows and columns
Tables
Charts and graphs
Pivot tables
Pictures and shapes
Headers and footers

4. Print Setup

Excel allows data to be printed professionally.

Print options include:

Page orientation (Portrait / Landscape)
Margins
Print area
Page breaks
Scaling
Header and footer

2. Lookup Introduction and Functions

What is Lookup?

Lookup functions are used to search data in a table and return related values from another column or row.

Common Lookup Functions

1. VLOOKUP (Vertical Lookup)

Searches data vertically in a table.

Syntax:


=VLOOKUP(lookup_value, table_array, col_index, range_lookup)

Example:
Find employee salary using employee ID.

2. HLOOKUP (Horizontal Lookup)

Searches data horizontally.

3. LOOKUP

Used for simple lookup operations.

4. XLOOKUP (Advanced)

Modern replacement of VLOOKUP and HLOOKUP.

Advantages of Lookup Functions

Saves time
Reduces errors
Automates searching
Useful in large datasets

3. Types of References and Cell Naming

Cell References

A cell reference identifies a cell or range in Excel.

Types of Cell References

1. Relative Reference

Changes when copied.

Example: =A1+B1

2. Absolute Reference

Does not change when copied.

Example: =$A$1+$B$1

3. Mixed Reference

One part fixed, one part changeable.

Examples:

$A1
A$1

Cell Naming (Named Ranges)

Cell naming allows assigning a name to a cell or range.

Advantages:

Easy formula writing
Better readability
Reduces errors

4. Excel Linkage

What is Excel Linkage?

Excel linkage means connecting data between worksheets or workbooks.

Types of Linkage

1. Sheet-to-Sheet Link

Data linked between sheets in same workbook.

Example:


=Sheet2!A1

2. Workbook-to-Workbook Link

Data linked from another Excel file.

Advantages

Automatic updates
Data consistency
Useful for reports

5. Custom Format and Excel Protection

Custom Format

Custom format allows users to display data in required format without changing actual values.

Examples:

Currency format
Date format
Phone number format
Text with numbers

Excel Protection

Excel provides security features to protect data.

Types of Protection

Protect sheet
Protect workbook
Password protection
Lock/unlock cells

Uses

Prevent unauthorized changes
Secure sensitive data
Maintain data integrity

6. Excel Tips and Tricks

Important Excel Tips

Use shortcuts (Ctrl+C, Ctrl+V, Ctrl+Z)
Use Freeze Panes
Use Filters for data analysis
Use Conditional Formatting
Use Pivot Tables
Use Data Validation

7. Pivot Table and Pivot Chart

Pivot Table

A Pivot Table is a powerful tool used to summarize, analyze, and report large data quickly.

Features of Pivot Table

Data summarization
Grouping
Filtering
Sorting
Calculations

Steps to Create Pivot Table

Select data
Insert → Pivot Table
Choose rows, columns, values
Analyze data

Pivot Chart

A Pivot Chart is a graphical representation of pivot table data.

Advantages:

Visual analysis
Easy comparison
Interactive charts

8. Conditional Formatting

What is Conditional Formatting?

Conditional formatting changes the appearance of cells based on conditions.

Examples

Highlight highest values
Show color scales
Data bars
Icon sets

Advantages

Easy data analysis
Identifies trends
Highlights errors

9. Advanced Graphs

What are Advanced Graphs?

Advanced graphs represent complex data visually.

Types of Advanced Charts

Combination charts
3D charts
Waterfall charts
Histogram
Funnel chart

Uses

Professional reporting
Business analysis
Decision making

10. Power Queries

What is Power Query?

Power Query is an advanced Excel tool used for data import, cleaning, and transformation.

Features of Power Query

Import data from multiple sources
Clean and transform data
Remove duplicates
Merge and append tables
Automate data preparation

Advantages

Saves time
Reduces manual work
Handles large datasets
Improves accuracy

MCQ Questions (50 – CBT Exam)

1. MS Excel is a:

A) Word processor
B) Spreadsheet software
C) Database software
D) Presentation software
Ans: B

2. A cell is formed by intersection of:

A) Row and sheet
B) Column and sheet
C) Row and column
D) Workbook and sheet
Ans: C

3. Rows in Excel are identified by:

A) Letters
B) Numbers
C) Symbols
D) Colors
Ans: B

4. Columns in Excel are identified by:

A) Numbers
B) Letters
C) Symbols
D) Icons
Ans: B

5. Insert menu is used to insert:

A) Data only
B) Formatting only
C) Objects and data
D) Password
Ans: C

6. VLOOKUP is used to:

A) Format cells
B) Search data vertically
C) Sort data
D) Filter data
Ans: B

7. HLOOKUP searches data:

A) Vertically
B) Diagonally
C) Horizontally
D) Randomly
Ans: C

8. Which is an advanced lookup function?

A) SUM
B) XLOOKUP
C) COUNT
D) IF
Ans: B

9. Relative reference changes when:

A) Deleted
B) Copied
C) Protected
D) Locked
Ans: B

10. Absolute reference symbol is:

A) #
B) $
C) &
D) @
Ans: B

11. Example of absolute reference:

A) A1
B) A$1
C) $A$1
D) $A1
Ans: C

12. Cell naming is used to:

A) Delete cells
B) Rename sheets
C) Assign name to cell
D) Protect workbook
Ans: C

13. Excel linkage connects:

A) Computers
B) Cells and sheets
C) Printers
D) Charts only
Ans: B

14. Sheet-to-sheet linking uses:

A) =Sheet1+A1
B) =Sheet2!A1
C) =A1@Sheet
D) =LinkA1
Ans: B

15. Custom format changes:

A) Actual value
B) Display of value
C) Formula
D) Sheet
Ans: B

16. Excel protection is used to:

A) Increase speed
B) Secure data
C) Format cells
D) Create charts
Ans: B

17. Which feature prevents editing?

A) Conditional formatting
B) Sheet protection
C) Sorting
D) Filtering
Ans: B

18. Pivot table is used for:

A) Data entry
B) Data summarization
C) Printing
D) Formatting
Ans: B

19. Pivot table is created from:

A) Chart
B) Data range
C) Formula
D) Cell only
Ans: B

20. Pivot chart represents:

A) Raw data
B) Pivot table data
C) Images
D) Text
Ans: B

21. Conditional formatting applies formatting based on:

A) Color
B) Condition
C) Font
D) Size
Ans: B

22. Data bars show:

A) Text length
B) Value comparison
C) Formatting
D) Borders
Ans: B

23. Which is an advanced chart?

A) Line chart
B) Pie chart
C) Histogram
D) Column chart
Ans: C

24. Advanced graphs are used for:

A) Decoration
B) Analysis
C) Printing
D) Security
Ans: B

25. Power Query is used for:

A) Formatting
B) Data cleaning
C) Printing
D) Protection
Ans: B

26. Power Query can import data from:

A) Excel only
B) Multiple sources
C) Printer
D) Scanner
Ans: B

27. Freeze Panes is used to:

A) Lock workbook
B) Fix rows/columns
C) Delete data
D) Hide sheet
Ans: B

28. Filter option is used to:

A) Delete rows
B) Sort data
C) Display selected data
D) Print data
Ans: C

29. Combination chart combines:

A) Two workbooks
B) Two formulas
C) Two chart types
D) Two sheets
Ans: C

30. Workbook protection protects:

A) Single cell
B) Sheet only
C) Entire file
D) Chart
Ans: C

31. Data validation is used to:

A) Enter correct data
B) Format data
C) Delete data
D) Print data
Ans: A

32. Which function returns average?

A) SUM
B) COUNT
C) AVERAGE
D) MAX
Ans: C

33. Excel tips improve:

A) Hardware
B) Productivity
C) Storage
D) Virus protection
Ans: B

34. Custom number format is applied using:

A) Insert tab
B) Home tab
C) Format cells
D) Review tab
Ans: C

35. Pivot tables are interactive because they allow:

A) Editing data
B) Drag and drop
C) Deleting files
D) Coding
Ans: B

36. Which chart shows trend over time?

A) Pie
B) Line
C) Bar
D) Area
Ans: B

37. Power Query saves time by:

A) Manual entry
B) Automation
C) Formatting
D) Printing
Ans: B

38. Conditional formatting helps to:

A) Hide data
B) Highlight important data
C) Encrypt data
D) Delete data
Ans: B

39. Advanced Excel is useful for:

A) Only students
B) Office work
C) Gaming
D) Hardware repair
Ans: B

40. Pivot table calculations include:

A) Sum
B) Count
C) Average
D) All of the above
Ans: D

41. Power Query removes duplicates using:

A) Delete
B) Remove duplicates option
C) Filter
D) Sort
Ans: B

42. Excel charts are used for:

A) Programming
B) Data visualization
C) Database creation
D) Security
Ans: B

43. Absolute reference is useful for:

A) Copying formulas
B) Fixing values
C) Formatting
D) Printing
Ans: B

44. Mixed reference example is:

A) A1
B) $A$1
C) A$1
D) 1A
Ans: C

45. Which Excel feature summarizes large data?

A) Conditional formatting
B) Pivot table
C) Data validation
D) Custom format
Ans: B

46. Power Query supports:

A) Small data only
B) Large datasets
C) Text only
D) Images
Ans: B

47. Print setup is used to:

A) Save file
B) Format page for printing
C) Insert chart
D) Protect data
Ans: B

48. Custom format does NOT change:

A) Value
B) Display
C) Appearance
D) Layout
Ans: A

49. Pivot charts update when:

A) File closes
B) Pivot table changes
C) Data deletes
D) Workbook protected
Ans: B

50. Advanced Excel skills are important for:

A) ITI COPA trade
B) Office automation
C) Data analysis jobs
D) All of the above
Ans: D

ITI (Trade-COPA) Day- 18

ITI COPA (Computer Operator & Programming Assistant) –

Basic Java Script Programs

1. Program to Display “Hello World”


<script>
  document.write("Hello World");
</script>

👉 Purpose:
Used to understand basic JavaScript output.

2. Program to Add Two Numbers


<script>
  var a = 10;
  var b = 20;
  var sum = a + b;
  document.write("Sum = " + sum);
</script>

👉 Concept Used: Variables, arithmetic operator

3. Program to Take Input from User and Display It


<script>
  var name = prompt("Enter your name:");
  document.write("Welcome " + name);
</script>

👉 Concept Used: prompt() function

4. Program to Check Even or Odd Number


<script>
  var num = prompt("Enter a number:");

  if (num % 2 == 0) {
    document.write("Even Number");
  } else {
    document.write("Odd Number");
  }
</script>

👉 Concept Used: if–else, modulus operator

5. Program to Find Largest of Two Numbers


<script>
  var a = 25;
  var b = 15;

  if (a > b) {
    document.write("A is greater");
  } else {
    document.write("B is greater");
  }
</script>

👉 Concept Used: comparison operator

6. Program to Print Numbers from 1 to 10


<script>
  for (var i = 1; i <= 10; i++) {
    document.write(i + "<br>");
  }
</script>

👉 Concept Used: for loop

7. Program to Find Factorial of a Number


<script>
  var num = 5;
  var fact = 1;

  for (var i = 1; i <= num; i++) {
    fact = fact * i;
  }

  document.write("Factorial = " + fact);
</script>

👉 Concept Used: loop, multiplication

8. Program to Display Array Elements


<script>
  var fruits = ["Apple", "Banana", "Mango"];

  for (var i = 0; i < fruits.length; i++) {
    document.write(fruits[i] + "<br>");
  }
</script>

👉 Concept Used: array, loop

9. Program to Display Current Date


<script>
  var today = new Date();
  document.write("Today Date: " + today.toDateString());
</script>

👉 Concept Used: Date object

10. Program Using Function to Add Two Numbers


<script>
  function add(a, b) {
    return a + b;
  }

  var result = add(10, 20);
  document.write("Result = " + result);
</script>

👉 Concept Used: function, return statement

ITI (Trade-COPA) Day-17

ITI COPA (Computer Operator & Programming Assistant) – Basic Notes

Topic- Introduction to JavaScript

1. Programming and Scripting Languages

A programming language is used to develop software applications, operating systems, and complex programs. Examples include C, C++, Java.

A scripting language is mainly used to control applications and automate tasks. Scripts are executed line by line without compilation.

Examples of Scripting Languages

JavaScript
Python
PHP
Shell Script

Difference

Programming Language	Scripting Language
Compiled	Interpreted
Used for software	Used for automation
Example: C, Java	Example: JavaScript

2. Introduction to JavaScript and Its Web Applications

JavaScript is a client-side scripting language used to create interactive web pages.

Uses of JavaScript

Form validation
Popup messages
Image sliders
Menu effects
Dynamic content update
Animation and multimedia

JavaScript runs inside the web browser and works with HTML and CSS.

3. Introduction to Web Servers and Their Features

A web server stores website files and delivers them to users using HTTP or HTTPS.

Examples of Web Servers

Apache
Nginx
IIS

Features

Handles multiple requests
Provides security
Supports scripting languages
Works 24×7

4. JavaScript Basics

4.1 Data Types

Number
String
Boolean
Undefined
Null

4.2 Variables

Variables store values.

Keywords:

var
let
const

4.3 Constants

Constants store fixed values.


const PI = 3.14;

4.4 Type Conversion

Number()
String()
Boolean()
parseInt()
parseFloat()

5. Operators in JavaScript

Arithmetic Operators

+ - * / %

Comparison Operators

== === != > < >= <=

Logical Operators

&& || !

Operator Precedence

Brackets
Arithmetic
Comparison
Logical

6. Control Statements and Loops

Conditional Statements

if
if-else
else-if
switch

Loops

for
while
do-while
for...in
for...of

7. Arrays in JavaScript

An array stores multiple values in one variable.

Types

Numeric array
String array
Mixed array
Multidimensional array

Array Properties

length
Index starts from 0

8. String Data Type

Strings are text values enclosed in quotes.

String Functions

length
toUpperCase()
toLowerCase()
indexOf()
replace()
substring()

9. Math and Date Objects

Math Object

Math.sqrt()
Math.pow()
Math.random()
Math.round()

Date Object

getDate()
getMonth()
getFullYear()
getTime()

10. Functions in JavaScript

A function is a reusable block of code.

Types

User-defined
Built-in
Anonymous
Arrow functions

Advantages

Code reuse
Easy maintenance
Reduces repetition

11. Built-in JavaScript Functions

alert()
confirm()
prompt()
parseInt()
parseFloat()
isNaN()

12. Pop-up Boxes

Types

Alert box – message display
Confirm box – Yes/No
Prompt box – input from user

13. Document Object Model (DOM)

DOM represents an HTML page as a tree structure.

Uses of DOM

Access HTML elements
Change content
Modify CSS
Handle events

14. Animation and Multimedia in JavaScript

JavaScript can:

Animate text and images
Control audio and video
Create interactive effects

Used in:

Websites
Games
Educational apps

MCQ Questions (30 – CBT Exam)

1. JavaScript is a:

A) Programming language
B) Scripting language
C) Markup language
D) Query language
Ans: B

2. JavaScript is mainly used for:

A) Database design
B) Styling pages
C) Making web pages interactive
D) Hardware control
Ans: C

3. JavaScript runs on:

A) Server
B) Browser
C) CPU
D) RAM
Ans: B

4. Which keyword is used to declare a constant?

A) var
B) let
C) const
D) static
Ans: C

5. Which is NOT a JavaScript data type?

A) Number
B) String
C) Boolean
D) Character
Ans: D

6. `===` operator checks:

A) Value only
B) Type only
C) Value and type
D) Assignment
Ans: C

7. Which operator is used for AND?

A) &
B) &&
C) ||
D) !
Ans: B

8. Which loop executes at least once?

A) for
B) while
C) do-while
D) for-in
Ans: C

9. Array index starts from:

A) 1
B) 0
C) -1
D) Any number
Ans: B

10. Which function displays a message box?

A) prompt()
B) confirm()
C) alert()
D) message()
Ans: C

11. Which function takes user input?

A) alert()
B) prompt()
C) confirm()
D) input()
Ans: B

12. Which object is used for math operations?

A) Number
B) Math
C) Calc
D) Integer
Ans: B

13. Which object handles date and time?

A) Time
B) Clock
C) Date
D) Day
Ans: C

14. JavaScript functions are used for:

A) Repetition
B) Storage
C) Reusability
D) Security
Ans: C

15. DOM stands for:

A) Document Object Model
B) Data Object Model
C) Digital Object Method
D) Document Oriented Model
Ans: A

16. DOM allows JavaScript to:

A) Access HTML elements
B) Compile code
C) Store data
D) Create database
Ans: A

17. Which loop is used to repeat code?

A) if
B) switch
C) loop
D) for
Ans: D

18. JavaScript is a:

A) Case-insensitive language
B) Case-sensitive language
C) Machine language
D) Assembly language
Ans: B

19. Which operator is used for OR?

A) &&
B) ||
C) !
D) ==
Ans: B

20. Which is a built-in JavaScript function?

A) print()
B) alert()
C) show()
D) input()
Ans: B

21. Which keyword declares a variable with block scope?

A) var
B) let
C) static
D) define
Ans: B

22. Which object is used for animation?

A) CSS only
B) JavaScript
C) HTML only
D) Database
Ans: B

23. JavaScript is mainly used on:

A) Server-side only
B) Client-side
C) Hardware
D) OS kernel
Ans: B

24. Which operator has highest precedence?

A) Logical
B) Comparison
C) Arithmetic
D) Assignment
Ans: C

25. JavaScript arrays can store:

A) One value
B) Multiple values
C) Only numbers
D) Only strings
Ans: B

26. Which function converts string to integer?

A) Number()
B) parseInt()
C) parseFloat()
D) String()
Ans: B

27. Which symbol is used for comments?

A) 
B) //
C) **
D) ##
Ans: B

28. Multimedia in JavaScript includes:

A) Text only
B) Audio and video
C) Database
D) Compiler
Ans: B

29. JavaScript improves:

A) Page security only
B) Interactivity
C) Hardware speed
D) Storage
Ans: B

30. JavaScript is used with:

A) HTML only
B) CSS only
C) HTML and CSS
D) Database
Ans: C

ITI (Trade-COPA) Day-16

ITI COPA (Computer Operator & Programming Assistant) – Basic Notes

Topic- Web Design Concepts

1. Introduction to Web Design

In today’s digital world, websites play a very important role in communication, business, education, government services, and entertainment. Web design refers to the process of creating, designing, and maintaining websites. It includes planning the structure of web pages, writing content, designing layout, adding images, links, forms, and applying styles to make the website attractive and user-friendly.

Web design mainly uses technologies such as HTML, CSS, and sometimes scripting languages, along with content management systems (CMS) and web authoring tools.

2. Concepts of Static and Dynamic Web Pages

2.1 Static Web Pages

A static web page is a type of web page where the content remains the same for all users. These pages are written using HTML and CSS only, and they do not change unless the developer manually edits the source code.

Characteristics of Static Web Pages

Fixed content
Same information for all users
Simple to create
Loads faster
No database connection

Technologies Used

HTML
CSS

Examples

Personal profile page
Company information page
Simple brochure website

Advantages

Easy to design
Low cost
Secure (no database)
Fast loading

Disadvantages

No user interaction
Difficult to update large websites
Not suitable for complex applications

2.2 Dynamic Web Pages

A dynamic web page displays different content to different users. The content can change automatically based on user input, time, database data, or other factors.

Characteristics of Dynamic Web Pages

Content changes dynamically
Uses server-side scripting
Connected to databases
Supports user interaction

Technologies Used

HTML
CSS
JavaScript
PHP, ASP.NET, Python, etc.
Database (MySQL, SQL Server)

Examples

Social networking sites
E-commerce websites
Online banking systems

Advantages

Interactive
Easy content management
Suitable for large websites

Disadvantages

Complex to develop
Requires server and database
More security risks

Difference Between Static and Dynamic Web Pages

Static Web Page	Dynamic Web Page
Fixed content	Changing content
No database	Uses database
Simple	Complex
Faster	Slower than static
HTML & CSS	HTML, CSS, scripts

3. Introduction to HTML

3.1 What is HTML?

HTML (HyperText Markup Language) is the standard language used to create web pages. It defines the structure and content of a web page using tags.

HTML is not a programming language; it is a markup language.

3.2 Features of HTML

Easy to learn
Platform independent
Supports multimedia
Works with CSS and JavaScript
Used by all web browsers

3.3 Structure of an HTML Document

An HTML document consists of:

<!DOCTYPE html> – Document type
<html> – Root element
<head> – Meta information
<title> – Page title
<body> – Main content

4. Various HTML Tags

4.1 Basic HTML Tags

<html> – Root tag
<head> – Header section
<title> – Title of webpage
<body> – Main content

4.2 Text Formatting Tags

<h1> to <h6> – Headings
<p> – Paragraph
<br> – Line break
<hr> – Horizontal line
<b> – Bold
<i> – Italic
<u> – Underline

4.3 List Tags

<ul> – Unordered list
<ol> – Ordered list
<li> – List item

4.4 Link and Image Tags

<a> – Hyperlink
<img> – Image

4.5 Table Tags

<table> – Table
<tr> – Table row
<td> – Table data
<th> – Table header

4.6 Form Tags

<form> – Form container
<input> – Input field
<textarea> – Text area
<button> – Button
<select> – Dropdown list

5. Concepts of Controls Used in Web Pages

Controls are input elements that allow users to interact with web pages, especially through forms.

Common Web Controls

Text box
Password box
Radio button
Check box
Submit button
Reset button
Dropdown list

Uses of Web Controls

Collect user information
Login forms
Registration forms
Feedback forms

Advantages

User interaction
Data collection
Improves website functionality

6. Concepts of CSS

6.1 What is CSS?

CSS (Cascading Style Sheets) is used to style and format HTML elements. It controls the appearance of web pages such as colors, fonts, layout, spacing, and alignment.

6.2 Features of CSS

Separates content from design
Improves website look
Reusable styles
Faster page loading

6.3 Types of CSS

1. Inline CSS

Applied directly inside HTML tag

2. Internal CSS

Written inside <style> tag

3. External CSS

Written in separate .css file

6.4 CSS Properties

Color
Background
Font
Border
Margin
Padding
Display

6.5 Applying CSS to HTML

CSS can be applied using:

Style attribute
<style> tag
<link> tag

7. Introduction to Open Source CMS

7.1 What is CMS?

A Content Management System (CMS) is software that helps users create, manage, and modify website content without coding knowledge.

7.2 Open Source Software

Open source software is software whose source code is freely available for use, modification, and distribution.

Advantages of Open Source CMS

Free to use
Easy content management
Community support
Customizable

7.3 Popular Open Source CMS

1. WordPress

Most popular CMS
Easy to use
Blogging and websites

2. Joomla

Flexible CMS
Used for portals and websites

Features of CMS

Themes and templates
Plugins and extensions
User management
Media management

8. Web Authoring Tools

What are Web Authoring Tools?

Web authoring tools help create websites easily using visual editors instead of manual coding.

Popular Web Authoring Tools

KompoZer
FrontPage
WordPress Editor

Advantages

Easy for beginners
No deep coding required
Faster development

9. Importance of Web Design for ITI COPA Students

Office website maintenance
IT support tasks
Basic web development jobs
Freelancing opportunities
CBT exam preparation

MCQ Questions (35 Questions – CBT Exam)

1. Web design is related to:

A) Hardware repair
B) Creating websites
C) Database only
D) Networking
Ans: B

2. Static web pages contain:

A) Dynamic content
B) Fixed content
C) Database
D) Scripts only
Ans: B

3. Dynamic web pages use:

A) Only HTML
B) Only CSS
C) Server-side scripting
D) Printer
Ans: C

4. HTML stands for:

A) HyperText Markup Language
B) High Text Machine Language
C) Hyper Transfer Machine Language
D) Hyper Tool Markup Language
Ans: A

5. HTML is a:

A) Programming language
B) Markup language
C) Database
D) Compiler
Ans: B

6. Which tag is used for paragraph?

A) <p>
B) <h1>
C) <br>
D) <title>
Ans: A

7. Which tag is used to insert image?

A) <image>
B) <img>
C) <src>
D) <pic>
Ans: B

8. Hyperlink tag is:

A) <link>
B) <href>
C) <a>
D) <url>
Ans: C

9. Which tag creates ordered list?

A) <ul>
B) <li>
C) <ol>
D) <dl>
Ans: C

10. `<br>` tag is used for:

A) Paragraph
B) Line break
C) Space
D) Image
Ans: B

11. Web controls are used for:

A) Design only
B) User interaction
C) Printing
D) Storage
Ans: B

12. Which is a form control?

A) <table>
B) <input>
C) <img>
D) <title>
Ans: B

13. CSS is used for:

A) Structure
B) Styling
C) Database
D) Security
Ans: B

14. CSS stands for:

A) Computer Style Sheet
B) Cascading Style Sheets
C) Creative Style System
D) Color Style Sheet
Ans: B

15. Inline CSS is applied:

A) In external file
B) Inside tag
C) In browser
D) In server
Ans: B

16. External CSS file extension is:

A) .html
B) .css
C) .js
D) .xml
Ans: B

17. CMS stands for:

A) Computer Management System
B) Content Management System
C) Control Management Software
D) Content Machine System
Ans: B

18. WordPress is a:

A) Browser
B) CMS
C) Compiler
D) Server
Ans: B

19. Joomla is an example of:

A) OS
B) CMS
C) Browser
D) Antivirus
Ans: B

20. Open source software means:

A) Paid software
B) Free software
C) Source code available
D) Trial software
Ans: C

21. KompoZer is a:

A) CMS
B) Web authoring tool
C) Browser
D) Server
Ans: B

22. FrontPage is used for:

A) Networking
B) Web designing
C) Programming
D) Database
Ans: B

23. `<table>` tag is used for:

A) Forms
B) Lists
C) Tables
D) Images
Ans: C

24. Dynamic websites are suitable for:

A) Small pages
B) Large applications
C) Offline use
D) Static data
Ans: B

25. CSS improves:

A) Security
B) Appearance
C) Database
D) Speed only
Ans: B

26. Which control allows multiple selection?

A) Radio button
B) Check box
C) Text box
D) Button
Ans: B

27. HTML file extension is:

A) .htm / .html
B) .css
C) .exe
D) .doc
Ans: A

28. `<head>` tag contains:

A) Images
B) Meta information
C) Forms
D) Tables
Ans: B

29. CMS reduces the need of:

A) Internet
B) Coding
C) Browser
D) Server
Ans: B

30. Web authoring tools are useful for:

A) Beginners
B) Hackers
C) Servers
D) Routers
Ans: A

31. HTML tags are written inside:

A) Brackets
B) Quotes
C) Angle brackets
D) Curly braces
Ans: C

32. CSS helps in:

A) Layout design
B) File storage
C) Email sending
D) Virus protection
Ans: A

33. Static websites are:

A) Interactive
B) Database driven
C) Non-interactive
D) Script based
Ans: C

34. Which is NOT a CMS?

A) WordPress
B) Joomla
C) KompoZer
D) Drupal
Ans: C

35. Web design knowledge is useful for:

A) IT support
B) Office work
C) Website maintenance
D) All of the above
Ans: D