M S EXCEL 15 FEB 2023

 

1.  What is the intersection of a column and a row on a worksheet called?

a.  Column

b.  Value

c.  Address

d.  Cell

2.  What type of chart is useful for comparing values over categories ?

a.           Pie

b.          Line

c.            Dot

d.          Column

3.          Which function in Excel tells how many numeric entries are there?

a.  NUM b.SUM c.Count d.none

 

4.          What type of chart is useful for showing trends or changes over time?

a.           Pie

b.          Line

c.            Dot

d.          Column

 

5.          The ____ feature of MS Excel quickly completes a series of data

a.  Autofill b.auto complete

c. filtering         d. sorting

   6. What type of chart is useful   for comparing parts of a whole ?

a.           Pie

b.          Line

c.            Dot

d.          Column

 

7.  What do you use to create a chart?

a.           Excel wizard

b.           Chart wizard

c.            Pie wizard

d.           Data wizard

8.  What type of chart is good for single series of data ?

a.   Pie b. dot c. line d column

9.            How many sheets are there, by default, when we create a new Excel file ?

a.3   b 5   c 10  d 4

10.    The shortcut key to insert new slide is

a.  Ctrl+N b. Ctrl+M  c. alt+m  d. alt+n


A. Tick () the correct options.

 1. A worksheet consists of:

 a. Rows and columns () 

b. Cells and rows ( ) 

 c. Columns only ( ) 

2. A cell with a dark green border is called: 

a. Selected cell ( ) 

 b. Active cell () 

 c. Bordered cell ( )

 3. In Excel, you can create and maintain the data in: 

a. Column format ( ) 

 b. Tabular format () 

 c. Rows format ( )

 4. Spreadsheet is also known as: 

a. Document ( ) 

 b. Worksheet () 

 c. Cells sheets ( ) 

5. The shortcut key to save a file is: 

a. Ctrl + S () 

b. Alt +S ( )

 c. Shift + A ( ) 

Q CELL- Intersection of a row and a column in a worksheet is called a cell. Each cell has a unique address which is made up of combination of a column letter and row number, e.g. A1, B3, C4, etc. You enter the data in cells.

Q What is Formula bar? Ans. Formula bar is located next to the Name box. It shows the data or formula of the active cells and allows you to enter and manipulate the active cell data and formula.

Q Define the Name box. Ans. Name box displays the cell reference (address) of the active cell. For example, A1

Q What do you mean by a ‘range of cells’? Ans. A group of adjacent cells is referred to as range of cells. To select a range of cells, we can click on a cell and drag the mouse over the remaining cells. Or click on the cell where selection is to be started, then, press and hold down the Shift key and click on the cell where the selection is to be finished

Q What is Excel? Explain any five tasks that you can do in Excel. Ans. Excel is very popular spreadsheet program. It allows you to create and maintain the data in tabular format. Excel is commonly used for storing, structuring and manipulating the numerical values or information, called data, in the form of rows and columns. The five tasks that we can do in excel are: 

 Excel allows us to create worksheets, much like paper ledgers, that can perform automatic calculations.

 Each Excel file is a workbook that can hold many worksheets. 

 Quick data entry can be done easily using Auto Fill option. 

 Data can be viewed in graphical form such as charts. 

 Excel provides us the facility of sorting and filtering large amount of data, which will save our time and make our spreadsheet more effective and attractive



Comments

Post a Comment

Popular posts from this blog

Internet chap 1

 1. Internet- Internet is a global network of computer networks that enables information to be exchanged. In internet, most computers are not connected directly to the internet. Rather they are connected to smaller networks, which in turn are connected through gateways to the internet backbone. Internet is not governed by any particular body. It is coordinated by many volunteer organizations.  2. Advantages of Internet-  • Greater access to information reduces research times.  • Useful communication links  • Global reach enables one to connect to anyone on the internet.  • Easy communication with other people.  • Publishing documents on the internet saves paper.  3. Disadvantages of Internet-  • Cyber frauds may take place involving credit/debit card numbers and details.  • Computer viruses get downloaded and spread across machines connected to networks and have detrimental effects. World Wide Web (WWW) - www is a set of progra...
Read more

CLASS IX 9 FEB 2023

Write down the name and purpose of various components of a chart. Answer: Various components or parts of chart are as follows: X-axis Refers to a horizontal axis, which is also known as category axis. Y-axis Refers to a vertical axis also known as value axis. X-axis title Conveys the full details of the X-axis values. Y-axis title Conveys the full details of the Y-axis values. Data series Refers to a set of data that you want to display in a chart. Chart area Refers to the total space that is enclosed by a chart. Plot area Refers to the main region of the chart in which your data is plotted. Chart title Denotes the type of data plotted in a chart. Legend In a chart showing different data series, a unique color or pattern is assigned to each data series. This unique color of pattern is known as a legend. Gridlines These are the horizontal and vertical lines within the plot area in a chart. Explain the concept of cell referencing along with its various types. Answer: Excel supports thr...
Read more

Computer Applications Class IX Types of Software (Chap 3)

Image
 HARDWARE- Hardware represents the physical and tangible components of the computer i.e. the components that can be seen and touched. Input devices, output devices, CPU, floppy disk, hard disk, CD, DVD etc. are examples of computer hardware.  ● SOFTWARE- software represents the set of programs that govern the operation of computer system and make the hardware run.  ● SOFTWARE can be classified broadly into two categories.  1. System Software- refers to the programs that control internal computer operations and make best use of the hardware. The system software can further be classified into following categories: Operating system Language processor Utilities or Utility Software  2. Application Software- is the set of programs necessary to carry out operations for a specified application. These are the programs written by programmers to enable computer to perform a specific task such as processing words, inventory control, handling calculations and figures, medica...
Read more