Microsoft Office Excel 2013 Quiz

Multiple Choice Quiz

4 points for each correct answer

40 minutes to answer all the questions

Take 75% or higher than to get your certificate

Time Left: 40:00

01. The intersection of a row and a column is called a ________.

02. A group of cells is called a ________.

03. Where is the fill handle located?

04. You can click the tabs at the bottom of a workbook to switch between ________.

05. Which of the following is an absolute cell reference?

06. How would you select non-contiguous cells?

07. How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?

08. The Conditional Formatting feature is used to,

09. Data can be arranged in ascending or descending order by using,

10. To select multiple non-adjecent cells in a worksheet you will click them holding,

11. Which of the following component displays the contents of active cell?

12. To move to the previous worksheet press,

13. Which keyboard shortcut opens the Go To dialog box?

14. Which feature starts with a desired result, then calculates the input value that will give that result?

15. In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ________ menu,

16. What MS-Excel feature can you use if you want to work with one record at a time?

17. In MS-Excel value used in a formula that does not change is called a,

18. In MS-Excel Graphics objects on a chart are used to,

19. What type of chart is useful for comparing values over categories

20. In MS-Excel to select an individual data marker or data label, you must,

21. MS-Excel uses the _______ Function when creating a data table,

22. In MS-Excel what does SUMIF function do?

23. Which button do you click to add up a series of numbers?

24. To create a formula, you can use,

25. Each excel file is called a workbook because,

Get your certificate