class 7 chapter 5
A. Choose the correct answer
1. The primary purpose of a
spreadsheet software is to:
a. Create animated presentations
b. Organise, analyse, and store
data in tabular form
c. Write long essays and reports
d. Edit video clip
Answer: b. Organise, analyse, and
store data in tabular form
---
2. What is the term for the entire
Excel file that you create and save, which can contain individual pages?
a. Worksheet
b. Cell
c. Workbook
d. Grid
Answer: c. Workbook
---
3. Which command is used to save
an Excel workbook for the very first time and specify its name and location?
a. Save
b. New
c. Open
d. Save As
Answer: d. Save As
---
4. You are creating a budget for
your birthday party. You have prices for decorations in cell B2 and food in
cell C2. You want to calculate the total cost in cell D2. Which formula would
you enter?
a. B2+C2
b. =B2+C2
c. SUM(B2,C2)
d. (B2+C2)
Answer: b. =B2+C2
---
5. You are working on a very large
worksheet with thousands of rows. You are currently in cell Z500. Which key
combination would you use to quickly jump back to the beginning of the
worksheet, cell A1?
a. Home
b. Ctrl + End
c. Ctrl + Home
d. Page Up
Answer: c. Ctrl + Home
---
6. You have numbers in cells A1,
A2, and A3. You entered the formula =A1+A2*A3. If A1 = 5, A2 = 2, and A3 = 3,
what will be the result displayed, considering the order of operations?
a. 30
b. 11
c. 16
d. 13
Answer: b. 11
Explanation: Multiplication is
done first: 2 × 3 = 6; then 5 + 6 = 11.
B. Fill in the Blanks
1. The intersection of a row and a
column is called a Cell.
2. The Formula Bar displays the
content of the active cell or the formula itself.
3. Rows in an Excel worksheet are
identified by Numbers.
4. Values like $500 or 25% are
examples of Numeric data.
5. The * symbol in an Excel
formula is used for Multiplication.
---
C. State whether the following
statements are True or False
1. The Page Up key moves the
active cell to the first row of the current sheet.
Answer: False
2. The Ctrl + N keyboard shortcut
is used to save an existing workbook.
Answer: False
3. “Roll No. 7A” is automatically
treated as a number by Excel because it contains digits.
Answer: False
4. You are currently in cell A100.
You need to quickly go to the last cell in the current column (Column A) that
contains data. You should press Ctrl + Down Arrow.
Answer: True
5. You have created a complex
calculation in Excel and want to ensure it remains stored for your next
computer class. You should press Ctrl + S frequently to save your progress.
Answer: True
6. You entered the formula
=(10-5)*2 in a cell. The result displayed in the cell would be 10.
Answer: True
---
D. Answer the Following Questions
1. List some of the benefits of
using an Excel program.
Answer:
1.
It helps to organise data in rows and columns.
2.
It performs calculations quickly.
3.
It helps analyse data.
4.
It can create charts and graphs.
5.
It makes data easy to edit and manage.
2. Explain the difference between
a Workbook and Worksheet in Excel.
Answer:
A Workbook is the complete Excel
file, which can contain multiple worksheets.
A Worksheet is an individual
spreadsheet page within a workbook.
3. What are the three main types
of data that can be entered into an Excel Cell?
Answer:
The three main types are:
1. Text/Label
2. Numeric/Number
3. Formula
4. Why is it important to save
your Excel workbook frequently while working on it?
Answer:
Saving frequently prevents loss of
work if the computer shuts down, crashes, or there is a power failure.
5. Describe ways to rename a
worksheet tab in Excel.
Answer:
You can rename a worksheet by:
Double-clicking the worksheet tab
and typing the new name.
Right-clicking the worksheet tab,
selecting Rename, and typing the new name.
Comments
Post a Comment