CISM Exam 2 Questions & Answers
(Grade A+)
Which of the following financial function arguments specifies the
amount paid each period? - correct answer ✅pmt
When linking workbooks using a formula, what type of link is
created? - correct answer ✅a link to the source workbook
Which of the following is not true when inserting a calculated field?
- correct answer ✅field names display with quotation marks
Which of the following provides a convenient way to monitor
changes in formulas when you work in large worksheets or with
multiple sheets? - correct answer ✅watch window
Which of the following statements is not true about screenshots? -
correct answer ✅when capturing an image from a web site, it is
not necessary to obtain permission
Up to three scenarios can be displayed at a time in a worksheet. -
correct answer ✅false
, CISM Exam 2 Questions & Answers
(Grade A+)
Which of the following functions allows you to substitute characters
for a specified number of characters in existing data? - correct
answer ✅replace function
Which of the following Solver reports identifies and lists each
parameter? - correct answer ✅answer report
An identifier is a character such as an exclamation point that marks
or signifies a component of an external reference. - correct answer
✅false
You can use the Find and Replace command to replace formats such
as font type, fill color, or border style. - correct answer ✅False?
The basic syntax for most database functions is FunctionName
(database, field, criteria). - correct answer ✅True
How many arguments do all database functions have? - correct
answer ✅3
(Grade A+)
Which of the following financial function arguments specifies the
amount paid each period? - correct answer ✅pmt
When linking workbooks using a formula, what type of link is
created? - correct answer ✅a link to the source workbook
Which of the following is not true when inserting a calculated field?
- correct answer ✅field names display with quotation marks
Which of the following provides a convenient way to monitor
changes in formulas when you work in large worksheets or with
multiple sheets? - correct answer ✅watch window
Which of the following statements is not true about screenshots? -
correct answer ✅when capturing an image from a web site, it is
not necessary to obtain permission
Up to three scenarios can be displayed at a time in a worksheet. -
correct answer ✅false
, CISM Exam 2 Questions & Answers
(Grade A+)
Which of the following functions allows you to substitute characters
for a specified number of characters in existing data? - correct
answer ✅replace function
Which of the following Solver reports identifies and lists each
parameter? - correct answer ✅answer report
An identifier is a character such as an exclamation point that marks
or signifies a component of an external reference. - correct answer
✅false
You can use the Find and Replace command to replace formats such
as font type, fill color, or border style. - correct answer ✅False?
The basic syntax for most database functions is FunctionName
(database, field, criteria). - correct answer ✅True
How many arguments do all database functions have? - correct
answer ✅3
