66 terms

Computer Exam

exam terms
STUDY
PLAY

Terms in this set (...)

Format
the format of a cell determines how the labels and values are presented as boldfaced, italicized, dollar signs, and/or commas
Font
the name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design
Font size
the physical size of the text, measured in units called points
Point
1/72 of an inch
Column heading
the box at the top of each column containing a letter
Row Heading
the box at the beginning of each row containing a number
Cell Styles
predesigned combination of formatting attributes
Absolute cell reference
this type of reference doesn't alter its formula when it is being copied from one cell to another allowing the user to retrieve information from that specific cell
Relative cell reference
When copying formulas from one cell to another, such as A1 and G1, this feature automatically changes the cell reference, or range.
Functions
Predefined worksheet formulas that enable you to perform simple calculations, as well as, complex calculations easily.
Complex Formula
formula using more than one arithmetic operator, such as, A1=8*(2+5)/4
Reference operators
enables you to use ranges in you calculations
Comparison operators
compare values for the purpose of true/false results using Boolean (AND, OR, NOT) or (≠, ≥, ≤, =, <, >)
Arithmetic operators
perform mathematical calculations such as (+, -, /, *)
Calculation operators
indicate what type of calculation you want to perform on the cells, range, or values and include arithmetic operators, comparison operators, text concentration operators, and reference operators
Formula Prefix
denoted by an = and is used to start a formula in Excel worksheet. Formulas start with the formula prefix, followed by the cell address, range names, values, and calculation operators
Edit
change the contents in an active cell
Arguments
the information necessary to calculate the answer
Function
a built in formula including the arguments, as well as cell references and other unique information
Values
numbers, formulas, and functions that can be used in calculations
Labels
Entries that contain text and numerical information not used in calculations such as "2009 sales" or "travel expenses"
Formulas:
equations within a worksheet that can be to make calculations as simple as adding a column of numbers, or as complex as profit- and - loss projections for a global corporation
Go to
activated by [F5], enables you to select a range of cells by typing the desired range
Anchor
activated by [F8], enables you to select a range of cells by clicking the beginning and ending range
Range
a selection of more than 2 or more cells such as B5: B14
Mode indicator
Located at the bottom left corner of the status bar and provides additional information about the certain task
Status bar
Located at the bottom of the Excel window and provides additional information about the certain task
Scroll bars
used to navigate around the worksheet when it is too large to fit on the screen at once
Sheet tabs
tabs which allow you to navigate between the multiple sheets of a workbook. The default number of tabs is 3
Active cell
the current cell you are working in
Cell pointer
a dark rectangle that outlines the cell that you are working in
Formula Bar
Allows you to enter or edit data In the worksheet
Name Box
Displays the active cell address
Cell address
the coordinates of an intersecting row and column
Cell
the intersection of a row and column
Title Bar
located at the top of the document and displays the Document and Program Name
Ribbon
Located below the title bar and displays commands needed for current task
Tabs
organize commands within the ribbon. Active tabs are highlighted
Office button
contains common commands such as Open/Save/Print File
Zoom Slider
located at the bottom of the window to the far right of the Status Bar
Quick Access Toolbar
located to the right of the MSO button (contains commonly used tasks such as save, undo, redo and can be edited using the drop down
Status Bar
located at the bottom of the window and contains information pertaining to the document such as page number, word count page layout, and the zoom slider
Vertical/Horizontal Bar
located at the right of the window and bottom of the window above status bar when available and allows you to scroll left/right/up/down within the document
Insertion point
blinking cursor which indicates where typed text will appear
I- Beam Pointer
moves the insertion point in a document or selects text
Selection Pointer
arrow pointing towards the left. Appears when pointing to the elements of the Word program window such as command buttons
Right Pointer
Arrow pointing towards the left. Used to select a line or lines of text. Appears when you point to the left edge of a line of text in a document window
Footnote/Endnote
an explanatory note that consists of two linked parts: The note reference mark that appears next to text to indicate that additional information is offered. Word places footnotes at the end of the page and endnotes at the end of the document.
Outline
A multilevel numbered or bullet list
Bullet
a character, often a small circle, that appears before items in a list to add emphasis. A numbered list is used to illustrate sequences and priorities
Indent Markers
These are on the horizontal ruler and indicate the indent settings for the paragraph. Dragging the indent marker to a new location is one way to change indentation; changing the indent settings in the Paragraph group on the Page Layout tab is another; and using the indent buttons in the Paragraph group on the Home tab is a third. We will talk about which marker controls which indentation in class.
Indent
When indenting a paragraph, you move its edge in from the left or right margin You can indent the paragraph, just the first line, or all lines except the first line.
Tab Stop
A point on the horizontal ruler that indicates the location at which to align text. By default, they are located every ½" from the left margin.
Justify
This alignment style places texts flush along the left and right margins.
Center-Align
Text is placed evenly between the left and right margins.
Right-Align
Text is flush (even) with the right margin
Left-Align
By default text is left-aligned in a document or flush (even) with the left margin.
Alignment
Paragraphs are aligned relative to the left and right margins in a document, or the center of a document.
Style
set of formats, such as font, font size, and paragraph alignment, which are named and stored together. Ms Word includes a set of Quick Styles that are designed to be used together in a document
dialog box launcher
A small arrow in the lower-right corner of a group on the Ribbon that you click to open a dialog box or task pane with more options. provides an additonal of extension of related commands
spelling and grammar
this feature displays a red or green wavy line under the text where a speeling of grammar error has occured
word wrap
setting that automatically starts a new line of text when the margin is reached
save
feature that allows you to store permanently a document with a directory
filename
the name of a saved document
mini toolbar
Appears when you first select text. Contains commonly used text and paragraph formatting commands.
screen tip
an explainatory not that consists of two parts: the note reference mark that appears next to the text to indicate that additional information is offered