Home > Microsoft Excel > Quizzes > Management Science MGSC 290 Final
Management Science MGSC 290 Final
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 74% Most missed: “In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the foll…”
Management Science MGSC 290 Final
Time left 00:00
25 Questions

1. Which of the following is a complete set of elements that is displayed in a chart?

2. Which of the following displays after the file name in the title bar when worksheets are grouped?

3. Which of the following features would you want to use to center worksheet titles over multiple cells?

4. Which of the following keystrokes are considered completion keys when executing functions as array formulas?

5. Which of the following statements is not true about screenshots?

6. How does Excel treat dates?

7. Which of the following Page Setup options lets you change the orientation of a worksheet to Portrait or Landscape?

8. Which of the following is not a procedure to prepare a consolidation worksheet?

9. Which of the following displays the result of a formula?

10. Which of the following views lets you apply headers and footers and view the layout of the spreadsheet prior to distribution?

11. Which of the following lets you select a chart element?

12. To select part of a window or screen for a screenshot, which of the following options should you select from the illustrations gallery?

13. Which of the following has an answer of 14?

14. Which of the following is the default paste option?

15. Which of the following summarizes data from multiple worksheets using a mathematical or statistical function?

16. Which of the following chart types use one data series to display each value as a percentage of the whole?

17. Which of the following functions retrieves a value from a range or table of cells located in another area of the worksheet?

18. Which of the following error values indicates that a cell reference is empty?

19. Where is the Take a Screenshot command located?

20. What must you do to enter a number as a label in a cell?

21. Which of the following is not a component of a SmartArt graphic?

22. Which of the following functions multiplies and then adds a series of arrays?

23. Which of the following is a color-coded editing tool that applies different colors to each cell or cell range within a formula?

24. How should you save a file if you want it to be compatible with older versions of Microsoft Excel?

25. Which of the following is a picture of a full or partial computer screen inserted as an object in a worksheet?