Across
- 4. Return logical (true-false) values
- 6. Seek __________ automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal.
- 7. Retrieve data from multidimensional databases involving online analytical processing (OLAP)
- 8. & Reference Look up and return data matching a set of specied conditions from a range
- 10. function The __________ tallies how many cells in the specified range contain numbers or dates.
- 12. Cell Style The __________ can be used for data that is inserted by the user.
- 15. and error One way to perform a what-if analysis is with __________ where you change one or more of the input values to see how they affect the calculated results.
- 16. Analyze engineering problems
- 18. and Trig Perform math and trigonometry calculations
- 19. Arguments __________ are not required by the function.
- 20. Provide information on web-based connections
- 21. Calculates the average of a collection of numbers, where number1, number2, and so forth are numbers or cell references
- 29. Calculates the median, or middle, value of a collection of numbers, where number1, number2, and so forth are either numbers or cell references
- 30. Displays the integer portion of number
- 32. function The __________ returns the maximum value in the range.
- 33. The formula or function contains a number divided by 0.
- 34. analysis A __________ explores the impact that changing input values has on calculated values.
- 35. Invalid numbers are used in a formula or function, such as text entered in a function that requires a number.
- 39. Counts how many cells are not empty in ranges value1, value2, and so forth including both numbers and text entries
- 40. __________ is a powerful application for interpreting a wide variety of data used in publications from financial reports to scientific articles.
- 41. Returns a random number between 0 and 1
- 45. Provide statistical analyses of data sets
- 46. A value is not available to a function or formula, which can occur when a workbook is initially set up prior to entering actual data values.
- 48. Adds a collection of numbers, where number1, number2, and so forth are either numbers or cell references
- 50. Analyze information for business and nance
Down
- 1. Calculates the maximum value of a collection of numbers, where number1, number2, and so forth are either numbers or cell references
- 2. Calculates the minimum value of a collection of numbers, where number1, number2, and so forth are either numbers or cell references
- 3. Some equations use __________, which are terms in a formula that don't change their value.
- 5. Functions from Excel 2010 or earlier, still supported to provide backward compatibility.
- 9. Counts how many cells in a range contain numbers, where value1, value2, and so forth are either numbers or cell references
- 11. Library group Functions are organized by category in the __________ .
- 13. One function can be places insude, or __________, within another function.
- 14. A formula or function requires two cell ranges to intersect, but they don’t.
- 17. Rounds number to the number of digits specied by number to the number of digits specied by number num_digits
- 22. Return text values or evaluate text
- 23. When a formula contains more than one function, Excel first evaluates the __________ function and then moved outwards to evaluate the next function.
- 24. Arguments __________ are required for the function to return a value.
- 25. __________ can be nested within one another.
- 26. value An __________ indicates that some part of a formula is preventing Excel from returning a value.
- 27. Digits __________ indicate the accuracy of the measured and calculated values.
- 28. A cell reference used in a formula or function is no longer valid, which can occur when the cell used by the function was deleted from the worksheet.
- 31. Retrieve and analyze data stored in databases
- 33. Excel doesn’t recognize text in the formula or function, such as when the function name is misspelled.
- 36. Return information about the format, location, or contents of worksheet cells
- 37. & Time Analyze or create date and time values and time intervals
- 38. Function button The __________ opens the Insert Function dialog box from which you can select a function.
- 42. The wrong type of argument is used in a function or formula. This can occur when you reference a text value for an argument that should be strictly numeric.
- 43. __________ are the numbers, text, or cell references used by the function to return a value.
- 44. Cell Style The __________ can be used for calculated values.
- 47. function The __________ returns the middle value in the range.
- 49. function The __________ returns the minimum value in the range.