Class 9 Exam  >  Class 9 Notes  >  Computer Applications for Class 9  >  Worksheet: Introduction to Microsoft Excel 2016

Worksheet: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9 PDF Download

Q.1. Fill in the blanks with the given words.

(i) In a cell you can have either a ______ or/and  ______ alignment.
(ii) To default name of an Excel workbook is  ______.
(iii) The ______ is the last column name in Excel.
(iv) A ______ is a file in which data in kept in worksheets.
(v)  ______ refers to a location of a cell which is the column name followed by row number.
(vi) Use the keyboard combination ______ to activate Format Cells.
(vii) An intersection point of a row and a column is called a ______.
(viii) By default text is aligned to the ______ and numbers are aligned to the ______.
(ix) The ______ group of the Home Tab contains the Fill command.
(x) Shift cells up option of the Delete dialog is used to fill the space produced by the ______ cell with the cell underneath it.

Q.2. State whether the following statements are True (T) or False (F).
(i) The default name for a worksheet in Excel is Sheet1.
(ii) The address of a cell is referred by the row number followed by the column number.
(iii) You can have maximum 10000 rows in an Excel worksheet.
(iv) An Excel worksheet there are maximum 1028 columns.
(v) A cell range is used to represent a group of cells.
(vi)  An Active Cell always have a thick border around it.
(vii) The Function Key F3 is used for direct cell editing.
(viii) It is not possible to select an entire worksheet at the click of a button.
(ix) The Name Box is used to show the address of the current selection or active cell in the form of Column and Row Headings.
(x) The content of a row or column cannot be deleted.

You can access the solutions to this worksheet here.

The document Worksheet: 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
61 videos|66 docs|14 tests

FAQs on Worksheet: Introduction to Microsoft Excel 2016 - Computer Applications for Class 9

1. What is Microsoft Excel 2016 and what are its primary uses?
Ans.Microsoft Excel 2016 is a spreadsheet application developed by Microsoft that allows users to organize, format, and calculate data with formulas using a system of rows and columns. It is widely used for data analysis, financial forecasting, and creating charts and graphs for visual representation of data.
2. How can I create a basic formula in Excel 2016?
Ans.To create a basic formula in Excel 2016, start by selecting the cell where you want the result to appear. Type the equals sign (=) followed by the formula you want to use, such as =A1+B1 to add the values in cells A1 and B1. Press Enter to calculate the result.
3. What are the different types of charts available in Excel 2016?
Ans.Excel 2016 offers various types of charts, including column charts, line charts, pie charts, bar charts, area charts, scatter plots, and more. Each type serves a different purpose and can be used to visualize data in different ways, helping to analyze trends and patterns.
4. How do I format cells in Excel 2016?
Ans.To format cells in Excel 2016, select the cells you want to format, right-click, and choose 'Format Cells' from the context menu. You can then change the number format, font style, cell border, and fill color according to your preferences to enhance the appearance of your data.
5. What is the purpose of using functions in Excel 2016?
Ans.Functions in Excel 2016 are predefined formulas that perform specific calculations and operations on data. They simplify complex calculations, enhance productivity, and minimize errors. Common functions include SUM, AVERAGE, VLOOKUP, and IF, which help users analyze and manipulate data effectively.
Related Searches

Viva Questions

,

ppt

,

mock tests for examination

,

Extra Questions

,

Free

,

Previous Year Questions with Solutions

,

Important questions

,

past year papers

,

practice quizzes

,

Worksheet: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9

,

Sample Paper

,

Worksheet: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9

,

MCQs

,

pdf

,

Exam

,

Summary

,

study material

,

shortcuts and tricks

,

Objective type Questions

,

Semester Notes

,

video lectures

,

Worksheet: Introduction to Microsoft Excel 2016 | Computer Applications for Class 9

;