CGS1060 EXCEL PRACTICE EXAM
QUESTIONS WITH VERIFIED ANSWERS
The MAX (maximum) statistical function will give you the _______ value in a range of
values - ANSWERSLargest
An example of the NOW function is _______. - ANSWERS=NOW()
_______ lets you merge cells in multiple rows without merging the rows together -
ANSWERSMerge Across
A(n) __________ reference is a cell reference that adjusts to the new location in the
worksheet when the formula is copied. - ANSWERSrelative
A _______ is the cell containing a formula that references the value or formula in the
selected cell. - ANSWERSdependent
The AutoSum button is found on the Home tab, in the ___________ group and enters
the SUM function arguments using the most likely range of cells based on the structure
of the worksheet. - ANSWERSEditing
If you are not sure of the name of the function you want, open the _______ dialog and
type keywords describing the function in the Search for a function box and click Go. -
ANSWERSInsert Function
One of the most useful financial functions in Excel is the _______ function, which you
can use to calculate loan payments. - ANSWERSPMT
Clicking the _______ selects an entire row in a worksheet - ANSWERSrow selector
To automatically fit cell content, _______ the right column border of the cell. -
ANSWERSdouble-click
To delete an unwanted worksheet, select _______ from the Delete menu -
ANSWERSDelete Sheet
If you select an entire column and then click the Insert button, Excel will automatically
insert a _______. - ANSWERScolumn
QUESTIONS WITH VERIFIED ANSWERS
The MAX (maximum) statistical function will give you the _______ value in a range of
values - ANSWERSLargest
An example of the NOW function is _______. - ANSWERS=NOW()
_______ lets you merge cells in multiple rows without merging the rows together -
ANSWERSMerge Across
A(n) __________ reference is a cell reference that adjusts to the new location in the
worksheet when the formula is copied. - ANSWERSrelative
A _______ is the cell containing a formula that references the value or formula in the
selected cell. - ANSWERSdependent
The AutoSum button is found on the Home tab, in the ___________ group and enters
the SUM function arguments using the most likely range of cells based on the structure
of the worksheet. - ANSWERSEditing
If you are not sure of the name of the function you want, open the _______ dialog and
type keywords describing the function in the Search for a function box and click Go. -
ANSWERSInsert Function
One of the most useful financial functions in Excel is the _______ function, which you
can use to calculate loan payments. - ANSWERSPMT
Clicking the _______ selects an entire row in a worksheet - ANSWERSrow selector
To automatically fit cell content, _______ the right column border of the cell. -
ANSWERSdouble-click
To delete an unwanted worksheet, select _______ from the Delete menu -
ANSWERSDelete Sheet
If you select an entire column and then click the Insert button, Excel will automatically
insert a _______. - ANSWERScolumn
