Home > Microsoft Excel > Quizzes > FBLA Spreadsheet Applications Functions
FBLA Spreadsheet Applications Functions
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 84% Most missed: “Shift press and hold ____ and drag Obj. to keep proportions”
FBLA Spreadsheet Applications Functions
Time left 00:00
23 Questions

1. to first cell of row

2. to last cell of column and the row that has that data

3. checks if the value in a given cell is not equal to the value in another cell

4. Counts everything(numbers, letters)

5. Converts month, year, day into date

6. a table view of row and column data

7. Counts only numbers

8. What refers to a range of cells where the range depends on the content of the cells

9. Gives CUrrent time

10. =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match - indicated as 0/FALSE or 1/TRUE).

11. A function that determines whether a condition is true or false

12. to cell A1

13. $A$1, doesn't change when copied or moved.

14. small lines that intersect an axis and represent the scale used for measuring values

15. B$1, B changes but row 1 stays the same

16. =NPER (rate, pmt, pv, [fv], [type]) | rate - The interest rate per period. | pmt - The payment made each period. | pv - The present value, or total value of all payments now. | fv - [optional] The future value, or a cash balance you want after the last payment is made. Defaults to 0. | type - [optional] When payments are due. 0 = end of period. 1 = beginning of period. Default is 0.

17. Shift press and hold ____ and drag Obj. to keep proportions

18. The future value of an investment based on fixed payments and a fixed interest rate across equal time periods

19. not possible to filter on a ______ Column

20. Bar graph

21. =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

22. Returns true if at least one argument is true

23. function calculates the present value of a paymen is AND returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false