Practice Test

Q1) When data is filtered, it is also sorted in ascending order. Show Answer

Q2) The AutoFilter command adds drop-down arrows to header rows. Show Answer

Q3) Once drop-down arrows are added to the header row, they cannot be removed. Show Answer

Q4) A graph can be created only through the Insert -> Chart option. Show Answer

Q5) No modifications can be made to a chart. Show Answer

Q6) The chart wizard can create new charts as well as modify existing charts. Show Answer

Q7) If the data values in a table are changed, the chart also changes. Show Answer

Q8) A chart cannot be moved around on a worksheet. Show Answer

Q9) The Legend on a chart can be removed. Show Answer

Q10) A pie chart can be drawn only from a single data series. Show Answer

Q11) The most appropriate form of chart for continuous data is the line chart. Show Answer

Q12) To plot chart based on two columns, the two columns must necessarily be adjacent to each other. Show Answer

Q13) Any number of data series can be used to plot a bar chart. Show Answer

Q14) All types of charts can be created through the Chart Wizard. Show Answer

Q15) When plotting a chart, the labels for the data should not be selected as they are not numeric data. Show Answer

Q16) Embedded charts can be created directly on a worksheet. Show Answer

Q17) Solver and Goal Seek are used for the same purpose in Excel. Show Answer

Q18) A macro can be used to automate the creation of a chart. Show Answer

Q19) Once a macro is created it cannot be modified. Show Answer

Q20) Goal Seek is the process of finding the point where costs equal revenue. Show Answer

Q21) Solver problems are limited to a single changing cell. Show Answer

Q22) A Scenario uses changing cells. Show Answer

Q23) Scenarios allow more than one variable to be changed at a time and automatically generate a two-variable data table. Show Answer

Q24) Auto Filter feature allows the user to : Show Answer

Q25) Which types of charts can Excel produce? Show Answer

Q26) The chart wizard Show Answer

Q27) What chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values? Show Answer

Q28) Using the F11 shortcut key to create a chart on chart sheet creates Show Answer

Q29) When two or more values have to be determined, which data analysis tool is used? Show Answer

Q30) Which of the following tool you will use in Excel to see what must be the value of a cell to get required result? Show Answer

Q31) Which of the following is not What IF analysis tool in Excel? Show Answer

Q32) Goal seek can be defined as: Show Answer

Q33) In a Goal Seek problem, you must specify all of the following except: Show Answer

Q34) Solver is a What-If analysis tool that: Show Answer

Q35) A Scenario uses all of the following except: Show Answer

Q36) Scenarios are What-If analysis tool that: Show Answer

Q37) Which of these tools is used to perform What-IF analysis? Show Answer

Q38) You want to track the progress of the stock market on a daily basis. Which type of chart should be used? Show Answer

Q39) If we want a macro be available in all workbooks it should be stored using which of these options? Show Answer

Q40) After recording a macro you can modify it using: Show Answer