Created by Andy Hajjar
almost 8 years ago
|
||
Question | Answer |
Absolute cell reference | A cell reference that stays the same no matter where you copy a formula. |
Accessibility | A term used to describe the degree to which the Internet is accessible by as many people as possible. |
Active cell | The cell you are working in; the cell where information or data will be input. information or data will be input. |
Adjustment handle | A control in the shape of a yellow diamond that allows you to modify a shape. |
Adware | Adware is software that displays advertisements on a person’s computer. In some cases, installation of Adware is voluntary and in exchange for a product or service. Some adware programs can include spyware. |
Align | To arrange in a line so as to be parallel |
Animation | Movement applied to individual elements on a single slide. |
Animation scheme | A built-in, standard animation effect. |
Annotation | A note that can be written or drawn on a slide for additional commentary or explanation. |
Antispyware software | Software that removes spyware from a computer. |
Antivirus software | Software that identifies and isolates (or deletes) computer viruses. |
Argument | A necessary input component required to produce the output for a function. |
Ascending order | Arranges data in alphabetical or sequential order from lowest to highest. |
ASCII (American Standard Code for Information Interchange) | A code for representing keyboard characters as numbers. |
Aspect ratio | The ratio of width to height |
Attachment | Attachment A file that is sent along with an e-mail message. |
AutoFill | An Excel operation that enables users to copy the content of a cell or a range of cells by dragging the fill handle over an adjacent cell or range of cells. |
AutoFit | The command used when formatting a spreadsheet to automatically adjust the height and width of cells. |
AutoFormat | A feature that evaluates an entire document, determines how each paragraph is used, then it applies an appropriate style to each paragraph. |
Automatic replacement | Makes a substitution automatically. |
AutoText | A feature that substitutes a predefined item for specific text but only when the user initiates it. |
AVERAGE function | The function that determines the arithmetic mean, or average, for the values in a range of cells. |
Background | The area of a display screen found behind the desktop icons. The area of a display screen found behind the desktop icons. |
Background Styles gallery | Background Styles gallery background styles for application to a theme. |
Backup | A copy of a file. |
Bandwidth | The amount of information or data that can be sent over a network connection in a given period of time, usually measured in seconds. |
Bar chart | A chart with a horizontal orientation that compares categories; useful when categorical labels are long. |
Bar tab | Does not position text or decimals, but inserts a vertical bar at the tab setting; useful as a separator for text printed on the same line. |
Bibliography | A list of works cited or consulted by an author and should be included with the document when published. |
Binary | The native format understood by computers, in which only two digits are used—zero and one. |
Biometrics | Technologies that automatically identify people through physiological and behavioural characteristics, such as fingerprints, eye retinas and voice patterns. |
Bit | A binary digit, either a one or a zero, that represents the on or off state of a computer circuit. |
Bitmap image | An image created by bits or pixels placed on a grid that form a picture. |
Blog | A personal journal entry that is posted online; short for Web Log. |
Bluetooth | A radio technology making transmission of signals over short distances between telephones, computers and other devices, like household appliances, without the use of wires. |
Bookmark | An electronic marker for a specific location in a document, enabling the user to go to that location quickly. |
Boolean operators | Commands that allow search terms to be combined to either narrow or broaden a search. Originally developed by the mathematician George Boole in the mid-19th Century. The three basic operators are: AND, OR and NOT. |
Border | A line that surrounds a paragraph, a page, a table, or an image, similar to how a picture frame surrounds a photograph or piece of art. |
Breakpoint | The lowest numeric value for a specific category or in a series of a lookup table to produce a corresponding result to return for a lookup function. |
Brightness | The ratio between lightness and darkness of an image. |
Broadband | A high-speed Internet connection. Options include DSL, cable, and satellite. |
Browser | A software application used to display Web pages, access Web resources, and search the Web. |
Building blocks | Document components used frequently, such as disclaimers, company addresses, or a cover page. |
Bulleted list | Itemizes and separates paragraph text to increase readability. |
Byte | Comprised of eight bits, a byte represents a character on the keyboard. |
Cable | A broadband Internet connection option that uses television cable to provide Internet access. |
Callout | A shape that includes a line with a text box that you can use to add notes. |
Case-insensitive search | Finds a word regardless of any capitalization used. |
Case-sensitive search | Matches not only the text but also the use of upper- and lowercase letters. |
Category label | Textual information, such as column and row headings (cities, months, years, product names, etc.), used for descriptive entries. |
CD drive | Reads from and writes to CDs |
Cell | The intersection of a column and row in a table or in an Excel spreadsheet |
Cell margin | The amount of space between data and the cell border in a table. |
Cell reference | The intersection of a column and row designated by a column letter and a row number. |
Censorship | The use of state or group power to control freedom of expression, such as passing laws to prevent media from being published or propagated. |
Center tab | Sets the middle point of the text you type; whatever you type will be centered on that tab setting. |
Change case | Feature that enables you to change capitalization of text to all capital letters, all lowercase letters, sentence case, or toggle case |
Character spacing | The horizontal space between characters. |
Character style | Stores character formatting (font, size, and style) and affects only the selected text. |
Chart | A graphic or visual representation of data. |
Chart area | The entire chart and all of its elements. |
Chat room | A virtual place on the internet where people with similar interests can meet and communicate together by typing messages on their computer in real time. |
Check box | Enables you to select one or more items that are not mutually exclusive in a dialog box. |
Citation | A note recognizing a source of information or a quoted passage. |
Clip | Any media object that you can insert in a document. |
ClipArt | A graphical image, illustration, drawing, or sketch. |
Clipboard | A memory location that holds up to 24 items for you to paste into the current document, another file, or another application. |
Close button | Removes a window from memory. |
Clustered column chart | A chart that groups similar data together in columns making visual comparison of the data easier to determine. |
Codec | Digital video compression scheme used to compress a video and decompress for playback. |
Collapsed outline | View that displays the title of slides only in the Outline view. |
Colors gallery | A gallery with a set of colors for every available there. |
Column | Formats a section of a document into side-by-side vertical blocks in which the text flows down the first column and then continues at the top of the next column. |
Column chart | A chart that displays data vertically in a column formation and is used to compare values across different categories. |
Column index number | A number, indicated by col_index_num in the function, that refers to the number of the column in the lookup table that contains the return values. |
Column width | The horizontal space or width of a column in a table or in a spreadsheet. |
Combine | Feature that incorporates all changes from multiple documents into a new document. |
Command | An icon on the Quick Access Toolbar or in a group on the Ribbon that you click to perform a task. A command can also appear as text on a menu or within a dialog box. |
Command button | A dialog box item that you click to accept or cancel selections |
Comment | A private note, annotation, or additional information to the author, another reader, or to yourself. |
Commercial software | Software that is sold and is protected by U.S. Copyright Law. |
Compare | Feature that evaluates the contents of two or more documents and displays markup balloons that show the differences between the documents. |
Compatibility checker | Looks for features that are not supported by previous versions of Word, Excel, PowerPoint, or Access |
Compress | The process of reducing the file size of an object. |
Computer maintenance | A set of services or procedures performed to keep a computer in good working condition |
Connector | A line that is attached to and moves with shapes. |
Contextual tab | A specialty tab that appears on the Ribbon only when certain types of objects are being edited. |
Contrast | The difference between the darkest and lightest areas of a image. |
Control Panel | Windows control center that enables you to change system settings, such as your background, screen saver, screen fonts, and accessibility options. |
Cookie | A text file that is sometimes saved to your computer when you visit a Web site, identifying you as a return visitor when you revisit the site later. |
Copy | The process of making a duplicate copy of the text or object leaving the original intact. |
Copyright | The legal protection afforded to a written or artistic work. |
Copyright violation | (Also known as copyright infringement ) The unauthorized use of material that is covered by copyright law, in a manner that violates one of the copyright owner's exclusive rights, such as the right to reproduce or perform the copyrighted work, or to make derivative works. |
COUNT function | The function that counts the number of cells in a range that contain numerical data |
COUNTA function | The function that counts the number of cells in a range that are not blank. |
CPU (processor) | The computer component that is considered the “brain” of the computer, coordinating all input, output, and processing activities. CPU stands for central processing unit. |
Crop | Process of reducing an image size by eliminating unwanted portions of an image. |
Cross-reference | A note that refers the reader to another location for more information about a topic. |
CRT Monitor | Monitor that is a large television-like computer output device. |
Current list | Includes all citation sources you use in the current document. |
Custom animation | An animation where the user determines the animation settings. |
Custom dictionary | A supplemental dictionary Microsoft Office uses to store items such as proper names, acronyms, or specialized words. |
Cut | Process of removing the original text or an object from its current location. |
Data | Facts about a specific record or sets of records. |
Data file | An item that you create and to which you give a name, such as a document or worksheet. |
Data label | The value or name of a data point in a chart. |
Data point | A numeric value that describes a single item on a chart |
Data series | A group of related data points that appear in row(s) or column(s) in the worksheet. |
Database | A file that consists of one or more tables and the supporting objects used to get data into and out of the tables. |
Decimal tab | Marks where numbers align on a decimal point as you type. |
Delete operation | The operation that removes all content from a cell or from a selected cell range. |
Descending order | Arranges data in alphabetical or sequential order from highest to lowest. |
Desktop | Contains icons and a taskbar. It is displayed when a computer first boots up. |
Desktop computer | A modular, stationary computer comprised of a system unit, keyboard, monitor, and mouse. |
Desktop Replacement notebook | The largest and heaviest type of notebook, which delivers the power and features almost on par with a desktop PC. Weighs about 7.5 pounds and more. |
Desktop Specifications | A term to describe the features of a desktop computer. |
Dialog box | A window that provides an interface for a user to select commands. |
Dialog box launcher | A small icon that, when clicked, opens a related dialog box. |
Dial-up connection | A connection to the Internet over a standard telephone line. |
Discussion board | A virtual message board where a person can either reply to existing messages or post new messages. A discussion board consists of "threads" and "messages." A thread is a series of messages on a particular topic, and each message is an individual contribution to a conversation. |
Distribute | To divide or evenly spread over a given area. |
Document Information Panel | Provides descriptive information about a document, such as a title, subject, author, keywords, and comments. |
Document inspector | Checks for and removes different kinds of hidden and personal information from a document. |
Document map | A pane that lists the structure of headings in your document. |
Document properties | The collection of metadata associated with a file. |
Domain | A name for the resources that make up an organization’s Web site. |
Domotics | (also called home automation) The combination of technology and services for remote or automatic control in the areas of safety, comfort and technical management around the home. |
Doughnut chart | A chart that displays values as percentages of the whole. |
Draft view | Shows a simplified work area, removing white space and other elements from view. |
Drop-down menu | Lists commands that relate to the menu name. |
DSL (Digital Subscriber Line) | High-speed Internet access provided through existing telephone lines. |
Duplex printer | A printing device that prints on both sides of the page. |
DVD drive | Reads from and writes to DVDs (unless it is a DVD-ROM disc, in which case it cannot be written to, only read from). |
E-commerce | Conducting online business through advertising, selling, and buying products. |
Effects gallery | Includes a range of effects for shapes used in a presentation. |
Electronic Piracy | To make or distribute copies of trademarked and/or copyrighted material through the internet without authorization. |
The transmission of online messages over a communication network. | |
Embedded computer | A self-contained computer device that has its own programming and typically do not receive input from you, nor do they interact with other systems |
Embedded object | An object from an external source that is stored within a presentation. |
Endnote | A citation that appears at the end of a document. |
Enhanced ScreenTip | Displays when you rest the pointer on a command on the Quick Access Toolbar or Ribbon. |
Ergonomics | The science of the design of equipment, especially so as to reduce operator fatigue, discomfort and injury. |
Ethernet | A network that uses Ethernet protocol and wiring to connect computers. |
Expanded outline | Displays the title and content of slides in the Outline view. |
Exploded pie chart | A chart that separates one or more slices of the pie for emphasis. |
Fast user switching | A Windows feature that enables you to quickly move from one user account to another. |
Favorite | A marker that identifies a Web page so that you can quickly display the page later, also called a "bookmark". |
File | A collection of data or information that has a name. |
File transfer protocol (ftp) | Used for uploading, storing, and downloading sharable files over the Internet. |
Filename | An identifier that you give a file when you save it. |
Fill | The inside of a shape. |
Fill handle | A small black solid square in the bottom-right corner of a selected cell. It is used to duplicate formulas. |
Filter | Condition that helps you find a subset of data meeting your specifications. |
Final Showing Markup | A view that displays inserted text in the body of the document and shows deleted text in a balloon. |
Find | Locates a word or group of words in a file. |
Firewall | Software that acts as a barrier between your computer and the Internet, prohibiting unauthorized Internet travel to or from the computer. |
First line indent | Marks the location to indent only the first line in a paragraph. |
Flowchart | An illustration showing the sequence of a project or plan. |
Folder | An object that can hold multiple files and subfolders. / A named area of storage on a disk. |
Font | A complete set of characters—upper- and lowercase letters, numbers, punctuation marks, and special symbols with the same design. |
Fonts gallery | Contains font sets for title text and body text. |
Footer | Information printed at the bottom of document pages. |
Footnote | A citation that appears at the bottom of a page. |
Format cells | Operations that control the formatting for numbers, alignment, fonts, borders, colors, and patterns in a particular cell. |
Format painter | Feature that enables you to copy existing text formats to other text to ensure consistency. |
Formatting text | Changes an individual letter, a word, or a body of selected text. |
Formula | The combination of constants, cell references, arithmetic operations, and/or functions displayed in a calculation. |
Formula bar | The area used to enter or edit cell contents. |
Frame | A boxed area, usually located at the side or top of a Web page, containing links and additional information. |
Freeform shape | A shape that combines both curved and straight lines to create a shape. |
Freeware | Copyrighted software that you can use as you like. |
Freezing | The process that enables you to keep headings on the screen as you work with large worksheets, rows and column. |
Full Screen Reading view | Eliminates tabs and makes it easier to read your document. |
Function | A preconstructed formula that makes difficult computations less complicated. |
FV function | The function that returns the future value of an investment if you know the interest rate, the term, and the periodic payment. |
Gallery | Displays a set of predefined options that can be clicked to apply to an object or to text. |
Gigahertz | Measurement of processor speed, usually in billions of hertz. |
Go To | Moves the insertion point to a specific location in the file. |
Gradient fill | A blend of colors and shades. |
A blend of colors and shades. | A blend of colors and shades. |
Group | Categories that organize similar commands together within each tab on the Ribbon. |
Grouping | Combining two or more objects. |
Guide | A straight horizontal or vertical line used to align objects. |
Hacking | Accessing illegally or without authorization computers, accounts, equipment or networks belonging to another party, or attempting to penetrate security measures of another system. |
Hanging indent | Aligns the first line of a paragraph at the left margin and indents the remaining lines. |
Hard copy | Printed output. |
Hard disk | A large-capacity storage device housed in the system unit. |
Hard drive | Stores programs and data files. A constant supply of electricity is not necessary to ensure the maintenance of hard drive contents. |
Hard page break | Forces the next part of a document to begin on a new page |
Hard return | Created when you press Enter to move the insertion point to a new line. |
Header | Information printed at the top of document pages. |
Help and Support Center | Provides assistance on Windows topics. |
Hidden | In Excel, the process of making rows, columns, and sheets invisible. |
Hidden text | Document text that does not appear onsc |
Hierarchy | Denotes levels of importance in a structure. |
Highlight | Background color used to mark text that you want to stand out or locate easily. |
Home page | The Web page that displays when you open Internet Explorer. Also refers to the main Web page for an organization’s Web site. |
Horizontal alignment | The placement of text between the left and right margins. |
Hotspot | A public location where Wi-Fi Internet access is available. |
Hub | A device that rebroadcasts communication to all equipment on a network. |
Want to create your own Flashcards for free with GoConqr? Learn more.