Page 65 - iPlus_Ver_2.0_class_7
P. 65
6. Which of the following is not a feature of Excel?
a. It allows you to enter data in a series using the Auto Fill feature.
b. It allows us to use formatting features to improve the look and feel of data.
c. It provides different types of functions to perform calculations.
d. It allows us to create vector graphics.
B. Fill in the blanks using the words given below.
Hints: Data, Formula, block, Quick Access, Title
1. ................................ is automatically recalculated in the worksheet if any change is made in a single
cell.
2. ................................ bar is located at the top of the window that shows the name of the current
workbook.
3. ................................ Toolbar displays commonly used commands such as Save, Undo, and Redo.
4. ................................ bar is used to enter and edit formulas and perform calculations on your worksheet
data.
5. A group of cells when selected forms a rectangle, which is called a ................................ .
C. Write ‘T’ for true and ‘F’ for false.
1. Data can be viewed in a graphical form as charts. ................................
2. Title bar is a box located on the left side of the Excel window. ................................
3. A formula is an expression which helps perform arithmetic calculation,
and also executes non-arithmetic tasks. ................................
4. An active cell is a collection of two or more cells. ................................
Section B (Subjective)
A. Short answer type questions:
1. Define functions.
2. What is a name box in Excel?
3. What is an active cell?
4. What is the cell range in Excel?
B. Long answer type questions:
1. What is the use of worksheet tab navigation buttons?
2. What is the difference between a workbook and a worksheet?
3. Define column heading.
4. Write the steps to create a new workbook.
63
Spreadsheets—An Introduction

