Quiz 2 Prep answers

Office:

  1. When assigned to a cell, the ___NOW____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
  2. The ____= or equal sign______ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text.
  3. Formatting that appears only when the value in a cell meets specified conditions is called _conditional formatting____.
  4. _Hiding cells__ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.
  5. When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a(n) _relative reference_.

Office 2:

  1. The general form of the VLOOKUP function is _C_.
    a. =VLOOKUP(table_array, col_index_num)
    b. =VLOOKUP(lookup_value, row_index_num)
    c. =VLOOKUP(lookup_value, table_array, col_index_num)
    d. =VLOOKUP(lookup_value)
  2. The process of summarizing data included on multiple worksheets on one worksheet is called __consolidation__.
  3. If the table contains no data, Excel sets the ___format__ of the cells in the first row to the default associated with the table quick style chosen when the table was created.
  4. A format code can have as many as _____four_____ sections.
  5. A __circular__ reference is a formula that depends on its own value.

Office 3:

  1. Some earlier versions of Excel use a language called XLM, rather than VBA, for their macros. EX 553
  2. What is the purpose of a message box? EX 562 to display messages to a user
  3. After a workbook has been reviewed by others, it usually is returned to the owner, who can then review those changes and decide whether or not to accept them. EX 742
  4. Worksheet backgrounds allow an image to be specified for use as a watermark behind the data in cells of a worksheet. EX 766
  5. Before distributing your workbook to others, consider what type of hidden information might be in your document.EX 682

 

HTML:

  1. If you wanted five frame rows, the <frameset> tag could contain which of the following relative percentages?A
    a. <frameset rows="20%, 20%, 20%, 20%, 20%">
    b. <frameset rows="10%, 10%, 10%, 10%, 10%">
    c. <frameset rows="30%, 10%, 20%, 40%, 50%">
    d. <frameset rows="20%, 20%, 10%, 10%, 20%">
  2. In a server-side image map, the __browser__ sends the x- and y- coordinates to the Web server for the position of the link on the image map.201
  3. The ___src_____ attribute indicates the Web page to be displayed in the frame.251
  4. If you use an asterisk to take whatever space is left for the unspecified frames, as in _D__, the first and third rows each would be 37.5 percent of the total screen size.263
    a. rows="*,75,*" c. rows="*,33,*"
    b. rows="*,37.5,*" d. rows="*,25,*"
  5. When a hotspot on a server-side image map is clicked, additional software is run that is stored on ____a web server___?201

Dreamweaver:

  1. Before you create a table, you should sketch a plan for it that shows its location on the Web page and the placement of text and graphics in its cells.
  2. Using hidden fields in Web forms makes it possible to provide information to the Web server and form processing script without the viewer knowing that the information is being sent.
  3. When inserting Flash Text, the Target should be set to _top to display the destination page in the whole browser window.4-17
  4. __C__ is an example of a root-relative path. 4-5
    a. http://www.yahoo.com/recreation
    b. assets/heroin.gif
    c. /striped_umbrella/activities.html
    d. spa.html
  5. When entering data in a table, you should press SHIFT + TAB to move the insertion point to the previous cell in a row. 5-20

Flash 1:

  1. The _sync_ option, provided by the Property inspector when creating motion-tweened animations, ensures that the object loops properly.
  2. The __transformation point_ is also the point that snaps to a motion guide.
  3. What are the steps involved in using a motion guide to create an animation?
    1. Create a motion-tweened animation.
    2. Select the layer the animation is on and insert a motion guide layer. The selected layer is indented below the motion guide layer. This indicates that the selected layer is associated with the motion guide layer.
    3. Draw a path using the Pen, Pencil, Line, Circle, Rectangle, or Brush tools.
    4. Attach the object to the path by dragging the object by its registration point to the beginning of the path in the first frame, and to the end of the path in the last frame.
  4. List five guidelines for optimizing movies.
    1. Use symbols and instances for every element that appears in a movie more than once.
    2. When possible, use tweened animations rather than frame-by-frame animations.
    3. For animation sequences, use movie clips rather than graphic symbols.
    4. Confine the area of change to a keyframe so that the action takes place in as small an area as possible.
    5. Use bitmap graphics as static elements rather than in animations.
    6. Group elements, such as related images.
    7. Limit the number of fonts and font styles.
    8. Use gradients and alpha transparencies sparingly.
  5. The _angular_ option, on the Property inspector for a shape tween, preserves the corners and straight lines and works only with objects that have these features.

Game Flash:

Your quiz will be a basic game creation so there are no quiz questions.

Alice 2.0:

  1. A bounding box is _a rectangular outline of a three dimentional space filled by an object_.
  2. A selection sequence is also known as a(n) _branching routine_.
  3. In the __Debug_ phase of the software development life cycle, each methods design and coding are corrected.
  4. _Linear sequences_ should have a clear starting and ending point.
  5. Every loop is either a count-controlled loop or a(n) _sentinel_ loop that is not count controlled.

A+ PC Repair

  1. If you get an error message about a missing DLL, the easiest way to solve this problem might be to reinstall the application.
  2. Why would you use a round PATA ribbon cable instead of traditional flat cable? round cables obstruct air flow less inside the case
  3. Which type of expansion slot uses a retention mechanism to help stabilize a heavy card? AGP
  4. Why might you disable quick booting features in BIOS when you are troubleshooting a problem? so you can see a full POST report
  5. Which of the following is an indication that an inadequate power supply is the source of an intermittent problem? a. the power supply whines when you first turn on the system

Java Programming

  1. When a method refers to an instance of an object with a variable, the variable is called a(n) ____________.
  2. Which of the following is an equality operator?
    a. !=
    b. =
    c. >=
    d. <=
  3. The access modifier, ____________________, indicates that the code can be accessed by all objects in the program and can be extended, or used, as a basis for another class.
  4. Adding the code, ____________________, to the end of the main() method header gives the program a way to acknowledge and handle potential input and output errors.
  5. In Java, the ____________________ is used to implement exponentiation.