Class 9 Exam  >  Class 9 Notes  >  Computer Applications for Class 9  >  Long Answer Type Questions: Introduction to Microsoft Excel 2016

Long Answer Type Questions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9 PDF Download

Q.1. State the process of deleting an entire row in Excel.

You can delete a row in a worksheet by a simple right click on the row heading and from the popup menu that appears click on the Delete option.


Q.2. State the process of formatting a group of numbers in Excel, so that it displays two digits after the decimal.

The method involves the following steps:

  • Select a cell or range of cells.
  • Right-click on the selected cells and from the popup menu that appears click on Format Cells... option. This makes the Format Cells dialog open.
  • Click on the Number tab and from the Category list click on Number.
  • Use the Decimal places box to specify the number of decimal places (e.g., if the number in the cell is 13.5 for 2 decimal places it displays 13.50, 3 decimal places would display 13.500). Click on Use 1000 Separator checkbox to specify the position of comma(,) in a given number.
  • Click the OK button.


Q.3. State the process of formatting the appearance of Time in a cell.

To Format the Appearance of Time in a Cell:

  • Select the range of cells you want to format.
  • Right-click and click on the Format Cells option to activate the Format Cells dialog box and click on the Number Tab.
  • Click Time in the Category list box and select the desired time format from the Type: list box.
  • Click the OK button.


Q.4. Explain the following options of the Insert dialog in Excel.
(i) Shift cells right
(ii) Shift cells down
(iii) Entire row
(iv) Entire column

(i) Shift cells right option to move the contents of the selected cell to the right when a cell is inserted.

(ii)  Shift cells down option to move the contents of the selected cell downward when a cell is inserted.

(iii) Entire row option to insert an entire row. The content of the original row is moved downward.

(iv) Entire column option to insert an entire column. The content of the original column is shifted to the right.


Q.5. State the process of changing the font colour of a group of entries in Excel.

To change the font colour:

  • Select a cell or range of cells.
  • From the Font Colour drop-down list select the desired colour. The default font colour in Excel is black.
The document Long Answer Type Questions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9 is a part of the Class 9 Course Computer Applications for Class 9.
All you need of Class 9 at this link: Class 9
62 videos|66 docs|14 tests

Top Courses for Class 9

62 videos|66 docs|14 tests
Download as PDF
Explore Courses for Class 9 exam

Top Courses for Class 9

Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
10M+ students study on EduRev
Related Searches

Extra Questions

,

Sample Paper

,

study material

,

Important questions

,

Long Answer Type Questions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9

,

video lectures

,

practice quizzes

,

Exam

,

Summary

,

Long Answer Type Questions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9

,

ppt

,

Viva Questions

,

mock tests for examination

,

Free

,

pdf

,

Semester Notes

,

Objective type Questions

,

past year papers

,

Long Answer Type Questions: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9

,

shortcuts and tricks

,

Previous Year Questions with Solutions

,

MCQs

;