Home > FBLA > Quizzes > FBLA Spreadsheet Applications Test 2
FBLA Spreadsheet Applications Test 2
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 48% Most missed: “For the logical_test part of the condition, the IF function uses such functions …”
FBLA Spreadsheet Applications Test 2
Time left 00:00
25 Questions

1. To paste a range of cells, press:
2. The Ignore Once option in the Spell-Check dialog box provides the following action:
3. As you key data, it appears in the active cell and in the:
4. To change a column width:
5. You can choose from 3-D styles.
6. You can change the font style and the font size by using the:
7. While using the Format Painter, the pointer is:
8. To remove formatting from a cell or a range, use the menu.
9. The Office Clipboard is a temporary memory area that can hold up to copied items.
10. The function INT(9.678) will give you the following result.
11. If you see a range address of A1:B3, the range would include:
12. To delete a cell, press the following keys on the numeric keypad:
13. To change the AutoCorrect Options, you would use this menu:
14. The MIN function calculates the value in a range.
15. When you edit a formula, you can press to move through the cell reference types.
16. If you key label Week 1 in A1 and use the AutoFill handle to fill the series, what label will you find in A5?
17. To hide a column heading, select the column and choose Column, Hide from the menu.
18. The Chart Wizard button is on the:
19. A/an reference does not change when a formula is copied.
20. To move the screen down one page, press:
21. Use the dialog box to make several changes at once to an AutoShape.
22. If you want Excel to use the value as shown in the cell, use the function.
23. When you delete cells, you are given the following option:
24. To set a Print Area, choose Print Area, Set Print Area from this menu:
25. Division formulas us a(n):