mcqs
help_req
quiz6_make_up.docxQuiz
Top of Form
|
Note: It is recommended that you save your response as you complete each question. |
When creating substitution values using the Series dialog box, what is the last number used in the substitution values?
Question 1 options:
|
|
Stop value |
|
|
Constraint |
|
|
Integer |
|
|
Step value |
Save
Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?
Question 2 options:
|
|
Two-variable Data Table |
|
|
Goal Seek |
|
|
Scenario Manager |
|
|
Solver |
Save
Which what-if analysis tool is best for manipulating one variable to determine one result?
Question 3 options:
|
|
Scenario Manager |
|
|
One-variable data table |
|
|
Goal Seek |
|
|
Solver |
Save
In order to complete a two-variable data table, which of the following must be included in the table?
Question 4 options:
|
|
Absolute reference |
|
|
Formula |
|
|
Constraint |
|
|
Integer |
Save
Which what-if analysis tool is best used for creating optimization models?
Question 5 options:
|
|
Two-variable data table |
|
|
Solver |
|
|
One-variable data table |
|
|
Goal Seek |
Save
Which dialog box enables you to specify the result cells for a scenario summary report?
Question 6 options:
|
|
Scenario Values |
|
|
Add Scenario |
|
|
Solver Options |
|
|
Scenario Summary |
Save
Which is the best tool for determining the optimal blend of products to produce in order to maximize profit?
Question 7 options:
|
|
Goal Seek |
|
|
Scenario Manager |
|
|
Two-variable data table |
|
|
Solver |
Save
Which of the following what-if analysis tools updates date in real time?
Question 8 options:
|
|
Scenario Manager |
|
|
One-variable data table |
|
|
Solver |
|
|
Goal Seek |
Save
Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years?
Question 9 options:
|
|
Goal Seek |
|
|
Solver |
|
|
Scenario Manager |
|
|
One-variable data table |
Save
Which of the following options is required to complete a Solver model?
Question 10 options:
|
|
Constraint |
|
|
Scenario |
|
|
Objective cell |
|
|
Set cell |
Save
Save All Responses
Quiz 7
Top of Form
|
Note: It is recommended that you save your response as you complete each question. |
Which of the following functions does not support multiple conditions?
Question 1 options:
|
|
MATCH |
|
|
OR |
|
|
NOT |
|
|
AND |
Save
When using Advanced Filtering, the criteria range must contain at least:
Question 2 options:
|
|
three rows. |
|
|
one columns. |
|
|
two rows. |
|
|
three columns. |
Save
Which of the following has the ability to restrict data view to only information that fits predetermined criteria?
Question 3 options:
|
|
INDEX |
|
|
HLOOKUP |
|
|
VLOOKUP |
|
|
Advanced Filter |
Save
Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000?
Question 4 options:
|
|
DCOUNTA |
|
|
DMAX |
|
|
DMIN |
|
|
DSUM |
Save
When using Advanced Filtering < > is the equivalent of:
Question 5 options:
|
|
equal to. |
|
|
greater than. |
|
|
not equal to. |
|
|
less than. |
Save
In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)), F5*K7 is the:
Question 6 options:
|
|
Value_if_true. |
|
|
Modifier. |
|
|
Value_if_false. |
|
|
Logical_test. |
Save
Which of the following is not an argument in a database function?
Question 7 options:
|
|
Criteria |
|
|
Database |
|
|
Filter |
|
|
Field |
Save
If there are four possible outcomes, how many logical tests are required?
Question 8 options:
|
|
4 |
|
|
3 |
|
|
2 |
|
|
1 |
Save
When using Advanced Filtering empty cells in the criteria range will return which of the following?
Question 9 options:
|
|
All records |
|
|
No records |
|
|
NA |
|
|
Select records |
Save
When using the MATCH function with an exact match lookup_value, the match type must be set to:
Question 10 options:
|
|
2. |
|
|
-1. |
|
|
1. |
|
|
0. |
Save
Save All Responses
Quiz 8
Top of Form
|
Note: It is recommended that you save your response as you complete each question. |
Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?
Question 1 options:
|
|
Descriptive Statistics |
|
|
Correlation |
|
|
Histogram |
|
|
ANOVA |
Save
Which of the following functions will help determine the strength of a relationship between two variables?
Question 2 options:
|
|
CORREL |
|
|
VARPA |
|
|
STDEV.P |
|
|
VAR.P |
Save
What does the order argument of the RANK.EQ function define?
Question 3 options:
|
|
The order in which numbers are ranked |
|
|
The ranking order scale |
|
|
The ranking stop value |
|
|
The lowest ranked value |
Save
Which of the following tools is not included in the Analysis ToolPak?
Question 4 options:
|
|
Rank Average |
|
|
Covariance |
|
|
Correlation |
|
|
Anova: Single Factor |
Save
Which data analysis tool is best suited to measure how two sets of data vary simultaneously?
Question 5 options:
|
|
Histogram |
|
|
Variance |
|
|
Correlation |
|
|
Covariance |
Save
Which of the following is a new statistical function in Excel 2013?
Question 6 options:
|
|
CORREL |
|
|
VARPA |
|
|
STDEV.P |
|
|
Skew.P |
Save
Which of the following functions will exclude quartiles 0 and 4 in its calculations?
Question 7 options:
|
|
QUARTILE.INC |
|
|
PERCENTILE.EXC |
|
|
QUARTILE |
|
|
QUARTILE.EXC |
Save
What function is best suited to determine how often a set of numbers appears within a dataset?
Question 8 options:
|
|
SUMIFS |
|
|
SUMIF |
|
|
FREQUENCY |
|
|
AVERAGEIF |
Save
The second quartile of both QUARTILE.EXC and QUARTILE.INC defines what percentile?
Question 9 options:
|
|
25th |
|
|
0 |
|
|
75th |
|
|
50th |
Save
Which of the following functions will determine the standard deviation of a sample?
Question 10 options:
|
|
STDEV.S |
|
|
STDEVA |
|
|
VARA |
|
|
STDEV.P |
Save
Save All Responses
Bottom of Form
Bottom of Form
Bottom of Form
Quiz9
Top of Form
|
Note: It is recommended that you save your response as you complete each question. |
Which of the following is the proper format for a 3-D reference?
Question 1 options:
|
|
Worksheet Name!RangeOfCells |
|
|
"Worksheet Name"!RangeOfCells |
|
|
'Worksheet Name!RangeOfCells' |
|
|
'Worksheet Name'!RangeOfCells |
Save
What happens when data that is externally linked is edited and both the source and destination file are open?
Question 2 options:
|
|
There will be no change |
|
|
A security prompt appears |
|
|
The links will automatically update |
|
|
The links will not update |
Save
To group nonadjacent worksheet tabs:
Question 3 options:
|
|
click Group on the View tab. |
|
|
click the first worksheet tab, press and hold Shift, and then click the last worksheet tab. |
|
|
right-click a worksheet tab and click Select All Sheets. |
|
|
click the first worksheet tab, press and hold Ctrl, and then click each additional worksheet tab. |
Save
When worksheets are grouped which of the following actions will not occur across all worksheets?
Question 4 options:
|
|
Formatting |
|
|
Data entry |
|
|
Structural changes |
|
|
Conditional formatting |
Save
When is the input message displayed in a cell that contains a validation rule?
Question 5 options:
|
|
When the user violates a rule |
|
|
When the workbook is opened |
|
|
When the cell is clicked |
|
|
When the cell is double-clicked |
Save
Which of the following functions cannot be used as a 3-D formula?
Question 6 options:
|
|
AVERAGE |
|
|
PMT |
|
|
MAX |
|
|
SUM |
Save
To group all worksheets:
Question 7 options:
|
|
right-click a cell and select All. |
|
|
right-click a worksheet tab and click Select All Sheets. |
|
|
click Group on the Data tab. |
|
|
click Group on the View tab. |
Save
What happens if you rename the source file of a worksheet that is used in an external reference?
Question 8 options:
|
|
The link will automatically update |
|
|
A prompt to manually update the link appears |
|
|
The linked data will appear in red text |
|
|
The workbook will not open |
Save
Which of the following is not a way to remove panes from a window that has been split?
Question 9 options:
|
|
Click Remove Split in the View tab |
|
|
Drag a vertical split bar to the left or right edge of the worksheet window |
|
|
Click Split in the Window group |
|
|
Double-click the split bar |
Save
What error will cause #NUM! to appear?
Question 10 options:
|
|
Misspelled name |
|
|
Deleted cell reference |
|
|
Invalid arguments in a function |
|
|
Invalid range name |
Save
Save All Responses Bottom of Form
Quiz 10
Top of Form
|
Note: It is recommended that you save your response as you complete each question. |
Once XML data is imported, where can the data source be manipulated?
Question 1 options:
|
|
XML options box |
|
|
View tab |
|
|
XML Source task pane |
|
|
Developer tab |
Save
When importing an Access database table, Excel:
Question 2 options:
|
|
imports the data in delimited format. |
|
|
imports the data in CSV format. |
|
|
imports the data as text. |
|
|
formats the data in default table style. |
Save
Which of the following tools is best suited for setting up a connection to a table on a Web page?
Question 3 options:
|
|
3-D formula |
|
|
Web inquiry |
|
|
Hyperlink |
|
|
Web query |
Save
Which function is best suited to return the specified number of characters from the middle of a text string?
Question 4 options:
|
|
LEFT |
|
|
SUBSTITUTE |
|
|
MID |
|
|
RIGHT 1 Copyright © 2014 Pearson Education, Inc. |
Save
What governing body created XML?
Question 5 options:
|
|
World Wide Web Consortium |
|
|
ICANN |
|
|
IEEE |
|
|
The Computer Science Society |
Save
Which of the following options will refresh connections within an Excel workbook?
Question 6 options:
|
|
Click Refresh in the Backstage area |
|
|
Click anywhere in the connected data |
|
|
Click Refresh All on the Connections group |
|
|
Click Refresh in the Insert tab |
Save
Which of the following is a file type that cannot be imported into Excel?
Question 7 options:
|
|
Text file |
|
|
|
|
|
CAD |
|
|
TIFF |
Save
Which of the following is an alternative to using the CONCATENATE function?
Question 8 options:
|
|
SUM |
|
|
: |
|
|
& |
|
|
+ |
Save
Which of the following is the best option for transferring data between incompatible systems?
Question 9 options:
|
|
XHTML |
|
|
XML |
|
|
CSS |
|
|
HTML |
Save
Which of the following are settings that control how imported data in cells connect to their source data?
Question 10 options:
|
|
Import settings |
|
|
Link settings |
|
|
Connection properties |
|
|
Data range properties |
Save
Save All Responses
Bottom of Form
