Flashcards
Introductioin to computers
Cards in this deck (38)
- 1An equation in a worksheet is called aFormula
- 2Entries that contain text and numeric information that are not use in calculations are calledlabels
- 3Numbers formulas and functions that are used in calculations are calledValues
- 4What symbol do all functions start with?= an equal sign
- 5Give an example of a formula=(D1+d8)
- 6A_____ uses more than one arithmetic operator.Complex Formula
- 7A _____ is a predefined worksheet formula that enables you to perform complex calculations easilyFunction
- 8Give an example of an excel funtionAverage
- 9This type of cell reference is used when you want to preserve the relationship to the formula locationRelative
- 10This type of cell reference is used when you want to preserve the exact cell address in a formulaAbsolute
- 11Which type of cell reference allows MS excel to auto-adjust a cell address or rangeRelative
- 12Which type of cell reference does NOT allow MS excel to auto-adjust a cell address or rangeAbsolute
- 13The ____ feature is used to auto-adjust a columns width so its data can be seenAutofit
- 14_____ applies different formats to data if the data meets the criteria you specifyConditional Formatting
- 15An excel workbook can contain one or more ____sheets
- 16A chart is a visual display of data. To create a chart you must first select the _____.Range of Data
- 17List three common chart typesPie, Line, and Bar
- 18What is another name for the horizontal axis of a chartX
- 19What is another name for the vertical axis of a chartY
- 20What is Presentation SoftwareA computer program used to organize and present information
- 21List the five things that are important to do when planning a presentationDetermining and outlining your message...Identifying the audience and delivery location...Determining the type of output...Determining the design...Deciding on additional materials needed.
- 22What is a slide layout?Contains text and object placeholders that are arranged in a specific way on the slide.
- 23What is a theme?A design theme includes a set of twelve coordinated colors, fonts for titles and other text called theme fonts. And affects for lines and fills called theme effects
- 24List the 6 primary views that power point has.Normal view, Notes page view, Slide show view, sorter view, Outlines view, reading view.
- 25What is smart artA smart art graphic is a professional quality diagram that visually illustrates text
- 26What does merging shapes mean?Combining multiple shapes together
- 27List any five things you can insert into a presentationtext from Microsoft word, text box, chart, table, pictures
- 28What is a handoutPrinted Hard copy of power point and can have up to 9 slides per page.
- 29What is relational database softwareLists of information that relate to one an another. Can manage data that is organized into lists such as info about customers, products, vendors, employees, sales,etc.
- 30List any three advantages of using access for database managementData entry faster, increases accuracy, information is more secure.
- 31Acess uses four main objects. List themTable, query, report, form
- 32What is a table?A table contains all of the raw data within the database in a spread sheet like view. Tables are linked with a common field to create a relational database, which minimizes redundant data.
- 33What is a query?Queries allows you to select a subset of fields or records from one or more tables. Queries are created when you have a question about the data.
- 34What is a form?Provides an easy to use data entry screen
- 35What is a report?Provides a professional printout of data that can contain enhancements such as headers, footers, graphics, and calculations on groups of records.
- 36What is the primary key field of a table?Contains data that uniquely identifies each record. No two records can have the same entry in this field.
- 37What is a one to many relationships?One record in the first table is related to many records in the second table
- 38What is another name for query datasheet view?
Information
- Description
- Flashcards on Introductioin to computers, created by Karis Marie on 16/12/2015.
- Created by
- Karis Marie
- Views
- 2
- Rating