Question

Ealborate the 5 type of views available in a spreadsheet.

Class 10..
Answer it fast..
Don't spam..​

Answer 1

Answer:

View tab contains 5 groups:-

 

 

a)    Workbook Views: -Excel offers 4 types of workbook views: - Normal, Page break preview, Page layout & Custom View. We use “Normal” option to see the normal view of Excel.

 

b)    Show: - We use this option to show and hide the Excel’s view. Ruler is used to show the rulers next to our documents.

 

c)    Zoom: -We can adjust the view as per our convenience. Zoom 100% is the standard view for viewing the Excel file. We use Zoom to selection to zoom the sheet so the selected range of cells fills the entire window.

 

d)    Window: -We use this option to access the window options. New window is used to open the same document in the new window, and we can perform in the both windows and thus both documents will get updated. Arrange all option helps us to stack the already opened window so that we can see all of them at once. Freeze Panes option is very useful for viewing vast data with the headers or we can use it to mark the comparison. Its usage always depends on requirement. Split option is used to divide the window into different panes such that each scrolls separately. Hide option is used to hide the current window.

 

e)    Macros: -With this option, we can record the macro.

Answer 2

There are various spreadsheet views that can be used to present our data in various ways:

• Normal view: Data entry and editing are done in a spreadsheet's normal view, which is the default view.
• Page Break Preview: It is used to inspect and modify page breaks for printing using the page break preview view.
• Page Layout View: This view shows the spreadsheet's margins, page breaks, and page orientation as they will appear when printed.
• Custom Views - With this view, it is used to design and preserve a unique look at a particular area of a spreadsheet, down to the number of rows and columns and the position of the data.

#SPJ3