INFORMATION
TECHNOLOGY MANAGEMENT
ASSIGNMENT
– EXCEL SHEET
AUTO-SUM
Fig: 1 Auto - Sum
Step 1
Select a cell next to the numbers you want to sum:
To sum a column, select the cell immediately below the last value in the
column.
To sum a row, select the cell to the right of the last number in the row.
Step 2
Click the AutoSum button on either the Home or Formulas tab.
A Sum formula appears in the selected cell, and a range of cells you're adding gets
highlighted
Step 3
Press the Enter key to complete the formula.
AVERAGES
Fig: 2 Averages
Step 1
Enter the numbers you want to find the average of.
Step 2
Find the average of the numbers you entered.
Step 3
Observe the result in the cell you entered the
formula in.
PERCENTAGE
Fig. 3 Percentag
Step 1 =Enter the numbers you want to find the
percentage of.
Step 2=Add all the numbers and divide them with
total number.
Step 3=Then click on enter, and you got the
percentage.
Minimum
Fig. 4 Minimum
Step 1 =Select a blank cell to apply the min function,
then Click Formula > Autosum > Min
Step 2 =Select the range that you want to get the
minimum data.
Maximum
Fig 5 Maximum
Step 1 =Select a blank cell to apply the max
function, then Click Formula > Autosum > Max
Step 2 =Select the range that you want to get the
minimum data.
Delimit text file
Fig: 6 Delimit text file
Step 1=Slide the column list you want to split by
delimit, and click Data> Text to columns.
Step 2=Then convert text to column wizard dialog
pops out, check Delimited option and click Next
Button.
Step 3=In the opening convert to Text to column
wizard step 2, step 3-dialog box, check the delimiter
you need to split the data.
Step 4=Click finish now you can see the column list in selection
has been split into multiple columns by specified delimiter.
Sort – Ascending
Fig 7 Sort – Ascending
Step 1=Select the First cell from data.
Press the key (Ctrl+Shift+L) on your keyboard.
Step 2=Click on the filter to Semester.
To sort the data in ascending order, in the top of
the filter, sort the data Smallest to Largest.
Step 3=Data will get sorted in ascending order.
Sort – Descending
Fig 8 Sort – Descending
Step 1=Select the First cell from data.
Press the key (Ctrl+Shift+L) on your keyboard.
Step 2=Click on the filter to Semester.
To sort the data in descending order, in the top of
the filter, sort the data largest to smallest.
Step 3=Data will get sorted in descending order.
Fig 9 BARCHART
Fig 10 PIECHART
Fig 11 COLUMN CHART
Fig 12 LINECHART
CHARTS
In Microsoft Excel, a chart is often called a
graph. It is a visual representation of data from
a worksheet that can bring more
understanding to the data than just looking at
the numbers.
A chart is a powerful tool that allows you to
visually display data in a variety of different
chart formats such as Bar, Column, Pie, Line,
Area, Doughnut, Scatter, Surface, or Radar
charts. With Excel, it is easy to create a chart.
Here are some of the types of charts that you
can create in Excel.
The Bar Chart is like a Column Chart lying on
its side. The horizontal axis of a Bar Chart
contains the numeric values.
A Pie Chart can only display one series of data.
Excel uses the series identifier as the chart
title (e.g. Animals) and displays the values for
that series as proportional slices of a pie.
The Line Chart is especially effective in
displaying trends. In a Line Chart, the vertical
axis (Y-axis) always displays numeric values
and the horizontal axis (X-axis) displays time
or other category.
Step 1=Select the range A1: D7
Step 2=On the insert tab, select Bar chart, Pie
chart, Line chart.
Fig. 13 applying filters in the table
Fig 14 color sort
FILTER
Filters can be applied in different ways to improve the
performance of your worksheet. You can filter text, dates,
and numbers. You can even use more than one filter to
further narrow your results.
Step 1=Begin with a worksheet that identifies each column
using a header row.
Step 2=Select the Data tab and then locate the Sort &
Filter group. Click the Filter command.
Step 3=Drop-down arrows will appear in the header of
each column. Click the drop-down arrow for the column
you want to filter. In this example, we'll filter the Type
column to view only certain types of equipment.
Step 4=The Filter menu appears. Uncheck the boxes next to
the data you don't want to view, or uncheck the box next
to Select All to quickly uncheck all. Check the boxes next to
the data you do want to view. In this example, we'll check
Laptop and Projector to view only these types of equipment.
Step 5=Adding greater than filter in Month
Adding less than filter in Bear
Adding equal to filter in Dolphins
Adding color filter in Whales.
COLOR FORMATTING
Step 1: Select the a given table
Step 2: Go to Home page and then select the conditional option
Step 3: After selecting theconditonal formatting then go and start
applying to the rules
Step 4: Select the option of new rule and select the option format only
cells contains that
Step 5: In theabove table the following rules were applied
Step 6: Once the rules are applied to given table then we need to
understand who all fullfil a given criteria or our expectation, for which
we will use sort
Step 7: Like who all secure 60 or above in the in the mathematics, for
which will go the data option and then select filter option.
Step 8: Then we will place filter on the colum of mathematics then
select our range; result is that out of a class of 20 there are 8 students
who have secured 60 or above.
Fig 15 Final Outcome
ITM
ASSIGNMENT
HTML
Q1. Create a new page; start with a web page using your name and
your description.
Ans=<html>
<head>
<title> <i><u><b1>"Myself"</i></u></b1></title>
</head>
<body>
<b>Name:</b> vinay tyagi<br>
<b>Father's Name:</b> Mr. Tyagi ji<br>
<b> Mother's Name:</b> Mrs. Tyagi ji <br>
<b> Address:</b> LODHI ROAD M BLOCK<br>
<b> College/ University:</b> IP UNIVERSITY <br>
<b> Contact No.: </b> 9865473421
</body>
</html>
Q2. Create a table.
Ans.
<html>
<head>
<title> "Table </title>
</head>
<body>
<table border="1">
<tr>
<th> First Name</th>
<th> Last Name</th>
<th> Address</th>
</tr>
<tr>
<td>Myra</td>
<td> Singh</td>
<td> Delhi</td>
</tr>
<tr>
<td>Amara </td>
<td> Singh</td>
<td> Delhi</td>
</tr>
<tr>
<td>Amita </td>
<td> Singh </td>
<td> Delhi</td>
</tr>
</table>
</body>
</html>
FIRST NAME LAST NAME ADDRESS
MYRA SINGH DELHI
AMARA SINGH DELHI
AMITA SINGH DELHI
Q3. Create a form
a) Name, b)City, c)State, d)Email
Submit, Reset and OK button.
Ans.
<html>
<head>
<title>"Form" </title>
</head>
<body>
<form method="post"action="handler/welcome.php">
Name: <input type="text"
name="Student_name"><br><br>
City: <input type="text" name="city_name"><br><br>
State: <input type="text"
name=State_name"<br><br>
Email: <input type="text"Email_id"<br><br>
<input type "submit" name="submit_button">
<input type "reset" name="reset" value="Reset"/>
<input type="button" name="OK" value="OK"/>
</form>
</body>
</html>
Q4. Write a program for <Font> tag.
Ans.
<html>
<head>
<title>Font tag</title>
</head>
<body>
<font size="1"> vinay</font><br>
<font size="2"> vinay</font><br>
<font size="3"> vinay</font><br>
<font size="4">vinay</font><br>
<font size="5"> vinay</font><br>
<font size="6"> vinay</font><br>
</body>
</html>
Q5. Write a program of background image.
Ans.
<html>
<head>
<title> Background Image</title>
</head>
<body>
<div style="back-groundimage:url(http://www.html.am/images/image-
codes/milford_sound_t.jpg);width:300px;height:200px;color:black;font-
size:18px;">
GOOD MORNING
</div>
</body>
</html>
Q6. Write a program for HOME|ABOUT US|CONTACT US|BLOG<div>.
Ans.
<html>
<head>
<title> Div tag</title>
</head>
<body>
<div id="menu" align="middle">
<a href="/index.htm">HOME</a>
<a href="/about/contact_us.htm> CONTACT</a>
<a href="about/index.htm>ABOUT</a>
</div>
</body>
</html>
Q7. Write a program for Order list or <ol>.
Ans.
<html>
<head>
<title> Order List</title>
</head>
<body>
<ol>
<li>Beetroot</li>
<li>Ginger</li>
<li>Potato</li>
<li>Radish</li>
<li>Spanich</li>
<li>Brinjal</li>
</ol>
</body>
</html>
Q8. Write a program for unordered list.
Ans.
<html>
<head>
<title> Unorder List</title>
</head>
<body>
<ul>
<li>Beetroot</li>
<li>Ginger</li>
<li>Potato</li>
<li>Radish</li>
<li>Spanich</li>
<li>Brinjal</li>
</ul>
</body>
</html>
Q9. Write a program for link tag used with external CSS.
Ans.
<html>
<head>
<title> link tag</title>
<head>
<link rel="stylesheet" type="text/css" href="theme.css">
</head>
<body>
<h1> I am formatted with a linked stylesheet</h1>
<p> Me tool</p>
</body>
</html>
Q10. Write a program for preserve <pre> tag.
Ans.
<html>
<head>
<title>Preserve tag</title>
</head>
<body>
<pre>
Hi
i am vinay
</pre>
</body>
</html>
Q11. Write a program for select tag.
Ans.
<html>
<head>
<title>Select tag</title>
</head>
<body>
<select>
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="opel">Opel</option>
<option value="audi">Audi</option>
</select>
</body>
</html>
Q12. Create a home page for website.
Ans.
<html>
<head>
<title> Webpage</title>
</head>
<body>
<h1>Hello world</h1>
<p> This is a test page</p>
</body>
</html>
