MGSC 290 USC Exam 2 Review Practice Test.

MGSC 290 USC Exam 2 Review Practice Test. Area - CORRECT ANSWER Which of the following charts displays the magnitude of change over time and shows the rate change? A) area B) XY C) stock D) radar Filters alter the source data range - CORRECT ANSWER Which of the following is not true about filters? A) A filter is criteria that specifies which data is shown. B) A filter is criteria that specifies which data is hidden. C) Filters let you switch between several scenarios for your data. D) Filters alter the source data range. 6-7 - CORRECT ANSWER For most pie charts, what is the maximum number of pie slices you should have? A) 2-3 B) 4-5 C) 6-7 D) 9-10 A single data series - CORRECT ANSWER What can pie charts graph? A) a single data series B) up to three data series C) up to five data series D) an unlimited number of data series Access cannot illustrate data in a chart, but Excel can - CORRECT ANSWER Which of the following is a good reason to import data from Access into Excel? A) Access cannot illustrate data in a chart, but Excel can. B) Excel is capable of managing large databases. C) Excel includes more advanced reporting capabilities. D) all of the above Field - CORRECT ANSWER In an Excel table, which of the following represents a column of data? A) header row B) record C) field D) table Filter - CORRECT ANSWER Which of the following is a criterion or a specification that data must meet to be shown? A) filter B) AutoFilter C) criterion range D) all of the above