SIMNet Final Exam - Excel With 100 Questions and
Answers
DIV/0 is an example of a worksheet _______ that can display in a cell. - ANSWER
Error
If you move a named cell, the name updates with the new cell location
automatically. - ANSWER True
When you type text in a cell, the text will appear to continue to the __________ as
far as it can until there is another cell that contains data. - ANSWER Right
To make changes to grouped sheets, just make the change in one sheet and this
same change will be made to the same cell in all sheets in the group. - ANSWER
True
The Decrease Decimal button permanently deletes decimal places from the
number entered into the cell. - ANSWER False
Excel includes a special group of functions to modify text. - ANSWER True
When you change a name, Excel automatically updates the name in any formula
that references that name. - ANSWER True
To move or copy more than one non-consecutive worksheet, press _______ on the
keyboard and click the worksheets you want to copy or move. - ANSWER Ctrl
The VLOOKUP function finds a value or cell reference in a cell range and returns
another value from the same row. - ANSWER True
A _______ is a special report view that summarizes data and calculates the
intersecting totals. - ANSWER PivotTable
If you want more of your worksheet columns to fit on a printed page, change the
orientation to Portrait. - ANSWER False
The Format Painter is located on the Home tab in the _______ group. - ANSWER
Clipboard
To remove the contents of a cell without removing the cell from the worksheet,
use one of the Clear commands. - ANSWER True
, A _______ is text that appears at the top of every page. - ANSWER header
When you enter a formula with more than one mathematical operation, the
formula is not necessarily calculated left to right as Excel calculations follow the
mathematical rules called the ___________________________. - ANSWER Order of
operations
Excel''s _______ function lets you enter a desired value (outcome) for a formula and
specify an input cell that can be modified in order to reach that goal. - ANSWER
Goal Seek
If you select an entire column and then click the Insert button, Excel will
automatically insert a _______. - ANSWER Column
A two-variable data table works the same way as a one-variable data table, using
inputs for both a column and a row variable. - ANSWER True
A(n) __________ reference is a cell reference that adjusts to the new location in the
worksheet when the formula is copied. - ANSWER Relative
You can arrange workbooks to view several at the same time. - ANSWER True
The Fill Handle tool is located at top left of the selected cell. - ANSWER False
To add emphasis to a pie chart slice, you can "explode" a single slice by clicking it
and dragging it away from the rest of the slices. - ANSWER True
When a filter has been applied to a column, the column header will display an
arrow. - ANSWER False
For the Subtotal command to work properly, you must sort the rows into order by
the first column. - ANSWER False
To define more than one print area, you need to hold down the _______ key after
selecting the first print area and drag across the cells to include in the second
print area. - ANSWER Ctrl
Names assigned to cells act as a list of _______ to the cell locations. - ANSWER
Shortcuts
One of the most useful financial functions in Excel is the _______ function, which
you can use to calculate loan payments. - ANSWER PMT
Answers
DIV/0 is an example of a worksheet _______ that can display in a cell. - ANSWER
Error
If you move a named cell, the name updates with the new cell location
automatically. - ANSWER True
When you type text in a cell, the text will appear to continue to the __________ as
far as it can until there is another cell that contains data. - ANSWER Right
To make changes to grouped sheets, just make the change in one sheet and this
same change will be made to the same cell in all sheets in the group. - ANSWER
True
The Decrease Decimal button permanently deletes decimal places from the
number entered into the cell. - ANSWER False
Excel includes a special group of functions to modify text. - ANSWER True
When you change a name, Excel automatically updates the name in any formula
that references that name. - ANSWER True
To move or copy more than one non-consecutive worksheet, press _______ on the
keyboard and click the worksheets you want to copy or move. - ANSWER Ctrl
The VLOOKUP function finds a value or cell reference in a cell range and returns
another value from the same row. - ANSWER True
A _______ is a special report view that summarizes data and calculates the
intersecting totals. - ANSWER PivotTable
If you want more of your worksheet columns to fit on a printed page, change the
orientation to Portrait. - ANSWER False
The Format Painter is located on the Home tab in the _______ group. - ANSWER
Clipboard
To remove the contents of a cell without removing the cell from the worksheet,
use one of the Clear commands. - ANSWER True
, A _______ is text that appears at the top of every page. - ANSWER header
When you enter a formula with more than one mathematical operation, the
formula is not necessarily calculated left to right as Excel calculations follow the
mathematical rules called the ___________________________. - ANSWER Order of
operations
Excel''s _______ function lets you enter a desired value (outcome) for a formula and
specify an input cell that can be modified in order to reach that goal. - ANSWER
Goal Seek
If you select an entire column and then click the Insert button, Excel will
automatically insert a _______. - ANSWER Column
A two-variable data table works the same way as a one-variable data table, using
inputs for both a column and a row variable. - ANSWER True
A(n) __________ reference is a cell reference that adjusts to the new location in the
worksheet when the formula is copied. - ANSWER Relative
You can arrange workbooks to view several at the same time. - ANSWER True
The Fill Handle tool is located at top left of the selected cell. - ANSWER False
To add emphasis to a pie chart slice, you can "explode" a single slice by clicking it
and dragging it away from the rest of the slices. - ANSWER True
When a filter has been applied to a column, the column header will display an
arrow. - ANSWER False
For the Subtotal command to work properly, you must sort the rows into order by
the first column. - ANSWER False
To define more than one print area, you need to hold down the _______ key after
selecting the first print area and drag across the cells to include in the second
print area. - ANSWER Ctrl
Names assigned to cells act as a list of _______ to the cell locations. - ANSWER
Shortcuts
One of the most useful financial functions in Excel is the _______ function, which
you can use to calculate loan payments. - ANSWER PMT
