Quiz 2 Prep

Office 1:

  1. When assigned to a cell, the _______ function returns a number that corresponds to the system date and time beginning with December 31, 1899. EX183
  2. The __________ preceding a formula is important because it alerts Excel that a formula or function is being entered and not text. EX91
  3. Formatting that appears only when the value in a cell meets specified conditions is called _____.EX118
  4. ____________________ 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. EX122
  5. When cell references are copied, each cell reference that Excel automatically adjusts for the new position is called a(n) __________.EX27

Office 2:

  1. The general form of the VLOOKUP function is ____.EX357
    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 ________________.EX418
  3. If the table contains no data, Excel sets the ____________________ of the cells in the first row to the default associated with the table quick style chosen when the table was created.EX347
  4. A format code can have as many as ____________________ sections.EX438
  5. A ____________________ reference is a formula that depends on its own value.EX456

Office 3:

  1. Some earlier versions of Excel use a language called ___________, rather than VBA, for their macros. EX 553
  2. What is the purpose of a message box? EX 562
  3. After a workbook has been reviewed by others, it usually is returned to the owner, who can then review those changes and _________. EX 742
  4. Worksheet backgrounds allow an image to be specified for use as a ____ behind the data in cells of a worksheet. EX 766
  5. Before distributing your workbook to others, consider _______________________ 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?263
    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 _________________________ sends the x- and y- coordinates to the Web server for the position of the link on the image map.201
  3. The _________________________ 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 ____, 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 __________________________?201

HTML5:

  1. The method for clearing browsing history varies among browsers but is commonly listed under ____________________. 108
  2. In a table that doesn’t use colspan or rowspan attributes, you can verify that each row includes content for every column by ensuring that each row contains ______________________________. 169
  3. You create anchors by assigning unique names to elements in your Web page using the HTML ____ attribute.112
  4. _________ works best for art that contains limited numbers of colors and areas with defined borders between areas. 130
  5. The CSS property of left can have a value in em, pixels, or percent of the ________________________. 190

Dreamweaver:

  1. Before you create a table, you should sketch a plan for it that shows its location on the Web page and the ____________________ of text and graphics in its cells.5-5
  2. Using ____________________ 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.6-21
  3. When inserting Flash Text, the Target should be set to _________ to display the destination page in the whole browser window.4-17
  4. ____ 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 ___________ to move the insertion point to the previous cell in a row. 5-20

Flash 1:

  1. The ____ option, provided by the Property inspector when creating motion-tweened animations, ensures that the object loops properly.4-15
  2. The ____________________ is also the point that snaps to a motion guide. 4-15
  3. What are the steps involved in using a motion guide to create an animation?4-14
  4. List five guidelines for optimizing movies.6-10
  5. The ____________________ option, on the Property inspector for a shape tween, preserves the corners and straight lines and works only with objects that have these features.5-5

Game Flash or Flash 2:

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

Alice 2.0:

  1. A bounding box is ____.74
  2. A selection sequence is also known as a(n) ____.139
  3. In the ____________________ phase of the software development life cycle, each methods design and coding are corrected.64
  4. ____________________ should have a clear starting and ending point.139
  5. Every loop is either a count-controlled loop or a(n) ____________________ loop that is not count controlled.163

A+ PC Repair

  1. If you get an error message about a missing DLL, the easiest way to solve this problem might be _________________________. 576
  2. Why would you use a round PATA ribbon cable instead of traditional flat cable? 233
  3. Which type of expansion slot uses a retention mechanism to help stabilize a heavy card? 353
  4. Why might you disable quick booting features in BIOS when you are troubleshooting a problem? 623
  5. Which of the following is an indication that an inadequate power supply is the source of an intermittent problem? 605
    a. the power supply whines when you first turn on the system
    b. you don’t see any indicator lights or fans spinning
    c. BIOS loses its date and time settings
    d. the system tries to boot from the wrong device

Java Programming

  1. Which of the following is not a comparison operator?154
    a. = c. ==
    b. <= d. >
  2. The ____ statement is an example of a selection structure. 233
  3. 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. 137
  4. A(n) ____________________ is a selection structure that is used to perform a single task when the condition in the statement is true. 233
  5. In Java, ____________________ is a constant that represents the presence of no data. 236

AP Computer Science

  1. Method names have the same _______________________ as other Java identifiers.174
  2. In the expression (p || q), if p is true, then _____________________ evaluate q. 205
  3. At the root (base) of Java’s class hierarchy is a class called _______________.163
  4. Consider the following code:

int idNum = 758;
double wage = 10.5;
printf(“The wage for employee %d is $%.2f per hour.”,
idNum, wage);

The output of the printf statement would be _____________________.253

  1. The JApplet method ____ can be used to locate and return the URL of the applet’s Web server. 294