How can we help?

You can also find more resources in our Help Center.

Study sets matching "excel chapter 3 microsoft office"

Study sets
Classes
Users

Study sets matching "excel chapter 3 microsoft office"

28 terms
Microsoft office 2010 Excel Chapter 3 Terms
Assumptions
25%
1 and 90 Degrees
Zero Degrees
The cell references in a formula are called
how many business worksheets has error in them
Excel allows you to rotate text in a cell counterclockwise by…
text is by default at
Assumptions
The cell references in a formula are called
25%
how many business worksheets has error in them
28 terms
Microsoft Office Excel Chapter 3
~Hunter D Groves
Categories
Chart
Chart Sheet
3rd Hour... Seat #28
In most cases, each column of charted worksheet data contains…
A graphic that compares and contrasts worksheet data in a vis…
A chart that occupies its own worksheet.
~Hunter D Groves
3rd Hour... Seat #28
Categories
In most cases, each column of charted worksheet data contains…
42 terms
Microsoft Office: Excel Chapter 3 Vocabulary
3-D
Absolute cell reference
Axis
Base
The shortened term for three-dimensional, which refers to an…
A cell reference that refers to cells by their fixed position…
A line that serves as a frame of reference for measurement an…
The starting point when you divide the amount of increase by…
3-D
The shortened term for three-dimensional, which refers to an…
Absolute cell reference
A cell reference that refers to cells by their fixed position…
16 terms
MIcrosoft Office Excel Chapter 3 Vocabulary
Office Clipboard
Drag and Drop
#REF!
Format Symbol
a reserved place in the computer's memory that allows you to…
using the mouse to move or copy cells
indicates a cell reference error
valid format symbols include the dollar sign, comma, and perc…
Office Clipboard
a reserved place in the computer's memory that allows you to…
Drag and Drop
using the mouse to move or copy cells
28 terms
Microsoft office 2010 Excel Chapter 3 Terms
The cell references in a formula are c…
how many business worksheets has error…
Excel allows you to rotate text in a c…
text is by default at
assumptions
25%
1 & 90 degrees
zero degrees
The cell references in a formula are c…
assumptions
how many business worksheets has error…
25%
10 terms
Microsoft office 2013: Excel Chapter 3 True/False
Excel allows you to rotate text in a c…
If you drag the fill handle to the lef…
When you move or copy a cell, the data…
Excel displays the error message #NULL…
TRUE
TRUE
FALSE
FALSE
Excel allows you to rotate text in a c…
TRUE
If you drag the fill handle to the lef…
TRUE
9 terms
Skills for Success with Microsoft Office 2010 Excel Chapter 3 Vocabulary
Clipboard
Clustered bar chart
detail sheet
Drag and Drop
A temporary storage area for items that are cut or copied
A bar chart that groups several values side by side within th…
A worksheet with cells referred to by summary sheet formulas.
A feature that allows a user to select text using a mouse or…
Clipboard
A temporary storage area for items that are cut or copied
Clustered bar chart
A bar chart that groups several values side by side within th…
17 terms
Word, Chapter 3, Microsoft Office
border
building block
business letter
cell
line on one or more edges of a paragraph, a boundary between…
can be used to store text or graphics you use often, an impor…
a letter that is sent to or from a company, includes inquirie…
intersection of a row and column in a table, a small compartm…
border
line on one or more edges of a paragraph, a boundary between…
building block
can be used to store text or graphics you use often, an impor…
21 terms
Microsoft Office-Chapter 3
Bulleted list
Center tab
Decimal tab
Endnote
List created with each item as a separate paragraph formatted…
Centers the text equidistant over the stop
Aligns the decimal point at the stop
Used to document a source. Found on the last page of a docume…
Bulleted list
List created with each item as a separate paragraph formatted…
Center tab
Centers the text equidistant over the stop
7 terms
Microsoft Excel Chapter 3
The labels along the lower edge of the…
A sequential number assigned to a date
The mathematical rules that specify th…
A worksheet that displays and recaps t…
Worksheet tabs
Serial Number
Operator pre
Summary sheet
The labels along the lower edge of the…
Worksheet tabs
A sequential number assigned to a date
Serial Number
12 terms
Microsoft Excel Chapter 3
Default settings
Group
Navigation pane
Print options
Pre-set options that determine how Excel will behave when per…
Commands related in functionality according to the tab they a…
A pane found on the left side of Backstage view. It provides…
A series of settings that allow you to change how a document…
Default settings
Pre-set options that determine how Excel will behave when per…
Group
Commands related in functionality according to the tab they a…
43 terms
Chapter 3 (Microsoft Office)
American Psychological Association (APA)
Bibliography
Brightness
Citation
One of two commonly used style guides for formatting research…
A list of cited works in a report or research paper; Also ref…
The relative lightness of a picture
A note inserted into a text of a research paper that refers t…
American Psychological Association (APA)
One of two commonly used style guides for formatting research…
Bibliography
A list of cited works in a report or research paper; Also ref…
5 terms
Microsoft Excel Chapter 3
Print options
Default options
Group
Navigation pane
a series of settings that allow you to change how a the docum…
pre-set options that determine how Excel will behave when per…
they are related in functionality and are located in the ribbon
Letters and numbers
Print options
a series of settings that allow you to change how a the docum…
Default options
pre-set options that determine how Excel will behave when per…
32 terms
Chapter 3 Microsoft office
After previous
Animation
Animation painter
Background style
An animation option that begins the animation sequence for th…
A visual or sound effect added to an object or text on a slide
A feature that copies animation settings from one object to a…
A slide background fill variation that combines theme colors…
After previous
An animation option that begins the animation sequence for th…
Animation
A visual or sound effect added to an object or text on a slide
28 terms
Microsoft Office chapter 3
Behind text
Border
Building block
Cell
Text wrapping option where object appears behind
Solid line on the edge of a paragraph
Where you can story text and graphics to use frequently
Intersection of row and column in a table
Behind text
Text wrapping option where object appears behind
Border
Solid line on the edge of a paragraph
Microsoft Excel Chapter 3
<
<=
<>
>
less than
less than or equal to
not equal to
greater than
<
less than
<=
less than or equal to
33 terms
Microsoft Excel Chapter 3
3-D
Absolute cell reference
Axis
Base
refers to an image that appears to have three spatial dimensi…
cell reference that does not adjust to the new cell location…
Reference that refers to cells by their fixed position in a w…
Starting point when you divide the amount of increase by it t…
3-D
refers to an image that appears to have three spatial dimensi…
Absolute cell reference
cell reference that does not adjust to the new cell location…
25 terms
Microsoft Excel Chapter 3
Chart
Chart Area
Plot Area
Data Series
Visual representation of numeric data... -Compares data... -Reveals…
Contains the entire chart and all of the elements.
Region containing the graphical representation of the values…
Group of related data points
Chart
Visual representation of numeric data... -Compares data... -Reveals…
Chart Area
Contains the entire chart and all of the elements.
20 terms
Microsoft Office Excel Part 3
Axis title
Bar chart
Category axis
Chart area
A label that describes either the category axis or the value…
A chart type that compared values across categories using hor…
The chart element that displays descriptive group names or la…
A boundary that contains the entire chart ad all of its eleme…
Axis title
A label that describes either the category axis or the value…
Bar chart
A chart type that compared values across categories using hor…
32 terms
Microsoft Office Excel Chapter 2
Argument
AutoCalculate
Formula AutoComplete
Function
The values and other inputs that a function uses to calculate…
A feature that temporarily performs the following calculation…
A feature that speeds up the manual entry of functions.
A predefined formula that performs a specific calculation usi…
Argument
The values and other inputs that a function uses to calculate…
AutoCalculate
A feature that temporarily performs the following calculation…
25 terms
Microsoft Excel Chapter 3
Categories
Chart
Chart sheet
Data marker
In most cases, each column of charted worksheet data contains…
A graphic that compares and contrasts worksheet data in a vis…
A chart that occupies its own worksheet.
The shape—bar, column, line, pie slice, and so on—representin…
Categories
In most cases, each column of charted worksheet data contains…
Chart
A graphic that compares and contrasts worksheet data in a vis…
21 terms
Microsoft Excel Chapter 3
>
=>
<
=<
Greater than
Greater than or Equal to
Less than
Less than or equal to
>
Greater than
=>
Greater than or Equal to
37 terms
Microsoft Office Excel Chapter 2
~Hunter D Groves
Argument
Auto Calculate
Formula AutoComplete
Seat #... 3rd Hour
The values and other inputs that a function uses to calculate…
A feature that temporarily performs the following calculation…
A feature that speeds up the manual entry of functions.
~Hunter D Groves
Seat #... 3rd Hour
Argument
The values and other inputs that a function uses to calculate…
32 terms
Microsoft Office Excel Chapter 2
Argument
AutoCalculate
Formula AutoComplete
Function
The values and other inputs that a function uses to calculate…
A feature that temporarily performs the following calculation…
A feature that speeds up the manual entry of functions.
A predefined formula that performs a specific calculation usi…
Argument
The values and other inputs that a function uses to calculate…
AutoCalculate
A feature that temporarily performs the following calculation…
19 terms
Microsoft Office Excel 2010: Lesson 3
automatic page break
copy
cut
fill handle
A page break Excel inserts whenever it runs out of room on a…
To duplicate a cell's contents without affecting the original…
To move cell contents from the original position and place in…
The black square in the lower-right corner of the active cell…
automatic page break
A page break Excel inserts whenever it runs out of room on a…
copy
To duplicate a cell's contents without affecting the original…
71 terms
Microsoft Office: Excel Chapter 1 Vocabulary
Active cell
Arithmetic operators
Auto Fill
AutoCalculate
The cell, surrounded by a black border, ready to receive data…
The symbols +, -, *, /, %, and ^ used to denote addition, sub…
An Excel feature that generates and extends values into adjac…
A feature that displays three calculations in the status bar…
Active cell
The cell, surrounded by a black border, ready to receive data…
Arithmetic operators
The symbols +, -, *, /, %, and ^ used to denote addition, sub…
43 terms
Chapter.3 Microsoft office vocab
American Psychological Association
Bibliography
Brightness
Citation
One of two commonly used style guides for formatting papers.
A list of cited works in a report or research paper; also ref…
The relative lightness of a picture.
A note inserted into the text of a research paper that refers…
American Psychological Association
One of two commonly used style guides for formatting papers.
Bibliography
A list of cited works in a report or research paper; also ref…
45 terms
Microsoft Office Excel
Absolute Cell Reference
Accounting Number Format
Active Cell
Auto Fill
A cell reference that refers to cells by their fixed position…
The excel number format that applies a thousand comma separat…
The cell, surrounded by a black border, ready to receive data…
An Excel feature that generates and extends values into adjac…
Absolute Cell Reference
A cell reference that refers to cells by their fixed position…
Accounting Number Format
The excel number format that applies a thousand comma separat…
30 terms
Microsoft Excel 2010: Chapter 3
zero
split double
#REF
freezing
when you first enter text, its angle is _____ degrees, and it…
the _____ ______ arrow mouse pointer is the result of moving…
excel displays the error message ______ in cells to indicate…
______ worksheet titles is a useful technique for viewing lar…
zero
when you first enter text, its angle is _____ degrees, and it…
split double
the _____ ______ arrow mouse pointer is the result of moving…
20 terms
Microsoft office word Chapter 3
drawing object
crosshair pointer
Tight
Reset Picture
a___is a graphic that you can create using word
when the mouse pointer changes to a(n) ___, you can drag from…
The___ text wrapping option wraps text around the object, wit…
With a graphic selected, you would click the___ button to rem…
drawing object
a___is a graphic that you can create using word
crosshair pointer
when the mouse pointer changes to a(n) ___, you can drag from…
32 terms
Microsoft Office Chapter 3 Vocab
After Previous
Animation
Animation painter
Background style
An animation option that begins the animation sequence for th…
A visual or sound effect added to an object or text on a slide
A feature that copies animation settings from one object to a…
A predefined slide background fill variation that combines th…
After Previous
An animation option that begins the animation sequence for th…
Animation
A visual or sound effect added to an object or text on a slide
32 terms
Microsoft Office Chapter 3 Vocab
After Previous
Animation
Animation painter
Background style
An animation option that begins the animation sequence for th…
A visual or sound effect added to an object or text on a slide
A feature that copies animation settings from one object to a…
A predefined slide background fill variation that combines th…
After Previous
An animation option that begins the animation sequence for th…
Animation
A visual or sound effect added to an object or text on a slide
69 terms
Microsoft Office Excel 2010
A spreadsheet
A worksheet
A workbook
Planning Structure of Worksheets
is an electronic file used to organize related data and perfo…
is a spreadsheet that contains formulas, values, text, and vi…
is a file containing related worksheets
-State the purpose of the worksheet... -Decide what input values…
A spreadsheet
is an electronic file used to organize related data and perfo…
A worksheet
is a spreadsheet that contains formulas, values, text, and vi…
35 terms
Microsoft Office: Excel Chapter 2 Vocabulary
Arguments
Average function
Comparison operators
Conditional format
The values that an Excel function uses to perform calculation…
An Excel function that adds a group of values, and then divid…
Symbols that evaluate each value to determine if it is the sa…
A format that changes the appearance of a cell—for example, b…
Arguments
The values that an Excel function uses to perform calculation…
Average function
An Excel function that adds a group of values, and then divid…
41 terms
chapter 3 Microsoft office program
American Psychological Association
Bibliography
Brightness
Citation
(APA) One of two commonly used style guides for formatting re…
A list of cited works in a report or research paper; also ref…
The relative lightness of a picture.
A note inserted into the text of a research paper that refers…
American Psychological Association
(APA) One of two commonly used style guides for formatting re…
Bibliography
A list of cited works in a report or research paper; also ref…
30 terms
Microsoft Excel 2010: Chapter 3
zero
split double
#REF
freezing
when you first enter text, its angle is _____ degrees, and it…
the _____ ______ arrow mouse pointer is the result of moving…
excel displays the error message ______ in cells to indicate…
______ worksheet titles is a useful technique for viewing lar…
zero
when you first enter text, its angle is _____ degrees, and it…
split double
the _____ ______ arrow mouse pointer is the result of moving…
18 terms
Microsoft Office 2007 Chapter 3
Clear paragraph formatting
Copy text
Cut text
Paste text
Ctrl + Q
Ctrl + C
Ctrl + X
Ctrl + V
Clear paragraph formatting
Ctrl + Q
Copy text
Ctrl + C
16 terms
Microsoft Office Excel 2007 Chapter 3: What-If Analysis, Charting, and Working with Large Worksheets
Office Clipboard
Drag and Drop
#REF!
Format Symbol
a reserved place in the computer's memory that allows you to…
using the mouse to move or copy cells
indicates a cell reference error
valid format symbols include the dollar sign, comma, and perc…
Office Clipboard
a reserved place in the computer's memory that allows you to…
Drag and Drop
using the mouse to move or copy cells
26 terms
Excel (Microsoft Office)
Workbook
Worksheets
Spreadsheet
Column
An Excel file with one or more worksheets.
the name given to an Excel spreadsheet, divided into rows and…
Another name for a worksheet.
A vertical selection of cells identified by one or more lette…
Workbook
An Excel file with one or more worksheets.
Worksheets
the name given to an Excel spreadsheet, divided into rows and…
34 terms
Microsoft Excel- Chapter 3 Vocab
3-D
Absolute cell reference
Axis
Base
Stands for three dimensional
cell reference that does not adjust to the new cell location…
a line that serves as a frame of reference
the starting point when you divide the amount of increase by…
3-D
Stands for three dimensional
Absolute cell reference
cell reference that does not adjust to the new cell location…
Microsoft Excel Chapter 3 Vocabulary
Office Clipboard
Drag and Drop
#REF!
Format Symbol
a reserved place in the computer's memory that allows you to…
using the mouse to move or copy cells
indicated cell reference error
percent, comma, or dollar sign
Office Clipboard
a reserved place in the computer's memory that allows you to…
Drag and Drop
using the mouse to move or copy cells
33 terms
Microsoft Excel 2013 Chapter 3
absolute cell reference
assumptions
Copy button
Copy Cells
Keeps the same cell reference as it copies a formula from one…
Values in cells that you can change to determine new values f…
Button used to copy contents and format of a source area to t…
Auto Fill option that fills destination area but does not cre…
absolute cell reference
Keeps the same cell reference as it copies a formula from one…
assumptions
Values in cells that you can change to determine new values f…
30 terms
Microsoft Office 2013: PowerPoint Chapter 3
Color _____ changes the intensity of c…
____ effects convert the photo into a…
____ Forward moves an object toward th…
_____ are displayed when a placeholder…
Saturation
Recolor
Bring
Selection handels
Color _____ changes the intensity of c…
Saturation
____ effects convert the photo into a…
Recolor
19 terms
Microsoft Excel Chapter 3 Vocabulary
<
<=
<>
>
...
...
...
...
<
...
<=
...
37 terms
Microsoft Office 2013 Excel - Chapter 5
Selection
Smart Art
Static
Ungroup
An area isolated with the mouse or cell references
Art items that are used to display relationships
A consolidation that does not change when data changes
To remove outlining on selection of data
Selection
An area isolated with the mouse or cell references
Smart Art
Art items that are used to display relationships
122 terms
Microsoft Office Excel
Active cell
Cell
Cell address
Formula bar
contains the cell pointer and is outlined by a dark box
intersection of a column and a row on a worksheet
location of a cell in a worksheet as identified by its column…
located above the worksheet data appears here
Active cell
contains the cell pointer and is outlined by a dark box
Cell
intersection of a column and a row on a worksheet
69 terms
Microsoft Office Excel 2010
A spreadsheet
A worksheet
A workbook
Planning Structure of Worksheets
is an electronic file used to organize related data and perfo…
is a spreadsheet that contains formulas, values, text, and vi…
is a file containing related worksheets
-State the purpose of the worksheet... -Decide what input values…
A spreadsheet
is an electronic file used to organize related data and perfo…
A worksheet
is a spreadsheet that contains formulas, values, text, and vi…
33 terms
Microsoft Excel 2013 Chapter 3
absolute cell reference
assumptions
Copy button
Copy Cells
Keeps the same cell reference as it copies a formula from one…
Values in cells that you can change to determine new values f…
Button used to copy contents and format of a source area to t…
Auto Fill option that fills destination area but does not cre…
absolute cell reference
Keeps the same cell reference as it copies a formula from one…
assumptions
Values in cells that you can change to determine new values f…
37 terms
CSC Microsoft Excel Chapter 3
100% Stacked Column Chart
Area Chart
Axis
Axis Title
A chart type that places (stacks) data in one column per cate…
A chart type that emphasizes magnitude of changes over time b…
Category or incremental value labels to identify the measurem…
A label that describes either the category axis or the value…
100% Stacked Column Chart
A chart type that places (stacks) data in one column per cate…
Area Chart
A chart type that emphasizes magnitude of changes over time b…
29 terms
Microsoft Office Chapter 3 Vocabulary
Behind Text
Border
Building Block
Business Letter
Text wrapping option where object appears behind text
Solid line on the edge of a paragraph
Where you can store text and graphics to use frequently
Includes requests, inquiries, confirmations, acknowledgements…
Behind Text
Text wrapping option where object appears behind text
Border
Solid line on the edge of a paragraph
1 of 10