BUS 1350 – Final Exam Part 5, 2026 – Study guide and practice material
the easiest way to create a new workbook that uses data from other workbooks is by simply -
correct answer ✔✔ copying and pasting worksheets from one workbook to another
you can work on different parts of the workbook at the same time by displaying different sheets
in separate windows by using which button in the window group on view tab - correct answer
✔✔ new window
how does excel distinguish between the 2 windows - correct answer ✔✔ adding a number after
the file name in the title bar
what 4 layout options can you choose from when you use the arrange all button in the window
group on view tab - correct answer ✔✔ tiled, horizontal, vertical, cascade
resizes the height and width of windows to fill the screen in both horizontal and vertical
directions to divide the workbook evenly on the screen - correct answer ✔✔ tiled layout
expands the width of the windows to fill the screen and places them in a single column by
dividing the workbooks into horizontal bands - correct answer ✔✔ horizontal layout
expands the height of the windows to fill the screen and places them in a single row by dividing
the workbook in vertical bands - correct answer ✔✔ vertical layout
layers the windows in an overlapping stack - correct answer ✔✔ cascade outline
generally you do not want more than ___ windows open at a time for cascade - correct answer
✔✔ 4
,as you scroll the worksheet contents in one window the sscrolling is mirrored in the other
window - correct answer ✔✔ synchronized scrolling
in a worksheet __________ any changes made to one worksheet are automatically applied to all
sheets in the group - correct answer ✔✔ group
what must the worksheets have the same in order for worksheet grouping to work - correct
answer ✔✔ organization and layout
a command that can be used to copy cell contents, formats, or both to worksheets in a group -
correct answer ✔✔ fill across worksheets
fill across worksheets only fills to the same ________ in different worksheets - correct answer
✔✔ location
the same page layout settings apply to all worksheets in teh group at the same time when doing
what with a worksheet group - correct answer ✔✔ printing
what tab's commands and features are not available when worksheets are grouped - correct
answer ✔✔ data
table features and formatting, conditioanl formatting, shapes, charts, and sparklines are
unavailable for - correct answer ✔✔ worksheet group
formulas with references to cells on the same sheet can be thought of as _____ refernces
because they involve only the row and column address - correct answer ✔✔ 2d
formulas with references to cells on a different worksheets can be thought of as ____
references as it includes the row and column address as well as the worksheet adress - correct
answer ✔✔ 3d
, when using a 3d reference to a worksheet the has a title with spaces what must you enclose the
sheet name with - correct answer ✔✔ single quotation marks
the general syntax for 3d reference - correct answer ✔✔ worksheetrange!cellrange
another way to reference several worksheets is to treat them as - correct answer ✔✔
worksheet groups
the syntax of the worksheet group reference - correct answer ✔✔ firstsheet:lastsheet!range
named range that references the same cell or range of cells across multiple worksheets in a
workbook - correct answer ✔✔ 3d named range
can a 3d named range be defined in the name box - correct answer ✔✔ no
where do you have to go to define a 3d name range - correct answer ✔✔ defined names in
formala tab
symbol that represents any character - correct answer ✔✔ wildcard
wildcard that represents any single character - correct answer ✔✔ ?
wildcard that represents any string of characters - correct answer ✔✔ asterisk *
what can you omit and use only wildcards for - correct answer ✔✔ any string of text
the easiest way to create a new workbook that uses data from other workbooks is by simply -
correct answer ✔✔ copying and pasting worksheets from one workbook to another
you can work on different parts of the workbook at the same time by displaying different sheets
in separate windows by using which button in the window group on view tab - correct answer
✔✔ new window
how does excel distinguish between the 2 windows - correct answer ✔✔ adding a number after
the file name in the title bar
what 4 layout options can you choose from when you use the arrange all button in the window
group on view tab - correct answer ✔✔ tiled, horizontal, vertical, cascade
resizes the height and width of windows to fill the screen in both horizontal and vertical
directions to divide the workbook evenly on the screen - correct answer ✔✔ tiled layout
expands the width of the windows to fill the screen and places them in a single column by
dividing the workbooks into horizontal bands - correct answer ✔✔ horizontal layout
expands the height of the windows to fill the screen and places them in a single row by dividing
the workbook in vertical bands - correct answer ✔✔ vertical layout
layers the windows in an overlapping stack - correct answer ✔✔ cascade outline
generally you do not want more than ___ windows open at a time for cascade - correct answer
✔✔ 4
,as you scroll the worksheet contents in one window the sscrolling is mirrored in the other
window - correct answer ✔✔ synchronized scrolling
in a worksheet __________ any changes made to one worksheet are automatically applied to all
sheets in the group - correct answer ✔✔ group
what must the worksheets have the same in order for worksheet grouping to work - correct
answer ✔✔ organization and layout
a command that can be used to copy cell contents, formats, or both to worksheets in a group -
correct answer ✔✔ fill across worksheets
fill across worksheets only fills to the same ________ in different worksheets - correct answer
✔✔ location
the same page layout settings apply to all worksheets in teh group at the same time when doing
what with a worksheet group - correct answer ✔✔ printing
what tab's commands and features are not available when worksheets are grouped - correct
answer ✔✔ data
table features and formatting, conditioanl formatting, shapes, charts, and sparklines are
unavailable for - correct answer ✔✔ worksheet group
formulas with references to cells on the same sheet can be thought of as _____ refernces
because they involve only the row and column address - correct answer ✔✔ 2d
formulas with references to cells on a different worksheets can be thought of as ____
references as it includes the row and column address as well as the worksheet adress - correct
answer ✔✔ 3d
, when using a 3d reference to a worksheet the has a title with spaces what must you enclose the
sheet name with - correct answer ✔✔ single quotation marks
the general syntax for 3d reference - correct answer ✔✔ worksheetrange!cellrange
another way to reference several worksheets is to treat them as - correct answer ✔✔
worksheet groups
the syntax of the worksheet group reference - correct answer ✔✔ firstsheet:lastsheet!range
named range that references the same cell or range of cells across multiple worksheets in a
workbook - correct answer ✔✔ 3d named range
can a 3d named range be defined in the name box - correct answer ✔✔ no
where do you have to go to define a 3d name range - correct answer ✔✔ defined names in
formala tab
symbol that represents any character - correct answer ✔✔ wildcard
wildcard that represents any single character - correct answer ✔✔ ?
wildcard that represents any string of characters - correct answer ✔✔ asterisk *
what can you omit and use only wildcards for - correct answer ✔✔ any string of text
