Home > FBLA > Quizzes > FBLA Spreadsheet Applications Test
FBLA Spreadsheet Applications Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 52% Most missed: “What formatting feature is applied to a cell so text does not flow into the next…”
FBLA Spreadsheet Applications Test
Time left 00:00
25 Questions

1. Excel automatically totals numbers when they are dropped into which area of a pivot table report?
2. Make a worksheet appear bigger or smaller on your screen is called ________.
3. Which
4. What happens when you freeze panes in a worksheet?
5. Which description identifies a .csv file?
6. How can the order of operations in a spreadsheet formula be changed?
7. Which product would be a good choice for a template?
8. When applying a filter, what happens to rows that do not meet the specified criteria?
9. The process of emphasizing one particular slice in a pie chart over others is referred to as ____ the slice.
10. If a national customer spreadsheet has the headings First Name, Last Name, City, State, ZIP, Phone; which column would be filtered to determine the customers closest to you?
11. What is a Lookup function used for?
12. What action do you need to take if a cell displays the # symbol?
13. The term used to describe the information on which a chart is based is:
14. What type of reports are visual representations of PivotTables?
15. Which tool will rotate text so it appears diagonally in a cell?
16. The small black box you see in the corner of a active cell is called a:
17. Changing the order of the fields in the _________ area affects how the data displays in a PivotTable.
18. A chart that appears on the same sheet as the worksheet data is called:
19. Which formula is correct for adding the contents of cells L4, L5, L6, L7 and L8?
20. Which one of the following best describes how to explode a pie chart?
21. What is an advantage of a spreadsheet program?
22. When charting the daily prices of a particular stock, what chart type is the best choice?
23. What is the NOW function used to display?
24. Which area is used specifically to filter the pivot table and create separate reports or separate pivot tables?
25. What key do you press to select nonadjacent cells?