MS EXCEL
Basic structure of MS-Excel
Choose the answer
1. The software which contains rows and columns is called………
Spreadsheet
Database
Word Processing
Presentation
2. What is the name of the selected cell?
6C
C6
4
A1
3. Which of the following used to create spreadsheet?
4. What is the cell address of the pineapple?
D3
C5
F2
A1
[Link] column is identified by a…
Number
Name
Letter
Nothing
6. The row is identified by a…
Number
Name
Letter
Nothing
7. What do we use Microsoft Excel for? (Select 2 options)
Typing a document
Creating the spreadsheet
Calculating how much pocket money you spend
Creating the presentation
8. Which keys are used to save the spreadsheet?
Ctrl + P
Ctrl + V
Ctrl + C
Ctrl + S
9. Which of these keys are used in Microsoft Excel for UNDO?
Ctrl + Z
Ctrl + V
Ctrl + C
Ctrl + X
10. Where can we see the name of
the sheet?
1
2
3
4
Shortcut Keys
1. Copy - Ctrl + C
[Link] - Ctrl + X
3. Paste - Ctrl + V
4. Undo - Ctrl + Z
5. Redo - Ctrl + Y
6. Save - Ctrl + S
7. New File - Ctrl + N
8. Open - Ctrl + O
Fill in the blanks
1. A program using a table comprising of rows, columns and cells.
MS Excel
2. The intersection of a row and a column is called
Active Cell
3. Provides easy access to frequently used commands:
Quick Access Toolbar
4. Microsoft Excel is categorized as a ________________ software.
Spreadsheet
5. MS- Excel can perform
Complex operations
Short Answers
1. What is Data?
Data is the raw facts that can be processed by any computing
machine. It can be texts or numbers inside the memory of electronic
devices.
2. Write some features of Ms-Excel
Calculation
Graphing tool
Auto sum
Chart
3. How to start Ms Excel?
1. Click the Start button on the Windows taskbar.
2. The Programs menu opens
3. Click Microsoft Excel
4. Excel opens a new workbook
Example Picture:
4. What is Cell referencing?
Each worksheet contains a number of columns and rows. Cell
reference or Cell Address is a combination of a column letter and a
row number that identifies a cell on a worksheet. Each cell of the
worksheet has a unique reference.
For example, B2
5. How to save Ms Excel?
a. Click on the File Menu
b. Select the Save Option from the File Menu
c. Enter File name
d. Click Save
Example Picture
Or
Press Save icon