c. Ctrl + c v 19. One challenge of nesting functions is to make sure that you include all of the parentheses. 20. Goal 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 v 21. A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook. 22. A lookup table organizes numbers or text into categories. 23. The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date. 24. Each slice in a pie chart represents a single value from a data series. 25. Excel charts are either placed in their own chart sheels or embedded in a worksheet. 26. Every chart contains elements that can be formatted, added to the chart, or removed from the chart. 27. Combination charts enable you to show three sets of data using the chart type that is best for each data sct. 28. In a line chart, the data markers are the points connected by the line. 29. The cell with the largest value contains a data marker that extends across the entire width of the cell, and the lengths of the other bars in the selected range are determined relative to that bar. V 30. When you create sparklines, clicking any cell in the data range selects all of the sparklines in the group. b. Click Mode d. Normal Mode V 34. "AZ" is an example of a a column heading c. cell reference b. row heading d. Name box 35. Whenever you click the Save button on the Quick Access Toolbar or press the keys, the workbook file is updated to reflect the latest content. a. Ctrl + V b. Ctrl + G d. Ctrl + S . S 36. mm/dd/yyyy is known as a. a text string c. a date format b. text data . d. number data 37. Ctrl + G is used to access the a. Go to Next worksheet command c. Go to a location in the worksheet command b. G column d. formula view 38. One of the benefits of Live Preview is that it a lets you see and evaluate different c. applies thematic styles to your formats as you develop your document workbook b. shows you what a document will lookd. allows you to track changes in your like when printed document 39. Italic, bold, bold italic, and underline are examples of a font themes c. graphics b. font styles d. d. character settings 40. In a workbook's theme, __colors are designated for text and background, colors are used for accents and highlights, and colors are used for hyperlinks. a. Four, two, six c. Four, six, wo b. Two, four, six b. , d. Six, four, two V 41. The command searches through the current worksheet or workbook for the content or formatting you want to locate. a Seek c. Locate b. Find d. Search V 42. The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is a. Alignment c. Protection b. Font d. Security V 43. Header and footer elements such as worksheet name, current date, and time are elements. a descriptive c. impact a database Multiple Choice Identify the choice that best completes the statement or answer the question 31. The advantage of an electronic is that the content can be casily edited and updated to rellect changing financial conditions, c. expression b. spreadsheet d. formula 32. Keyboard can help you work faster and more efficiently because you can keep your hands on the keyboard. 2. KeyTips c. ShortTips b. Screen Tips d. shortcuts the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need a Touch Mode c. Tap Mode 33. In
