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