ALL OF LEVEL ONE 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?
Alt + 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…
- Shift + Home.
- Alt + Home.
- Ctrl + Shift + spacebar in the desired column.
- Ctrl + spacebar in the desired column
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
- clicking the Save button on the Quick Access toolbar
- pressing F12 and then clicking the Save button at the Save As dialog box
- pressing Ctrl + S
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
When the Trace Error button appears, what is displayed in the upper left corner of the active cell?
a small, dark green triangle
What type of cell values will the AVERAGE function ignore and not use in its calculation?
blank cells
When writing a formula by pointing, this displays at the left side of the Status bar.
Point
To copy data or formulas using the fill handle, first position the mouse pointer on the desired fill handle until it turns into a…
thin black cross
What symbol is used to indicate an absolute cell reference?
$
Instead of typing dollar signs ($), which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?
F4
What will happen if you press Ctrl + ` (grave accent)?
the worksheet will display formulas instead of results
What does the error code #N/A mean?
an argument parameter has been left out of a function
Clicking the down-pointing arrow at the right side of the AutoSum button and then clicking More Functions will display this dialog box…?
insert function
Which of the following is not one of the categories of functions offered by Excel?
scientific
What does the MIN function return?
the minimum function in a range
A built-in formula, such as =SUM, is called a(n)…?
function
The process of calculating a formula and inserting the value in a cell is referred to as…
returning the result
Which of the following formulas shows an example of a mixed cell reference?
=$A$3+B$3
Functions require inputs upon which to operate. The inputs, which can be numbers or cell references, are called…
arguments
What does the COUNT function count?
the number of numeric values in a range
Which of the following is not a common mistake made while inputting data in a formula?
writing a formula by pointing rather than typing the formula
If one of the cells in a range of cells you use as an argument for an AVERAGE function contains text instead of numbers, what will Excel do?
ignore the text and calculate the average
Copy a formula relatively in a worksheet using the Fill button. The Fill button is located in the _____ group on the _____ tab.
editing
HOME
What does it mean for a formula to have a mixed cell reference?
it has a cell reference in which one component (row or column) is relative, while the other is absolute
Use this keyboard command to display the Insert Function dialog box.
Shift + F3
An Insert Function button can be found on the FORMULAS tab and…
the formula bar
When writing your own formulas, you must begin each formula with…
an equals sign =
The Trace Error button is a type of…
smart tag
Excel’s functions are grouped into _____ categories.
13
Use this function key to update a NOW or TODAY function.
F9
If you want to change the order of operations in a formula, use these around the part of the formula you want to calculate first.
parentheses
How many functions can Excel perform?
more than 300
Which of the following is not one of the types of cell references discussed in Chapter 2?
dynamic
If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it to cell D3?
the formula will change to =SUM(A3:C3)
The function that returns the arithmetic mean of the arguments is called…
average
The multiple layers of parentheses in a formula are called…
nested parentheses
What does it mean for a formula to have relative cell references?
the cell references change when the formula is copied to a new cell
At the Function Arguments palette, enter into this text box the range of cells you want to include in the formula.
Number1
In the Insert Function dialog box, what displays in the Select a function list box?
the most recently used functions
An absolute cell reference _____ change when copied to another cell.
does not
If you have a range of cells containing employee salaries, what function would you use to return the highest value in the range?
MAX
When creating a formula by pointing to cell references instead of typing them, what happens to the cell to which you are pointing?
a temporary moving border is placed around the cell
What happens to formulas with relative cell references when they are copied using the fill handle?
a relative version of the formula is copied into the selected cell(s)
Use this keyboard command to display formulas in a worksheet.
Ctrl + `
In Excel’s order of operations, which type of operation happens first?
negations
This function returns the current date in a date format.
=TODAY()
In terms of an Excel formula, what is a constant?
a value entered directly into a formula
Indicate what the following formula will do: =B2/C2.
it will divide the contents of cell B2 by the contents of cell C2
What error code will display in a cell when a function name is not entered correctly into a formula?
NAME?
Display all formulas in a worksheet by clicking the Show Formulas button in the _____ group on the _____ tab.
formula auditing
FORMULAS
After typing a formula into a cell, you can finish by pressing any of the following keys except…
spacebar
The Trace Error button allows you to do each of the following except…
delete the formula containing the error
When writing a formula by pointing, how do you end the formula?
press the enter key
The Increase Decimal and Decrease Decimal buttons change decimal places for…
existing numbers only
To insert a new row in a worksheet, select _____ and then click the Insert button.
the row below where the row is to be inserted
If you want to enter data on more than one line in a cell, you can enter the data on the first line and then move the insertion point to the next line in the cell by…
pressing ALT + ENTER
What does the Merge & Center button in the Alignment group on the HOME tab do?
merges the selected cells and centers the data within the merged cells
Which of the following is not one of the options at the Merge & Center button’s drop-down list?
Merge Workbooks
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
By default, numbers typed in a cell are formatted to…
right-align, with no decimals or commas unless they are typed in the cell
If you enter the value $45.50 into a cell with default formatting, Excel automatically…
applies currency formatting to the number
The column width number in the Column Width dialog box represents…
the average number of characters in the standard font that will fit in a cell
Which button do you click to display the Column Width dialog box?
Format
You can use your mouse to change the height of multiple rows at the same time if the rows are…
adjacent to one another
The name of this button in the Font group changes depending on the most recent option it was used to apply.
boarders
To give your worksheet a professional look, you can apply a predefined set of colors, fonts, lines and fill effects by…
applying a theme
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
What happens if you select three columns in a worksheet, click the Insert button arrow, and then click Insert Sheet Columns?
Three columns are inserted immediately to the left of the selected columns
By default, when inserting a column in a worksheet, the new column is placed…
immediately to the left of the column containing the active cell
Which of the following changes in text format can you not make on the Font tab of the Format Cells dialog box?
Orientation
When text is too long to fit in a cell, it normally overlaps into the next cell to the right. If you want data to remain in a cell and wrap to the next line within the same cell, select the _____ option at the Format Cells dialog box.
Wrap text
How is clearing cell contents different from deleting cells?
Clearing cell contents gives you the option of removing both contents and formatting from a cell
To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position.
Select All button
When you insert rows into a worksheet, all references affected by the insertion…
are automatically adjusted
The Clipboard group on the HOME tab contains the _____ button, which can be used to copy formatting to different locations in the worksheet.
format printer
You can insert a new row in a worksheet by clicking the Insert button arrow, clicking Insert Cells, and then clicking this at the Insert dialog box.
entire row
You can specify the formatting for numbers in a cell…
(?)
What does the Orientation button in the Alignment group do?
rotates data in a cell
If you enter numbers into a cell, they will be automatically aligned…
at the right side of the cell
If you want to copy formatting to several different locations in a worksheet, select the cell that contains the desired formatting and then _____ the Format Painter button.
double click
What happens if you select multiple columns and then drag one of the selected column boundaries?
all selected column widths change
To add a background color to a selected cell, use the _____ button in the Font group on the HOME tab.
fill color
To reduce the size of the text font so that all selected data fits within a column, click the _____ option on the Alignment tab in the Format Cells dialog box.
shrink to fit
Which component of a theme consists of a set of line and fill effects?
effects theme
On which tab in the Format Cells dialog box can you choose the degrees to rotate text?
alignment
Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column?
accounting
The gridlines that display in a worksheet..
do not print by default
To change the height of a row using your mouse, position the mouse pointer on the boundary line in the row header until the mouse pointer turns into a _____, then drag the boundary to the desired height.
double headed arrow pointing up and down
Using the Delete key to delete cells…
only deletes the cell contents
You can see how a theme will affect your worksheet before you apply it by using the _____ feature.
live preview
Approximately how many points are contained in a vertical inch?
72
When a row height is being changed, the row height number that displays represents a measurement in…
points
What happens if you select and merge a block of cells that contain data?
Only the data in the upper left cell of the block will be retained.
Select the rows or columns you do not want to display on the screen and point to Hide & Unhide…
(?) in the drop-down menu of the Format button in the Cells group on the HOME tab
Click this button arrow in the Number group on the HOME tab to display a drop-down list of common number formats.
Number Format
You can adjust a column width to fit the longest entry in the column by double-clicking…
on the column boundary line
Excel measures row height in _____ and column width in _____.
points; characters
Right-clicking in a cell will display the…
mini toolbar
Which of these formatting options is not found in the Font group on the HOME tab?
superscript
By default, all columns in a worksheet…
are all the same width
In which number category can you specify the formatting for Zip codes?
Special
This number category in the Format Cells dialog box is used for very large or very small numbers.
Scientific
To delete a row, select the row and then click the Delete button in the _____ group on the _____ tab.
Cells; HOME
When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?
You specify the range in the Rows to repeat at top text box in the Page Setup dialog box
At the Page Setup dialog box with the Sheet tab selected, you can specify rows and/or columns to print on every page of the worksheet. How is this feature normally used?
to print row and column titles on multipage worksheets
What generally displays in the Sort By option box at the Sort dialog box?
the title of the first column of selected cells
Using the _____ dialog box to sort data in a column maintains the relationship among the data.
sort
Which of the following is not one of the paper sizes for an Excel worksheet at the Size button drop-down list?
landscape
If you undo an action with the Undo button on the Quick Access Toolbar and then decide that you want to reinstate the action, what should you do?
Press the Redo button
Use the Background button in the Page Setup group on the Page Layout tab to do which of the following?
Insert into the worksheet a background picture that displays behind the data
A restriction placed temporarily on data in a worksheet to isolate specific data is called a(n)…
filter
What are the two options for page orientation in the Page Setup group on the Page Layout tab?
portrait and landscape
You can find options for printing headings and gridlines on the Sheet tab at the Page Setup dialog box and
in the Sheet Options group on the Page Layout tab
Do the worksheet gridlines appear by default when printed? If not, can you instruct Excel to print them? How?
No, the gridlines do not print by default, but you can print them by checking the Print check box in the Sheet Options group on the Page Layout tab.
Use this keyboard shortcut to redo an action.
CRTL + Y
Using options at the Page Setup dialog box with the Margins tab selected, you can center a worksheet…
both vertically and horizontally on a page
Excel’s spelling check feature reviews the worksheet from _____ to _____.
the active cell; the last cell in the worksheet that contains data
Use the Search option at the expanded Find and Replace dialog box to search by _____ or _____.
rows; columns
To sort data by a column other than the default column, which of the following methods should you use?
Click the Sort & Filter button and then click Custom Sort
Page breaks display as _____ along cell borders in a worksheet.
dashed lines
To use Excel’s spelling check feature, click the Spelling button in the _____ group on the_____ tab.
Proofing; Review
