ADVANCED EXCEL CHARTS QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 Data graphed as slices of a circular area is a Bar chart Scatter chart Pie chart Column chart When charts are pasted into a word file, they are no longer linked to the excel chart. True False It depends how the chart is pasted What type of chart is useful for showing trends or changes over time Pie chart Column chart Line chart Dot chart This is an object that explains the symbols, patterns, or colors used to differentiate the series in the chart. Category axis Dictionary Embedded chart Legend Shows the values on the chart. Excels creates a range of values based on the data Row headings Gridlines Category axis Value axis This describes what is charted. It can be places above or below the chart. Chart title Chart area Bar chart Pie chart What type of chart will you use to compare performance of two employees in the year 2016 Column chart Line chart Pie chart Dot chart In MS-Excel value used in a formula that does not change is called a Cell address Constant Function None of these Comments puts in cells re called? Smart tip Cell tip Web tip Sort tip You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source Client None A function inside other function is called Nested function Round function Inner function None of the above which element of a worksheet can be protected from accidental modification Contents Objects Scenarios All of the above A chart that displays on the same worksheet as the data graph Value axis Gridline Embedded chart The part of the chart area that displays data. Legend Axis Series Plot area When you insert as Excel file into a word document, the data are Hyperlinked Placed in a word table Linked Embedded What type of chart is useful for comparing values over categories? Pie Chart Column Chart Line Chart Dot Graph All worksheet formula Manipulate values Manipulate labels Return a formula result Use the addition operator Data graphed as slices of a circular area is a Bar chart Scatter chart Pie chart Column chart A chart can be moved to a separate sheet. True False Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? Rows and columns Headings Speed None The part of the chart area that displays data. Legend Axis Series Plot area How will you graphically represent expenditure in different departments ? Column Chart Line Chart Pie Chart Dot Chart A features that displays only the data in column(s) according to specified criteria Formula Sorting Filtering Pivot This is an optional for the chart’s categories Category title legend graph title embedded chart Once a type of graph is chosen, it cannot be changes True False This is an optional title or name for the chart Plot area Category title Chart title Heading You want to track the progress of the stock market on a daily basis. Which type of chart you use? Pie chart Row chart Line chart Column chart When you insert an excel file into a word document. The data are Hyperlinked placed in a word table Linked Embedded Use the word menu bar and tool bars What is the keyboard shortcut for creating a chart from the selected cell range? F2 F4 F8 F11 Once you have created a chart you cannot add another data series. True False Previous Next Total Question16 Wrong Answer13 Right Answer13
