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.

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
  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. How can you create an internal link to a named anchor in Dreamweaver? To create an internal link, you first select the text element or graphic object that you want to make a link, then you use the Browse for File icon next to the Link text box in the Property inspector to specify the relative path to the destination page.
  4. What is a hotspot? How can you create one? A hotspot is an area on a graphic that, when clicked, links to a different location on the page or to another Web page. For example, a map of the United States could have a hotspot placed on each state so that viewers could click a state to link to information about that state. To create a hotspot on an image, select the image on which you want to place the hotspot, then create the hotspot using one of the hotspot tools in the Property inspector.
  5. How can you format a table cell in Dreamweaver? Formatting a cell can include setting properties that visually enhance the cell appearance, such as setting a cell width, assigning a background color, or setting global alignment properties for the cell content. To format a cell, you need to either select the cell or place the insertion point inside the cell you want to format, then choose the cell formatting options you want in the Property inspector. For example, to choose a fill color for a selected cell, click the Background Color button in the Property inspector, then choose a color from the color picker. In order to format a cell, you must expand the Property inspector to display the cell formatting options.

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. At the end of the boot record is a small program, called the _bootstrap loader_ which can be used to boot from the disk.169
  2. To share a network printer using Windows, a Windows component called _Client for Microsoft Networks_ must be installed on the remote computer using the printer. 287
  3. A(n) ____file allocation unit______ is the minimum unit the operating system uses to store information.169
  4. A(n) _____INPUT DEVICE______ is any hardware component that allows users to enter data or instructions.222
  5. Because ECP requires a __DMA___ channel, using it can cause resource conflicts.224

Java Programming

  1. When a method refers to an instance of an object with a variable, the variable is called a(n) ___reference variable__.
  2. Which of the following is an equality operator? A
    a. !=
    b. =
    c. >=
    d. <=
  3. The access modifier, ___public____, 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, _throws IOException_, 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 __pow() method__ is used to implement exponentiation.