CS111 Final
Give the 4-bit binary equivalent for the following decimal number: 2
0010
Give the 8-bit binary equivalent for the following decimal number: 127
0111 1111
Give the 4-bit binary equivalent for the following decimal number: 11
1011
Give the 4-bit binary equivalent for the following decimal number: 12
1100
Give the 8-bit binary equivalent for the following decimal number: 225
1111 1111
Give the decimal equivalent for the following 4-bit binary number: 1110
14
Give the decimal equivalent for the following 8-bit binary number: 1100 0100
196
Give the decimal equivalent for the following 8-bit binary number: 1111 1111
255
Give the decimal equivalent for the following 4-bit binary number: 0100
4
What is the output message produced in the alert box by the code alert(3 + 3)
6
Give the decimal equivalent for the following 4-bit binary number: 1001
9
In programming, "true" and "false" are called _________ values.
Boolean
A Value (as it applies to Excel) a. is a number that represents a quantity and can be the basis of calculations. b. includes letters, numbers, and spaces. c. is a combination of cell references, operators, values, and/or functions used to perform calculations. d. controls the sequence in which Excel performs arithmetic operations.
a
A function is a a. predefined formula that performs a calculation. b. activity performed by a worksheet. c. defined purpose for a set of cells or a group of formulas. d. set of rules that govern the structure and components for a formula.
a
A letter with an accent mark, for example, ñ, is displayed using the: a. escape symbol b. accent symbol c. special symbol d. mark symbol
a
A mixed cell reference a. contains both an absolute and a relative cell reference. b. contains neither absolute nor relative cell references. c. occurs when a formula directly or indirectly refers to the cell containing the formula. d. contains cells that are incorrectly related.
a
A nanosecond is: a. 1/1,000,000,000th of a second b. 1/1,000th of a second c. 1/1,000,000th of a second d. 1/100th of a second
a
A nonadjacent range a. contains two or more cells or ranges that are not touching each other. b. will be automatically corrected by the Compact and Repair command. c. is on a separate worksheet. d. is selected with the "Ctrl + Alt + Delete" key combination.
a
A related group of networked computers forms a: a. domain b. broadband c. DNS d. server
a
A way in which product developers who create technologies minimize learning time is by creating controls that match our expectations, such as with sliders and dials. a. True b. False
a
ARM, which stands for Advanced RISC Machine, is a standard computer that is often embedded in other kinds of chips or is a component of consumer devices. a. True b. False
a
An Input Area (as it applies to Excel 2010) is defined as a. is a range of cells containing values for variables used in formulas. b. displays the name of a worksheet within a workbook. c. is a range of cells containing results based on the output area. d. displays the content of the active cell.
a
Applications, especially from the same vendor (e.g., Microsoft, Google, or Apple), are consistent. a. True b. FalseApplications, especially from the same vendor (e.g., Microsoft, Google, or Apple), are consistent.the
a
Because the Xerox's Alto was targeted at businesses, the metaphor the PARC researchers chose for the GUI was a desktop. a. True b. False
a
Before a packet reaches its destination, it usually will visit a sequence of computers. The steps it takes from one to the next are called: a. hops b. skips c. jumps d. vaults
a
By selecting the ________ option, you can make sure that data entered into the foreign key field of one table matcheѕ existing data in the primary key field of a related table. a. referential integrity b. required field c. common field d. key match
a
Communication between one sender and many receivers is called: a. broadcast communication b. client/server communication c. multicast communication d. point-to-point communication
a
Computing in its most general form involves data, software, and hardware. a. True b. False
a
Feedback is an indication that either the computer is still working or it is done. a. True b. False
a
In Excel, which cell becomes active when you press the "Enter" key? a. The next cell down b. The next cell to the right c. The cell at the end of the current row d. The cell at the bottom of the next column
a
In a directory hierarchy in a Web address, folder names are separated by a: a. slash (/) b. backslash (\) c. dot (.) d. space
a
In computing, data and information are interchangeable. a. True b. False
a
In computing, data is stored in memory, on the hard disk, or in the cloud represented as binary digits. a. True b. False
a
In relation to Copy/Paste/Edit, which of the following terms refers to information before it is transformed or edited to a new form? a. source value b. original value c. final value d. target value
a
In software, a program that stops operating to avoid harm is called: a. fail-safe b. fault-tolerant c. bug-safe d. fail-soft
a
In the Fetch/Execute Cycle, the action of performing a machine instruction occurs during the: a. Instruction Execute (EX) step b. Instruction Fetch (IF) step c. Data Fetch (DF) step d. Instruction Decode (ID) step
a
Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow? a. Irene should include the primary key in the customer information table as a foreign key in the order information table. b. Irene should include the foreign key in the customer information table as a primary key in the order information table. c. Irene cannot establish a relationship between the two tables. d. Irene should include the primary key in the customer information table as a primary key in the order information table.
a
It took approximately 3 years to finish building the ENIAC. a. True b. False
a
Logical operators can be combined and grouped using: a. parentheses b. square brackets c. plus and minus d. curly brackets
a
Many desktop applications, regardless of vendor, share basic features, such as a File menu and an Edit menu, and furthermore, the items within these menus include the same operations. A. True B. False
a
Metaphors are essential to computer usage because they guide us in learning and using software. a. True b. False
a
One example of descriptive text is anchor text, which is: a. highlighted link text, specified inside <a...> tags, describing the page to which it links b. a phrase within <title> tags c. a textual description of a picture d. included within a <meta...> tag
a
Rebooting a computer means to: a. restart the computer b. run a program from the hard disk c. start the computer d. None of these
a
Software is a collective term for programs; the instructions computers perform to implement applications. a. True b. False
a
Spaces that have been inserted for readability are called: a. white space b. blanks c. tags d. embedded space
a
The Alto personal computer, created by the Xerox Palo Alto Research Center (PARC), was the first computer with a Graphic User Interface (GUI). a. True b. False
a
The Basic Input/Output System (BIOS) is stored on a microchip called the: a. Boot ROM b. flash memory package c. ARM processor d. kernel
a
The JavaScript code var x; is ________ the variable x. a. declaring b. identifying c. instantiating d. defining
a
The NATO broadcast alphabet: a. encodes letters as words b. is very efficient minimizing the amount of memory needed to store each letter c. makes it difficult to distinguish between different letters d. encodes all digits using unusual names
a
The PV is a. the present value of a loan. b. a set of vertical range names. c. the Percent of Value for a price discount. d. the opposite of a GV.
a
The Placeholder Technique is used to "hide" part of the text that you don't want to tamper with when using Find/ReplaceAll (F/RA). a. True b. False
a
The Table Array a. is a range containing a lookup table. b. is the argument in a VLOOKUP function that identifies from which column to return a value. c. calculates the periodic payment for a loan with a fixed interest rate and fixed term. d. looks up a value in a horizontal table where the first row contains the values to compare with the lookup value.
a
The ________ data type is used to hold long sentences or paragraphs of descriptive data. a. Memo b. OLE c. Hyperlink d. Text
a
The ________ group on the External Data Tab has options that you can use to send a portion of a database to other applications a. Export b. Save As c. Collect Data d. Import & Link
a
The ________ view in Access looks similar to an Excel Spreadsheet. a. Datasheet b. Form c. Report d. Design
a
The advantage of integration in creating integrated circuits is that: a. costs do not increase as wiring complexity increases b. more space between components prevents overheating c. paleolithography allows the chip to be constructed in a single layering process d. active and connective parts of a circuit are kept as separate components
a
The camera of a smart phone would be classified as an input device. a. True b. False
a
The gesture that is typically used to launch an application is a: a. double tap b. drag c. flick d. two-finger sweep
a
The query processor processes an AND query by: a. intersecting b. removing duplicates c. using a GUI d. crawling
a
The title that appears on the title bar of the browser is specified using: a. title tags b. html tags c. pagename tags d. body tags
a
This places information in order by using non-digit symbols. a. Collating Sequence b. PandA Representation c. Bytes d. All of these
a
To benefit from an automatic validation service that ensures a Web page works for all Web surfers, where should the additional lines of code be inserted in the HTML code? a. before the <html...> tag b. immediately following the <title> tags c. within the <body> tags d. at the end of the file
a
Using ROY G BIV to remember, in order, the colors of the rainbow as red, orange, yellow, green, blue, indigo, and violet is an example of a(n): a. mnemonic b. algorithm c. abstraction d. generalization
a
Using only 0s and 1s means the information can be perfectly: a. reproduced b. consistent c. converted to a placeholder d. turned into a desktop
a
When an operation is processing a series of inputs, the "completion count" gives the tally of the completed instances, or equivalently, the number remaining. a. True b False
a
When we install a new app, we should immediately and intuitively perform two important activities: "clicking around" and "blazing away." a. True b. False
a
Which of the following would be the best choice for a primary key? a. Social Security Number b. Street Address c. Last Name d. First Name
a
Which of the following would be used to display an ampersand on a Web page? a. & b. && c. <&> d. \&
a
Writing software is the job of programmers and software developers. a. True b. False
a
You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs? a. The pound signs are present because the column is not wide enough to display the data. b. The pound signs are present because the data type used on the cells is incorrect. c. The pound signs serve as a warning that the data in the cells contain an error. d. The pound signs are present because the value of the fields are null.
a
You can create or modify a table's field names and data types in ________ view.
a
You can have an HTML element, such as a paragraph, change its background color whenever the user moves the cursor on top of that element. One way to do this is to add a Javascript function to that element's __________ property. a. onmouseover b. hover c. cursor d. mouseon
a
You want to set the contents of a paragraph with id="p1". To do this with JavaScript, you change the blank section in the following code to what? document.getElementById("p1").________ = "hello" a. innerHTML b. INNERHTML c. InnerHtml d. innerhtml e. Any of the above
a
The JavaScript code x = 1; is called a(n) _______ statement.
assignment
The JavaScript code x = 1; is called a(n) ________ statement.
assignment
A Web page is made up of objects that contain other objects. A section can contain a paragraph, and that paragraph can contain an image. For any given web page, there is one object that contains all the other objects. This is the __________ object. a. page b. document c. body d. html
b
A family of styling specifications with a common name is called a: a. text document b. class c. HTML document d. tree
b
A field, or a combination of fields, that must have a unique value in a given table is a ________ for that table. a. foreign key b. primary key c. characteristic value d. identifier
b
A peripheral used by the computer for both input and output is the: a. printer b. hard disk c. mouse d. keyboard
b
A relational database is a collection of: a. fields. b. tables. c. values. d. records.
b
A sheet tab (as it applies to Excel 2010) a. identifies the address of the current cell. b. displays the name of a worksheet within a workbook. c. conceals the applicable formulas for the workbook. d. displays the content of the active cell.
b
A structure without any properties or content is: a. information b. an instance c. a shortcut d. a record
b
A weakness of Wikipedia is that: a. editing of content is highly restricted b. the content is not validated by experts c. it covers a limited number of topics d. it contains timely information
b
An expression used in queries to filter records in a table is called a(n): a. filter function. b. criterion. c. selector. d. selection key.
b
Blazing away is justified by the consistent interface, while clicking around is justified because running software can't break the computer. a. True b. False
b
DSL stands for: a. dialup service link b. digital subscriber line c. direct service link d. digital subscriber link
b
Data from two or more tables can be connected by specifying a: a. query form. b. common field. c. primary key. d. hyperlink.
b
Dianna wants to compact an Access database. She can find the tool to compact the database by clicking on the ________ tab. a. Home b. File c. Create d. External
b
Digitizing sound: a. requires lossless compression techniques b. uses bits to represent both positive and negative values c. is always more accurate than recording with an analog device d. achieves perfection using an unlimited number of bits
b
Due to its affordability, Xerox manufactured mass quantities of the Alto personal computer for businesses. a. True b. False
b
Getting files from a Web server is called: a. uploading b. downloading c. multicasting d. client-based networking
b
How many bits does each hex digit require? a. 2 b. 4 c. 16 d. Hex is not measured in bits.
b
Identify a method used to find authoritative information. a. Obtain the information needed from Wikipedia. b. Choose information from respected organizations. c. Choose reports from tertiary sources. d. Seek a single online source.
b
In a client/server structure, there: a. is a dedicated connection b. are transmissions to complete a request c. is a one-to-many connection d. is a broadcast connection
b
In a query, which of the following statements is true regarding delimiters in the criterion of a field? a. Number data types must be enclosed in single quotes b. Number data types require no delimiters c. Date/Time data types must be enclosed in quotations d. Text data types must be enclosed in pound signs
b
In a search engine, the index is built by the: a. query processor b. crawler c. indexer d. linker
b
In software, a program that continues to operate but with possibly degraded functionality is called: a. bug-safe b. fail-soft c. fault-tolerant d. fail-safe
b
Instruction sequences that repeat are called: a. sorting b. loops c. assumptions d. tests
b
Irene is working in a database that organizes city court case information. Irene must find court cases in either one of two cities. Irene should use the Filter by Form ________ condition. a. EITHER b. OR c. BOTH d. AND
b
Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is: a. Number b. OLE c. Memo d. Text
b
Most of the information today is delivered by Libraries. a. True b. False
b
On the computer, one billion clock ticks per second is called one: a. megahertz b. gigahertz c. nanohertz d. terahertz
b
Perfect reproduction is a property of analog information. a. True b. False
b
Placeholders can be inserted throughout your work for all long, commonly occurring phrases, and the placeholders can later be changed easily using: a. metaphors b. Find/ReplaceAll (F/RA) c. Copy/Paste/Edit (C/P/E) d. Copy/Paste (C/P)
b
Relying on 0s and 1s in representing digital information results in a great disadvantage in creating reproductions. a. True b. False
b
Something can't be considered a computer unless it has a keyboard attached to it. a. True b. False
b
The Formula Bar (as it applies to Excel 2010) a. displays the name of a worksheet within a workbook. b. displays the content of the active cell. c. identifies the address of the current cell. d. is at the intersection of a column and a row.
b
The JavaScript code var x=1; is ________ the variable x. a. setting b. initializing c. evaluating d. assigning
b
The PandA system: a. contains gray b. is binary c. has 10 digits d. is formed from 256 letter representations
b
The computer first digitized the census data in 1980. a. True b. False
b
The fill handle (as it applies to Excel 2010) a. performs the same action as pressing "enter." b. is a small black square at the bottom-right corner of a cell that facilitates fill operations. c. copies the contents of one worksheet to another. d. is a quick way to copy a format from one range to another.
b
The maximum size of the Text data type is ________ characters. a. 25 b. 255 c. 50 d. 200
b
The order of precedence (as it applies to math operations in Excel) a. controls which rows and columns are processed first. b. controls the sequence in which Excel performs arithmetic operations. c. determines which worksheet will be displayed when Excel is opened. d. determines which cells will have their formulas evaluated first.
b
The original version of ASCII used: a. 4-bit code b. 7-bit code c. 8-bit code d. 16-bit code
b
The value in a field with the ________ data type will be automatically increased each time a new record is entered. a. Currency b. AutoNumber c. Number d. Date/Time
b
The very last part of a URL is the: a. protocol b. pathname c. domain d. server computer's name
b
Transistors helped advance computing because they complicated the assembly process. a. True b. False
b
When a URL ends in a folder name instead of a file name, many servers will automatically look for a file called: a. dir.html b. index.html c. home d. Any of these
b
When determining the page layout, CSS considers every HTML5 element to be enclosed in a: a. page b. box c. body d. folder
b
When the completion time of a computer operation can be predicted, applications typically show an hourglass icon. a. True b. False
b
Which field property type should be applied to fields that should not remain empty? a. Special b. Required c. Indexed d. Format
b
Which of the following is an example of definiteness? a. Add and multiply values A, B, and C to obtain the result. b. Add A and B. Divide the sum by C. If C = 0, the solution is "undefined." c. Use multiplication and addition operations to solve the problem. d. All of these
b
A DHCP (Dynamic Host Computer Protocol): a. makes sure a computer gets the same IP every time it connects to the network b. lets the computer select its own IP when it connects to the network c. assigns an IP address to the computer from a list of possible addresses d. maintains a LAN's connection to the Internet
c
A cell address (as it applies to Excel 2010) a. searches for and displays similar labels as you type. b. is a number that represents a quantity and can be the basis of calculations. c. identifies a cell by a column letter and a row number. d. identifies the electronic "neighborhood" of a spreadsheet.
c
A circular reference a. is an input such as a cell reference or a value needed to complete a function. b. is a rule that governs the structure and components for functions. c. occurs when a formula directly or indirectly refers to the cell containing the formula. d. ties the last cell in a row or column to the first cell in that same row or column.
c
A digitization guideline stating that the sampling frequency should exceed the signal frequency by at least two times is the: a. Analog-Digital rule b. Sample Rate rule c. Nyquist rule d. Leibniz rule
c
A function Screen Tip a. automatically inserts functions such as SUM (B4:C4). b. estimates the value of a function when you type it in. c. is a small pop-up description that displays the arguments for a function as you enter it. d. automatically inserts formulas such as =B4+C4.
c
A heuristic process: a. is guaranteed to work 100 percent of the time b. yields the specified answer or reports back that no such answer exists c. provides guidelines for finding a solution d. All of these
c
A relative cell reference a. indicates a cell's specific location and the reference does not change when you copy the formula. b. occurs when a formula directly or indirectly refers to the cell containing the formula. c. indicates a cells relative location from the cell containing the formula; the reference changes when you copy the formula. d. contains an absolute and a relative cell reference as part of the formula.
c
A search engine consists partly of a: a. link and a crawler b. snoop and a bull's-eye c. crawler and a query processor d. spider and a web
c
A worksheet is defined as a. the background color of a cell. b. an unfinished project. c. a single spreadsheet that often contains formulas, functions, values, text, and visual aids. d. the current cell location of the insertion point as indicated by a dark border.
c
A(n) ________ is a question you ask about data stored in a database. a. search function b. view c. query d. data expression
c
A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query criterion to limit the results produced by the query. a. wildcard b. conditional c. comparison d. delimiter
c
An Argument (as it applies to Excel 2010) a. displays a list of functions and defined names as you enter a function. b. calculates the total of values contained in two or more cells. c. is an input such as a cell reference or a value needed to complete a function. d. is a small pop-up description that displays the results of the cell.
c
An Output Area (as it applies to Excel 2010) a. displays the content of the active cell. b. displays the name of a worksheet within a workbook. c. is a range of cells containing results based upon manipulation of the variables in the input area. d. is a range of cells containing values for variables used in formulas.
c
AutoComplete (as it applies to Excel) a. adds all the numbers in the columns automatically. b. is a number that represents a quantity and can be the basis of calculations. c. searches for and displays any other similar label in the current column as you begin to type. d. adds all the numbers in the row automatically.
c
Booting a computer means to: a. restart the computer b. run a program from the hard disk c. start the computer d. None of these
c
Haptic devices: a. rapidly display still images as a way to fool our eyes and brain b. are used to keep out "spambots" c. are input/output technology for interacting with our sense of touch and feel d. Use a combination of half audio and half video signals
c
How are hardware failures generally resolved? a. by testing using the specification b. buying only hardware that does not break c. using techniques such as redundancy d. employing a staff for 24 hour support
c
In Access, a criterion used in a query to specify a blank field is: a. Empty b. Invalid c. Null d. Void
c
In JavaScript, the statement terminator is a(n) ________. a. colon (:) b. comma (,) c. semi-colon (;) d. period (.)
c
Referential integrity should be enforced in a database with related tables becausa. makes the database easier to repair. b. helps link data to an outside application. c. helps ensure invalid data is not entered into a table. d. makes the database easier to back up
c
Searching for "baseball" AND ("stadiums" OR "parks") AND NOT "national parks" would look for: a. baseball and stadiums and parks, not national parks b. baseball or stadiums or parks, not national parks c. baseball stadiums or baseball parks and would omit national parks d. None of these
c
The New and Open commands are normally located on the: a. Edit menu b. Main menu c. File menu d. Shortcut menu
c
The PMT function a. tells whether an expression is a Permissible Mathematical Term in a certain context. b. returns the mean time between events being processed. c. calculates the periodic payment for a loan with a fixed interest rate and fixed term. d. returns the total number of payment periods for a loan or savings plan.
c
The ________ is a special character that is used to represent one or more characters in the criterion of a query. a. operand b. delimiter c. wildcard d. operator
c
The ________ tab holds all of the operations necessary to carry out data import and export. a. Home b. Database Tools c. External Data d. File
c
The active cell (as it applies to Excel 2010) a. is where all the formulas of the workbook do the math. b. is the cell that always holds the current date. c. is the location of the insertion point as indicated by a dark border. d. is where all the functions of the database perform the calculations
c
The logical test a. contains data for the basis of the lookup and data to be retrieved. b. gives a popup hint that your formula may not make any sense c. checks whether an expression evaluates to true or to false. d. checks the syntax of an expression
c
To create a Web page with along with a description of their purpose, it would be best to use: a. an ordered list b. an unnumbered list c. a definitional list d. a table
c
What is the first step of debugging? a. Check "obvious" error sources. b. Isolate the problem. c. Check that the error is reproducible. d. Generate a theory to explain the problem.
c
Which GUI metaphor features file cabinets and wastebaskets as typical components? a. touch metaphor b. office metaphor c. desktop metaphor d. Windows metaphor
c
Which of the following is an effective technique in using the hit list? a. Check every hit by opening the link. b. Randomly select the links to open. c. Skim top-level information and decide which links to explore further. d. Follow the target until you establish a pattern
c
Which of the following represents the correct order, from largest to smallest? a. LAN, WWW, Internet b. WWW, Internet, LAN c. Internet, WWW, LAN d. Internet, LAN, WWW
c
Which of the following statements best describes a one-to-many relationship between two tables? a. A primary key in the first table matches exactly one foreign key in the second table. b. A foreign key in the first table matches several primary keys in the second table. c. A primary key in the first table matches several foreign keys in the second table. d. Primary and foreign keys have multiple cross matches between a first and second table.
c
Which of the following will display the rocket.jpg file on the page if the image is stored in the same folder as the page? a. <img "rocket.jpg"/> b. <img src rocket.jpg/> c. <img src= "rocket.jpg" /> d. <img src "rocket.jpg"/>
c
You can use ________ to create a relationship between two tables that have a common field. a. link queries b. relational criteria c. join lines d. referential integrity
c
www.cs.washington.edu is a(n) a. pathname b. protocol c. domain d. email address
c
A Formula (as it applies to Excel 2010) is a. should be used in each column of a workbook. b. a number that represents a quantity and can be the basis of calculations. c. a built in function that returns a value d. a combination of cell references, operators, values, and/or functions used to perform calculations.
d
A cell (as it applies to Excel 2010) a. cannot be used for labels or headings. b. must have text entered into it. c. must have formulas entered into it. d. is the intersection of a column and a row.
d
A kind of software that translates a programming language into machine instructions is a(n): a. algorithm b. driver c. browser d. compiler
d
A(n) ________ field is used to produce a value from an expression or function. a. AutoNumber b. expression c. production d. calculated
d
Access differs from other Microsoft software because it: a. size of the data you can work with. b. number of people that can view the file at one time. c. type of formatting you can perform. d. number of undo's you can perform.
d
An absolute cell reference a. occurs when a formula directly or indirectly refers to the cell containing the formula. b. can occur only once in a formula. c. contains the address of a relative cell reference. d. indicates a cell's specific location and the reference does not change when you copy the formula.
d
Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed? a. Both the birthday and age fields should be calculated fields. b. Both the birthday and age fields should be stored fields. c. The birthday should be a calculated field and the age should be a stored field. d. The birthday should be a stored field and the age should be a calculated field.
d
Different algorithms for the same problem can: a. solve the same problem differently b. take different amounts of processing time c. mean that one algorithm is preferred over others d. All of these
d
Digitized sound can be: a. "fixed" by removing offending noises b. computed to reduce the number bits c. reproduced exactly d. All of these
d
Extended ASCII code: a. was developed in the United States b. was adopted by IBM as the standard for character representation c. is now known as ISO-8859-1 d. All of these
d
In Excel, semi-selection or pointing a. is used to select just part of a cell's contents. b. indicates a cells relative location from the cell containing the formula. c. indicates a cell's specific location and the reference does not change when you copy the formula. d. is the process of using the mouse to select cells while building a formula.
d
Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is: a. Text b. Memo c. Number d. AutoNumber
d
Ribbon Commands with arrows indicate a. that you should hit "Enter" on the keyboard. b. a link to another worksheet. c. the next step in the process. d. there are two or more sub-commands related to the command.
d
The HTML tag for bold text is: a. <i></i> b. <bld></bld> c. <bb></bb> d. <b></b>
d
The NPER a. is a "Not Permitted" Error b. is the number of possible arguments in a function c. is a "Number Past Expected Result" Error. d. is the total number of payment periods.
d
The Name Box (as it applies to Excel 2010) a. displays the name of a worksheet within a workbook. b. displays the content of the active cell. c. is located at the intersection of a column and a row. d. identifies the address of the current cell.
d
The VLOOKUP function. a. references a cell located a given distance up or down in the current column. b. vertically aligns a cell according to a given style. c. returns the value of a given variable. d. looks up a value and returns a related result from the lookup table.
d
The ______ function displays the current date. a. calendar b. date c. currentDate d. today
d
The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field. a. Input Mask b. Default Value c. Caption d. Format
d
The ________ organizes and lists the database objects in an Access database. a. Form Wizard b. Database Tools tab c. Object View panel d. Navigation Pane
d
The ________ tab contains all the tools necessary for producing tables, forms, and queries in Access. a. Database Tools b. External Data c. Home d. Create
d
The data type "Text" (as it applies to Excel) a. is of little concern to Excel because Excel does calculations on numbers. b. should be entered into every cell of the spreadsheet. c. includes formulas, functions, and formatting. d. includes letters, numbers, and spaces not used in calculations.
d
The gesture described as a quick sweep with the finger leaving the surface is known as a: a. drag b. sweep or swipe c. tap d. flick
d
The hardware implementation of the Fetch/Execute Cycle is the: a. input/output (I/O) ports b. peripherals c. RAM d. control unit
d
The mouse was invented by: a. Steve Jobs and Steve Wozniak at Apple b. Aung San Suu Kyi in Burma c. Bill Gates at Microsoft d. Douglas Engelbart and others at Stanford Research Institute
d
The next instruction in a Fetch/Execute cycle on a 32-bit system is usually at the memory address: a. PC*4 b. PC c. PC-2 d. PC + 4
d
The placeholder technique: a. involves a triple substitution using find-and-replace b. uses a unique token as the placeholder c. requires the use of # d. Both "involves a triple substitution using find-and-replace" and also "uses a unique token as the placeholder" are correct
d
The preferred way to specify a break that continues the text on the next line in a Web page is: a. <br></br> b. <linebreak> c. by pressing the 'enter' key d. <br />
d
The result of a query, which appears similar to a table, is called a: a. datasheet. b. report. c. form. d. recordset.
d
To adjust the column width and/or row height of many cells at once a. just type longer or taller formulas in some of them. b. drag the fill handle across the cells. c. type the address of the first and last cells in the "Go To" dialog box. d. click and drag across the cells to select them and use any sizing method you choose.
d
To assist with HTML debugging, errors discovered by FireFox while rendering a page can be listed by going to the: a. Diagnostic Analyzer b. HTML Debugger c. HTML Compiler d. Error Console
d
To put a long text label on two or more lines within a single cell a. insert a text box using F4. b. type the second line then use the Backspace key. c. type the first line, then hit "Enter." d. insert a line break with the "Alt + Enter" key combination.
d
Using even parity, the byte of data "1010 0011" would: a. use a ninth bit to determine exactly which bit was changed if an error occurred b. include a ninth bit set to 1 c. not make use of a ninth bit d. include a ninth bit set to 0
d
What does ASCII stand for? a. Algorithmic Sequence of Computer Integrated Information b. All Standards Complete Initialization Interface c. Aspiring Students Confused by Incoherent Incantations d. American Standard Code for Information Interchange
d
What type of information comes from experts? a. information found in a library b. information found in Google's Advanced Search c. information on the Web d. authoritative information
d
When choosing between Access and Excel, it is best to use Access in all of the following circumstances EXCEPT when: a. you are managing a large quantity of data. b. you require multiple tables to manage data. c. multiple users need to work with data simultaneously. d. you need to create complex charts or graphs.
d
Which of the following is NOT an example of an Access object? a. Form b. Query c. Table d. Filter
d
Which of the following is an example of the computer providing feedback to the user? a. Editing changes become visible on the screen. b. The cursor changes to indicate an operation is in progress. c. A progress bar shows how much of the work is done. d. All of these
d
Which of the following is not controlled by the operating system? a. Internet connection management b. memory management c. I/O devices management d. high-level language conversion to binary
d
Which of the following lacks finiteness? a. Bake for 50 minutes at 375 degrees. b. Read Chapter 10. c. Repeat until you get to the end of the file. d. Find pi.
d
Which search technique will help avoid over constraining? a. Include a general topic term. b. Remove terms from the search using NOT. c. Add as many descriptive words as possible. d. Begin with an inclusive search and add more words one at a time.
d
With JavaScript, you can produce a popup window with a a short message by calling the ________ method. a. popup() b. message() c. window() d. alert()
d
A string of length zero ( "" ) is called the _______ string.
empty
How many digits are there in the hexadecimal system? a. 2 b. 4 c. 10 d. 12 e. 15 f. 16
f
In JavaScript, and other programming languages, a group of letters enclosed in double quotes is known as a string ____________.
literal
In the expression 2 + 2 the plus sign is called a(n) _________ (one word)
operator
In JavaScript, HMTL and CSS you can make a mistake just by putting a semi-colon instead of a colon, or a comma instead of a period. Such a mistake is known as a _______ error.
syntax
You can run JavaScript code when a user clicks a button. If you want that code to refer to the button itself, you have to include a reference to that button when you call the code. You do this by using a special JavaScript keyword. For example, you would use it in place of the blank in the following code to change the position of the button. What is that word? <button onclick="scoot(__________)">Click Me.</button>
this