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:

  1. X-axis Refers to a horizontal axis, which is also known as category axis.
  2. Y-axis Refers to a vertical axis also known as value axis.
  3. X-axis title Conveys the full details of the X-axis values.
  4. Y-axis title Conveys the full details of the Y-axis values.
  5. Data series Refers to a set of data that you want to display in a chart.
  6. Chart area Refers to the total space that is enclosed by a chart.
  7. Plot area Refers to the main region of the chart in which your data is plotted.
  8. Chart title Denotes the type of data plotted in a chart.
  9. 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.
  10. 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 three types of cell referencing, which are as follows:

1.    Relative Every relative cell reference in formula automatically changes when the formula is copied down a column or across a row. As the example illustrated here shows, when the formula is entered (= B4 — C4) in Cell D4 then this formula copied in D5 then it will change into (= B5 — C5) related to cell.

2.    Absolute An absolute cell reference is fixed. Absolute references do not change if you copy a formula from one cell to another. Absolute references have dollar sign ($) like $S$9. As the shows, when the formula =C4*$D$9 is copied from row, the absolute cell reference remains as $D$9. ‘

3.    Mixed A mixed cell reference has either an absolute column and a relative row, or an absolute row and a relative column, e.g. $A1 is an absolute reference to column A and a relative reference to row 1. As a mixed reference is copied from one cell to another, the absolute reference stays the same but the relative reference changes.

 



Question 1:  Name any four basic elements of a slide.

 Answer:  The four basic elements of a slide are as follows:

1. Titles

2. Subtitles

3. Drawing objects

 4. ClipArt

Question

2:  How many views of a slide PowerPoint provided?

 Answer:  There are six views of a PowerPoint presentation:

1. Normal view

2. Outline view

 3. Notes Page view

 4. Slide Show

 5. Slide Sorter view

 6. Master view

 

Question 3:  State three functions of the Slides Pane. 

Answer:  Three functions of the Slides Pane are as follows: .

 1. New slides may be added to the presentation.

2. Allows marking a slide as hidden for not showing it during a slide show.

3. Deleting a slide from the presentation in case it is no longer needed.

Question 4:  Write three functions that can be performed in Slide Sorter view of a presentation. 

Answer:  The three functions that can be performed in Slide Sorter view are as follows:

 1. We can see the entire presentation.

2. We can move slide from one place to another using click-drag method. Also, we can rearrange the order of slides.

3. We can insert, rename and delete slides.

Question 5:  How are Header and Footer useful? 

Answer:  Header and Footer are very useful for displaying the similar useful information on each slide. One can change the Header and Footer details at any time in the presentation.

Question 6:  Explain the various views of a slide available in PowerPoint 2007.

 Answer:  In Microsoft Office PowerPoint, different views of a slide are used to edit, print and deliver a presentation.

Different types of views available in PowerPoint 2007 are explained below: 

1. Normal View: This is the main editing view, where you write and design your presentations, i.e. actual screen which is displayed. The view is also known as Slide view. A Normal view is the default view size for the screen. 

2. Slide Sorter View: It provides a view of slides in thumbnail form. This view makes it easy to sort and organize the sequence of the slides at the time of creating presentation and also, at the time of preparing presentation for printing. 

3. Notes Page View: In the Notes Page view, the notes pane is located just below the slide pane. Here, notes that apply to the current slide can be typed. Later, these notes can be printed and referred while giving actual presentation. Notes can also be printed to handout to the audience or included in a presentation that is delivered to the audience or posted on a Web page. 

4. Slide Show View: This is used to deliver a presentation to the audience. Slide Show view takes up the full computer screen, like an actual presentation. In this view, you can see your presentation, the way audience wants. This view enables you to see how graphics, timings, movies, animated effects and transition effects will look during the actual presentation. To exit Slide Show view, press Esc key from the keyboard.

 5. Master View: The Master views include Slide view, Handout view and Notes view. They are the main slides that store information about the presentation, including background color, fonts effects, placeholder sizes and positions. The key benefit to working in a Master view is that on the Slide Master, Notes Master, or Handout Master, you can make universal style changes to every slide, notes page, or handout associated with the presentation.



1 MS Excel stands for ___________

A. Micromax Excel

B. Management Excel

C. Microsoft Excel

D. Microsoft Excess

2. MS Excel is a ________.

A. Database Management software

B. Presentation software

C. Workbook software

D. Spreadsheet software

3. ________is the best alternative to MS Excel offered by Google Inc.

A. Google Slides

B. Google Sheets

C. Google Files

D. Google Keep

4. Free online version of MS excel is known as ________

A. Office for the web

B. Excel Mobile

C. Word Mobile

D. Excel for the web

5 MS Excel 2019 has row limit of __________

A. 1,048,576

B. 4,81,0576

C. 16384

D. 1,57,648

6 Microsoft Excel was first time launched in ______ by the Microsoft Corporation

A. 1985

B. 1991

C. 1995

D. 1998

7 Formulas in Excel start with ________

A. /

B. f

C. –

D. =

8 A file that contains one or more worksheets to organize data is known as _______

A. Workbook

B. Excelbook

C. Datasheet

D. Spreadsheet

9. How cells are named in ms excel?

A. using rename option

B. using name box

C. simply double click on sheet name

D. simply double click on cell and name it

10. The intersection of a column and a row in MS Excel worksheet is known as _______

A. Row

B. Cell

C. Column

D. Tab

11 In Microsoft Excel spreadsheets, rows are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

12 In Microsoft Excel spreadsheets, COLUMNS are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

13 In Microsoft Excel spreadsheets, CELLS are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

14. ___________ is a collection of cells organized in rows and columns where you keep and manipulate the data.

A. Workbook

B. Worksheet

C. Spreadsheet

D. ARRAY

15. _________function in MS Excel worksheet represents the total number(s) of entries in the cell(s).

A. SUM

B. AVG

C. COUNT

D. TOTAL

16 What is the extension of a Microsoft Excel file?

  1. msxcl
  2. xcl
  3. xlsx
  4. xlsm

17  What is the default file name of Microsoft Excel file?

  1. Workbook.xlsx
  2. Workbook1.xlsx
  3. Worksheet.xlsx
  4. Worksheet1.xlsx

18. Microsoft Excel is used for?

  1. Analysis
  2. Data Entry
  3. Data Management
  4. Accounting
  5. Budgeting
  6. All of the above

19 What is the collection of worksheets called?

    1. Ledger
    2. Book
    3. Testbook
    4. Workbook

20.The total number of columns in a worksheet?

  1. 26
  2. 256
  3. 12,834
  4. 16,384
https://sscstudy.com/ccc-questions-future-skill-and-cyber-security/

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

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