Home > Microsoft Excel > Quizzes > FBLA Spreadsheet Applications Study Guide
FBLA Spreadsheet Applications Study Guide
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 67% Most missed: “The part of a chart that contains the graphical representation of the data serie…”
FBLA Spreadsheet Applications Study Guide
Time left 00:00
25 Questions

1. The axis against which data series in a chart is plotted usually appears along the left side of a chart

2. Counts only numbers

3. The axis that displays the series values from the data series

4. An argument that is required for the function to return a value

5. A chart that shows the correlation between two or more sets of values

6. Descriptive text that appears next to an axis

7. A value in a formula that doesn't change

8. A conditional format that adds a horizontal bar to the background of a cell proportional in length to the cells value

9. A chart that displays data values as columns with the height of each column proportional to its value; bar graph

10. currently selected cell that you can type in

11. A data label that appears as a call out bubble pointing to a data marker

12. takes you to the first cell of a row

13. Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false

14. A feature that copies content ( text, values, or formulas) informants from a cell or range into an adjacent cell or range

15. The range that contains the data displayed in a chart

16. A chart that combines two or more excel chart types into a single graph

17. A visual representation of a set of data values also called a graph

18. A cell reference that is automatically changed when copied or moved; e.g. B5

19. An alternate axis in a chart against which other data series with a different scale is plotted usually appears on the right side of a chart

20. Counts everything(numbers, letters)

21. A chart that displays data values using a connected line rather than columns or bars

22. The number of digits that should be displayed for a calculation; they indicate the accuracy of the measured and calculated values

23. A date function that displays the current date

24. how a range is identified - format is cell in upper left corner and lower right corner, separated by a colon (e.g. B5:D16)

25. A set of spark lines that can be formatted individually