PART1

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.
E-mail	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.

Next up

Description

Resource summary

Similar

	Created by Andy Hajjar over 7 years ago