Study sets, textbooks, questions
Upgrade to remove ads
MS Excel 2007 & Computer Terminology
Terminology for MS Excel 2007
Terms in this set (60)
Formerly call the toolbar this area contains tabs such as home and insert.
Relative Cell Reference
As a formula or function is filled, copied and pasted to other cells, it references in the formula or function change to reflect the function's new location.
The function name is followed by it in parentheses and tells Excel which values to calculate.
Cell that contain the insertion point and is identified by a dark border around the cell. Its address is shown in the formula bar. Any action you perform is performed on the active cell.
The area on the Desktop that is currently being used and which usually contains a file or an application.
Line effects that you can place around cells or cell ranges to improve the appearance or effectiveness of your worksheets.
It is the intersection of a row and a column. It can contain a label, a numeric value, or a formula.
It is the location of a cell on a worksheet and is defined by the column letter and the row number. For example, cell A1 is where column A and row 1 intersect.
Graphical presentations of data from a worksheet.
Vertical divisions of a worksheet that are identified by letters.
Returns the number of numerical items in the range in the argument.
An expression entered in a cell that performs numeric calculation, logical comparison, or text string manipulation.
Located under the toolbars at the top of the working screen it contains the edit line for working with formulas, and provides information regarding cell addresses.
Developed the Analytical and Difference Engines but was unable to successfully build the machines.
A key to the data illustrated in a chart.
Returns the largest value in the range in the argument.
Returns the smallest value in the range in the argument.
Located on the formula bar, indicates the current address of the active cell or cell range.
Used to tell Excel what mathematical functions to perform in a formula. The following symbols are examples which are used most often in Excel formulas: Addition (+) Subtraction (-) Multiplication (*) and Division (/).
A block of cells that can be selected, manipulated, named, or formatted as a group.
The horizontal divisions of a worksheet that are identified by numbers.
They contain the names of the worksheets in a workbook at the bottom of the working screen.
Generic term for applications, such as Excel, that you can use to enter, analyze, and calculate data. It performs mathematical calculations and projections based on data entered.
Located at the bottom of the screen and provides information about the particular operation in progress. The right side of it contains information regarding CAPS LOCK, NUM LOCK, and AutoCalculate.
Adds the values in the function argument or the values in the cell references in the argument.
The Excel file that stores your information. Each one may contain numerous worksheets.
A cell formatting option that forces text to break into lines within a cell.
Returns the number of items in the range in the argument.
Returns the number of cells in the range in the argument that do not contain any items.
Most printers will allow you to print your document so that the information can be read in one of two ways of viewing the page. Portrait is long. Landscape is wide.
A command that stores a new file or an existing file under a new name onto a disk.
A command that stores a file or changes to a file onto a disk.
A black symbol in the lower right corner of the active cell. Clicking-and-dragging this can copy cell contents or create a series. If Excel recognizes the cell contents as a series, it will continue the series. If Excel doesn't recognize the cell contents as a series, it will copy the contents to the other cells.
The default setting for numbers.
A number or cell reference in the formula.
A feature that copies format attributes such as colors, borders and fill effects from an object, text, or cell in order to apply the same formatting to another object, text or cell.
By dragging the handle of the cell Excel recognizes the cell contents as part of a series and will complete other selected cells with the next items in the series.
Quick Access Toolbar
It is located to the right of the Microsoft Office Button, which provides quick access to tools you need often such as Save, Undo, and Repeat Typing
developed punch cards & electric tabulating for the 1890 census. The effort was the beginning of IBM.
French inventor of a loom that could automatically weave complicated patterns by use of a program (1752-1834)
first major invention in electronics. Was used in radio, TV's, and early computers. They ran very hot and were easily damaged.Use in the creation of the first generation of computers.
A tiny circuit device invented in 1947 that amplifies, controls, and generates electrical signals. Use in the creation of the second generation of computers.
(from a combination of MOdulate and DEModulate) electronic equipment consisting of a device used to connect computers by a telephone line
a small crystal semiconductor fabricated to carry out a number of electronic functions. Use in the creation of the third generation of computers., electronic equipment consisting of a small crystal of a silicon semiconductor fabricated to carry out a number of electronic functions in an integrated circuit
The main circuit board of a microcomputer. The motherboard contains the connectors for attaching additional boards.
a small plastic magnetic disk enclosed in a stiff envelope with a radial slit. Used to store data or programs for a microcomputer and are noted for their relatively slow speed and small capacity and low price.
computer hardware that holds and spins a magnetic or optical disk and reads and writes information on it
the most common computer memory which can be used by programs to perform necessary tasks while the computer is on.
A chip on the motherboard that is prerecorded with and permanently stores the set of instructions that the computer uses when you turn in on; permanent memory
Electronic Numerical Integrator and Computer; U.S. government-sponsored machine developed to calculate the settings used for weapons. Often considered the first computer.
a hand-operated electronic device that controls the coordinates of a cursor on your computer screen as you move it around on a pad
Absolute Cell Reference
cell reference that does not adjust to the new cell location when copied or moved
Daughter of Lord Byron and is consider the first programmer. Worked with Babbage.
Allows the user to send information to the computer. Any hardware component that allows you to enter data, programs, commands, and user responses a computer. Example: Keyboard.
Sends information from the computer to another devise. Lets users examine the results of processed data (monitor, printer, speakers)
The Brain of the computer - the central processing unit., The part of a computer (a microprocessor chip) that does most of the data processing.
A circular chart divided into triangular areas proportional to the percentages of the whole
A graph that uses line segments to show changes that occur over time
Type of graph most often used for categorical data
The basis of computer system programming, These digits operate on a base-16 number system rather than the base-10 number system most people use. These numbers use the letters A, B, C, D, E, and F along with the numbers 0 to 9 to create their 16 different digits.
Sets with similar terms
COMPUTER APPLICATION MIDTERM 2016
Mdl Productivity Programs glossary
Computer Applications 7 - Excel Vocab
Spreadsheet Basics Terms
Other sets by this creator
Indian Patent Acts
Last Minute History Set