Excel Chapter 1
Excel remembers the last ____ actions you have completed
100
How many chart types does Excel offer
15
To get the the next line, click
ALT + ENTER
Pressing the ____ key to complete an entry activates the adjacent cell the the right.
Arrow
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
Auto Correct
The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Option
The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with or without formatting.
Auto Fill Option
Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words.
AutoCorrect
To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key
BACKSPACE
While typing in a cell, you can press the ____ key to erase all the characters back to and including the incorrect character you just typed.
Backspace
You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
CTRL + B
Pressing the ____ keyboard shortcut key selects cell A1.
CTRL + Home
To move to the first cell
CTRL + Home
To get current date
CTRL + Semicolon
The deault font for a new workbook is _____ 11 point regular black
Calibri
To use he AutoCalculate area, first select the range of cells containing the numbers you want to check. Next, right-click the AutoCalculate area to display the Customize status Bar shortcut menu.
Commonly used: average, count, numerical count, minimum, maximum, and sum.
____ properties are associated with all Microsoft Office files and include author, title, and subject.
Document
Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files.
Document properties
Which of the following keys moves the insertion point to the end of data in a cell.
End
_____ indicates how characters are emphasized.
Font style
Which of the following keys moves the insertion point to the beginning of data in a cell?
HOME
Which of the following is the Ribbon path to the Cell Styles button
HOME tab / Styles group
Which of the following keys toggles between Insert mode and Overtype mode.
Insert
_____ cells involves creating a single cell by combining two or more selected cells.
Merging
The active cell reference appears in the _____ on the left side of the formula bar.
Name box
Excel's ____ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total
SUM
____ is/are used to place worksheet, column, and row titles on a worksheet.
Text
A character with a point size of 10 is about 10/72 of one inch in height
True
A requirements document includes a need statement, source of data, summary of calculations, and any other special requirements for a worksheet
True
The group of adjacent cells beginning with B4 and ending with B8, written as B4, is called a range.
True
The opposite of merging cells is splitting a merged cell.
True
The ___ button allows you to erase recent cell entries.
Undo
=NOW()
Updates current date
You use _____ to view an XPS file.
XPS Viewer
What effect does the Account Number Format have on the select cells
assigns a fixed # sign to the numbers in the range and rounds the figure to the nearest 100th
The date you change a file is an example of a
automatically updated property.
To enter data in a cell, you must first select the
cell
A _____ conveys a visual representation of data.
chart
You can enter the correct range in a function by typing the beginning and ending cell references separated by a
colon
A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called
data series
The range of cells receiving the content of copied cells is called the
destination area or paste area
Clicking the ____ box completes an entry.
enter
A pie chart with one or more slices offset is referred to an an ___ pie chart.
exploding
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
As you type, Excel displays the entry (and the Cancel and Enter box) in the
formula bar
_____ involves reducing the electricity consumed
green computing
Like an area chart, a ____ chart often is used to illustrate changes in data over time.
line
What effect does the Comma Style format have on the selected cells
makes larger numbers easier to read
Combining two or more selected cells into one cell is called ____ cells.
merging
The easiest way to select a cell is to move the block _____ plus sign
pointer to a cell and then click.
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY
recognizes letter, hyphen and space
A ____ reference is an adjusted cell reference in a copied and pasted formula
relative
The automatically adjusted cell reference in a pasted formula is called a
relative reference.
The person or persons requesting the worksheet shoul supply their requirements in a _____ document.
requirements
Perry decides that before either of his employees creates a new workbook he must give them a
requirements document
In a worksheet, ______ typically contain information that is similar to a list.
rows
Perry also decides that he should approve ____ of any proposed worksheet.
sketch
The first step in creating an effective worksheet is to make sure you
understand what is required.
An Excel ____ allows data to be summarized and charted easily.
worksheet