ADVANCED EXCEL CHARTS QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 This is an optional for the chart’s categories Category title legend graph title embedded 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 Part of a pie chart that represents one value from the series. Axis Data Slice Chart This is created from the row or columns headings in the data. A category describes what is shown in the chart Category axis Data series Value axis Data marker What type of chart will you use to compare performance of sales of two products? Column chart Line chart Pie chart Both A and B What term refers to a specific set of values saved with the workbook? Range Scenario Trend line What-if analysis 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 This is an optional title or name for the chart Plot area Category title Chart title Heading We can check the conditions against______ when applying conditional formatting Cell value Formula Both of the above None of the above This is the rectangular area bounded by the category and value axes. Plot area Category axis Data point Data point How will you graphically represent expenditure in different departments ? Column Chart Line Chart Pie Chart Dot Chart What is the keyboard shortcut for creating a chart from the selected cell range? F2 F4 F8 F11 You can merge the main document with data source in Excel. In mail merge operation, Word is usually Server Source Client None Corresponds to the category labels in a pie chart and series names in other charts Plot area Legend Gridlines Slice Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? Rows and columns Headings Speed None What type of chart is good for single series of data? Column Chart Line Chart Pie Chart Cone Chart Data graphed as slices of a circular area is a Bar chart Scatter chart Pie chart Column chart What do you call the chart that slows the proportions of how one or more data elements relate to another data element. XY chart Line chart Pie chart Column chart This describes what is charted. It can be places above or below the chart. Chart title Chart area Bar chart Pie chart Which would you choose to create a bar diagram? Edit, chart Insert, chart Tools, chart Format, chart What type of chart is useful for comparing values over categories? Pie Chart Column Chart Line Chart Dot Graph 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 The programming language in which Excel records the macro code is? Basic Visual basic Video Basic Basic2 This is an optional for the chart’s categories Category title legend graph title embedded chart Data graphed as slices of a circular area is a Bar chart Scatter chart Pie chart Column chart This is the rectangular area bounded by the category and value axes. Plot area Category axis Data point Data point When you insert as Excel file into a word document, the data are Hyperlinked Placed in a word table Linked Embedded A chart can be moved to a separate sheet. True False A visual representation of worksheet data. Column Data Chart Legend 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 Previous Next Total Question16 Wrong Answer13 Right Answer13
