Scribd
Upload
818 views2 pages

Introduction To MS Excel: Ques/Ans

This document provides an introduction to Microsoft Excel. It answers common questions about Excel including defining key terms like worksheets and cells. It explains how worksheets display data in a grid of rows and columns. It also describes useful features like Autofill for automatically entering sequential data or copying formulas. The document notes there is typically one worksheet named Sheet1 in a new workbook by default, but additional worksheets can be added. It outlines two methods for creating a new workbook: starting from blank or using templates. Finally, it defines the cell pointer and discusses editing data directly in cells or by overwriting contents.

Uploaded by

Saundarya Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
818 views2 pages

Introduction To MS Excel: Ques/Ans

This document provides an introduction to Microsoft Excel. It answers common questions about Excel including defining key terms like worksheets and cells. It explains how worksheets display data in a grid of rows and columns. It also describes useful features like Autofill for automatically entering sequential data or copying formulas. The document notes there is typically one worksheet named Sheet1 in a new workbook by default, but additional worksheets can be added. It outlines two methods for creating a new workbook: starting from blank or using templates. Finally, it defines the cell pointer and discusses editing data directly in cells or by overwriting contents.

Uploaded by

Saundarya Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Introduction to MS Excel

Ques/Ans

1. What is a worksheet?
Ans. Worksheet is the area where you enter the data. It is a grid of cells made of rows and
columns.

2. What is AutoFill? How is it useful?


Ans. Autofill is a a special feature of MS Excel that helps you to enter data automatically. Using
this feature you can enter a predictable series e.g. 1,2,3.......; days of the week, etc. It is also
useful for copying the formula to the other cells after it has been entered in a cell and to copy the
data of the first cell to other cells.

3. How many worksheets are there by default in a workbook in Excel 2013?


Ans. By default there is only one worksheet named Sheet1 in a workbook in Excel 2013.
However you can add new worksheets which will be automatically named Sheet 2, Sheet 3, etc.

4. Which are the two ways in which you can create a workbook in Excel 2013?
Ans. MS Excel provides following two methods to create a workbook-
a) Creating a new blank workbook - This can be done by following the given steps:
Step 1 : Click on File tab. Backstage view will
appear.
Step 2 : Click on New.
Step 3 : Select Blank Workbook
b) Creating a new workbook from a template - This can be done by following the given steps:
Step 1 : Click on the File tab. Backstage
view will appear.
Step 2 : Click on New. Several templates will
appear.
Step 3 : Select a template to review it.
Step 4 : A preview of the template will
appear., along with some additional
information about the template.
Step 5 : Click Create to use the selected
template.

5. What is a cell pointer?


Ans. Cell pointer is the highlighted cell boundary which specifies that the cell is an active cell.

6. In how many ways you can edit data in a cell?


Ans. Editing in data in a cell can be done in two ways-
a) By partially modifying the cell contents by pressing F2 or double clicking the mouse after
selecting the cell to be edited.
b) By overwriting the contents of the cell you want to edit.
7. How can you select a complete row?
Ans. To select a complete row click on the row number you want to select. The pointer becomes
a thick black arrow. Multiple rows can be selected by dragging across multiple row numbers.

Last modified: 08:45

You might also like