CBSE Class 8 Computer Science Introduction to MS Excel Notes

Question: A Workbook is a collection of ______________
a. Cell
b. Rows
c. Columns
d. Worksheets
Answer: d

Question: By default, each worksheet contains _________ worksheets.
a. 2
b. 3
c. 4
d. 5
Answer: b

Question: A cell is an intersection of ____________- and ___________
a. Rows, Columns
b. Row, Cell Address
c. Column, Formula Bar
d. None of the above
Answer: a

Question: __________ cell is the cell in which we are currently working.
a. Dead
b. Active
c. Working
d. None of the above
Answer: b

Question: Every ___________ in Excel sheet has unique address.
a. Cell
b. Row
c. Column
d. Worksheet
Answer: a

Question: A maximum of ___________ rows are available in worksheet.
a. 83524
b. 1048576
c. 16384
d. 65536
Answer: b

Question: A maximum of __ columns are available in worksheet.
a. 83524
b. 1048576
c. 16384
d. 65536
Answer: c

Write True or False

Question: Excel can be used for mathematical calculations
Answer: True

Question: The status bar appears are the top of the Excel Window.
Answer: False

Question: When we enter a formula in a cell, it is displayed in the Formula bar.
Answer: True

Question: The Ribbon is located near the bottom of the Excel Window
Answer: False

Question: To open MS Excel, type Excel in search bar and press enter button from keyboard.
Answer: True

Very short Answer: type of questions

Question: Write the steps to start excel.
Answer: Start -> All Programs -> Microsoft Office -> Microsoft Office Excel

Question: Write the name of any four Excel-window components.
Answer: Formula Bar, Name Box, Status Bar, Title Bar, Scrollbar, Tabs, Worksheet

Question: Which function key is used to edit the contents of a cell?
Answer: F2

Question: What is used to fill the range and series in the cells?
Answer: Fill Handle

Question: Write the shortcut key to save the file in Excel.
Answer: Ctrl+S

Question: Write the shortcut key to create a new workbook or file in Excel.
Answer: Ctrl+N

Question: Write the shortcut key to open existing file in Excel.
Answer: Ctrl+O

Question: Write the shortcut key to insert a worksheet in the Excel file.
Answer: Shift+F11

Short Answer Type Questions

Question: What are various uses of MS Excel.
Answer: Excel can be used for performing following tasks:
1. It can be used to perform mathematical calculations.
2. It can be used to represent the data in the form of charts
3. It can be used to make time-table.
4. It can be used to prepare salaries of employees
5. It can be used to prepare results of students.

Question: List the parts of MS Excel Window.
Answer:  Following is the list of parts of MS Excel Window:
- Title Bar
- Quick Access Bar
- Tabs
- Ribbon
- Name Box (Address Bar)
- Formula Bar
- Work Area
- Status Bar
- Scroll Bar

Question: Explain the Formula Bar.
Answer:  Formula bar appears below the ribbon. It displays the contents of active cell. We can edit the cell contents using this bar. Besides this, it can also be used to enter new contents or formula in the active cell of the worksheet.

Question: What is Active Cell in MS Excel?
Answer:  Active Cell is also called Current Cell. In Excel, Active cell is a cell in which are working currently. It appears as a dark rectangular box. Address of active cell can be seen in the name box of Excel window.

Question: What is MS Excel?
Answer:  MS Excel is a product of Microsoft. It is a part of Microsoft Office. It is used to manage mathematical data and to perform calculations on them. We can perform calculations using formula and inbuilt functions of MS Excel.