ADVANCED EXCEL CHARTS QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 which element of a worksheet can be protected from accidental modification Contents Objects Scenarios All of the above This is the rectangular area bounded by the category and value axes. Plot area Category axis Data point Data point What term refers to a specific set of values saved with the workbook? Range Scenario Trend line What-if analysis Data graphed as slices of a circular area is a Bar chart Scatter chart Pie chart Column 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 A features that displays only the data in column(s) according to specified criteria Formula Sorting Filtering Pivot A visual representation of worksheet data. Column Data Chart Legend A function inside other function is called Nested function Round function Inner function None of the above What are the tabs that appear at the bottom of each workbook called? Reference tabs Position tabs Location tabs Sheet tabs Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? Rows and columns Headings Speed None Part of a pie chart that represents one value from the series. Axis Data Slice 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 What is the keyboard shortcut for creating a chart from the selected cell range? F2 F4 F8 F11 What type of chart is useful for comparing values over categories? Pie Chart Column Chart Line Chart Dot Graph Part of a pie chart that represents one value from the series. Axis Data Slice Chart This is an optional for the chart’s categories Category title legend graph title embedded 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 type of chart is useful for showing trends or changes over time Pie chart Column chart Line chart Dot chart Data graphed as slices of a circular area is a Bar chart Scatter chart Pie chart Column chart Corresponds to the category labels in a pie chart and series names in other charts Plot area Legend Gridlines Slice When you insert as Excel file into a word document, the data are Hyperlinked Placed in a word table Linked Embedded In MS-Excel Comments put in cells are called Smart tip Cell tip Web tip None of these This is the rectangular area bounded by the category and value axes. Plot area Category axis Data point Data point Shows the values on the chart. Excels creates a range of values based on the data Row headings Gridlines Category axis Value axis In MS-Excel value used in a formula that does not change is called a Cell address Constant Function None of these 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 A chart that displays on the same worksheet as the data graph Value axis Gridline Embedded chart This is the background for the chart. It can be filled with a color or pattern Chart title Chart area Background Fill We can check the conditions against______ when applying conditional formatting Cell value Formula Both of the above None of the above All worksheet formula Manipulate values Manipulate labels Return a formula result Use the addition operator Previous Next Total Question16 Wrong Answer13 Right Answer13
