COMPUTER

• Plot area – The area defined by the Xand Y axis of a chart.
• Input – Data entered in a worksheet.
• Output – Information designed togenerate.
• Portrait - is useful for worksheets that need to fit more rows into one page.
• Landscape - is useful for worksheets that need to fitmore columns into one page.
• Page Break - shows a preview of the pages to be printed.
• Auto Fill – It creates a series of entries based on the data you enter in one or two cells.
• Auto Filter – It enables you to temporarily hide everything in a table except the records you specifically want to view, based on the criteria you specify
• Cell Styles are a combination of fill and font color designed to highlight and to emphasize cell contents in your workbook.
• Cell Merge - converts selected cells into a single cell
• Wrap Text - is used when the text appears in a single cell and you want to increase the height of the cell without expanding the row or column.
• Sorting - is a task that allows you to change or arrange the order of your spreadsheet data.
• A Chart is a graphical presentation of your data.
• Gap Width – The value that controls the spaces between cluster of columns or bars, the higher the gap width value, the larger the space between clusters of data markers.
• Gridline – Lines across plot area foreasy reference back to axes
• Column Chart - It is one of the most commonly used chart type
• Line Chart - It is used to plot data changes in a period of time.
• Pie Chart - It is used to emphasize a significant element in your data
• Pie Chart - They usually show percentages subdivided into slices representing data values
• Pie Chart also known as Circle Graph
• Bar graphs - are most often used to show amounts or the number of times a value occurs.
• Area Chart - It displays the magnitude of change over time, and can be used to draw attention to the total value across a trend. It can also be used to show relationship of parts to a whole.
• Stock Chart - is used to illustrate the fluctuation of stock prices.
• Surface Chart - shows a three-dimensional surface that connects a set of data points
• Doughnut Chart is like a pie chart, a doughnut chartshows the relationship of parts to a whole, but it can containmore than one data series.
• Bubble Chart data is arranged in columns on a worksheet, so that x values are listed in the first column andcorresponding y values and bubble size values are listed inadjacent columns. This is how the values are plotted in a bubblechart.
• Radar Chart compares the aggregate values of several data series
• Sparklines are mini charts that fit into a single cell