DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Paste row data into a column
|
|
Rearrange data in a range of cells
|
|
Change the orientation of axes in a chart
|
|
Toggle Axis Titles off and on
|
|
None
|
Detailed explanation-1: -After you switch rows to columns in the chart, the columns of data are plotted on the vertical axis, and the rows of data are plotted on the horizontal axis. However, you can quickly change the way that worksheet rows and columns are plotted in the chart by switching rows to columns or vice versa.
Detailed explanation-2: -Select the worksheet with your chart for printing. Go to the Page Layout tab and click on the arrow under the Orientation icon. Pick the Landscape option.
Detailed explanation-3: -On the Format tab, in the Current Selection group, click Format Selection. In the Format Axis dialog box, click Alignment. Under Text layout, do one or more of the following: In the Vertical alignment box, click the vertical alignment position that you want.