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
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.
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