Short description 1 Excel tutorial 3 1. (1.0 point) which of the following is a statistical function? a. INT b. Rand c. Ring d. Average 2... summary


You are watching: When you nest functions, you should have ____.

Excel indict 3 1. (1.0 point) i m sorry of the complying with is a statistical function? a. INT b. Edge c. Ring d. Median 2. (1.0 point) i m sorry of the adhering to is a mathematics & Trig function? ____ a. INT b. Counting c. MIN d. Typical 3. (1.0 point) Every function has to follow ____. A. A formula b. Directions c. Syntax d. A format 4. (1.0 point) In the following formula: =IF(A1=\"YES\", \"DONE\", \"RESTART\"), what wake up if A1= “NO”? a. The formula returns the message “RESTART”. B. The formula return the message “DONE”. C. The formula returns the text “NO”. D. The formula returns the text “NO, RESTART”. 5. (1.0 point) i m sorry of the following is no a day function? ____ a. Year b. Now c. And also d. Today 6. (1.0 point) The lot of money being loaned is recognized as the ____. A. Mortgage b. Principal c. Loan quantity d. Proposed principal 7. (1.0 point) once you copy a formula that consists of an absolute referral to a brand-new location, the reference ____. A. Is updated immediately b. Does not readjust c. I do not care bold d. Has a dotted summary in its cabinet 8. (1.0 point) The ____ is most regularly used with data that has actually only a few possible values. A. Setting b. Mean c. Center d. Amount 9. (1.0 point) ____ arguments may provide much more control end the went back value. A. Loved one b. Forced c. Optional d. Pure 10. (1.0 point) If an optional argument is no included, Excel assumes a(n) ____ value for it. A. Default b. Generic c. Static d. Absolute 11. (1.0 point) once you swarm functions, girlfriend should have actually ____. A. The equal sign b. The same variety of left and also right clip c. At the very least two attributes d. The correct variety of brackets 12. (1.0 point) Optional arguments are in ____ type. A. Interlocutor b. Italic c. Normal d. Red 13. (1.0 point) Which duty is supplied to adjust 3,162.50 come 3,163? ____ a. Edge b. Round c. Fall d. ROUNDUP 14. (1.0 point) many Recently offered is a ____. A. Team on the Formula tab top top the Ribbon b. Classification in the Insert duty dialog box c. Classification in the role Arguments dialog box d. Command ~ above the Office switch menu 15. (1.0 point) using AutoFill is ____ than copying and also pasting. A. Slow b. Much faster c. Much safer d. Riskier 16. (1.0 point) Blue, Accent1, irradiate 60% is an example of cabinet ____. A. Dimension b. Formatting c. Border color d. Elevation 17. (1.0 point) utilizing AutoFill, what would certainly be the extended collection of the initial entry Jan? ___ a. Uary b. Feb, Mar, Apr c. Kan, Lan, Man, Nan d. Jan1, Jan2, Jan3, 18. (1.0 point) For most loan and investment calculations, you need to enter the annual interest price ____ the variety of times the interest is compounded during the year. A. Included to b. Subtracted indigenous c. Multiplied by d. Divided by 19. (1.0 point) In the formula =IF(A1=B1, C1, C2), the an outcome will be C2 if ____. A. A is same to B b. A does no equal B c. A1+B1 is equal to C1 d. Nobody of the above 20. (1.0 point) as soon as you go into a formula into a cell, Excel interprets cell references in the formula in relation to the cell’s location. A. True b. False 21. (1.0 point) The Rand( ) function falls under the statistical category. A. True b. False 22. (1.0 point) One an obstacle of nesting attributes is to make sure that you include all of the parentheses. A. True b. False 23. (1.0 point) functions are arranged in the duty Library team in the duty tab ~ above the Ribbon. A. True b. False 24. (1.0 point) To go into a mixed reference, type $ after one of two people the heat or column reference. A. True b. False 25. (1.0 point) not all features have arguments. A. True b. False 26. (1.0 point) count is a statistical function. A. True b. False 27. (1.0 point) In the function Arguments dialog box, required disagreements are in bold type. A. True b. False 28. (1.0 point) You can open the Insert role dialog box by click the Insert function button top top the Ribbon. A. True b. False29. (1.0 point) The layout Painter switch is ~ above the Clipboard group. A. True b. False30. (1.0 point) making use of the AutoFill feature is more efficient 보다 copying and pasting. A. True b. False31. (1.0 point) In the list of AutoFill Options, the to fill Formatting only option is the default setting. A. True b. False 32. (1.0 point) AutoFill can recognize some fads if you plugin a minimum that at the very least two values, such together “Monday, Tuesday.” a. True b. False 33. (1.0 point) you can develop decision-making capacity into a formula through the use of a reasonable function. A. True b. False 34. (1.0 point) together you start to type a function name in ~ a formula into a cell, a perform of features that start with the letter you typed appears. A. True b. False 35. (1.0 point) The OR role is a logical role that returns one worth if the statement is true and returns a various value if the explain is false. A. True b. False 36. (1.0 point) The statement “A1 >= B1” tests whether the value in cabinet A1 is lesser 보다 or equal to the worth in cabinet B1. A. True b. False 37. (1.0 point) Use loved one references as soon as you desire to repeat the same formula with various cells. A. True b. False 38. (1.0 point) A mixed formula consists of both relative and also absolute references. A. True b. False 39. (1.0 point) as soon as the data consists of a few extremely large or extremely tiny values, it could be ideal to use the mean value indigenous the sample. A.

See more: Animal Species That Are Threatened By Extinction Are Primarily In The Phylum ________.

True b. False