Class
6th
Subject
– Computer
L-8
Working in Ms Excel
Paste and Label Ms- Excel Window
Make
a list of all shortcut commands in Ms- Excel
|
Command |
Short cut |
|
To select a single cell |
Left click on it |
|
To Select a range of adjacent cells |
Drag from the first cell to the last cell, or click on the
first cell, hold the Shift key and click on the last cell (scrolling if
necessary) |
|
To Select non-adjacent cells or ranges |
Hold CTRL (Windows) or Command (Mac) key and click or drag |
|
To Select an entire row or column |
Left click on the row or column heading |
|
To Select all cells |
Left click on the blank header in the upper left corner |
|
To Select the next cell to the right |
Use the Tab key |
|
To Select the next cell down the column |
Use the Enter key |
|
To Select the A1 Home cell |
Press Ctrl + Home keys together |
|
To Select the last cell
in a sheet |
Press Ctrl + End keys together |
|
To Select the cells around the active cell |
Press Ctrl + Shift + 8 keys together (Select Region) |
Fill in the blanks
1.
When you open Excel, a new file is created called Book
1
2. Microsoft Office Excel is a powerful tool used to create and format spreadsheets.
3.
Rows travel horizontally and are numbered.
4.
Columns travel vertically and are assigned letters.
5.
You can select a range of cells either by using a mouse or a
keyboard.
6. Wrapped Text wraps the contents of a cell across
several lines if it's too large than the column width. It increases the height
of the cell as well.
7. Text control allows
you to control the way Excel 2007 presents
information
in a cell.
State True or False:
1. You can change the font size of text with in a cell. TRUE
2. Text cannot be aligned within a cell. TRUE
3. The number of decimal places to be displayed can be increased or
decreased in Excel. TRUE
4. Justified option aligns data in cell to the left and to the right
borders.
FALSE
5. We can select a range of cells only with keyboard. FALSE
Short answer type questions.
1. What is the use
of Excel?
Ans:
Microsoft Office Excel is a powerful tool used to
create and format spreadsheets. Spreadsheets allow information to be organized
in rows and tables and analyzed with automatic mathematics. Spreadsheets are
commonly be used to perform many different types of calculations.
2. What do you mean
by Cell.
Ans:
Cells are the basic rectangular building blocks
of a spreadsheet. They are assigned an address, generally referred to as a cell
reference, according to their column and row (e.g. the cell in column B at row
3 is referenced as cell B3).
3. Define Row and
column.
Ans:
Row : Rows travel horizontally and are numbered.
Column
: Columns travel vertically and are assigned letters.
Long answer type questions:
1. What do you mean
by alignment tab?
Ans:
Alignment Tabs align data relative to the margin,
so if you change the margin, Word realigns the text automatically. ...
Alignment Tabs align data relative to the margin, so if you change the margin,
Word realigns the text automatically.
2. Write the steps
to select a range of cells with keyboard.
Ans:
To select a range of cells using keyboard, follow
the steps given below:
1. Bring the cell pointer on any of the corners.
2. While hold down the shift key, move the cell pointer towards the
diagonally opposite corner cell using arrow keys.
3. After reaching the destination cell, release the shift key. You will
get the desired range that has been selected.
3. Write the steps
to change vertical alignment from the alignment group.
Ans:
To change vertical alignment from the alignment
group:
•
Select a cell or range of cells.
•
Click the Top Align, Center, or Bottom Align command.
4. What do you mean
by Wrapped text and merged cells?
Ans:
Wrapped Text wraps the contents of a cell across several lines if it's too large
than the column width. It increases the height of the cell as well.
Merge Cells can also be applied by
using the Merge and Center button on the Home
tab.
Ok mam
ReplyDelete