Introduction to MS Excel Class 8 Computer Science Notes and Questions

Notes Class 8 Revision Notes

Please refer to Introduction to MS Excel Class 8 Computer Science notes and questions with solutions below. These revision notes and important examination questions have been prepared based on the latest Computer Science books for Class 8. You can go through the questions and solutions below which will help you to get better marks in your examinations.

Class 8 Computer Science Introduction to MS Excel Notes and Questions

Class 8 Computer Introduction to MS Excel Notes and Questions

Fill in the blanks

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

Answer

Worksheets

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

Answer

3

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

Answer

Rows, Columns

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

Answer

Active

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

Answer

Cell

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

Answer

1048576

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

Answer

16384

Write True or False

Question 1 Excel can be used for mathematical calculations

Answer

True

Question 2 The status bar appears are the top of the Excel Window.

Answer

False

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

Answer

True

Question 4 The Ribbon is located near the bottom of the Excel Window

Answer

False

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

Answer

True

Very short answer type of questions

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

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

Question 3 Which function key is used to edit the contents of a cell?

Answer

F2

Question 4 What is used to fill the range and series in the cells?

Answer

Fill Handle

Question 5 Write the shortcut key to save the file in Excel.

Answer

Ctrl+S

Question 6 Write the shortcut key to create a new workbook or file in Excel.

Answer

Ctrl+N

question 7 Write the shortcut key to open existing file in Excel.

Answer

Ctrl+O

Question 8 Write the shortcut key to insert a worksheet in the Excel file.

Answer

Shift+F11

Short Answer Type Questions
Q:1 What are various uses of MS Excel.

Ans: 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 2 List the parts of MS Excel Window.
Ans: 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 3 Explain the Formula Bar.
Ans: 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 4 What is Active Cell in MS Excel?
Ans: 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 5 What is MS Excel?
Ans: 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.

Introduction to MS Excel Class 8 Computer Science

We hope the above Introduction to MS Excel Class 8 Computer Science are useful for you. If you have any questions then post them in the comments section below. Our teachers will provide you an answer. Also refer to MCQ Questions for Class 8 Computer Science