Page 56 - 2502_Pakistan-kifayat_C-8

Timeline

Spreadsheet software is a computer program that helps you organise, store, and work with data in
rows and columns.
Microsoft Excel is the most versatile and widely used of all the Office applications.

The Excel window has many components such as Title bar, Status bar, View bar, Sheet tabs, Worksheet,
Rows and Columns, Cells, Name box, and Formula bar.
In Excel, you can change the size of columns and rows to fit your data, making sure everything fits
neatly without cutting off any text or numbers.
Excel has built-in formulas and functions and many more tools to present data in a meaningful and
attractive way.

Functions are predefined formulas in Excel to perform both simple and complex calculations.

Choose the correct option.

1. What is the smallest unit in an Excel worksheet?

a. Worksheet b. Row

c. Column d. Cell

2. Which of the following tabs contains commands such as New, Open, Save, etc.?
a. File tab b. Home tab

c. Sheet tab d. Insert tab

3. Choose the function you would use in Excel to find the largest value in a range.

a. MIN() b. COUNT()

c. AVERAGE() d. MAX()
4. What is the default name of a new worksheet in Excel?

a. Book1 b. Sheet1

c. File1 d. Excel1

5. Determine which Excel function returns the remainder after division.

a. ROUND() b. QUOTIENT()
c. REMAINDER() d. MOD()

Tick ( ) the correct statements and cross ( ) the wrong ones.

1. A worksheet is a single page where data is entered in rows and columns.

2. The SUM() function is used to subtract numbers.

54 Premium Edition-VIII