CGS 2518 FSU EXAM 1 QUESTIONS
WITH CORRECT ANSWERS
What is the keyboard shortcut to create an absolute reference?
(a) F2
(b) F3
(c) F4
(d) Alt - Answer-(c) F4
You have a workbook that contains sales data for different regional sales reps of a
company. Which task is the least like to be done while the worksheets are grouped?
(a) Fill the sales categories across the worksheets.
(b) Format the column and row labels at the same time.
(c) Enter specific values for the first sales rep.
(d) Format the values with an appropriate number style. - Answer-(c) Enter specific
values for the first sales rep.
Your manager sent you a workbook that contains data validation rules. One rule
specifies a maximum value of 15% with a warning alert. You try to enter 22% in that
cell. What happens?
(a) Excel enters the 22% with no message boxes.
(b) Excel enters the 22% and provides message box to inform you that your entry
violates the validation rule.
(c) Excel displays a message box and prevents you from entering 22%.
(d) Excel displays a message box informing you the value is above the maximum value
and lets you choose to go ahead and enter that value or a different value. - Answer-(d)
Excel displays a message box informing you the value is above the maximum value and
lets you choose to go ahead and enter that value or a different value.
The function =FV(D10,D8,-D5) is entered in cell D12. Which cell is a dependent of cell
D8?
(a) D10
(b) D12
(c) D5
(d) D1 - Answer-(b) D12
If you want to display a portion of all three worksheets in a workbook, what should you
do?
, (a) Open two new workbook windows, arrange windows, and the click a different
worksheet tab in each window.
(b) Use the freeze Panes option and cascade the title bars of all open workbooks.
(c) Double-click the split boxes to display four window panes, click within each pane,
and the click the worksheet tab to display its content.
(d) Use the Spit, Freeze Panes, and Arrange All commands at the same time. - Answer-
(a) Open two new workbook windows, arrange windows, and the click a different
worksheet tab in each window.
A personal trainer stores how much weight each person can lift in several categories.
Each week's data are stored in a separate worksheet within the same workbook, and
each worksheet has an identical structure. Assume cell F5 contains the weight the first
person can bench press. What function can identify that person's highest amount
bench-pressed in all worksheets?
(a) =COUNT9Week 1, Week4:F5_
(b) =SUM(Week 1:Week4:F5)
(c) =MAX('Week 1:Week 4'!F5)
(d) =MAX(Week1:Week4:'F5') - Answer-(c) =MAX('Week 1:Week 4'!F5)
You want to create a hyperlink within your document to the SEC Web site. Which type
of link do you create?
(a) Existing File or Web Page
(b) Place in this Document
(c) Create New Document
(d) E-Mail Address - Answer-(a) Existing File or Web Page
Cell B15 contains the formula =B14+B15. You created a:
(a) 3-D Formula
(b) Circular Reference
(c) Syntax Error
(d) Reference Formula - Answer-(d) Reference Formula
You want to create a situation so that you can monitor the results of cell formulas on a
different worksheet as you change data on another worksheet. You should create a:
(a) Data validation window
(b) Hyperlink between worksheets
(c) Watch Window
(d) Circular Reference Window - Answer-(c) Watch Window
You created several workbooks (accounting, finance, management, and marketing) in
the same folder as the main workbook SchoolOfBusiness. What formula correctly links
to cell D20 in the Fall 2018 worksheet within the Finance workbook?
WITH CORRECT ANSWERS
What is the keyboard shortcut to create an absolute reference?
(a) F2
(b) F3
(c) F4
(d) Alt - Answer-(c) F4
You have a workbook that contains sales data for different regional sales reps of a
company. Which task is the least like to be done while the worksheets are grouped?
(a) Fill the sales categories across the worksheets.
(b) Format the column and row labels at the same time.
(c) Enter specific values for the first sales rep.
(d) Format the values with an appropriate number style. - Answer-(c) Enter specific
values for the first sales rep.
Your manager sent you a workbook that contains data validation rules. One rule
specifies a maximum value of 15% with a warning alert. You try to enter 22% in that
cell. What happens?
(a) Excel enters the 22% with no message boxes.
(b) Excel enters the 22% and provides message box to inform you that your entry
violates the validation rule.
(c) Excel displays a message box and prevents you from entering 22%.
(d) Excel displays a message box informing you the value is above the maximum value
and lets you choose to go ahead and enter that value or a different value. - Answer-(d)
Excel displays a message box informing you the value is above the maximum value and
lets you choose to go ahead and enter that value or a different value.
The function =FV(D10,D8,-D5) is entered in cell D12. Which cell is a dependent of cell
D8?
(a) D10
(b) D12
(c) D5
(d) D1 - Answer-(b) D12
If you want to display a portion of all three worksheets in a workbook, what should you
do?
, (a) Open two new workbook windows, arrange windows, and the click a different
worksheet tab in each window.
(b) Use the freeze Panes option and cascade the title bars of all open workbooks.
(c) Double-click the split boxes to display four window panes, click within each pane,
and the click the worksheet tab to display its content.
(d) Use the Spit, Freeze Panes, and Arrange All commands at the same time. - Answer-
(a) Open two new workbook windows, arrange windows, and the click a different
worksheet tab in each window.
A personal trainer stores how much weight each person can lift in several categories.
Each week's data are stored in a separate worksheet within the same workbook, and
each worksheet has an identical structure. Assume cell F5 contains the weight the first
person can bench press. What function can identify that person's highest amount
bench-pressed in all worksheets?
(a) =COUNT9Week 1, Week4:F5_
(b) =SUM(Week 1:Week4:F5)
(c) =MAX('Week 1:Week 4'!F5)
(d) =MAX(Week1:Week4:'F5') - Answer-(c) =MAX('Week 1:Week 4'!F5)
You want to create a hyperlink within your document to the SEC Web site. Which type
of link do you create?
(a) Existing File or Web Page
(b) Place in this Document
(c) Create New Document
(d) E-Mail Address - Answer-(a) Existing File or Web Page
Cell B15 contains the formula =B14+B15. You created a:
(a) 3-D Formula
(b) Circular Reference
(c) Syntax Error
(d) Reference Formula - Answer-(d) Reference Formula
You want to create a situation so that you can monitor the results of cell formulas on a
different worksheet as you change data on another worksheet. You should create a:
(a) Data validation window
(b) Hyperlink between worksheets
(c) Watch Window
(d) Circular Reference Window - Answer-(c) Watch Window
You created several workbooks (accounting, finance, management, and marketing) in
the same folder as the main workbook SchoolOfBusiness. What formula correctly links
to cell D20 in the Fall 2018 worksheet within the Finance workbook?
