Thursday, November 28, 2024

Html - Coding

  Basic Structure

<html>

<head>

<title></title>

</head>

<body>

</body>

</html>

Basics of Text Formatting

<p> </p> Paragraph

<br> Line Break

&nbsp Spacing

<h1></h1> to <h6></h6> Heading and Sub Headings

<center> </center> Center Text

<font size=?> size ranges from 1 to 7 </font> Font Size

<font color=?> color ranges </font> Font Color

<font face=?> font format </font> Font Face


List in HTML

<ul> Unordered List

<li> </li>

</ul> 

<ol>  Ordered Lists

<li> </li>

</ol>

<dl> Definition List

<dt> </dt>

<dd> </dd>

</dl>

Adding Image in a Webpage with border

<img src="C:\Users\HP440\Pictures\anyimage.jpg" border=5>

Specifying Image size in a webpage and alternate to an image

<img src="C:\Users\HP440\Pictures\anyimage.jpg" height=300 weidth=300 alt="anypicture">

Background, Foreground Colors and Background Images

<body  background="C:\Users\HP440\Pictures\anyimage.jpg" bgcolor=blue text=yellow>

</body>

Hyperlinks & Anchor Tags

<a href="https://www.wikipedia.org/" target="_blank"> Click for Wikepedia </a>

Hyperlink within a web page

<h1>para1</h1><a href=#p15> Go to para 15</a>

<h1>para15</h1><a name="p15"> </a>

Graphical Hyperlink

<a href="https://www.wikipedia.org/"> <img src="C:\Users\HP440\Pictures\wikepedia.jpg"> </a>

Creating Tables

<table border=1 cellspacing=5 cellpadding=5>

<tr>

<td> </td>

</tr>

</table>

at No comments:
Labels:

Tuesday, November 12, 2024

MS Excel Logical Formulas with Solution

 ANSWERS

Assignment 1: High-Value Comparisons

  1. Formula: =1350=1700 → Result: FALSE
  2. Formula: =1350>1700 → Result: FALSE
  3. Formula: =1350<=1700 → Result: TRUE
  4. Formula: =1700<>1350 → Result: TRUE
  5. Formula (with both values as 1700): =1700=1700 → Result: TRUE

Assignment 2: Comparing Negative Values

  1. Formula: =-300<-150 → Result: TRUE
  2. Formula: =-300>-150 → Result: FALSE
  3. Formula: =-300=-150 → Result: FALSE
  4. Formula: =-150<=-300 → Result: FALSE
  5. Formula: =-300<>-150 → Result: TRUE

Assignment 3: Fractional Comparisons

  1. Formula: =3.5<4.2 → Result: TRUE
  2. Formula: =3.5=4.2 → Result: FALSE
  3. Formula: =3.5>=4.2 → Result: FALSE
  4. Formula (with both values as 4.2): =4.2=4.2 → Result: TRUE
  5. Formula: =3.5<>4.2 → Result: TRUE

Assignment 4: Price Comparisons

  1. Formula: =225<250 → Result: TRUE
  2. Formula: =225=250 → Result: FALSE
  3. Formula: =225>=250 → Result: FALSE
  4. Formula (with both prices as 250): =250=250 → Result: TRUE
  5. Formula: =225<>250 → Result: TRUE

Assignment 5: Comparing Large and Small Values

  1. Formula: =5000>120 → Result: TRUE
  2. Formula: =5000<120 → Result: FALSE
  3. Formula: =5000=120 → Result: FALSE
  4. Formula (with both values as 5000): =5000>=5000 → Result: TRUE
  5. Formula: =5000<>120 → Result: TRUE

Assignment 6: Small Number Comparisons

  1. Formula: =5>3 → Result: TRUE
  2. Formula: =5<3 → Result: FALSE
  3. Formula: =5=3 → Result: FALSE
  4. Formula (with both numbers as 3): =3=3 → Result: TRUE
  5. Formula: =5<>3 → Result: TRUE

Assignment 7: Age Eligibility

  1. Formula: =21>18 → Result: TRUE
  2. Formula: =18=21 → Result: FALSE
  3. Formula: =21<=18 → Result: FALSE
  4. Formula (with both values as 18): =18=18 → Result: TRUE
  5. Formula: =18<>21 → Result: TRUE

Assignment 8: Inventory Checks

  1. Formula: =1500>1300 → Result: TRUE
  2. Formula: =1500=1300 → Result: FALSE
  3. Formula: =1300<1500 → Result: TRUE
  4. Formula (with both values as 1500): =1500<=1500 → Result: TRUE
  5. Formula: =1300<>1500 → Result: TRUE

Assignment 9: Salary Comparison

  1. Formula: =3500<4500 → Result: TRUE
  2. Formula: =3500=4500 → Result: FALSE
  3. Formula: =4500>=3500 → Result: TRUE
  4. Formula (with both values as 4500): =4500=4500 → Result: TRUE
  5. Formula: =3500<>4500 → Result: TRUE

Assignment 10: Exam Score Comparison

  1. Formula: =78<85 → Result: TRUE
  2. Formula: =78=85 → Result: FALSE
  3. Formula: =85>78 → Result: TRUE
  4. Formula (with both values as 85): =85=85 → Result: TRUE
  5. Formula: =78<>85 → Result: TRUE
at No comments:
Labels:
Subscribe to: Posts (Atom)

Html Practical's with Solution

  • Html - Coding
       Basic Structure <html> <head> <title></title> </head> <body> </body> </html> Basics of Te...
  • Practicals-Html
      Note: Make a New Folder in E: or D: with your name and make seperate notepad file for each practical's. Practical No.1 Write HTML code...
  • MS EXCEL Q&A
    Questions and Answers Define Spreadsheet Ans : A spreadsheet is a software application used to store, organize, and manipulate data in a...