Apply pre-defined layout to the range of cells by using___________.
Formatting
Conditional Format
Auto Format
Sort & Filter
________combine two or more cells in a spreadsheet and to centres the content of the new cell.
Merge and center
Left Align
Center
Auto format
_______chart emphasizes the change of magnitude over time.
Line chart
Area chart
Pie chart
Surface chart
To apply Auto format ,the step is:
Select the cell ---------Format-----Autoformat
Select the cell------Autoformat
Select the cell--------Format----conditional format
Format--------Autoformat
To filter a range ,follow the steps:
Click the cell-----Data-----Filter-----Autofilter
Click the cell-----Filter-----Autofilter
Click the cell-----Window----Autofilter
Click the cell-----Tools----Filter----Autofilter
_________represent the horizontal axis of the chart.
X axis
Y axis
Z axis
V axis
_________chart compares different values present in a worksheet.
Column chart
Bar chart
__________is used to select various objects in a chart.
Chart type
Chart object
Data table
Chart wizard
__________displays the group of rows and columns to be plottted on the chart.
Legend
Data series
Chart area
To align the cell content to left click on _______button.
