FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What tab do you need to go to change the orientation of a worksheet?
A
Page Layout
B
Format
C
Home
D
Insert
Explanation: 

Detailed explanation-1: -On the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.

Detailed explanation-2: -On the Design tab, in the Chart Layouts group, click the chart layout that you want to use. Note: When the Excel window is reduced in size, chart layouts will be available in the Quick Layout gallery in the Chart Layouts group.

Detailed explanation-3: -There are two kinds of page orientation options in MS Excel; Portrait and Landscape. Portrait orients the page vertically while Landscape orients the page horizontally. Worksheets with a lot of columns benefit from landscape mode, whereas worksheets with a lot of rows benefit from portrait mode.

Detailed explanation-4: -To view a page in Page Layout View, first you need to click the worksheet that you want to change in this view and then on the ‘View’ tab click ‘Page Layout View’ which is found under the ‘Views’ group.

Detailed explanation-5: -Windows Excel: Go to File > Options > Advanced. Go to After pressing Enter, move selection and use Direction arrow to choose a direction. Mac Excel: Go to Excel > Preferences > Edit. Go to After pressing Enter, move selection and use Direction arrow to choose a direction.

There is 1 question to complete.