Excel 1 MC
Numbers that extend beyond cell's width appear as ___ in cell
#####
you can use wildcard characters in the FInd what box to search for data that matches a particular pattern. Use ____for 2 or more characters
*
The worksheet that is displayed in the work area
Active worksheet
Identifies the cell, and is formed by combining the cell's column letter and row number
Cell reference
Gavin wants to preview the next page of the worksheet. What should he do?
Click the Next Page button
to use the replace command, in the ___ group on the home tab of ribbon, click the FInd & Select button, and then click Replace
Editing
What would he do to magnify the view?
Either A or B
to edit data directly in a cell, make cell active and press the ___key or double-click cell
F2
Microsoft Office Excel 2007 is the presentation program in Microsoft Office 2007
False
Saving a workbook means loading an existing workbook file from a disk into the program window
False
The Save As command saves an existing workbook in a disk, using its current name and save location
False
The cell in the worksheet in which you can type data is called the open cell
False
The easiest way to change the active cell in a worksheet is to use to click Cell on the Ribbon and type in the cell's location
False
Equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2
Formula
Which search option should Dori choose
Neither A nor b
Before you use the resources to print a worksheet, you should use it to see how the printed pages will look
Preview
to switch to print preview, click ___ in the Print dialog box
Preview
A group of selected cells
Range
A grid of rows and columns in which you enter text, numbers, and the results of calculations
Spreadsheets
If a cell is not long enough to display all the cell's contents, extra text extends into the next cells if there is room
True
The contents of the active cell always appear in the Formula Bar
True
The excel program window has the same basic pasts as all Office programs: the title bar, the Quick Access Toolbar, the Office Button, the Ribbon, and the status bar.
True
The formula bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
True
To clear the active cell, you can use the Ribbon, the keyboard, or the mouse
True
Dori knows that she has entered in an incorrect value of 4,321 in one of the cells and wants to find it. She would choose "cell contents" as her place to search in it search option section
Within
The file used to store worksheet
Workbook
A computerized spread sheet
Worksheet
The file used to store worksheets is called a
Worksheet
You can magnify or reduce the view of a worksheet with the ______ controls on the status bar
Zoom
IF you try to close a workbook with unsaved changes, a dialog box will____
ask you whether or not you want to save
you can close a workbook by clicking office button and clicking ___
close
range is identified by its range reference seperated by a ____
colon
____ of the worksheet appear w=vertically and are identified by letter at the top of the worksheet window
columns
the ___ will always appear in a formula bar
contents of a n active cell
to replace cell contents, select cell, type new data, and enter data by clicking the enter button on the Formula bar or by pressing ____
enter or tab
drag zoom slider to the ____ to decrease zoom percentage
left
cell reference area located below ribbon that displays cell reference of an active cell
name box
the ____ dialog box allows you to select a printer, the number of copies to print, the parts of the worksheet to print, and the way the printed worksheet will look
to clear active cell use ____
ribbon keyboard or mouse
each cell is identified by a unique cell reference, which is formed by combining cell's column letter and ___
row number
____appear horizontally and are identified by numbers on left side of worksheet window
rows
name of each worksheet appears in _____ at the bottom of worksheet window
sheet tab
WHen excel starts, the program window displays a blank workbook titled BOOK1, which includes____blank worksheets
three
in excel, a computerized spreadsheet
worksheet
