BIM2 Excel Fall19 Exam Questions
Correctly Answered.
Which of the following buttons in the Info portion of Backstage View opens a menu which contains the
command to check for accessibility issues? - CORRECT ANSWER Check for Issues
Which of the following tools can be used to inspect a document for hidden data and personal
information? - CORRECT ANSWER Document Inspector
Which of the following file types should be chosen when saving a workbook as a template? - CORRECT
ANSWER Excel Template
Which of the following locations in the New portion of Backstage View should be clicked to view a
workbook template you created? - CORRECT ANSWER Design
Which of the following types of form controls should Mark enter if he wants the control to run a macro
when clicked? - CORRECT ANSWER Button
Which of the following tabs must be present on the Ribbon to insert form controls? - CORRECT ANSWER
Developer
Which of the following tools can be used to create a data form? - CORRECT ANSWER Form Tool
Which of the following tabs contains the command to add a sparkline to a worksheet? - CORRECT
ANSWER Insert
Which tab on the Ribbon holds the command to open the formula view? - CORRECT ANSWER Formulas
Which of the following is NOT a comparison operator? - CORRECT ANSWER / slash
, Which of the following tabs contains the commands to add a text box or shape? - CORRECT ANSWER
Insert
Which of the following is a feature which updates the web page each time a change is saved on the
source worksheet or workbook? - CORRECT ANSWER AutoRepublish
Which of the following is a workbook designed with a standard structure and format which makes it
easier to capture, organize and edit information? - CORRECT ANSWER Form
Which of the following can be added to a chart to show data trends? - CORRECT ANSWER Trendline
Which of the following form controls can be used to place related controls in one visual unit? - CORRECT
ANSWER Group box
Which of the following form controls could be used to turn on or off a value which indicates a choice? -
CORRECT ANSWER Check box
Which of the following is a small chart in the background of a worksheet cell which provides a visual
representation of data? - CORRECT ANSWER Sparkline
Which tab holds the command to create a PivotTable? - CORRECT ANSWER Insert
Which of the following can be used to plot one or more data series on a secondary axis? - CORRECT
ANSWER Dual-Axis chart
Which tab on the Ribbon contains the commands for importing information into Excel? - CORRECT
ANSWER Data
Which group contains the options to import data? - CORRECT ANSWER Get External Data
Which of the following formulas adds together values greater than 5000 in cells C2 through C17? -
CORRECT ANSWER =SUMIF(C2:C17,">5000")
Correctly Answered.
Which of the following buttons in the Info portion of Backstage View opens a menu which contains the
command to check for accessibility issues? - CORRECT ANSWER Check for Issues
Which of the following tools can be used to inspect a document for hidden data and personal
information? - CORRECT ANSWER Document Inspector
Which of the following file types should be chosen when saving a workbook as a template? - CORRECT
ANSWER Excel Template
Which of the following locations in the New portion of Backstage View should be clicked to view a
workbook template you created? - CORRECT ANSWER Design
Which of the following types of form controls should Mark enter if he wants the control to run a macro
when clicked? - CORRECT ANSWER Button
Which of the following tabs must be present on the Ribbon to insert form controls? - CORRECT ANSWER
Developer
Which of the following tools can be used to create a data form? - CORRECT ANSWER Form Tool
Which of the following tabs contains the command to add a sparkline to a worksheet? - CORRECT
ANSWER Insert
Which tab on the Ribbon holds the command to open the formula view? - CORRECT ANSWER Formulas
Which of the following is NOT a comparison operator? - CORRECT ANSWER / slash
, Which of the following tabs contains the commands to add a text box or shape? - CORRECT ANSWER
Insert
Which of the following is a feature which updates the web page each time a change is saved on the
source worksheet or workbook? - CORRECT ANSWER AutoRepublish
Which of the following is a workbook designed with a standard structure and format which makes it
easier to capture, organize and edit information? - CORRECT ANSWER Form
Which of the following can be added to a chart to show data trends? - CORRECT ANSWER Trendline
Which of the following form controls can be used to place related controls in one visual unit? - CORRECT
ANSWER Group box
Which of the following form controls could be used to turn on or off a value which indicates a choice? -
CORRECT ANSWER Check box
Which of the following is a small chart in the background of a worksheet cell which provides a visual
representation of data? - CORRECT ANSWER Sparkline
Which tab holds the command to create a PivotTable? - CORRECT ANSWER Insert
Which of the following can be used to plot one or more data series on a secondary axis? - CORRECT
ANSWER Dual-Axis chart
Which tab on the Ribbon contains the commands for importing information into Excel? - CORRECT
ANSWER Data
Which group contains the options to import data? - CORRECT ANSWER Get External Data
Which of the following formulas adds together values greater than 5000 in cells C2 through C17? -
CORRECT ANSWER =SUMIF(C2:C17,">5000")
