Search
Create
Log in
Sign up
Log in
Sign up
EXCEL-Chapter 1: Creating a Worksheet and an Embedded Chart
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Microsoft: Office 2010-EXCEL heavy boarder, category axis, sum, document properties, theme, requirements, chart, embedded, rows, columns
Terms in this set (70)
You know a cell is selected when a _____ surrounds the cell.
heavy boarder
The horizontal axis for a chart is called the x-axis, or the _____.
category axis
The _____ function adds all of the numbers in a range of cells.
sum
Excel helps you organize and identify your files by using _____ , which are the details about a file.
document properties
A _____ is a collection of cell styles and other styles that have common characteristics.
theme
A _____ is a collection of fonts and color schemes.
theme
A _____ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for a worksheet.
requirements
A _____ conveys a visual representation of data.
chart
A chart is _____ when it is drawn on the same worksheet as the data.
embedded
_____ typically contain information that is similar to terms in a list.
Rows
_____ in a worksheet typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.
Columns
To split a merged cell, select the cell and click the _____ button.
merge & center
The _____ command in the Auto Calculate area displays the highest value in the selected range.
maximum
The _____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
The _____ feature of Excel works behind the scenes, correcting common mistakes.
auto correct
You can select any cell by entering its cell reference in the _____ box on the left side of the formula bar.
name
The range of cells receiving a copy is called the _____ area.
destination
To toggle between insert mode an overtype mode press the _____ key.
insert
In _____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.
insert
The opposite of merging cells is _____ cells.
splitting
_____ properties include file system properties, such as the date you can change or create a file, and statistics, such as the file size.
Automatically updated
The _____ on a worksheet is one in which you can enter data.
active cell
A _____ chart is used to illustrate changes in data over time.
line
If automatic recalculation is disabled, press _____ to redraw charts.
F9
To do in-cell editing, select the cell, then press the _____ key.
F2
To enter a number as text, start the entry with an _____ .
apostrophe
You _____ an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.
bold
_____ can include information such as the project author, title, subject, and keywords.
Metadata
The procedure of editing a cell contents directly in the cell is called _____ .
in-cell editing
With in-cell editing, you move the insertion point to the beginning of data in a cell by pressing _____ .
home
A _____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
range
A _____ is a word or phrase that further describes a document.
keyword
_____ mode is when Excel replaces the character to the right of the insertion point with what you are currently typing.
Overtype
_____ cells involves creating a single cell by combining two or more selected cells.
Merging
To erase recent cell entries, use the _____ command on the Quick Access Toolbar.
undo
The Auto Correct feature works behind the scenes correcting which of the following mistakes?
all
two initial capital letters,
capitalizes the names of the days, and
replaces commonly misspelled words with their correct spelling
Which of the following document properties include title, author, and subject?
standard
_____ allow data easily to be summarized and charted.
worksheets
The small black square located in the lower-right corner of the heavy border around the active cell is called the _____ .
fill handle
In Excel, any set of characters containing a letter, hyphen, or space is considered _____ .
text
The _____ contains areas where you can view and enter document properties.
document information panel
AutoCalculate area
easily can obtain a total, an average, or other information about the numbers in a range
AutoCorrect feature
Excel works behind the scenes, correcting common mistakes when you complete a text entry in a cell
Cancel box
cancels an entry
copy area
cell being copied
edit mode
Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell
Enter box
completes an entry
font
or font face, defines the apperance and shape of the letters, numbers, and special characters
font color
defines the color of the characters
font size
specifies the size of the characters on the screen
font style
indicates how te characters are emphasized
format
a worksheet to emphasize certain entries and make the worksheet easier to read and understand
green computing
which involves reducing the enviromental waste generated when using a computer
hardcopy
is information that exists on a physical medium such as paper
legend
which indentifies the colors assigned to each bar inthe chart
marquee
proposed range to sum surrounded by a moving border
number
can contain only the following characters: 0123456789 + - () , / . $ % E e
paste area
the range of cells receiving the copy
point size
of 10 is about 10/72 of one inch in height
printout
is information that exists on a physical medium such as paper
relative reference
Each adjusted cell references
save
store a workbook permentaly
snaps
the edge of the chart area to the worksheet gridlines
source area
is the small black square located in the lower-right corner of the heavy border around the active cell
splitting a merge cell
the opposite of merging cells
standard properties
are associated with all Microsoft Office documents and include author, title, and subject
to select a cell
is to use the mouse to move the block plus sign mouse pointer to the cell and then click
value axis
vertical axis
x-axis
horizantal axis
y-axis
vertical axis
YOU MIGHT ALSO LIKE...
EXCEL-Chapter 1: Creating a Worksheet and an Embedded Chart
41 Terms
navaabi1771
Excel Chapter 1
49 Terms
barrcla0086
Excel Chapter 1
40 Terms
saenvic1093
Excel Chapter 1
43 Terms
JoriLaCour
OTHER SETS BY THIS CREATOR
Medications week 7
10 Terms
amariri2257
Access Chapter 2 Vocabulary
36 Terms
amariri2257
Powerpoint Chapter 2 Vocabulary
23 Terms
amariri2257
chapter one powerpoint
46 Terms
amariri2257
;