CLASS - 6 || SUBJECT - COMPUTER || LESSON - 5 || MS EXCEL 2013: FORMATTING AND CALCULATIONS ||

-

 

LESSON – 5

MS EXCEL 2013: FORMATTING AND CALCULATIONS

 

1.  How will you add border to cells?

To add borders to the cells, follow the steps given below:

a.  Select the cells to which you want to add borders to

b.  From the font group on the home tab, click on the drop-down arrow of borders. The borders drop-down menu appears.

c.  Select border style you want to use

d.  Select erase border to erase borders from cells

e.  Click on line colour to open the sub-menu for changing colours of the borders.

f.   Click on line style to open the sub-menu for changing the line style of the borders.

g.  Click on more borders to add additional border styles. This will open the format cells dialog box with the border tab open.

 

2.  What is order precedence?

It means the order in which the operators are executed when two or more operators are used in single calculations.

 

3.  Write the steps to change the row height?

To change the row height:

a.  Select any cell of the row

b.  Click on format to open its drop-down menu

c.  Click on row height to open the row height dialog box

d.  Click on auto fit row height to let excel automatically adjust row height

e.  Enter a specific height you want for the row

f.   Click on OK

 

4.  How will you select a group of adjacent cells?

To select a group of adjacent cells, choose the first cell in the group. Now, press and hold down the shift key and with the help of the arrow keys, select the group of adjacent cells you want.

 

5.  What is cell address?

There 17 million cells in single worksheet. We need to assign an address to every cell in order to differentiate from others. A cell address is intersection of the row and column where cell is located. Cell address assists while using formulas.

Comments

Post a Comment

Popular posts from this blog

CLASS - 3|| SUBJECT - SCIENCE|| LESSON - 4|| INSECTS||

-
Image
  LESSON – 4 INSECTS   QUESTIONS & ANSWERS :-   1.   What are insects? Name some common insects found in our surroundings. Insects are small creatures that are found almost everywhere. They are different in size, colour and features. Some common insects like ants, bees, butterflies, beetles, mosquitoes, flies, honeybees and grasshoppers can be seen in our surroundings.   2.   What are the main parts of an insect’s body? Draw a labelled diagram of an insect’s body. An insect’s body is divided into three main parts – head, thorax and abdomen. 3.   What do you mean by life cycle? Draw a labelled diagram of the life cycle of a butterfly. Life cycle is the series of changes that happen to a living creature over the course of its lifetime.   4.   Name three insects which are useful to us and how? There are some insects which are very useful to us. a.   Honeybees give us honey and beeswax. Candles, soaps and cr...
Read more

CLASS - 3// SUBJECT - SCIENCE // LESSON - 5 // PLANTS- PARTS AND THEIR FUNCTIONS //

-
Image
  LESSON - 5 PLANTS- PARTS AND THEIR FUNCTIONS   1.     What are the two main parts of a plant? A plant is divided into two main parts- the shoot and the root. The part of the plant which is above the soil is called the shoot. The part of the plant which remains under the soil is called the root.   2.     What are the main functions of a root? a.      Roots fix plants firmly in the soil. b.     They help the plants to stand straight c.      They hold the soil and prevent it from being washed away by water or wind. d.     They take in water and minerals from the soil and pass them, to the stem. e.     Some roots store food.   3.     What are the main functions of leaves? Why are they called the kitchen of the plant? Leaves prepare and store food for the plant, gives out the oxygen during the process of photosynth...
Read more

CLASS 6 / GEOGRAPHY / LESSON 1 (Q/A)

-
Chapter 1 The Earth in the Solar System I.              Answer the following questions briefly. 1.      How does a planet differ from a star?   Differences between a planet and a star: PLANET STAR A planet does not have its own light and heat. It derives its light from a star A star possesses its own heat and light. A planet is usually smaller than stars. Stars are very huge objects compared to a planet in general. 2.     What is meant by the ‘Solar System’? The term Solar System refers to the “family” of the Sun. The Sun is a star around which eight planets, among other celestial objects, revolve in orbits. This whole system of bodies is called the Solar System. The Sun is the “head” of this system.   3.     Name all the planets according to their distance from the sun. The list...
Read more