Microsoft Excel Test (True/False and Multiple Choice)
which view should be used when preparing a worksheet for printing?
Page Layout View
range
a selection of two or more cells
which number format displays values with a dollar sign aligned at the left edge of the cell and two decimal places?
accounting
workbook
an Excel spreadsheet document
the intersection of a row and column is a
cell
to select the entire worksheet:
click the Select All button
to size a picture proportionately, a __________ handle should be dragged
corner
worksheet
each Excel workbook contains one
Individual columns on a worksheet are identified by a number
false
cell references have to be typed in uppercase letters
false
formatting changes the value of the data stored in a cell
false
if a label is truncated because it extends beyond the width of the cell, the truncated data is deleted
false
individual rows on a worksheet are identified by a letter
false
it is possible to change the width of a single cell
false
labels and values displayed in the same column are automatically aligned the same
false
labels can be used in calculations
false
the accounting and currency formats are exactly the same
false
the cell contents of the active cell are displayed in the name box
false
unless cells are formatted otherwise, labels are right aligned
false
unless formatted otherwise, values are automatically left aligned
false
unless otherwise formatted, dates/times are right aligned
false
when pasting a range of cells, any existing cell contents at the new location are automatically moved to make room for the pasted data
false
which number format displays numbers the way they are typed?
general
data from Word can be copied to an Excel worksheet...
if it is organized in a table or aligned with tabs and tab stops
how many worksheets are in a new workbook
one
which number format displays values as a percentage with two decimal places?
percentage
cell references that reflect the row or column they have been copied to are called
relative cell references
which key enters data and makes the next cell in the column active?
the Enter key
which key cancels data entry and restores the original contents of the cell?
the Esc key
which key removes the dashed border around copied cells?
the Esc key
pointing
the best method for entering cell references into a formula
cell reference
the column letter and row number that identify a single cell
adjacent cells are cells that are next to each other
true
formatting is applied to cells to make the data easier to understand
true
formulas are mathematical statements used to calculate values
true
formulas that contain cell references automatically recalculate if a value in a referenced cell changes
true
in excel, a formula must begin with an equal sign
true
the fill handle is used to copy cell contents to adjacent cells
true
the order in which excel evaluates a mathematical expression can be changed by including parentheses in the expression
true
values can be used in calculations
true
when pasting a range of cells, only the upper-left cell of the destination range need to be seleceted
true
