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...
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")
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Nursewendo. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
