4. ICT Soft Tools: Spreadsheet
Q.1
Fill in the Blanks.
1.
…………. Is a software in the Microsoft Office
Suite which is used principally for accounting. Excel
2.
Excel 2007 adds the extension …………. to
every workbook filename. .xlsx
3.
Spreadsheets of an Excel workbook are called
………………………. Worksheets
4.
In Excel, cells are formed by the intersection
of ……………… and columns. Rows
5.
A selected cell in an Excel worksheet is called
a/an ________ cell. active
6.
The ______________ box in Excel displays the
address of the active cell. Name
7.
To add the values in a selected row, column or
cell, __________ option is used in Excel. F2
8.
In Excel, the result of the formula, =5+2^3, is
_________. 13
9.
___________ chart in Excel is (usually) used for
scientific data analysis. XY Scatter
10.
In Excel, ________ the facility Is used to
complete one entry at a time. form
Q.2
State True or False
1.
An active cell is the one in which information
is being entered. True
2.
We can minimize the Ribbon in a Microsoft Office
Application to display only the names of the tabs by double clicking on the
name of the active tab. True.
3.
There are keyboard shortcuts for every
button/icon on the Ribbon. True.
4.
The cell at the first row and first column of an
excel worksheet is referred as 1A. False
5.
The address of the active cell of a worksheet
can be seen in the Formula bar. False
6.
In Excel, to place the insertion point inside a
selected cell, you double-click inside the cell or press the function key F2. True.
7.
In Excel, if the text is too long, it is
displayed in the right side of the cell as if they are empty. True
8.
In Excel, when we select the Wrap Text option in
the Alignment group of the Home tab, the cell height adjusts according to the
text without any change in the cell width. True
9.
By default , Excel 2007 enters time as AM. True
10.
Excel
2007 considers a leading plus sign as defining a formula. True
11.
The formula in Excel, =A5+D5 returns the sum of
the numbers in the cells A5 and D5. True
12.
Suppose the cell B2 of a worksheet contains the
formula, =A$1, if you copy the cell B2 to B3 , the formula changes to =B$1. False
13.
The formula in Excel, =MEAN(A5:D5), returns the arithmetic
mean of the numbers in the range A5 to D5. False
14.
In Excel, the formulas =5+3*2 and =(5+3)*2 give
the same result, viz., 16.. False.
Q.3
Rewrite the following statement by selecting the correct option.
1.
Excel
2007 adds the extension ________ to every workbook filename. .xlsx
2.
When we open Excel 2007, the default number of
worksheets present in a workbook are . 3
3.
By default , number data type in a
worksheet cell is displayed horizontally . right
aligned
4.
In Excel, a single click on any of the small
arrows at the end of the scroll bar. Scrolls
the active worksheet one cell at a time.
5.
Right- clicking on any if the tab scrolling
buttons in Excel 2007 displays. The
List of worksheets in the active workbook.
6.
To select all cells in a worksheet,. Click the diagonal arrow at the
intersection of row and column headers.
7.
The Page Layout view in Excel 2007 is similar to
the _______ view in Word 2007. Print
Layout
8.
Find the valid time from the following ______ . 02:26
9.
In Excel 2007, the mathematical expressions are
referred to as _________ . Formulas
10.
The _________ operator combines a range of cells
on worksheet for calculation. Union
Q.4
Rewrite the following statement by selecting two correct options.
1.
In Excel 2007, each worksheet can contain
___________, __________ . 10,48,576
rows, 16,384 columns
2.
In Excel 2007, which of the following is true
about a cell? It is formed by the
intersection of a row and a column, It is identified by a unique address.
3.
In Excel 2007, country specific special formats
can be applied to which of the following data type? Date , Time
4.
Which of the following characters can we use
while specifying a date in Excel? Forward
slash, Hyphen
5.
In Excel 2007, functions are ________, _______
formulas. Built in , Predefined
Q.5
Answer the following questions:
1.
Navigation in Excel.
Answer: There are different
ways to navigate or scroll through a worksheet, or between worksheets of a
workbook. You can use the arrow keys , the scroll bar, sheet tabs, sheet tab
scroll buttons ot the mouse.
i.
To move one row up or down: press the scroll
lock key on the keyboard, and use the up or down arrow keys, or click the
scroll arrows at the ends of the vertical scroll bar.
ii.
To move one window up or down: press the Page Up
or Page Down key on the keyboard.
iii.
To scroll up or down a few rows at a time:
rotate the mouse wheel button forward or back.
iv.
To move between cells on the worksheets , click
any cell or use the arrow keys. When you move to a cell, it becomes the active
cell.
2.
Changing row height and column width.
Answer: 1) Changing
row height: if you increase the font size of the contents of a cell or wrap
text, Excel automatically increases the height of that entire row. Also , you
can customize the height of row in below ways:
(a) click on the row header to select the row. Hold the mouse
pointer over the bottom border of the row header, when the mouse pointer changes
to , drag the mouse to increase
or decrease the width.
(b)
You can also set the row height by clicking format icon of the cells group on
the Home tab.
2) Changing
Column width: if the data entered in a cell is too long to fit in the cell,
you can double click on the right border of its column header. Then , the width
of the column increases to fit the data . you can customize the height of row
in below ways:
(a) click on the row header to
select the row. Hold the mouse pointer over the bottom border of the row
header, when the mouse pointer changes to , drag the mouse to increase or
decrease the width.
(b)
You can also set the row height by clicking format icon of the cells group on
the Home tab.
Q.6:
Answer the following in brief:
1.
Various uses of Excel 2007.
Answer: MS Excel 2007 is a
spreadsheet program and any application that requires spreadsheets can be done
using Excel .Applications which require handling large amounts of data,
calculating, sorting, filtering and formatting of data before printing or
displaying as charts or tables can be easily handled by Excel. For these
reasons, applications such as Payroll, Inventory, Accounts are being routinely
done on Excel.
2. What is
formula in Excel? What are different types of operators that can be used in a
formula?
Answer: A formula is an
expression which calculates the value of a cell. Functions are predefined
formulas and are already available in Excel. There are four different
types of calculations operator:
arithmetic comparison, text concatenation, and reference. Arithmetic operators
are used to perform basic mathematical operations such as addition,
subtraction, multiplication, finding percentage and produce numeric results.
Comparison operators are used to compare two values eg. TRUE or FALSE. A text
concatenation operator joins two text strings. Reference operators are used to
combine ranges of cells for calculations.
3. What
are functions? How are functions used in Excel 2007?
Answer: Excel 2007 has several
Pre-written or Inbuilt formulas known as Functions. Functions simplify our work
by doing complex calculations without us having to remember the formulas.
Functions can be entered in Excel by following the “=” sign with the name of the
function. Excel prompts you to enter the required values which are known as
arguments and displays the results in the active cell.
e.g.
IF(J3> 35, “PASS”, “FAIL”)
Here
the IF Function has 3 arguments which are put in brackets following the IF
Keyword and separated by commas.
Q.7:
Answer the following :
1. What
are the advantages of an electronic spreadsheet program?
Answer: The advantages of electronic spreadsheet
program:
i.
An electronic spreadsheet program has the
obvious advantages of processing speed and storage capacity of a computer.
ii.
Calculations using a spreadsheet program are
almost free of errors, i.e. , if the data entered and formula used are correct,
then the calculated results are definitely correct.
iii.
It has the important facility of automatic recalculation.
When one value is changed, all other values that depend on that first value
change automatically as the spreadsheet is recalculated by the program.
iv.
Tabular numerical data can be represented in
easy-to-gasp pictorial from such as graph or charts.
2. Explain
the features of the Excel 2007 Window.
Answer: The Title Bar in Excel displays the name of
the Program and the Workbook. The Ribbon consists of 7 main Tabs and more may
be displayed depending upon the Work being done. Each of the Tabs are divided
into Groups and Commands. The Microsoft Office Button has other commands while
the Quick Access Toolbar provides a quick way to carry out often repeated
commands. The address of the active cell is displayed in the Name Bar while its
contents are displayed in the Formula Bar. The Horizontal and Vertical Scroll
Bars, the Worksheet Tabs and the Tab scrolling buttons allow a quick way to
navigate around the Excel Workbook Window.
3. What
are graphs or charts? How can different types of charts or graphs be prepared
with Excel?
Answer: A Graph or Chart is a
pictorial representation of numerical data that is entered in Excel. Since
large amounts of numerical data which is presented in a series of rows and
columns is difficult to understand, a chart brings out the important points
represented by these numbers in an easy-to-understand way. The Chart Group
under the Insert Tab allows us to choose different types of Graphs. To insert a
chart in our Worksheet we must perform the following steps.
1.
Select the range of data which must be used to create the chart.
2.
Click on the Insert tab and then on the type of Chart you want from the Chart
Group.
3.
Choose the desired type from the list of displayed options.
4. The
chart as selected by you will be displayed.
5.
Change the Title or Legend as desired.
6. You
can choose to put the chart on the same worksheet as the Data or on an separate
sheet. Click Finish when done.
7. Your
chart will be displayed.
