CTCT 6200 Module 5 Vocabulary: ncd0014

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485
Across
  1. 3. In Computer Concepts, a program that you access over the Internet, in a browser on your computer or on your mobile device, also known as a web app.
  2. 8. Apps that run from a removable storage device such as an external hard drive or flash drive, or from the cloud.
  3. 12. Features in spreadsheet apps that perform financial, mathematical, logical, date and time, and other calculations.
  4. 13. Apps that provide tools for maintaining your computer or mobile device.
  5. 16. An app that lets you create visual aids for presentations to communicate ideas, messages, and other information to a group.
  6. 18. To specify a set of restrictions to only display specific database records, online images, or files.
  7. 21. A named operation that replaces the action of an arithmetic expression.
  8. 23. In Publisher, tear-offs and business information fields that are automatically updated across pages and publications.
  9. 24. Programs that help you perform specific tasks when using your computer or smartphone.
  10. 26. A keyboard displayed on-screen that includes keys for typing text, numbers, and symbols.
  11. 29. An application that runs from the hard drive of a local computer.
  12. 30. A mathematical statement in a spreadsheet or table cell that calculates a value using cell references, numbers, and arithmetic operators such as +, -, *, and /.
  13. 36. A collection of related worksheets contained within a single file.
  14. 37. Short for “application,” a computer program that performs specific tasks; also called a program.
  15. 39. The template for the slides in a presentation that contains theme elements and styles, text formatting, the slide background, and other objects that appear on all the slides in the presentation.
  16. 44. Apps that allow you to interact with and edit digital media.
  17. 48. The manner in which a slide appears on the screen in place of the previous slide during a slide show.
  18. 49. Large and complex data sources that defy easy handling with traditional data processing methods.
  19. 51. A powerful, high-capacity computer you access using the Internet or other network
  20. 56. Apps that give you tools to pursue your interests.
  21. 58. An online store to help you locate and download apps for your mobile device.
  22. 62. Google’s web-based productivity applications for creating documents, spreadsheets, presentations, email, and calendars.
  23. 63. Premade pictures and symbols you can use in electronic documents.
  24. 64. Tools that protect and organize files and let you share documents with others.
  25. 65. A grid of square colored dots, called pixels, that form a picture
  26. 66. A named set of instructions written in the Visual Basic programming language that perform tasks automatically in a specified order.
  27. 67. Microsoft’s productivity suite which includes word processing, spreadsheets, and presentation apps, as well as Microsoft Outlook for email, Microsoft OneNote for note taking, and Microsoft Access for databases.
  28. 69. A language that provides a standardized way to request information from a relational database system.
  29. 70. A PowerPoint document that lets you create and deliver a dynamic, professional-looking message to an audience in the form of a slide show.
  30. 73. Mobile apps designed for a specific operating system like Android or iPhone.
  31. 74. A cell reference that does not change when the formula containing that reference is moved to a new location.
  32. 76. A cell’s location, expressed by its column letter and row number, such as A1.
  33. 77. A single sheet in a workbook file that is laid out in in a grid of rows and columns
  34. 78. Apps that you access on a smartphone or tablet.
  35. 79. A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell.
  36. 80. A line that represents the general direction in a series of data.
  37. 81. A link to a workbook on a OneDrive that can be viewed by users.
  38. 82. A named collection of formats that are stored together and can be applied to text or objects.
  39. 83. A spreadsheet table designed to create meaningful data summaries that analyze worksheets containing large amounts of data.
  40. 84. In an Access or in an Excel table or PivotTable, a column containing a specific property for each record, such as a person, place, object, event, or idea.
  41. 85. A software program used to organize and present information in the form of an electronic slide show.
Down
  1. 1. A blinking vertical line that appears when you click in a paragraph, cell or text box; indicating where new text or an object will be inserted.
  2. 2. A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a worksheet.
  3. 4. Apps for personal use that you may use to create documents, develop presentations, track appointments, or to stay organized.
  4. 5. A graphic that represents data using bars, columns, dots, lines, or other symbols to make the data easier to understand and to make it easier to see the relationships among the data.
  5. 6. A design principle centered on building apps to work on mobile devices first because these typically have more restrictions, such as smaller screens.
  6. 7. A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field.
  7. 9. A way to share files so others may read the file, but cannot change it.
  8. 10. An open source suite of productivity apps.
  9. 11. A quick, simple chart located within a cell that serves as a visual indicator of data trends.
  10. 14. Also known as mobile commerce.
  11. 15. A format for storing digital images that tend to be simple images composed of shapes, lines, and diagrams.
  12. 17. The direction in which content is printed on the page.
  13. 19. In Computer Concepts, a document that has been preformatted for specific purpose
  14. 20. A collection of data organized in a manner that allows access, retrieval, and use of that data.
  15. 22. Bars on the right edge and bottom edge of a document window that let you view a document that is too large to fit on the screen at once.
  16. 25. A term used to describe a PowerPoint presentation.
  17. 27. In Excel, to make notes about basic worksheet assumptions, complex formulas, or questionable data.
  18. 28. These apps let you use your mobile device to make online purchases of goods and services.
  19. 31. Special formatting that is applied if values meet specified criteria.
  20. 32. A database that consists of a collection of tables that can be joined through a common field
  21. 33. In Access, a collection of records for a single subject, such as all of the customer records
  22. 34. The box formed by the intersection of a column and a row.
  23. 35. In Power BI or similar programs, a request for information from a data source.
  24. 36. A way to explore the impact that changing input values has on calculated values and output values
  25. 38. A collection of productivity apps such as Microsoft Office 365, Apple iWork, G Suite, or Apache OpenOffice.
  26. 40. An Access object that creates a professional printout of data that may contain enhancements such as headers, footers, and calculations on groups of records.
  27. 41. Commonly used software to create documents and reports, mailing labels, flyers, brochures, newsletters, resumes, letters, and more.
  28. 42. Apps that provide tools for sharing or receiving information.
  29. 43. Tools that developers can use to build apps that work on multiple platforms, rather than writing different code for Android or iPhone devices.
  30. 45. Short for picture element, an individual point of color on a display screen or printout.
  31. 46. A productivity suite for computers running macOS and iPhones and iPads running the iOS operating system.
  32. 47. In Excel and Access, and in Word tables, information necessary for a formula or function to calculate an answer.
  33. 50. To organize data, such as table rows, items in a list, or records in a mail merge, in ascending or descending order, based on criteria such as date, alphabetical order, file size, or filename.
  34. 52. The process of changing the appearance of text and objects.
  35. 53. Another name for bitmap images.
  36. 54. In Access, an object that provides an easy-to-use data entry screen that generally shows only one record at a time.
  37. 55. In PowerPoint, an effect applied to an object that makes the object appear, disappear, change, or move.
  38. 57. A way to provide content so that it adapts appropriately to the size of the display on any device.
  39. 59. An app stored on an Internet server that can be run entirely in a web browser.
  40. 60. A cell reference that changes when the formula containing that reference is moved to a new location
  41. 61. In Access and Excel, a row of data in a table, representing a complete set of field values for a specific person, place, object, event, or idea; also called a tuple.
  42. 68. A component of a function or formula that indicates what will occur. For example SUM is the name of a function.
  43. 71. An app written for a specific operating system and installed on a computer or mobile device.
  44. 72. In Access, any form or report element such as a label, text box, or combo box. In Windows, an object used to manipulate a window or to use a program.
  45. 75. In Access, Excel, Publisher, or in a Word table, a column label that describes a data field.