Lesson 6 Microsoft Excel

Lesson 6 Microsoft Excel

1. How do you print only an embedded chart?
A. Choose Print Chart only from the Print tab
B. Choose Print Chart from the Home ribbon
C. Select the chart and choose Print from the File tab
D. Choose Print Chart from the View ribbon

2. In a chart, what is data that appears along the horizontal scale of the chart called?
A. Y-axis data B. X-axis data C. Vertical data D. Horizontal data

3. Which command on the Page Layout Ribbon enables a user to choose an image to display behind the data in a worksheet?
A. Print Area B. Breaks C. Background D. Effects

4. What ribbon is used to create charts in a workbook?
A. Insert ribbon B. Home ribbon C. View ribbon D. File tab

5. What graphically represents changes in a data series over time?
A. Sparkline B. Trendline C. Chartline D. Error bar

6. Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
A. Shapes B. Picture C. SmartArt D. Screenshot

7. What ribbon contains the commands for creating charts in Excel 2010?
A. Home B. Page Layout C. Insert D. Data

8. Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
A. Style B. Design C. Layout D. Format

9. Which ribbon is available when a chart is selected and attempting to delete chart labels?
A. Chart tools style B. Chart tools design C. Chart tools format D. Chart tools layout

10. Which is a graphical representation used in statistical or scientific data to show the degree of uncertainty relative to each data marker in a series?
A. Sparkline B. Trendline C. Chartline D. Error bars

11. What is the name of the zone on the worksheet where the chart appears?
A. Chart region B. Chart sector C. Chart location D. Chart position

12. To add visual interest to worksheets and charts, where is the command located to insert clip art images?
A. Home ribbon B. Insert ribbon C. Page Layout ribbon D. Chart Tools Deisgn ribbon

13. What is the term used to refer to a dot on a computer monitor that contains color?
A. Mark B. Point C. Icon D. Pixel

14. Which dialog box contains commands to rotate the chart area on 3-D charts?
A. Format Chart Area B. Chart Styles C. Format Data Point D. Chart Position

15. Which command on the Chart Tools Ribbon do you use to swap data over the axis in a chart?
A. Select Data B. Swap Data C. Switch Row/Column D. Switch Data

16. Which command on the Insert Ribbon inserts a graphic from a file into a worksheet?
A. Shapes B. Picture C. SmartArt D. Screenshot

17. In Microsoft Excel 2010, which is a graphical representation of data that is created from information in a workbook?
A. Table B. Chart C. List D. Picture

18. What ribbon contains the commands used to create a chart in Excel?
A. Home Ribbon B. Insert Ribbon C. Formulas Ribbon D. Data Ribbon

19. What two options are offered when a user elects to move a chart?
A. New Sheet or Delete Sheet B. New Sheet or Object in
C. New Sheet or New Workbook D. New Workbook or Object in

20. Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
A. Shapes B. Picture Cropping C. Screen Clipping D. Screenshot

21. Which is a tiny chart that provides a visual representation of data in a worksheet cell?
A. Trendline B. Sparkline C. Dataline D. FlashPoint

22. Which Chart Tools Ribbon tab enables a user to add pictures, shapes, or textboxes to a chart area?
A. Style B. Design C. Layout D. Format

23. What chart would be used to compare data as separate items that vary over time?
A. Column B. Doughnut C. Pie D. Radar

24. Which ribbon is available when a chart is selected and enables the user to customize the style and layout of the chart?
A. Chart tools style B. Chart tools design C. Chart tools format D. Chart tools layout

25. By default, how many chart types buttons are offered in the Charts group?
A. Three B. Four C. Five D. Six

26. In a chart, what is data that appears along the vertical scale of the chart called?
A. Y-axis data B. X-axis data C. Vertical data D. Horizontal data

27. Since cells in a chart are linked to the data in the worksheet, how would you update data on a chart?
A. Double-click the chart to edit the data
B. Double-click the number in the chart to type in the new number
C. Right-click on the chart and choose edit mode
D. Change the data on the corresponding worksheet, and the chart will automatically be updated

28. What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
A. Slivers B. Partials C. Slicers D. Movers

29. In Excel 2010, which term refers to a chart created on the same worksheet as the data?
A. In-place chart B. Embedded chart C. Inside chart D. Linked chart

30. Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
A. Style B. Design C. Layout D. Format

31. Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
A. Clip Art B. Picture C. SmartArt D. Instant Art

32. Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?
A. Style B. Design C. Layout D. Format

33. What term refers to an Excel Chart with offset pieces?
A. Exploded B. Shattered C. Separated D. Detached

34. What type of chart would be used to show proportions of a part to the whole?
A. Column B. Line C. Pie D. Radar