MGSC 290 Exam 3 Questions and
Answers|Latest Update
Which of the following commands is not available in a shared workbook? all of the
above
Which of the following creates a drop-down list from which you select one option?
Combo box
Which of the following displays in the upper right corner of a cell after a comment has been
added? small red triangle
Which of the following displays warning information yet allows users to make an entry?
Information message box
Which of the following error alerts shows an exclamation point (!) in a yellow triangle?
Warning box
Which of the following extensions does Excel assign to templates? .xltx
,Which of the following form controls is a radio button that allows a user to select one choice
from a set of possibilities? Option button
Which of the following functions displays the combo box result in a worksheet cell?
INDEX
Which of the following identifies commands, features, and other objects that are not supported in
earlier versions of Excel? Check Compatibility command
Which of the following information is stored in a workbook's change history? all of the
above
Which of the following is a comment message that appears on screen as soon as a cell with data
validation is selected? input message
Which of the following is a dialog box that lists the properties and data that can be removed from
a workbook? Document Inspector
, Which of the following is a pop-up text box attached to a cell? Comment
Which of the following is a programming language that allows you to expand the abilities of
Excel? VBA
Which of the following is a value or label that does not conform to validation criteria?
invalid data
Which of the following is not an option in the Allow drop-down list when setting data validation
with an operator? Between
Which of the following is not an option in the Highlight Changes dialog box? Printing
workbook changes
Which of the following is not an option on the Advanced tab of the Share Workbook dialog box?
Allow changes by more than one user
Which of the following is not true for Excel templates? Templates cannot include
formulas.
Answers|Latest Update
Which of the following commands is not available in a shared workbook? all of the
above
Which of the following creates a drop-down list from which you select one option?
Combo box
Which of the following displays in the upper right corner of a cell after a comment has been
added? small red triangle
Which of the following displays warning information yet allows users to make an entry?
Information message box
Which of the following error alerts shows an exclamation point (!) in a yellow triangle?
Warning box
Which of the following extensions does Excel assign to templates? .xltx
,Which of the following form controls is a radio button that allows a user to select one choice
from a set of possibilities? Option button
Which of the following functions displays the combo box result in a worksheet cell?
INDEX
Which of the following identifies commands, features, and other objects that are not supported in
earlier versions of Excel? Check Compatibility command
Which of the following information is stored in a workbook's change history? all of the
above
Which of the following is a comment message that appears on screen as soon as a cell with data
validation is selected? input message
Which of the following is a dialog box that lists the properties and data that can be removed from
a workbook? Document Inspector
, Which of the following is a pop-up text box attached to a cell? Comment
Which of the following is a programming language that allows you to expand the abilities of
Excel? VBA
Which of the following is a value or label that does not conform to validation criteria?
invalid data
Which of the following is not an option in the Allow drop-down list when setting data validation
with an operator? Between
Which of the following is not an option in the Highlight Changes dialog box? Printing
workbook changes
Which of the following is not an option on the Advanced tab of the Share Workbook dialog box?
Allow changes by more than one user
Which of the following is not true for Excel templates? Templates cannot include
formulas.
