ADVANCED EXCEL CHARTS QUIZ DESCRIPTION Total Questions −30 00 Max Time − 15:00 A chart can be moved to a separate sheet. True False Shows the values on the chart. Excels creates a range of values based on the data Row headings Gridlines Category axis Value axis All worksheet formula Manipulate values Manipulate labels Return a formula result Use the addition operator The programming language in which Excel records the macro code is? Basic Visual basic Video Basic Basic2 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 A function inside other function is called Nested function Round function Inner function None of the above A features that displays only the data in column(s) according to specified criteria Formula Sorting Filtering Pivot 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 We can check the conditions against______ when applying conditional formatting Cell value Formula Both of the above None of the above What type of chart is useful for showing trends or changes over time Pie chart Column chart Line chart Dot chart This is an optional title or name for the chart Plot area Category title Chart title Heading Part of a pie chart that represents one value from the series. Axis Data Slice Chart Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? Rows and columns Headings Speed None This is an optional for the chart’s categories Category title legend graph title embedded chart In MS-Excel Comments put in cells are called Smart tip Cell tip Web tip None of these A visual representation of worksheet data. Column Data Chart Legend This describes what is charted. It can be places above or below the chart. Chart title Chart area Bar chart Pie chart 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 Comments puts in cells re called? Smart tip Cell tip Web tip Sort tip Once a type of graph is chosen, it cannot be changes True False This is the rectangular area bounded by the category and value axes. Plot area Category axis Data point Data point What type of chart is good for single series of data? Column Chart Line Chart Pie Chart Cone Chart What type of chart is useful for comparing values over categories? Pie Chart Column Chart Line Chart Dot Graph What are the tabs that appear at the bottom of each workbook called? Reference tabs Position tabs Location tabs Sheet tabs The next line in MS-Excel below the toolbar area is called Title bar Status bar Formula bar Menu bar 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 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 What is the keyboard shortcut for creating a chart from the selected cell range? F2 F4 F8 F11 Previous Next Total Question16 Wrong Answer13 Right Answer13
