Class-X-Solved Exercise:
Unit-8 Spreadsheet (Intermediate)
Session-6 Manage Workbook Views
Session-7 Apply Cell and Range Names
I. Objective Type Questions:
1. Fill in the blanks:
a. Different types of views are available under _____ group in the view tab.
Answer: Workbook view
b. In __________ view, we can enter and edit data.
Answer: Normal
c. In _________ view, we can view number of pages in a worksheet.
Answer: Page layout
d. The ____ helps you to view a selected area of a workbook.
Answer: Print area
e. Name assigned to particular cells in a worksheet is called as ________.
Answer: Range name
f. The Define name option is available under ____ group in the _____tab.
Answer: Define Names, formulas
2. Write 'T' for true and 'F' for false:
a. Arrange has an address called as range address.
Answer: T
b. A1-B3 is an example of range address.
Answer: T
c. Full screen view removes ribbon, toolbars, etc. from display.
Answer: T
d. Page break preview helps to know the contents of a Printed page.
Answer: T
e. Custom view allows to save changes to current position and allows to change row height, frozen panes etc.
Answer: T
II. Multiple choice questions. Tick the correct answer:
1. If you want to check the print settings of a worksheet, which view, you will use out of the following?
a. page layout b. normal c. print preview d. page break
Answer: Print preview
2. A group of cells in excel is called as
a. label b. column c. workbook d. range
Answer: Range
3. When you start to select a range of cells, you see a thick white cross shaped pointer called as : a. cell selector b. cell cross c. range selector d. selection pointer
Answer: Selection pointer
III. Short Answer Questions:
1. List the different view available in excel 2007.
Answer: Excel provides five different types of views of a worksheet which are helpful for reading, editing, formatting and doing print settings of a worksheet.
1. Normal view
2. Page layout view
3. Page break view
4. Custom view
5. Full screen view
2. What is the importance of page layout view?
Answer: The page layout view allows you to view the way a page will look on paper before you print it out. It is helpful for the addition of headers and footnotes.
3. How will you exit from the full screen view?
Answer: To exit full screen, simply right click on your mouse, and click on close full screen.
4. What is range name?
Answer: Range name is a descriptive name assigned to a cell or cell range in excel 2007 to help make formulas in your worksheets much easier to understand and maintain.
5. List any three rules you should follow while naming a cell or cell range.
Answer: There are three rules you should follow while naming a cell or cell range.
1. The first character must be a letter, an underscore, or a backslash.
2. Non spaces are allowed in a range name.
3. Do not use a name that is the same as a cell address. For example, you can't name a range U2 or UB40, but Blink 182 and ABBA are just fine.
Some other links:
No comments:
Post a Comment