CHAPTER 9: ELECTRONIC SPREASHEET

 

CHAPTER 9: ELECTRONIC SPREADSHEET

 

1. What is a spreadsheet?    

A spreadsheet is a collection of data and information organized in the form of rows and columns.

2. What is a range of cells?

A group of adjacent cells is known as a range of cells.

3. Define an active cell.

A cell with a dark boundary is known as active cell.

4. Can you insert a new worksheet in a workbook? If yes, tell the keyboard shortcut to insert it.

Yes a new worksheet can be inserted in a workbook.

The shortcut key to insert it is Shift + F11 key

5. How do you enter the data into an active cell using the formula bar?

We enter data into an active cell using the formula bar by clicking in the formula bar and then typing the data.

6. What do you do if you want to edit an existing entry of cell?

To edit an existing entry of cell select the cell and press F2 key. Then move the cursor to the required position and correct it. Finally press the Enter key.

7. Tell the keyboard shortcut to open a cell in edit mode.

The keyboard shortcut to open a cell in edit mode is F2 key.

8. What happens when you close the Excel application without saving it?

When we close the Excel application without saving it will notify us that the current file is not saved and ask us if we want to save the file with options Yes, No and Cancel

9. How many types of data can be entered in the cells?

Three types of data can be entered in the cells. They are Numbers or Date, Formula and Text.

10. Define the Text type of data.

Text type of data included a combination of letters, numbers and special characters.

11. Give the name of any three functions in Excel?

Name of any three functions in excel are SUM(), AVERAGE() and MAX().

12. Give an example of how the AVERAGE function is evaluated?

The AVERAGE function will sum the numbers in the specified range and then divide it by the number of numbers in the range.

13. Describe the following charts:   (a) Pie chart   (b) Line Chart   (c) Column Chart

a)  Pie chart shows the parts of the whole items that make up a data series to the sum of the items.

b) Line Chart shows trends in data at equal intervals. It is helpful for depicting the change in value over a period of time.

c) Column Chart shows data changes over a period of time or defines comparisons among individual items.

14. What is the difference between category axis and value axis?

The X-axis or horizontal axis is called Category axis while Y-axis or vertical axis is called Value axis.

15. What is the chart area and the plot area in a chart?

The total region of the chart in which the chart is defined is called Chart Area while the area of the chart in which the data is plotted is called Plot Area.

16. What is cell reference?

Cell reference is the address of a cell in a formula.

17. How do you insert a new worksheet?

A new worksheet can be inserted by pressing Shift + F11

18. Explain how the & operator works on text.

The & operator is used to concatenate two texts. Example “APS” & “ Bengdubi” will produce the result as APS Bengdubi.

19. What is the purpose of the Enter and Cancel buttons to the left of the formula bar?

The Enter button to the left of the formula bar is used to accept the data while the Cancel button is used to reject the data.

20. What is the difference between Save and Save As in Excel?

Save is used to save the changes made in the existing file while Save As is used to create a new copy to update the changes and keep the previous file as it is.

21. How are dates interpreted in Excel?

Dates can be represented in Excel as dd-mm-yyyy, dd-mm-yy, dd-m-yy, dd.m.yy, yyyy-mm-dd and dd mmm yyyy.

22. What is Excel?

Excel is a spreadsheet program which consists of data and information in the form of row and columns.

23. Give example of the Text data type in Excel and how can they be concatenated using operator of Excel?

An example of text data type in Excel is “Suman Sharma” and “Jayanta Sinha”

They can be concatenated using & operator.

24. What is Name box?

The Name box is the one which shows the address of the active cell.

25. What is a function? Give four examples.

A function is a pre-defined formula in Excel.

Four examples of functions are SUM(), AVERAGE(), MAX() and MIN().


MCQ'S

1. Which of the following consists of rows and columns?

(a) Worksheet                        (b) Title Bar                 (c) None of these

2. A cell is identified by __________

(a) A row number                   (b) A column letter     (c) A column letter followed by a row number

3. Which of the following shows you the location of an active cell?

(a) Formula bar                       (b) Status Bar              (c) Name box

4. Which of the following allows us to create a new copy of an existing file to update changes and keeps the previous one, while saving an existing file?

(a)  Save                                  (b) Copy existing                                 (c) Save As

5. What do you do to save the changes in an existing file?

(a) Use ‘Save’ button             (b) Press Ctrl+N from keyboard          (c) Use ‘Save As’ option

 6. What is the keyboard shortcut to create a new workbook?

(a) Ctrl + T keys                       (b) Ctrl + N keys                                 (c) Ctrl + M keys

 7. In Excel, a formula begins with a/an

