Excel tutorial
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 57% Most missed: “'AZ' is an example of a ____.”
Excel tutorial
Time left 00:00
25 Questions

1. ____ displays the location of the different page breaks within the worksheet.

2. To change the order of operations, enclose part of the formula in ____.

3. To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

4. ____ makes it easier to enter repetitive text in cells.

5. An Excel worksheet can have a maximum of ____ columns in a worksheet

6. Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

7. What is the result of the expression =50+20/10 X 5?

8. You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

9. If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

10. When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

11. ____ enters text based on patterns it finds in the data.

12. According to the order of operation in Excel:

13. When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

14. A(n) ____ is a group of cells in a rectangular block.

15. In the figure above, Box 1 points to the formula =F13 X G13 in the ____.

16. The characters +, -, X , and / are examples of ____.

17. In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

18. You can move to the previous or next sheet by pressing the ____ keys.

19. To make A1 the active cell, you should press which of the following keys?

20. To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

21. Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

22. What is the syntax for a SUM formula adding the values of cell F6 to F9?

23. An Excel formula always begins with a(n) _

24. In ____ orientation, a page is taller than it is wide.

25. In the figure above Box 3, points to color coded ____ references.