1 / 53

Excel Worksheet Navigation and Display Techniques

Learn how to navigate and display different portions of a worksheet in Excel using arrow keys, page up/down key, slider bars, and scroll bars.

keithrobinson
Download Presentation

Excel Worksheet Navigation and Display Techniques

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. What do you use to navigate and display different portions of a worksheet in the worksheet window? • Arrow Keys • Page up or Page Down Key • Slider bars • Scroll bars

  3. D. Scroll bars

  4. Which command on the home ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? • Find & select • Format cell • Sort & filter • organize

  5. C. Sort & filter

  6. In order to directly report the data, what must a pivot chart always be associated with? • Table • Range • pivot table • worksheet

  7. C. pivot table

  8. Which technique uses the table column heading arrows to narrow data in a table to show only specific items meeting a desired criterion? • Auto filter • Auto sort • Organize • filter

  9. A. Auto filter

  10. How do you quickly modify a table style to meet user preferences? • Right-click on a style and choose modify • Right-click on a style and choose duplicate • Double-click a style from the table quick styles gallery • Choose modify from the style group on the home ribbon

  11. B. Right-click on a style and choose duplicate

  12. Which tab in the pivot chart tools ribbon allows a user to apply chart tittles to the pivot chart? • Design • layout • Format • analyze

  13. B. Layout

  14. What is the name of the technique of entering a number once and copying it so that it is entered in the same cell on all selected worksheets? • Total field • Auto sum • Calculated field • Analyzed field

  15. C. Calculated

  16. Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data? • Pivot chart • Pivot table • Pivot data • Rotate table

  17. B. Pivot table

  18. Which ribbon is visible when a pivot table is selected, and allows a user to apply various style to the pivot table? • Layout • Options • Designed • Format

  19. C. Designed

  20. What are the individual items that make up a record in a table called? • Column • Records • Field • Table

  21. C. Field

  22. What is the process of viewing a pivot table report for a subset that meets the criterion only? • Filtering • Sorting • positioning • arrange

  23. Filtering

  24. What home ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style? • Style • Alignment • Editing • Font

  25. A. Style

  26. Which is a way to qualify data by specifying a matching condition or asking a question of the data? • Filter • Sort • Query • Probe

  27. C. Query

  28. Which tab in the pivot chart tools ribbon allows a user to apply a chart style to the pivot chart? • Design • Layout • Format • Analyze

  29. A. Design

  30. What can you use to easily filter pivot tables and cube functions interactively in a worksheet? • Slicer • cutter • division • sliver

  31. A. Slicer

  32. What are graphical objects that contain buttons a user can click to filter the data in pivot tables and pivot chart? • Slivers • Partials • Slicers • Movers

  33. C. Slicers

  34. When sorting data in a table, which fields are selected as field to sort by? • Field keys • Table keys • Sort keys • Sequence keys

  35. C. Sort keys

  36. When creating a pivot table, which are drawn in columns in the worksheet data? • Records • Fields • cells • Ranges

  37. B. Fields

  38. Which command on the home ribbon do you use to organize data in ascending or descending order? • Find & select • Format cell • Sort & filter • Organize

  39. C. Sort & filter

  40. Which is the name of an interactive graphical representation of data that allows a user to change the groupings? • Pivot chart • Pivot table • Pivot data • Rotate table

  41. Pivot chart

  42. What is the purpose of the -/+ buttons that appear across the categories on a pivot table? • Decrease/increase • Collapse/expand • Reduce/add • Subtract/add

  43. B. Collapse/expand

  44. What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches? • Text • String • Thread • Key

  45. B. String

  46. What is a visual way to show how two variables relate to each other in a table? • Sparkline • Data line • Data trend • Trend line

  47. D. Trend line

  48. What command specifies complex criteria to limit which records are included in the result set of a query? • Sort • Advanced filter • Filter • screen

  49. B. Advanced filter

  50. What technique selects from the internet to add to an excel worksheet? • Web search • Web filter • Internet probe • Web query

More Related