Hello dear students, and welcome to Net Explanations. On this page, we have posted Excel – Introduction Class 5 Computer Worksheet Extra Questions and Answers. For more CBSE Board Class 5 computer worksheets, check out this page.
Excel – Introduction Class 5 Computer Worksheet
1) Answer the following questions (32)
a) What is Microsoft Excel? (1)
b) What is Worksheet? (1)
c) How many columns and rows each worksheet of Excel contains? (2)
d) What is cell is Microsoft Excel? (1)
e) What are the types of data in a cell? (3)
f) What are the components of Microsoft Excel? (Any ten) (10)
g) What is column heading? (1)
h) What is row heading? (1)
i) What are gridlines? (1)
j) What is the default active cell? (1)
k) What is the mouse pointer displayed as whenever it is located in a cell on the worksheet? (1)
l) How Excel automatically aligns the text and numbers? (2)
m) What is the file extension for MS Excel? (1)
n) What is autofill feature of Excel? How it helps us? (2)
o) How to start MS Excel? (2)
p) How to enter data in worksheet of MS Excel? (2)
2) Write true or false (8)
a) Microsoft Excel is a presentation program.
b) Intersection of column and rows are called cell.
c) Title bar shows the name of the worksheet.
d) Excel automatically left aligns the number data.
e) If worksheet contains data, it deletes without confirmation.
f) Autofill helps us to save time and effort.
g) Excel file extension is .pdf .
h) Gridlines are the horizontal and vertical lines.
Answer
1) Answer the following questions (32)
a) What is Microsoft Excel? (1)
Answer – Microsoft Excel is aspreadsheet program which helps us to organize data and complete calculation.
b) What is Worksheet? (1)
Answer – Worksheet is the rows and columns present in the Microsoft Excel.
c) How many columns and rows each worksheet of Excel contains? (2)
Answer –Each worksheet of Excel has 16384 columns and 1048576 rows.
d) What is cell is Microsoft Excel? (1)
Answer –Cell in Microsoft Excel is the small intersection of a column and a row.
e) What are the types of data in a cell? (3)
Answer – There are three rules of data in a cell
Labels (text)
Values (numbers)
Formulas
f) What are the components of Microsoft Excel? (Any tem) (10)
Answer – The components of Microsoft Excel are,
Title bar
File tab
Tab
Ribbon
Formula bar
Worksheet window
Row and column heading
Cell
Active cell
Gridlines
Mouse pointers
Scroll bars
Status bars
g) What is column heading? (1)
Answer –Column heading is the letter above the grid which identifies the column.
h) What is row heading? (1)
Answer – Row heading is the row number on the left side of the grid which identifies each row.
i) What are gridlines? (1)
Answer –In Microsoft Excel the rows and columns consists of vertical and horizontal lines, these are called gridlines.
j) What is the default active cell? (1)
Answer –The default active cell is A1.
k) What is the mouse pointer displayed as whenever it is located in a cell on the worksheet? (1)
Answer –The mouse pointer is displayed as block plus sign whenever it is located in a cell on the worksheet.
l) How Excel automatically aligns the text and numbers? (2)
Answer – Excel automatically aligns the text to the right and the numbers to the left.
m) What is the file extension for MS Excel? (1)
Answer – The file extension for MS Excel is .xlsx .
n) What is autofill feature of Excel? How it helps us? (2)
Answer –Autofill feature of Excel used to add duplicate entries or data to the spreadsheet.
It helps us by saving time and efforts.
o) How to start MS Excel? (2)
Answer – To start MS Excel following steps should be followed,
First click on the start button on the bottom left corner of the screen.
A list would appear, click on the Excel.
Then Excel will open.
Click on the blank workbook.
p) How to enter data in worksheet of MS Excel? (2)
Answer –
First open the excel.
Then open a blank workbook.
Then, click on the cell where you want to type data.
Type the data and after finishing press enter.
Move on to the next cell.
2) Write true or false (8)
a) Microsoft Excel is a presentation program.
Answer –False
b) Intersection of column and rows are called cell.
Answer – True
c) Title bar shows the name of the worksheet.
Answer – True
d) Excel automatically left aligns the number data.
Answer – True
e) If worksheet contains data, it deletes without confirmation.
Answer – False
f) Autofill helps us to save time and effort.
Answer – True
g) Excel file extension is .pdf .
Answer – False
h) Gridlines are the horizontal and vertical lines.
Answer – True