MGSC 290 Exam 3 – Flashcards
Unlock all answers in this set
Unlock answersquestion
What is Data Validation?
answer
A process in which Excel checks data to verify that it matches the established requirements
question
Which of the following is not one of the three taps in the Data Validation dialog box?
answer
True: settings, input message, error alert
question
Which of the following is not what you can specify in validation settings?
answer
True: Build a simple condition, set date and time, limit length
question
When typing entries for a data validation list, what should you separate items with?
answer
Comma
question
Which of the following is not one of the three error alert?
answer
Anything but stop, warning, information
question
Which of the following is a programming language that allows you to expand the abilities of Excel?
answer
VBA (Visual Basic for Application)
question
When you select a state abbreviation from a combo box, how does the form control record your selection?
answer
Number
question
Which of the following is a worksheet object that is similar to a form control but more flexible and robust?
answer
ActiveX Control
question
Which of the following extensions does Excel give to templates?
answer
.xltx
question
The word _____ appears after the file name in the title bar after a workbook is shared.
answer
Shared
question
What you can do with Track Change [Review tab, Changes group]?
answer
Accept/reject/highlight changes
question
What are the three Solver components known as?
answer
Variable, objective, constraint
question
How many types of reports can you create using the Solver Results dialog box?
answer
3: Answer, sensitivity, limits
question
Which of the following reports include statistical data?
answer
Answer
question
When you insert a calculated field in a PivotTable, where is it initially placed?
answer
Last field in the PivotTable
question
When you refresh a PivotTable, what happened?
answer
Updates information
question
Which of the following statements is not true about the Slicer tool?
answer
True: Acts as a filter, displays only certain data
question
Which of the following statements is not true about a one-variable data table?
answer
True: Subs values for one arguments in a formula, and displays results when that formula is altered
question
Which of the following statements is not true about a two-variable data table?
answer
True: uses two sets of values, one in a column and one in a row
question
In an XML file, which of the following characters encloses the tags?
answer
Chevron braces
question
What are the sequences of importing an XML file via XML Source task Pane?
answer
Open, navigate to folder with .xml, open, click use the xml source task pane, ok, point at a field name in xml source task pane and drag it to a cell, drag each field name from the xml source task pane to a cell in the worksheet
question
Which of the following statements is not true about running a macro?
answer
True: excel blocks macros, must trust macro to view it, when it runs it carries out command of the current workbook, common macros formatting cell contents, importing data, applying filtering options
question
The code behind a macro is written in a programming language that is often referred to as:
answer
VBA
question
By default, how is a macro recorded?
answer
With absolute references
question
What happens when you try to save a workbook with macros as a regular Excel workbook?
answer
Get a message box
question
Which of the following statements is not true about VBA?
answer
True: VBA is built on these assumptions: Objects, calling methods, collections
question
When you run a macro that was recorded with absolute references, where should the cursor be?
answer
Anywhere in the worksheet
question
Which of the following steps could alter the properties of buttons so that the buttons do not move?
answer
Right-click the control, choose Format control, then select the Don't move or size with cells radio button on the Properties tab
