St’s Mary’s Convent School

Aghwanpur Moradabad 244001

Name- Krishana Prakash rai

Class- ‘X’ Marshall
Subject- Information Technology
Submitted to- Mrs.Anita

Q1. Explain the styles given in the Styles and

Formatting Window for writer and paste the screen
shot of the window also

Answer- OpenOffice.org supports the

following types of styles:
1. Page styles
2. Paragraph styles
3. Character styles
4. Frame styles
5. Numbering styles
6. Cell styles
7. Graphics styles
8. Presentation Style

Page styles : include margins, headers

and footers, borders and backgrounds. In
Calc, page styles also include the
sequence for printing sheets.

Paragraph styles : control all aspects

of a paragraph’s appearance, such as text
alignment, tab stops, line spacing, and
borders, and can include character
formatting.
Character styles : affect selected
text within a paragraph, such as the font
and size of text, or bold and italic
formats.
Frame styles : are used to format
graphic and text frames, including
wrapping type,
borders, backgrounds, and columns.

Numbering styles : apply similar

alignment, numbering or bullet
characters, and fonts to numbered or
bulleted lists.

Q2. Write the steps to create new

style in Open Office Writer.
Ans. We can create New (Custom)
Styles in two ways
1. Creating a new style from a
selection :

1. Open the Styles and Formatting

window and choose the type of style
you want to create.

2. In the document, select the item

you want to save as a style.

3. In the Styles and Formatting

window, click on the New Style from
Selection icon
4. After Clicking on New Style from
Selection, create style dialog box
appear.

5. Write the name for the new style

and click on OK.

Q3.Write the steps to crop an image?

Ans- 1.Select a picture.

2.Select the Picture Tools > Format

tab and select Crop.

3. There are different ways to

crop your picture: Drag a cropping
handle to crop it from the side,
top, or bottom. Press Shift to
crop the entire photo down to the
size you want.

4. Press Esc to finish.

Q4.What are the steps to create a

template using wizard?

Ans. To create a template using a

wizard:
From the main menu, choose File >
Wizards > type of template required.
Follow the instructions on the pages
of the wizard.
In the last section of the wizard,
you can specify the name and location
for saving the template.

Q5. What do you mean by data

consolidation? Give an example with
stops?
Ans- Data consolidation is the
corralling, combining, and storing of
varied data in a single place. It
lets users manipulate different types
of data from one point of access and
helps turn raw data into insights
that drive better, faster decision-
making. The term sometimes is used
interchangeably with data
integration.

Data consolidation enables businesses

to streamline their data resources,
discover patterns, and look for
insights in multiple types of data.

Step 1: Open all files (workbooks)

that contain the data you want to
consolidate.
Step 2: Ensure the data is organized
in the same way (see example below).

Step 3: On the Data ribbons, select

Data Tools and then Consolidate.

Step 4: Select the method of

consolidation (in our example, it's
Sum).
Step 5: Select the data, including
the labels, and click Add

Step 6: Repeat step 5 for each

worksheet or workbook that contains
the data you need included

Step 7: Check boxes "top row"

", "left
column", and "create links to data
source" (note you don't have to tick
these boxes if you don't want labels
or don't want live links) and click
the OK button.

Q6. What do you mean by subtotals?

Give an example with steps?

Ans- T he Excel SUBTOTAL function with

function num 101-111 neglects values
in hidden rows, but not in hidden
columns.
For example, if you use a formula
like SUBTOTAL(109, A1:E1) to sum
numbers in a horizontal range, hiding
a column won't affect the subtotal.

Q7. What do you mean by Goal seek?

Give an example with steps.

Ans- Goal Seek is a process of

calculating a value by performing
what if analysis on a given set of
values. For our purposes, Excel's
Goal Seek feature lets you adjust a
value used in a formula to achieve a
specific goal. ... Calculating the
terms of a loan is a good example of
a what-if situation.

Q8. What do you mean by solver? Give

an example with steps?

Ans- A solver is a mathematical

software tool that finds the best
solution to a problem by changing the
values of variables. It can be used
to solve complex business problems,
such as optimizing profits or
minimizing costs.
Q9. What are the steps to compare the
worksheet?

Ans- Highlight the first cell of a

blank column.

When comparing two columns in a

worksheet, you'll be outputting your
results onto a blank column. Make
sure you are starting on the same row
as the two columns you're comparing.
For example, if the two columns you
want to compare start on A2 and B2,
highlight C2.

Type the comparison formula for the

first row. Type the following
formula, which will compare A2 and
B2. Change the cell values if your
columns start on different cells:
=IF(A2=B2,"Match","No match")
Double-click the Fill box in the
bottom corner of the cell. This will
apply the formula to the rest of the
cells in the column, automatically
adjusting the values to match.
Look for Match and No match. These
will indicate whether the contents of
the two cells had matching data. This
will work for strings, dates,
numbers, and times.
Note that case is not taken into
consideration ("RED" and "red" will
match).

