Excel Exam Flashcards
You ____ an entry in a cell to emphasize it or make it stand out from the rest of the worksheet.
Bold
To erase recent cell entries, use the ____ command on the Quick Access Toolbar..
Undo
____ computing involves reducing the environmental waste generated when using a computer.
Green
____ in a worksheet typically contain information that is similar to items in a list.
Rows
The range of cells receiving a copy is called the ____ area.
Destination
The cell being copied is called the ____ area.
Source
The ____ command in the AutoCalculate area displays the number of non blank cells in the selected range.
Count
The AutoCorrect feature works behind the scenes correcting which of the following mistakes?
A: Two initial capital letters
B: Capitalizes the names of the days
C: Replaces commonly misspelled words with their correct spelling
D: All of the above
D: All of the above
A ____ is a collection of fonts and color schemes.
Theme
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
Which of the following document properties include title, author, and subject?
Standard
Which of the following is not a valid entry into a cell that requires numbers?
#
Excel’s ____ function allows you to add all of the numbers in a range of cells.
Sum
To toggle between Insert mode and Overtype mode press the ____ key(s).
Insert
A printed version of a worksheet is called a ____.
Hard copy
By default, Excel positions text in a cell ____.
Left-aligned
A(n) ____ chart is drawn on the same worksheet as its data.
Embedded
To split a merged cell, select the cell and click the ____ button.
Merge & Center
____ can include information such as the project author, title, subject, and keywords.
Metadata
____ allow data easily to be summarized and charted.
Worksheets
The ____ contains areas where you can view and enter document properties.
Document Information Panel
To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.
Format
A ____ chart is used to illustrate changes in data over time.
Line
In a worksheet, Excel automatically ____ numeric data.
Right-aligns
If automatic recalculation is disabled, press ____ to redraw charts.
F9
You know a cell is active when ____.
a heavy border surrounds the cell
The font face defines the appearance and shape of which of the following? A: Letters B: Numbers C: Special characters D: All of the above
D: All of the above
A(n) ____ document includes a needs statement, a source of data, a summary of calculations, and any other special requirements for a worksheet.
Requirements
The ____ command in the AutoCalculate area displays the highest value in the selected range.
Maximum
The vertical axis of a chart is called the ____ axis.
Value
To enter a number as text, start the entry with a(n) ____.
Apostrophe
The ____ is a blinking vertical line that indicates where the next typed character will appear.
Insertion point
____ are the details about a file.
Document properties
The ____ feature of Excel works behind the scenes, correcting common mistakes.
AutoCorrect
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
You can select any cell by entering its cell reference in the ____ box on the left side of the formula bar.
Name
____ cells involves creating a single cell by combining two or more selected cells.
Merging
In Excel, any set of characters containing a letter, hyphen, or space is considered ____.
Text
A(n) ____ is a series of two or more adjacent cells in a column or row or rectangular group of cells.
Range
____ in a worksheet typically contain descriptive information about items in rows.
Columns
The ____ on a Worksheet is one in which you can enter data.
Active Cell
____ properties include file system properties, such as the date you change or create a file, and statistics, such as the file size.
Automatically updated
The opposite of merging cells is ____ cells.
Splitting
The procedure of editing a cell contents directly in the cell is called ____.
in-cell editing
To do in-cell editing, select the cell, then press the ____ key
F2
You can easily obtain a total, an average, or other information about the numbers in a cell by using the ____ area on the status bar.
AutoCalculate
A ____ is a word or phrase that further describes a document.
Keyword
The small black square located in the lower-right corner of the heavy border around the active cell is called the ____.
Fill Handle
The ____ is the order in which arithmetic operators are calculated.
Order of operations
____ colors tend to pull away from your worksheet’s reader.
Cooler
____ allows you to select cells for use in a formula by using the mouse.
Point Mode
To verify that a formula contains the intended cell references, use Excel’s ____.
Range Finder
Use the ____ function to determine the lowest number in a range.
MIN
To display your worksheet in formula view, press ____.
CTRL + ACCENT MARK
The ____ function displays the highest value in a range
MAX
The ____ version of a worksheet shows the actual formulas.
Formulas
When you decrease a column width to ____, the column is hidden.
0
The process of finding and correcting errors in a worksheet is called ____.
Debugging
