Unit Test — Unit test Answers

25 verified answers2 views
1
Free Preview

Which phrase best describes a scenario in Excel 2019?

A
a type of what-if analysis that allows a user to define a single variable for a single function or formula
B
a type of what-if analysis that allows a user to define multiple variables for multiple functions or formulas
C
a type of chart analysis that allows a user to predict outcomes using data
D
a type of chart analysis that allows a user to set predetermined outcomes using data
2
Free Preview

Which phrase is the best definition of sparklines in Excel 2019?

A
a type of graphic that users can insert into a worksheet
B
a type of mini chart that users can insert into a worksheet
C
a simple image that is displayed in Excel
D
a link to an outside source that is referenced in a worksheet
3

Kyle is searching for the solver function but cannot seem to find it anywhere, not even under the Data tab in the ribbon.Where can it be found?

A
If it is not on the ribbon, it has not been activated; Kyle needs to activate it under Add-Ins in the Excel Options dialog box.
B
It is not under the Data tab because it is a formula; Kyle needs to look under the Formula tab on the ribbon in the Add-Ins group.
C
It is not a function that is usually displayed on the ribbon; Kyle can add it to the ribbon as a macro function.
D
Solver is a separate program; Kyle needs to launch it from his operating system's Start menu.
4

Which is NOT a valid sparkline type?

A
line
B
column
C
win/loss
D
bar
6

Which option is used once a sparkline has already been inserted to format it to a particular type and color?

A
Insert tab, Sparklines group
B
Insert tab, Filters group
C
Sparklines Design contextual tab
D
Sparklines Format tab
7

What is the maximum number of cells a user can select for the Set Objective variable in the Solver Parameters dialog box?

A
A user can select only a single cell for the Set Objective variable.
B
A user can select up to three cells for the Set Objective variable.
C
A user can select any number of cells for the Set Objective variable.
D
A user can select as many active cells as a worksheet contains for the Set Objective variable.
9

Which is an example of a bound form?

A
custom dialogue form
B
navigation form
C
switchboard form
D
data entry form
10

When is it a good time to create a database?

A
when you have a long list of contacts you need to save and refer to
B
when you have a short list of contacts you need to save and refer to
C
when you have a small volume of data you need to track and calculate
D
when you have large volumes of data you need to track and analyze
11

Which is the best description of the difference between bound and unbound forms?

A
Bound forms are similar to hierarchical forms but pop up in a separate window, while unbound forms are flat forms that do not have subforms.
B
Bound forms are linked to a table or query, while unbound forms are not linked to a table or query but are used to operate and navigate a database.
C
Bound forms perform tasks based on user input, while unbound forms navigate between multiple forms.
D
Bound forms are the basic interface for inputting information into tables or queries, while unbound forms have one or more subforms within the main form.
12

In researching his history report about the Civil War, why is Ariq most likely to use secondary data than primary data?

A
Secondary data provides a starting point to find primary data.
B
Secondary data is easier and less time consuming to find.
C
Secondary data is always more reliable and credible.
D
Secondary data eliminates the need for other research.
13

Which database can be used on a desktop computer?

A
an online dictionary
B
an online shoe company that has seven hundred fifty thousand customers
C
the mailing information of the 432 voters in a city council member’s district
D
the online banking information of the customers of a national bank
14

A report titled “Employees in Company A” contains the names of employees in descending alphabetical order, with the number of years each employee worked at the company. Which statement is true?

A
The report is sorted only because it organizes the names of the employees in alphabetical order.
B
The report is sorted only because it gives information about employees by number of years of employment.
C
The report is grouped only because it organizes the names of the employees in alphabetical order.
D
The report is grouped only because it gives information about employees by number of years of employment.
16

What is the first step in creating a database?

A
creating relationships within tables
B
creating relationships between tables
C
determining the number of tables to create
D
determining what data will be stored
20

Which is an advantage of using a flat file instead of a relational database?

A
A flat file is easier to set up.
B
It is easier to assign foreign keys to a flat file.
C
A flat file reduces storage of redundant data.
D
A flat file reduces storage of irrelevant data.

Did you find these answers helpful?