Click on the correct response for each question below.
 |
1 |  |  To create an organization chart, choose:
|
|  | A) | Insert, Chart, Organization Chart
|
|  | B) | Insert, Organization Chart
|
|  | C) | Insert, File, Organization Chart
|
|  | D) | Insert, Picture, Organization Chart
|
 |
 |
2 |  |  Which of the following refers to a type of diagram used to show the personnel structure
|
|  | A) | a company or organization?
|
|  | B) | Cycle Diagram
|
|  | C) | Organization Chart
|
|  | D) | Pyramid Diagram
D. Target Diagram
|
 |
 |
3 |  |  In a Web Query, the selected areas of a Web page are marked with a
|
|  | A) | black checkmark
|
|  | B) | yellow box
|
|  | C) | green arrow
|
|  | D) | purple dot
|
 |
 |
4 |  |  Which of the following functions is used to calculate sum-of-years-digits depreciation?
|
|  | A) | SYD
|
|  | B) | SLN
|
|  | C) | DDB
|
|  | D) | VDB
|
 |
 |
5 |  |  Which of the following functions is used to calculate straight line depreciation?
|
|  | A) | DDB
|
|  | B) | VDB
|
|  | C) | DB
|
|  | D) | SLN
|
 |
 |
6 |  |  The syntax for referencing data from another worksheet is
|
|  | A) | =SheetName:CellName.
|
|  | B) | =SheetName.CellName.
|
|  | C) | =SheetName!CellName.
|
|  | D) | =SheetName&CellName.
|
 |
 |
7 |  |  To copy a worksheet, choose
|
|  | A) | Edit, Copy.
|
|  | B) | Edit, Copy or Move Worksheet.
|
|  | C) | Edit, Worksheet.
|
|  | D) | Edit, Move.
|
 |
 |
8 |  |  The table that is used to find the results in a lookup function is called what?
|
|  | A) | Lookup_table
|
|  | B) | Array
|
|  | C) | Lookup_index
|
|  | D) | Range_lookup
|
 |
 |
9 |  |  To find the smallest value that is greater than or equal to the lookup value in a Match function, set the Match_type argument to
|
|  | A) | 0.
|
|  | B) | -1.
|
|  | C) | 1.
|
|  | D) | >=.
|
 |
 |
10 |  |  Written instructions that will then be translated into actual computer code are referred to
|
|  | A) | |
|  | B) | allegories.
|
|  | C) | macros.
|
|  | D) | machine language.
D. pseudocode.
|
 |
 |
11 |  |  Which of the following likes of VBA code will copy the contents of cell B7 in worksheet "expenses" to cell A3 in worksheet "balance"?
|
|  | A) | Worksheets("balance").Cells(3,1).Value=Worksheets("expenses").Cells(7,2).Value
|
|  | B) | Worksheets("expenses").Cells(7,2).Value =Worksheets("balance").Cells(3,1).Value
|
|  | C) | Worksheets("balance").Cells(1,3).Value=Worksheets("expenses").Cells(2,7).Value
|
|  | D) | Worksheets("expenses").Cells(2,7).Value =Worksheets("balance").Cells(1,3).Value
|
 |