COMPREHENSIVE SPREADSHEET MODELLING FINAL EXAM
LATEST 2024 ACTUAL EXAM
Display the ___ tab to specify page setup options, such as setting the location of
page breaks or centering a printout horizontally and vertically. - ANSWER: PAGE
LAYOUT
You can drill a ___ down through a workbook. (format, function, formula) - ANSWER:
all of the above
To select adjacent sheets, select the first sheet by clicking its tab and then hold down
the ___ key and click the sheet tab at the other end of the list of adjacent sheet tabs.
- ANSWER: SHIFT
1,2,3,4 etc. is an example of a ____ fill series? - ANSWER: linear
If you complete a paste operation using the ___ key, then the marquee disappears
and the office Clipboard no longer contains the copied data following the action. -
ANSWER: ENTER
If you are summing numbers on noncontiguous sheets, hold down the ___ key when
selecting the sheets. - ANSWER: CTRL
A style affects the format of a cell or range of cells only if the corresponding check
box is selected in the ___ area in the style dialog box. - ANSWER: Style includes
Excel displays ___ on the worksheet to show the boundaries of each page. -
ANSWER: dotted lines
A range that spans two or more worksheets in a workbook is called a(n) ___ range. -
ANSWER: 3-D
Use the shortcut key ___ to copy the format of the source area but not the contents.
- ANSWER: CTRL+R
Use which of the following to sum all the values in column A? - ANSWER: =sum(a : a)
Use the shortcut key ___ to copy the format of the contents, format and styles of the
source area. - ANSWER: CTRL+K
which of the following is NOT a series type that you can create in Excel (Auto fill,
Growth, Date) - ANSWER: Nonlinear
By default, headers and footers ___. - ANSWER: are blank
, A(n) ___ dollar sign always appears immediately to the left of the first significant
digit in a cell. - ANSWER: floating
A format code can have up to ___ sections. - ANSWER: four
The ___ defines the appearance and format of a printed worksheet. - ANSWER: page
setup
A ___ appears at the top of every printed page. - ANSWER: header
Consolidating data from other workbooks can be referred to as ___. - ANSWER:
linking
___ allow you to specify how cell entry assigned a format will appear. - ANSWER:
Custom format codes
A ___ reference is a formula that depends on its own value. - ANSWER: circular
The ___ style is the format style that Excel initially assigns to all cells in a workbook. -
ANSWER: Normal
A ___ appears at the bottom of every printed page. - ANSWER: footer
A(n) ___ is a group of format specifications that are assigned a style name. -
ANSWER: style
Linked workbooks are called the ___ workbooks. - ANSWER: source
To copy the contents of a cell to the cell directly below it, tap or click in the target
cell and press ___. - ANSWER: CTRL+D
A(n) ___ dollar sign always appears in the same position in a cell (regardless of the
number of significant digits). - ANSWER: fixed
Use the shortcut key ___ to copy the formulas from the source area but not the
contents or format. - ANSWER: CTRL+F
Excel limits the number of worksheets you can have in a workbook ___. - ANSWER:
based on the amount of memory in your computer
Which of the following functions will display the system date? - ANSWER: NOW()
You use the ___ to drag through cells to create a fill series - ANSWER: fill handle
A date might be displayed as a series of ___ if the date, as initially formatted by
Excel, does not fit in the width of the cell. - ANSWER: number signs
LATEST 2024 ACTUAL EXAM
Display the ___ tab to specify page setup options, such as setting the location of
page breaks or centering a printout horizontally and vertically. - ANSWER: PAGE
LAYOUT
You can drill a ___ down through a workbook. (format, function, formula) - ANSWER:
all of the above
To select adjacent sheets, select the first sheet by clicking its tab and then hold down
the ___ key and click the sheet tab at the other end of the list of adjacent sheet tabs.
- ANSWER: SHIFT
1,2,3,4 etc. is an example of a ____ fill series? - ANSWER: linear
If you complete a paste operation using the ___ key, then the marquee disappears
and the office Clipboard no longer contains the copied data following the action. -
ANSWER: ENTER
If you are summing numbers on noncontiguous sheets, hold down the ___ key when
selecting the sheets. - ANSWER: CTRL
A style affects the format of a cell or range of cells only if the corresponding check
box is selected in the ___ area in the style dialog box. - ANSWER: Style includes
Excel displays ___ on the worksheet to show the boundaries of each page. -
ANSWER: dotted lines
A range that spans two or more worksheets in a workbook is called a(n) ___ range. -
ANSWER: 3-D
Use the shortcut key ___ to copy the format of the source area but not the contents.
- ANSWER: CTRL+R
Use which of the following to sum all the values in column A? - ANSWER: =sum(a : a)
Use the shortcut key ___ to copy the format of the contents, format and styles of the
source area. - ANSWER: CTRL+K
which of the following is NOT a series type that you can create in Excel (Auto fill,
Growth, Date) - ANSWER: Nonlinear
By default, headers and footers ___. - ANSWER: are blank
, A(n) ___ dollar sign always appears immediately to the left of the first significant
digit in a cell. - ANSWER: floating
A format code can have up to ___ sections. - ANSWER: four
The ___ defines the appearance and format of a printed worksheet. - ANSWER: page
setup
A ___ appears at the top of every printed page. - ANSWER: header
Consolidating data from other workbooks can be referred to as ___. - ANSWER:
linking
___ allow you to specify how cell entry assigned a format will appear. - ANSWER:
Custom format codes
A ___ reference is a formula that depends on its own value. - ANSWER: circular
The ___ style is the format style that Excel initially assigns to all cells in a workbook. -
ANSWER: Normal
A ___ appears at the bottom of every printed page. - ANSWER: footer
A(n) ___ is a group of format specifications that are assigned a style name. -
ANSWER: style
Linked workbooks are called the ___ workbooks. - ANSWER: source
To copy the contents of a cell to the cell directly below it, tap or click in the target
cell and press ___. - ANSWER: CTRL+D
A(n) ___ dollar sign always appears in the same position in a cell (regardless of the
number of significant digits). - ANSWER: fixed
Use the shortcut key ___ to copy the formulas from the source area but not the
contents or format. - ANSWER: CTRL+F
Excel limits the number of worksheets you can have in a workbook ___. - ANSWER:
based on the amount of memory in your computer
Which of the following functions will display the system date? - ANSWER: NOW()
You use the ___ to drag through cells to create a fill series - ANSWER: fill handle
A date might be displayed as a series of ___ if the date, as initially formatted by
Excel, does not fit in the width of the cell. - ANSWER: number signs
