AnswersLHS Computer ApplicationsUnit Test

Unit Test — Cumulative exam Answers

25 verified answers
1
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
2
Free Preview

Connie needs to use the data consolidation tool in Excel 2019. Where can she find this capability?

A
Data tab and Data Tools group
B
Data tab and External Data group
C
Formula tab and Calculation group
D
Review tab and Changes group
3

What is the shortcut key to launch the Macros dialog box?

A
Alt+F7
B
Alt+F8
C
Ctrl+F8
D
Ctrl+F7
4

What type of result does the MATCH function, when used on its own, return?

A
It returns the lookup value located in a specific location.
B
It returns a value that is the same as the lookup value.
C
It returns the cell reference of the lookup value.
D
It returns the relative position of a lookup value, either as a row or column number, within the selected array.
5

Which feature allows an Excel 2019 user to visualize data on a map by plotting geographic and temporal or time-related data on a globe or custom map?

A
3D map
B
grid graph
C
time lapse
D
real-time data
6

When using the protection options in Excel 2019, what does the Protect Workbook function do?

A
It protects all the worksheets in a workbook from being reformatted or typed into.
B
It adds a password to access the worksheet.
C
It prevents worksheets from being inserted, deleted, or moved.
D
It saves a workbook in a way that will allow only a select group of people to access it.
7

Nolan has just created a linked cell to another cell in a separate worksheet in his current Excel 2019 workbook.What kind of cell relationship has Nolan created in the linked cell?

A
precedent
B
dependent
C
external
D
nonfunctional
8

Janet is working on a highly confidential company budget spreadsheet, and she needs to prevent anyone, including administrators in the IT department, from being able to open the file and view its contents.What should she do?

A
Use the Home tab, select Protect Sheet, and enter a password to prevent access to the sheet.
B
Click the Info tab in the Backstage view, select Protect Workbook, select Encrypt with Password, and enter a password.
C
Click the Review tab, select Protect Workbook, and enter a password for protecting the sheet.
D
Click the View tab and customize the view to protect the sheet from unauthorized users.
9

Pam has created a linked cell to another worksheet within the same workbook to automatically update sales data.What kind of linked cell has Pam created?

A
external link
B
internal link
C
cell reference
D
worksheet reference
10

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.
11

Chen is busy recording a macro in Excel, but she has made a mistake. What is the best course of action to take in this scenario?

A
Pause the macro and click Rewind to fix it.
B
Rerecord the macro.
C
Click Undo.
D
Delete the macro and the workbook.
12

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.
13

Which feature is used to summarize data from multiple worksheets but does not require that the data be in the same location on every worksheet?

A
data consolidation
B
3-D reference
C
edit links
D
internal link
14

Which statement is the best description of what a macro can do in Excel 2019?

A
It is a type of formatting users can apply to enlarge the worksheet area.
B
It is a file type that a user can save a workbook as.
C
It is a series of instructions contained in one command that users can apply to automate complex and/or repetitive tasks.
D
It is a recording function that allows the user to save worksheets, audio recordings, and videos that are displayed on the screen
15

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
16

Which steps are used to view and delete the macros that have been enabled in a workbook?

A
Press Alt+F8, select the macro to be deleted, and press Delete.
B
Under the Developer tab, click the Macros button in the Code group, select the macro to delete, and press Delete.
C
Press Alt+F11, click Tools, and select Macros; then, select the macro to delete and press Delete.
D
All of the options listed are correct.
17

Robyn is using lookup functions in her Excel 2019 worksheet. Which formula uses the correct syntax?

A
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
B
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
C
=VLOOKUP(lookup_value, table_array, col_index_num, value)
D
=VLOOKUP(table_array, lookup_value, col_index_num, value)
18

Which is NOT a valid sparkline type?

A
line
B
column
C
win/loss
D
bar
19

Zoe has been asked to identify the external links that exist in a workbook that has primarily been managed by another employee.Which feature should she use?

A
Show/Hide Links
B
Data tab and External Links group
C
Edit Links dialog box
D
Data tab and Data tools group
20

How can Workbook Protection that has been applied to a workbook be removed?

A
Open the file, enter the password, and then resave the workbook to remove the protection.
B
Right-click the workbook and select Remove Protection from the menu list.
C
Select the cells to unprotect, click the Home tab on the ribbon, and select Lock Cells in the Format menu.
D
Click the Review tab on the ribbon and click Protect Workbook in the Changes group.

Did you find these answers helpful?

More from this Course

Quiz
25 verified answers

Unit Test

Quiz
24 verified answers

Unit Test

Quiz
25 verified answers

Unit Test

Unit Test — Cumulative exam Answers — LHS…