(a)  equal to (=) sign              (b) plus (+) sign                       (c) hash (#) sign

8. What is used as a separator for numerical values in thousands, one hundred thousands, etc.?

(a) Comma                              (b) Decimal                             (c) Hash

 9. What will the following expression evaluate to, in Excel?  2+3*4+5

(a)  45                                     (b) 19                                      (c) 29

 10. What does the following expression evaluate to? (2+3)^2

(a) 24                                       (b) 11                                       (c) 25

 11. What is the name given to pre-defined formulas in Excel?

(a) Formulae                           (b) Functions                           (c) Headers

12. In which tab of the Format cells dialog box can you find the Wrap Text option?

(a)  Number                           (b) Font                                    (c) Alignment

13. What category of Number in Format cells dialog box allows changing of one time type to another?

(a) Number                             (b) Date                                   (c) Time

14. What is the first step (after making the active cell) to take to change a number into scientific format?

(a) Right-click on cell             (b) Left-click on cell                (c) Scroll with mouse

15. Which of the following is Autofill handle a part of?

(a)  Ms Word                          (b) Ms Excel                            (c) Ms Powerpoint

16. If you do not use the $ sign anywhere, what type of cell reference will it be?

(a) Relative                             (b) Mixed                                (c) Absolute

17. Which keyboard shortcut can let you quickly add a chart after the selection of range of cells?

(a) F5                                       (b) F10                                     (c) F11

18. Which of the following is arranged in groups?

(a) Ribbon                              (b) Scrollbars                           (c) Formula bar

19. Which of the following lists the location of an active cell?

(a) Quick Access toolbar         (b) Worksheet                         (c) Name Box

20. Which of the following is an example of mixed reference?

(a) A12                                                (b) $W$11                               (c) $D12

21. Which of the following will take you to the last cell containing data in the worksheet?

(a) Ctrl + Home                       (b) Ctrl + End                           (c) Ctrl + Down arrow

22. Which of the following do you press to open Save As dialog box?

(a) Ctrl + S                              (b) Alt + S                                (c) Shift + S

23. Which of the following is a keyboard shortcut to open a new workbook?

(a) Ctrl + N                              (b) Ctrl + M                             (c) Ctrl + W

24. A cell with a dark boundary is known as a/an:

(a) Inactive cell                       (b) Active cell                         (c) Working cell

25. What is the extension of a workbook saved in Excel 2010?

(a) .xls                                     (b) .xl                                       (c) .xlsx

26. What type of chart looks circular in nature?

(a) Scatter chart                      (b) Pie chart                           (c) Radar chart

27. What character does every formula start with?

(a) Equal to (=)                       (b) Colon (:)                             (c) Semicolon (:)

Popular posts from this blog

CHAPTER 1: COMMUNICATION SKILLS - I

COMMUNICATION SKILLS - I   1. What is Communication? Communication is the process of exchanging thoughts, facts and ideas between two or more people by means of verbal and non-verbal language. Or Communication is the process of transferring or sharing of information between two or more people.   2. Name the different Communication Styles (Types of communication). They are the different types of communication which can be done. It is of three types: 1.       Verbal communication 2.       Non-verbal communication 3.       Visual communication   3. What is Verbal communication? Verbal communication is the use of language to transfer/share information through speaking or writing. It is one of the most common types used during presentations, video conferences, phone calls, meetings and one-to-one conversations.   4. What are the Factors which determine the effectiveness of verbal communication? The factors which determine the effectiveness of verbal commu
Read more

CHAPTER 4: ENTREPRENEURSHIP SKILLS - I

1. What do you understand by Business? Business refers to all economic activities which are concerned with the production or purchase and sale or exchange of goods and services with the objective of earning profits. 2. Define Entrepreneurship. Entrepreneurship is the process of discovering and opportunity, mobilizing resources, launching an enterprise to exploit the opportunity and an attempt to create value.  3. What is Hybrid business? Hybrid businesses are companies that may be classified in more than one type of business.   4. What do you understand by a cooperative society? Cooperative society is the one which is organized with the purpose of rendering service to its members and to the public in general. It is organized on the principle of mutual self-help. As an incorporated association of persons, it enjoys perpetual life. It has a distinct identity and the liability of its members is limited.   5. State the roles of an Entrepreneur. The roles of an Entrepreneur
Read more

CHAPTER 6: INTRODUCTION TO IT-ITeS INDUSTRY

  C HAPTER 6: INTRODUCTION TO IT-ITeS INDUSTRY 1. Write the full form of GIGO. The full form of GIGO is Garbage In Garbage Out. 2. Expand the following:      (a) CAT                       (b) MRI (a) CAT: Computerized Axial Tomography machine (b) MRI: Magnetic Resonance Imaging 3. Explain how IT helps in Business IT helps to perform business transactions online between two people who are in different locations. Additionally online payment can also be done through debit and credit cards provided by the banks to the customers. Internet Banking can also be used in place of debit and credit cards for payment for online transactions. 4. What are the three public services which you can do on the Internet from Home? The three public services which can be done on the Internet from Home are a) Linking of Pan Card to Bank Accounts b) E-filling of Income Tax returns c) Payment of taxes 5. How does IT help in Home Computing? IT helps in Home Computing in the following w
Read more