1 / 57

Excel 2010 Functions and Features

This guide provides information on various functions and features in Excel 2010, including data entry, formulas, formatting, calculations, and more.

sandersw
Download Presentation

Excel 2010 Functions and Features

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 1pt 1 pt 1 pt 1pt 1 pt 2 pt 2 pt 2pt 2pt 2 pt 3 pt 3 pt 3 pt 3 pt 3 pt 4 pt 4 pt 4pt 4 pt 4pt 5pt 5 pt 5 pt 5 pt 5 pt

  2. Which Excel 2010 mode displays active cell entries in the formula bar and a flashing insertion point in the active cell? • Data Entry • Toggle • Overtype • Edit

  3. Answer… D. Edit

  4. What function finds the maximum value in a range? • Sum • Max • Average • Min.

  5. Answer… B. Max

  6. What is the quick keyboard command for converting a worksheet to formulas version so that all worksheet formulas may be seen on the screen or printed? • Ctrl + ‘ ( Accent Mark) • Ctrl + “ (quotation) • Alt + ‘ (Accent Mark) • Shift + “ (quotation)

  7. Answer… A. Ctrl + ‘ ( Accent Mark)

  8. What message does excel display to indicate a cell reference error? • #REF! • ERROR! • #CELL! • #NAME?

  9. Answer… A. #REF!

  10. How often does Excel 200 automatically recalculate formulas in a worksheet? • Every 5 minutes • Each time you click on a cell • Each time you enter a value into the cell • Each time the worksheet is opened or closed

  11. Answer… C. Each time you enter a value into the cell

  12. What command totals related data in several rows by inserting totals for selected cells? • Subtotals • Group • Totals • calculate

  13. Answer… A. Subtotals

  14. Which type of function does IF function perform? • Logical • Conditional • Series • Calculations

  15. Answer… B. Conditional

  16. Which of the following is the default method for summarizing data in a PivotTable? • Count • Average • Max • Sum

  17. Answer… D. Sum

  18. How are a cell reference in a formula and its corresponding location in a worksheet identified? • Arrows pointing from the formula to the location • Cell reference and cell location are circled • Cell reference and cell location are outlined in matching colors • Lines connect from the formula to the location

  19. Answer… C. Cell reference and cell location are outlined in matching colors

  20. What type of formatting appears only when the value in a cell meets conditions specified by a user? • Criterion • Conditional • Logical • Restrictive

  21. Answer… B. Conditional

  22. What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously? • Copy method from Shortcut Menu • Copy using the Fill Handle • Copy from the Home Ribbon • Copy using the Quick Access Toolbar

  23. Answer… B. Copy using the Fill Handle

  24. Which function will find the minimum value in a selected area? • Sum • Max • Average • Min

  25. Answer… D. Min

  26. Which of the following is a valid Excel 2010 function? • AVERAGE, MAX, and NUM • MAX, MIN, and WEEK • AVERAGE, MAX, and MIN • WEEKDAY, MAX, and CLOSE

  27. Answer… C. AVERAGE, MAX, and MIN

  28. Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula? • Function library • Defined names • Formula auditing • Calculation

  29. Answer… C. Formula auditing

  30. Which command on the Formulas Ribbon enables a user to specify when a formula is computed? A. Function library B. Defined names C. Formula auditing D. Calculation

  31. Answer… D. Calculation

  32. What part of the formula is entered directly as a value? • Constant • Case • Argument • operator

  33. Answer… A. Constant

  34. What is the data connection between workbooks called that maintains control over critical data? • Link • Relationship • Association • Connection

  35. Answer… A. Link

  36. Which function do you use to insert todays date in a worksheet so that it automatically updates each time the worksheet is opened? • Today • Weekday • Date • Current date

  37. Answer… A. Today

  38. When typing a function directly into a worksheet cell, what provides a description of currently selected functions? • Screenshot • Description box • Function box • Screen tip

  39. Answer… D. Screen tip

  40. What type of formula cell reference instructs Excel 2010 to keep the cell reference constant in the formula as it copies it to the destination area? • Relative • Mixed • Absolute • Unconditional

  41. Answer… C. Absolute

  42. Which of the following always begins with an equal sign (=) and performs calculations or other actions using the data in a worksheet? • Formula • Array • Range • Series

  43. Answer… A. formula

  44. What is a prewritten formula that is built into Excel 2010 called? • Utility • Procedure • Function • Statement

  45. Answer… C. Function

  46. Which option provides a list of error-checking options following the assignment of an invalid formula to a cell? • Trace Error • AutoCorrect • Paste • Auto Fill

  47. Answer… A. Trace Error

  48. Which is the valid function for displaying the highest value in a range of values? • Max • High • Upper • Top

  49. Answer… A. Max

  50. Which term describes the process of creating a formula that refers to a cell in the same location but non separate sheets in a workbook? • 3-D range • 3-D formula • 3-D reference • Wide range

More Related