Module 5 Computer Concepts Exam

Module 5: Review: 1. You want to share information about an upcoming event at your school by creating a short promotional video. Which type od app might you use to create the video? a. Device Management b. Communications c. Personal Intrest d. Graphics and Media 2. Which of these is not an option for formatting text? a. Changing the text’s color b. Making text bold c. Changing the text’s size d. Copying a region of text 3. Which type of app would most likely NOT be found included in a productivity suite? a. Web Browser b. Presentation c. Spreadsheet d. Word Processing 4. To run a productivity app with most complete and advanced capabilities, you would most likely ____. a. Download it from an app store to your smartphone b. Install and run the software on your desktop or laptop computer c. Update the app online to make sure you have the most recent version d. Run a web app in a web browser 5. Mobile first design is important because _____. a. Sales of personal computers have surpassed sales of smartphones b. Developers can only write apps for one platform c. Smartphones generally have more processing power than laptops d. Developers must provide simplified user experiences for apps that run on small screens 6. When a value in a worksheet changes, the spreadsheet program will ____. a. Launch a calculator for you to check the calculations b. Delete the value c. Recalculate any cells whose formulas depend on the value that changed d. Reformat any cells whose values changed 7. When giving a presentation, pushing one slide off the right edge of the screen as another one appears is an example of a(n) _______. a. Entrance b. Transition c. Exit d. Animation 8. In a relational database, data is organized into rows of data called _______. a. Views b. Tables c. Records d. Fields 9. When you take a photo with a digital camera, most likely it is saved in _____ format. a. TIFF b. GIF c. JPG d. PNG Key Terms: Absolute Reference - A cell reference that does not change when the formula containing that reference is moved to a new location. Animations - In PowerPoint, an effect applied to an object that makes the object appear, disappear, change, or move. Apache OpenOffice - An open source suite of productivity apps. Apps - Short for “application,” a computer program that performs specific tasks (also called a program). App Store - An online store to help one locate and download apps for a mobile device. Apple iWork - A productivity suite for computers running macOS and iPhones and iPads running the iOS operating system. Application Software - Programs that help one perform specific tasks when using a computer or smartphone. (also called software applications or apps). Argument - In Excel and Access, and in Word tables, information necessary for a formula or function to calculate an answer. Big Data - Large and complex data sources that defy easy handling with traditional data processing methods. Bitmap - Grid of square colored dots, called pixels, that form a picture; also, a file containing a graphic that consists of a bitmap. Built-in Functions - Features in spreadsheet apps that perform financial, mathematical, logical, date and time, and other calculations. Cell - The box formed by the intersection of a column and a row. Cell Address - A cell’s location, expressed by its column letter and row number, such as A1. Charts - 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. Clip Art - Premade pictures and symbols one can use in electronic documents. Communications Apps - Apps that provide tools for sharing or receiving information. Conditional Formatting - Special formatting that is applied if values meet specified criteria. Controls - In Access, any form or report element such as a label, text box, or combo box. In Windows, an object is used to manipulate a window or to use a program. Cross-platform - Tools that developers can use to build apps that work on multiple platforms, rather than writing different code for Android or iPhone devices. Database - A collection of data organized in a manner that allows access, retrieval, and use of that data. Device Management Apps - Apps that provide tools for maintaining a computer or mobile device. Documents - In Excel, to make notes about basic worksheet assumptions, complex formulas, or questionable data. Document Management Tools - Tools that protect and organize files and let one share documents with others. Drawing Apps - Apps that let one create simple, two-dimensional images, which are often vector graphics. Field - 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. Field Name - In Access, Excel, Publisher, or in a Word table, a column label that describes a data field. Filter - To specify a set of restrictions to only display specific database records, online images, or files. Form - In Access, an object that provides an easy-to-use data entry screen that generally shows only one record at a time. Format - The process of changing the appearance of text and objects. Formulas - A mathematical statement in a spreadsheet or table cell that calculates a value using cell references, numbers, and arithmetic operators (such as +, -, *, and /). Function - A named operation that replaces the action of an arithmetic expression. G Suite - Google’s web-based productivity applications for creating documents, spreadsheets, presentations, email, and calendars. Graphics and Media Apps - Apps that allow one to interact with and edit digital media. Insertion Point - A blinking vertical line that appears when one clicks in a paragraph, cell or text box; indicating where new text or an object will be inserted. Local Applications - An application that runs from the hard drive of a local computer. Macros - A named set of instructions written in the Visual Basic programming language that perform tasks automatically in a specified order. M-commerce/Mobile Commerce - Also known as mobile commerce. These apps let one use a mobile device to make online purchases of goods and services. Microsoft Office 365 - 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. Mobile Apps - Apps that one can access on a smartphone or tablet. Mobile First Design - A design principle centered on building apps to work on mobile devices first because these typically have more restrictions, such as smaller screens. Name - A component of a function or formula that indicates what will occur. For example SUM is the name of a function. Native App - An app written for a specific operating system and installed on a computer or mobile device. On-screen Keyboard - A keyboard displayed on-screen (that includes keys for typing text, numbers, and symbols). Operators - A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell. Page Orientation - The direction in which content is printed on the page. Paint Apps - An app designed for drawing pictures, shapes, and other graphics with various onscreen tools, (such as a text, pen, brush, eyedropper, and paint bucket). Personal Interest Apps - Apps that give you tools to pursue ones interests. Photo and Image Editing Apps - Apps that provide the capabilities of paint apps and let one enhance and modify existing photos and images. Pivot Tables - A spreadsheet table designed to create meaningful data summaries that analyze worksheets containing large amounts of data. Pixels - Short for picture element, an individual point of color on a display screen or printout. Platform-Specific - Mobile apps designed for a specific operating system like Android or iPhone. Portable Apps - Apps that run from a removable storage device such as an external hard drive or flash drive, or from the cloud. Presentation - PowerPoint document that lets you create and deliver a dynamic, professional-looking message to an audience in the form of a slide show. Presentation Apps - An app that lets one create visual aids for presentations to communicate ideas, messages, and other information to a group. Presentation Software - A software program used to organize and present information in the form of an electronic slide show. Productivity Apps - Apps for personal use that one may use to create documents, develop presentations, track appointments, or to stay organized. Productivity Suite - A collection of productivity apps such as Microsoft Office 365, Apple iWork, G Suite, or Apache OpenOffice. Query - A question/request for information (formal manner) Raster - Another name for bitmap images. Read-Only Access - A way to share files so others may read the file, but cannot change it. Records - 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. Relational Database - A database that consists of a collection of tables that can be joined through a common field; each table contains information on a specific subject, stored in the same file. Relational Database Management System (RDBMS) - A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field. Relative Reference - A cell reference that changes when the formula containing that reference is moved to a new location. Report - An Access object that creates a professional printout of data that may contain enhancements (such as headers, footers, and calculations on groups of records). Responsive Design - A way to provide content so that it adapts appropriately to the size of the display on any device. Scroll Bars - Bars on the right edge (vertical scroll bar) and bottom edge (horizontal scroll bar) of a document window that let one view a document that is too large to fit on the screen at once. Server - A powerful, high-capacity computer you access using the Internet or other network; it stores files and “serves” them, that is, makes the files available to, users; (usually grouped at a location called a data center). Slide Master - 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. Slide Show - Term used to describe a PowerPoint presentation. Sort - 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). Sparklines - A quick, simple chart located within a cell that serves as a visual indicator of data trends. Spreadsheet - A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a worksheet. Structured Query Language (SQL) - A language that provides a standardized way to request information from a relational database system. Style - A named collection of formats that are stored together and can be applied to text or objects. Tables - In Access, a collection of records for a single subject, such as all of the customer records; the fundamental building block of a relational database because it stores all of the data. Template - In Computer Concepts, a document that has been preformatted for specific purpose (such as an invitation, a brochure, a flyer, a cover letter, or a resume). Transitions - The manner in which a slide appears on the screen in place of the previous slide during a slide show. Trendlines - A line that represents the general direction in a series of data. Vector - A format for storing digital images that tend to be simple images composed of shapes, lines, and diagrams. Video Editing Apps - Apps that allow one to modify a segment of a video, called a clip. View-Only Link - A link to a workbook on a OneDrive that can be viewed by users. Web App - An app stored on an Internet server that can be run entirely in a web browser. Web-Based Applications What-If Analysis - A way to explore the impact that changing input values has on calculated values and output values. Word Processing Software - Commonly used software to create documents and reports, mailing labels, flyers, brochures, newsletters, resumes, letters, and more. Workbook - A collection of related worksheets contained within a single file. Worksheet - A single sheet in a workbook file that is laid out in a grid of rows and columns.