EL1 C1 Flashcards
when the mouse pointer displays as a white plus sign, it is referred to as the…
cell pointer
when you click the AutoSum button, Excel looks first for a range of cells containing numbers _____ the active cell, and then _____ the active cell.
above
left of
display the Open backstage area by clicking the FILE tab and then clicking the Open option, or by pressing…
CRTL + O
pressing Ctrl + Home will take you to the…
first cell of the worksheet
clicking the Quick Print button will…
send the workbook directly to the printer
to select all cells from the active cell to the beginning of the row, press…
shift + home
which keyboard command closes Excel?
CRTL + F4
which keyboard shortcut displays the Go To dialog box?
CRTL + G
which of the following is not a valid name for an Excel workbook?
MyBudget/version2.xlsx
by default, numbers in a cell are aligned at the _____ and decimals and commas _____ display.
right
will not
to select specific characters within a cell (rather than the whole cell), begin by…
double clicking in the desired cell
Which element of an Excel worksheet displays the active cell address or name assigned to the active cell?
name box
The AutoCorrect feature in Excel automatically corrects…
common typing errors
What happens if you enter text into a cell and it is too long to fit in the cell?
The text overlaps into the cell to the right, but it is not stored in that cell.
What is another name for the cell address?
cell reference
You can select nonadjacent cells with your mouse by…
holding down the Ctrl key while clicking the desired cells
How many buttons display to the left of the search text box in the Excel Help window?
5
The area of the worksheet that contains tabs with commands and buttons is called the…
ribbon
When applied to an amount, this button adds a dollar sign, any necessary commas, and a decimal point followed by two decimal digits…?
accounting number format
Positioning your mouse pointer on the gray boundary line between columns in the column header is the first step toward…
changing column width
When you have finished editing the data in a cell, you must get out of Edit mode. Which of the following will not accomplish this?
pressing Home
To merge cells and center text, use the Merge & Center button located in the _____ group on the _____ tab.
alignment
home
What is the keyboard shortcut to display the Excel Help window?
F1
An Excel workbook consists of an individual “page” represented by a tab at the bottom of the Excel window. This is called a…
worksheet or sheet
The keyboard shortcut Alt + = inserts _____ into the active cell.
the SUM function
In addition to in its worksheet cell, where else is a data value displayed in Excel?
in the formula bar
Where in the worksheet area will you find the Name box?
upper left corner
To print a workbook, begin by clicking the _____ tab.
FILE
When a cell containing data is active, anything you type will…
take the place of the existing data
If numeric data in a number is too long to display in the cell, what does Excel do?
it displays number symbols (###) to indicate that the numeric value is too long to display
What is the name of the area at the bottom of the Excel screen that shows the Zoom level, the viewing mode, and the current mode?
status bar
Using the keyboard, you can select an entire column of cells by pressing…
CRTL + spacebar in the desired column
A workbook name can contain up to _____ characters.
255
The individual cells in the Excel worksheet area are identified by a letter and number combination, such as A2, known as the…
cell address or cell reference
There are several ways to save an Excel workbook. Which of the following is not one of them?
double-clicking the FILE tab on the ribbon
You can make a cell active by left-clicking in it, or you can use…
the Go To feature
You can copy a formula to other cells quickly by using…
autofill(?)
To enter data in a cell, the cell must be…
active
One of the features Excel offers to help with data entry is the AutoComplete feature, which automatically…
inserts data in a cell that begins the same as a previous entry
The horizontal and vertical scroll bars…
shift the display of cells, but do not change the active cell
If you do not want a series to increment while using AutoFill, hold down the _____ key while dragging the fill handle.
ALT
