Revision Notes for Chapter-2
1 What do you mean by MS-Excel?
Ans MS-Excel stands for Microsoft Excel.
Microsoft Excel is one of the most popular spreadsheet
software available in the market. It is often used for data entries,
record keeping etc.
2 What is Quick Access tool bar?
Ans Quick Access Toolbar contains the frequently used commands .By
default it has three commands Save, Undo and Redo.
3 What is Title bar?
Ans Title bar appears next to Quick Access toolbar, displays the name of
the workbook that is currently in use.
4 What is Ribbon in MS-Excel?
Ans Ribbon is just below the title bar. It is a collection of tabs namely
Home, Insert, Page, Layout, Formula etc.
5 What is Formula bar?
Ans Formula bar which is just below the ribbon allows a user to enter data
or formula in a particular cell
6 What is Address box in MS-excel?
Ans Address box in excel is next to formula bar, it displays the address of
the cell in which user is currently working.
7 What is Work Area?
Ans Work area is made of rows and columns. Collections of rows and
columns is known as Worksheet and collection of worksheets is known
as Workbook.
8 What is the extension for saving an excel sheet?
Ans The extension for saving an excel file is .xlsx
9 What is a cell in excel sheet?
Ans Single unit formed by an intersection of rows and columns is known as
a cell
10 What is Autofill Feature?
Ans Autofill is the easiest method to fill data in cells automatically, it
identifies the series and fills the data in the selected range of cells.
11 What is Flash Fill feature?
Ans Flashfill identifies the pattern and fills the data automatically in
selected range of cells.
12 What is Undo and Redo?
Ans Undo command can be applied using shortcut key Ctrl+Z and it cancels
the effect of previously executed command.
Redo command can be applied using shortcut key Ctrl+Y and it cancels
the effect of last executed Undo command.
13 What is the default value for Row height?
Ans 15.00 points is the default value for Row height.
14 What is the default value for column width?
Ans 8.43 points is the default value for column width.
15 What formula should be used to calculate total of values in cells
B1,B2,B3?
Ans =B1+B2+B3
16 Fill in the blanks:
a) The intersection of a row and a column is known as a cell
b) Text, digit and formula are the types of data that can be
entered in a cell.
c) Textual data is by default left aligned in Excel.
d) Formula bar provides information about the operation being
performed in a selected cell.
e) The address of presently active cell appears on the address box
of excel sheet
f) A feature of MS Excel that identifies the series and fills the data
automatically is known as Autofill.
g) A feature of MS-Excel that identifies the pattern and fills the
data automatically is known as Flashfill.
h) Insert button is in the cells group on the home tab.
i) The Undo and Redo buttons are available on the Quick Access
Toolbar
17 State True or False:
a) Quick Access toolbar contains the most frequently used
commands. ( True )
b) Formula bar appears below the ribbon. (True)
c) Title bar displays the name of the workbook currently in use in
MS-Excel.(True)
d) We click in the Delete drop-down menu and choose the delete
Sheet rows option to delete a cell.(False)
e) We cannot change the row height and column width manually.
(False)
f) We can use the short cut key Ctrl+E instead of flash-fill
option.(True)
g) Shift+F11 key is used to insert a new worksheet(True).
h) We can change the color of a Sheet tab in Microsoft Excel.(True)
18 Short keys in Excel:
Ctrl+C→ for copying data
Ctrl+V→ for pasting data
Ctrl+X→ for cut and copy data
Ctrl+Z→ for Undo
Ctrl+Y→ for Redo
Ctrl+S→ for saving an excel file
Ctrl+E→ for Flash Fill option
