Scribd
Upload
4 views2 pages

CH 5 - Spreadsheet

The document provides an overview of basic spreadsheet operations, including the differences between moving and copying cells, resizing rows and columns, and key features of MS Excel such as Autosum and Autofill. It also mentions two open-source spreadsheet software options, Google Sheets and Libre Office Calc, and explains the options available in the Font group for text formatting. Overall, it serves as a guide for Grade 10 students studying basic computing in vocational education.

Uploaded by

Shahla Inamdar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

CH 5 - Spreadsheet

The document provides an overview of basic spreadsheet operations, including the differences between moving and copying cells, resizing rows and columns, and key features of MS Excel such as Autosum and Autofill. It also mentions two open-source spreadsheet software options, Google Sheets and Libre Office Calc, and explains the options available in the Font group for text formatting. Overall, it serves as a guide for Grade 10 students studying basic computing in vocational education.

Uploaded by

Shahla Inamdar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Grade 10 NIOS

Subject: Basic computing (Vocational)


Ch 5- SPREADSHEET

1. What is the difference between moving and copying cells?


Copying cells Moving cells
Copying cells copies the entire cell, Moving cells moves the entire cell,
including the formulae and their values to including the formulae and their values to
another location. another location.
The formulae or the value remains in the The formulae or the value is deleted from
original location. the original location.
The shortcut key to copy cells is Ctrl +C. The shortcut key to move cells is Ctrl +X.

2. How do you resize a row or a column in a spreadsheet?


The steps to resize the row/column are:
1. Select the row or column that needs to be resized.
2. Right click on that row or column.
3. Click on Column width/Row height and enter the desired width/height value

3. What are the main features of MS Excel?


The main features of MS Excel are:
1. Autosum: It helps to calculate the sum of the content of all the cells in a
specified range.
2. Autofill: It helps to quickly fill the series of numbers or values; e.g., date,
week days etc., in a range of cells.
3. Sorting: It helps to arrange the contents of cells in increasing or decreasing
order.
4. Filtering: It helps to filter out some of the data based on some selection
criteria.
5. Charts: It helps to present the data using graphs like Pie chart, Bar chart etc.
6. Formula: It helps to insert any type of formula in the sheet to obtain the
calculated output. Few of the functions are like mathematical, trigonometrical
etc.
7. Pivot Table: It is a tool that allows you to reorganize and summarize selected
columns and rows of data in a spreadsheet to obtain a desired report. A pivot
table does not actually change the original spreadsheet.

4. Give the names of any two open source softwares used for creating a spreadsheet.
Google Sheets and Libre Office Calc.

5. Explain the options of Font group.


The options of Font group are-
1) Bold, Italics and Underline Text
Select the cell or range of cells and click on B, I or U options as desired to make the text
bold, italics or underlined respectively.
2) Add Borders to the Cells
Select the cells where you want to apply the borders and click on ‘Borders’ option on
the ‘Home’ tab (refer Fig. 5.9). You will observe different types of borders. Click the
desired one to apply the corresponding border style.
3) Change Text and Cell Colors
In order to make the text impressive, one can change the color of the text in a cell and
also change the background color of the cell. Select the cell or cells for which you wish
to change the color of the text and click on the drop down menu of A icon. Select the
desired color from the color box. To change the background color of cells click on the Fill
color icon (paint bucket) and apply the desired color.
4) Change Font and Font Size
Select the cell or cells in which you wish to change the font and font size. Select font
style and font size options from the ‘Home’ tab. Select the desired font style and size
from the drop down menu.

***********

You might also like