Q10. What do you mean by Macro? Give

an example with steps.

Ans- A macro in computer science is a

rule or pattern that specifies how a
certain input sequence should be
mapped to a replacement output
sequence according to a defined
procedure.

Step 1:Set up the macro

A. Select the View tab, then click

Macros
> Record Macro.

B. In the Record Macro dialog box,

enter a macro name and description.
Follow these rules for the name:
Macro names must begin with a letter
and use either letters or numerals.
You cannot use spaces, non-
alphanumeric characters, or periods.
Macro names can be 80 characters
maximum
Macro names cannot conflict with the
program's reserved commands or
keywords such as Print, Save, Copy,
Paste.

C. For the Store Macro In field,

choose All Documents to run this
macro in all of your Word documents.

D. Next, in the Assign Macro To

panel, click Button or Keyboard
(shortcut) for the method used to
access and run the macro.

Note: Most of the shortcut keys are

already used by the system. Even
though you can overwrite many of
these shortcuts, it's much easier to
attach your macro to a button.

Step 2: Add a macro button to the

Quick Access Toolbar.

A. Click Button and the Word Options/

Customize Quick Access Toolbar screen
opens.

B. Click Modify, choose an icon to

represent your macro button, then
click OK.
C. When finished, click OK again to
exit.
Step 3: Record the macro.

Step 4: Stop recording.

When finished, select the View tab

again, then click Stop Recording.

Q11. Write the steps to create table

with minimum five fields on an entity
"STUDENT" in design view.

Ans- To create a table named

'STUDENT' with at least five fields
in design view, follow these steps:
Step by Step Solution:

Step 1
Open your database management system
(DBMS) and select the option to
create a new table.

Step 2
In the design view, enter the field
names as follows: ID, Name, Address,
Phone, and DOB.

Step 3
Set the data type for each field: ID
as Integer, Name as Varchar, Address
as Varchar, Phone as Varchar, and DOB
as Date.
Step 4
For the ID field, set the constraint
to be the Primary Key to ensure each
record is unique.

Step 5
Review the table design to ensure all
fields and data types are correct.

Step 6
Save the table with the name
'STUDENT'.

Final Answer:
The table 'STUDENT' has been created
with the specified fields and
constraints.

Q12. Write the command for the

following table Student.
1. Display all the records of table
Student.
2. Insert record of your choice

3. Display record of student whose

roll number is 3

4. Display record of students who are

in class 'X
5. Display the record of" Anuj".

Ans- The following SQL commands will

help you perform the required
operations on the 'Student' table:

1.To display all the records of the

table Student:
SELECT * FROM Student;

2.To insert a record of your choice

(for example, inserting a student
with Rollno 3, Class 'X', Name
'Ravi', Phone number '9876543'):

INSERT INTO Student (Rollno, Class,

Name, Phone_n)
VALUES (3, 'X', 'Anuj', '9876543');
3.To display the record of the
student whose roll number is 3:
SELECT * FROM Student WHERE Rollno =
3

4.To display the record of students

who are in class 'X':
SELECT * FROM Student WHERE Class =
'X';

5.To display the record of 'Anuj':

SELECT * FROM Student WHERE Name =
'Anuj';

Q13. Define the followings:

(i) Primary Key
(ii) Composite Primary Key
(iii) Foreign Key

Ans- 1.Primary keys:-

The primary key refers to a column

or a set of columns of a table that
helps us identify all the records
uniquely present in that table. A
table can consist of just one primary
key. Also, this primary key cannot
consist of the same values
reappearing/repeating for any of its
rows. All the values of a primary key
have to be different, and there
should be no repetitions.

2.Foreign key:-

We use a foreign key to establish

relationships between two available
tables. The foreign key would require
every value present in a column/set
of columns to match the referential
table’s primary key. A foreign key
helps us to maintain data as well as
referential integrity.

3.Composite Primary key:-

Composite key, or composite primary

key, refers to cases where more than
one column is used to specify the
primary key of a table. ... PRIMARY
KEY (COLUMN_1, COLUMN_2, ...)); Some
database-specific examples are shown
below. In all cases the composite key
created consists of COL1 and COL2.

Q14. Differentiate DDL and DML

commands.

Ans-Data definition language(DDL):-

DDL commands in SQL are used to deal
with descriptions of the database
schema and to create and modify the
structure of the database objects in
the database.

Data manipulation language(DML):-

DML commands are used to manipulate

the data within the schema created by
DDL. They are generally used for
inserting, updating, and querying
from the relational database.

Q15.A)

Ans-
Create table items
(Item no integer Primary key,
I name varchar(15), Price
numeric(10,2), Quantity integer (3));
B)

Ans- 1. Insert into item values(66,

'Gel', 150, 70);

2. Select *from item where price

>=100 and price <=300;