Study sets, textbooks, questions
Upgrade to remove ads
EXCEL-Chapter 1: Creating a Worksheet and an Embedded Chart
Microsoft: Office 2010-EXCEL heavy boarder, category axis, sum, document properties, theme, requirements, chart, embedded, rows, columns
Terms in this set (73)
You know a cell is selected when a _____ surrounds the cell.
The horizontal axis for a chart is called the x-axis, or the _____.
The _____ function adds all of the numbers in a range of cells.
Excel helps you organize and identify your files by using _____ , which are the details about a file.
A _____ is a collection of cell styles and other styles that have common characteristics.
A _____ is a collection of fonts and color schemes.
A _____ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for a worksheet.
A _____ conveys a visual representation of data.
A chart is _____ when it is drawn on the same worksheet as the data.
_____ typically contain information that is similar to terms in a list.
_____ in a worksheet typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.
merge & center
To split a merged cell, select the cell and click the _____ button.
The _____ command in the Auto Calculate area displays the highest value in the selected range.
The _____ is a blinking vertical line that indicates where the next typed character will appear.
The _____ feature of Excel works behind the scenes, correcting common mistakes.
You can select any cell by entering its cell reference in the _____ box on the left side of the formula bar.
The range of cells receiving a copy is called the _____ area.
To toggle between insert mode an overtype mode press the _____ key.
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.
The opposite of merging cells is _____ cells.
_____ properties include file system properties, such as the date you can change or create a file, and statistics, such as the file size.
The _____ on a worksheet is one in which you can enter data.
A _____ chart is used to illustrate changes in data over time.
If automatic recalculation is disabled, press _____ to redraw charts.
To do in-cell editing, select the cell, then press the _____ key.
To enter a number as text, start the entry with an _____ .
You _____ an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.
_____ can include information such as the project author, title, subject, and keywords.
The procedure of editing a cell contents directly in the cell is called _____ .
With in-cell editing, you move the insertion point to the beginning of data in a cell by pressing _____ .
A _____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
A _____ is a word or phrase that further describes a document.
_____ mode is when Excel replaces the character to the right of the insertion point with what you are currently typing.
_____ cells involves creating a single cell by combining two or more selected cells.
To erase recent cell entries, use the _____ command on the Quick Access Toolbar.
two initial capital letters,
capitalizes the names of the days, and
replaces commonly misspelled words with their correct spelling
The Auto Correct feature works behind the scenes correcting which of the following mistakes?
Which of the following document properties include title, author, and subject?
_____ allow data easily to be summarized and charted.
The small black square located in the lower-right corner of the heavy border around the active cell is called the _____ .
In Excel, any set of characters containing a letter, hyphen, or space is considered _____ .
document information panel
The _____ contains areas where you can view and enter document properties.
Status bar command used to obtain a total, average, or other information about numbers in a range
Automatically corrects capital letters, replaces commonly misspelled words
automatically updated properties
Properties that include system file properties
Cancels an entry by clicking
the cell being copied
displays the active cell entry in the formula bar and a flashing insertion point in the active cell
completes an entry
Defines appearance and shape of letters and numbers
Defines the color of characters
Specifies the size of characters
Indicates how the characters are emphasized
How you make a worksheet easier to read and understand
involves reducing the environmental waste generated when using a computer
in information that exist on a physical medium such as paper
Identifies each bar in a chart
proposed range to sum surrounded by a moving border
0 1 2 3 4 5 6 7 8 9 + - () , / . $ % E e
the range of cells receiving the copy
10/72 of an inch
information that exist on a physical medium such as paper
What each adjusted cell reference is called
to keep all documents
aligns the egde of the chart
splitting a merged cell
Unmerging a cell
Properties that include author, title, and subject
Any set of characters containing letters, hyphens, or spaces
to select a text
to make a cell active
Sets with similar terms
EXCEL-Chapter 1: Creating a Worksheet and an Embed…
CISC - Excel Chapter 1
Chapter 1 for Excel
Excel Chapter 1
Other sets by this creator
WORD-Chapter 3: Creating a Business Letter with a…
WORD-Chapter 2: Creating a Research Paper with Cit…