a) doesn't exist
b) points to the next instruction to be carried out
c) performs arithmetic
d) is also called long term storage
2) A good analogy for sequential access memory is:
a) a scroll
b) a book
c) a chair
d) all of the above
3) An example of an input device is:
a) the monitor
b) the printer
c) the microphone
d) the speakers
4) In HTML, a tag is surrounded by
a) ( )
b) {}
c) <>
d) [ ]
5) A collection of four bits is called a:
a) byte
b) nibble
c) bit
d) frit
1) Run length encoding is an example of
a) lossless compression
b) lossy compression
c) vector graphics
d) a Phishing scam
2) Vector graphics
a) use lines, polygons, etc. to describe images
rather than a bitmap
b) is usually much smaller than raster graphics
c) in certain contexts, are much smoother than raster graphics
d) all of the above
3) A domain name server
a) is another name for "the Internet"
b) is a phone book, giving IP addresses for domain names
c) is a person from whom you buy your domain name
d) is the text between the :// and the first slash
4) The folder on the cs12 machine in which to put all of
your web files is called:
a) Public.HTML
b) Web.Files
c) public_html
d) public html
5) $A$1 is an example of:
a) a relative reference
b) an absolute reference
c) a mixed reference
d) an R1C1 reference
6) If I used my method for solving the traveling sales problem,
for 100 cities, I would calculate the solution is about
a) 1 minute
b) 1 day
c) 1 week
d) 1 year
e) more than 1 trillion years
7) To get the largest number of a bunch of numbers, I would use
a) BIGGEST
b) LARGEST
c) MAX
d) MIN
8) If I put one IF inside another IF, it is called
a) fluffing
b) iffing
c) nesting
d) resting
9) The HTML tag to include an image is
a) IMAGE
b) PIC
c) IMG
d) OMG
10) The 20Q game, which asks questions and then guesses
what you are thinking of, might use:
a) optical character recognition
b) HTML
c) a decision tree
d) a Huffman tree
a) lossless compression
b) lossy compression
c) vector graphics
d) a Phishing scam
2) Vector graphics
a) use lines, polygons, etc. to describe images
rather than a bitmap
b) is usually much smaller than raster graphics
c) in certain contexts, are much smoother than raster graphics
d) all of the above
3) A domain name server
a) is another name for "the Internet"
b) is a phone book, giving IP addresses for domain names
c) is a person from whom you buy your domain name
d) is the text between the :// and the first slash
4) The folder on the cs12 machine in which to put all of
your web files is called:
a) Public.HTML
b) Web.Files
c) public_html
d) public html
5) $A$1 is an example of:
a) a relative reference
b) an absolute reference
c) a mixed reference
d) an R1C1 reference
6) If I used my method for solving the traveling sales problem,
for 100 cities, I would calculate the solution is about
a) 1 minute
b) 1 day
c) 1 week
d) 1 year
e) more than 1 trillion years
7) To get the largest number of a bunch of numbers, I would use
a) BIGGEST
b) LARGEST
c) MAX
d) MIN
8) If I put one IF inside another IF, it is called
a) fluffing
b) iffing
c) nesting
d) resting
9) The HTML tag to include an image is
a) IMAGE
b) PIC
c) IMG
d) OMG
10) The 20Q game, which asks questions and then guesses
what you are thinking of, might use:
a) optical character recognition
b) HTML
c) a decision tree
d) a Huffman tree
1) If you wanted to maximize profits by
modifying a series of cells, you could use:
a) Goal Seek
b) Optimizer
c) Maximizer
d) Solver
2) An example of a constraint
is ______that a cell must contain a positive number_
It is useful for ___restricting solutions for Solver__.
3) The developer tab in Excel
a) contains the record macro button
b) is by default not visible
c) A and B
d) None of the above
4) VBA can be used to:
a) write UDFs in Excel
b) write macros in Excel
c) extend the functionality of Excel
d) all of the above
5) The R1C1 reference R[2]C[-3]
refers to ___a cell two rows down and three columns to the left__
6) If I have an APR and want to pass it
into an Excel Financial Function,
where the compounding occurs monthly,
what would I have to do to that rate?
a) nothing; leave it alone
b) multiply it by 12
c) divide it by 12
d) subtract 1 from it
7) In VLOOKUP, the table
is most often ____________
and the lookup value
is most often ______________.
a) absolute, absolute
b) relative, relative
c) absolute, relative
d) relative, absolute
8) In financial functions, a deposit
made by you into the bank
would be encoded as:
a) a negative value
b) a positive value
c) zero
d) none of the above
9) The int constraint:
a) restricts values to be whole numbers
b) restricts values to be bigger than zero
c) restricts values to be smaller than zero
d) does nothing, since there *is* no int constraint
10) The financial function to find the number of payments
one must make on a loan is called:
a) PV
b) FV
c) NUMPAYMENTS
d) NPER
modifying a series of cells, you could use:
a) Goal Seek
b) Optimizer
c) Maximizer
d) Solver
2) An example of a constraint
is ______that a cell must contain a positive number_
It is useful for ___restricting solutions for Solver__.
3) The developer tab in Excel
a) contains the record macro button
b) is by default not visible
c) A and B
d) None of the above
4) VBA can be used to:
a) write UDFs in Excel
b) write macros in Excel
c) extend the functionality of Excel
d) all of the above
5) The R1C1 reference R[2]C[-3]
refers to ___a cell two rows down and three columns to the left__
6) If I have an APR and want to pass it
into an Excel Financial Function,
where the compounding occurs monthly,
what would I have to do to that rate?
a) nothing; leave it alone
b) multiply it by 12
c) divide it by 12
d) subtract 1 from it
7) In VLOOKUP, the table
is most often ____________
and the lookup value
is most often ______________.
a) absolute, absolute
b) relative, relative
c) absolute, relative
d) relative, absolute
8) In financial functions, a deposit
made by you into the bank
would be encoded as:
a) a negative value
b) a positive value
c) zero
d) none of the above
9) The int constraint:
a) restricts values to be whole numbers
b) restricts values to be bigger than zero
c) restricts values to be smaller than zero
d) does nothing, since there *is* no int constraint
10) The financial function to find the number of payments
one must make on a loan is called:
a) PV
b) FV
c) NUMPAYMENTS
d) NPER
1) In order to separate the markup for meaning
from the formatting in HTML, we should use:
a) CSS
b) JavaScript
c) ECMAScript
d) cookies
2) An example of client-side scripting, which is sent
by the webserver to the browser and then runs
in the browser, is:
a) CSS
b) JavaScript
c) PHP
d) HTML
3) An example of server-side scripting, which runs
on the webserver but whose results are sent to
the browser, is:
a) CSS
b) JavaScript
c) PHP
d) HTML
4) A SELECT query may have:
a) a WHERE clause
b) an ORDER BY clause
c) a GROUP BY clause
d) all of the above
5) The Cartesian product of two tables will be:
a) nothing
b) the sum of: every number of the first table multiplied by
every corresponding number on the second table.
c) Every record of the first table, paired with every
record of the second table.
d) Every field that the two tables share in common.
6) A record corresponds, roughly, to a _________ in Excel
a) row
b) column
c) cell
d) formula
7) In an Access query, the wildcard ? will match:
a) any text whatsoever
b) any text whatsoever, including nothing
c) one character
d) only capital letters
8) A field which uniquely identifies a record is called a:
a) foreign key
b) primary key
c) relationship
d) index
9) We can use a foreign key to:
a) lock a database
b) lock a table
c) unlock a record from another table
d) match up information from one table to another table,
by finding the corresponding primary key
10) We can generate a report, a form, and a query, via a:
a) wizard
b) warlock
c) witch
d) sorcerer
from the formatting in HTML, we should use:
a) CSS
b) JavaScript
c) ECMAScript
d) cookies
2) An example of client-side scripting, which is sent
by the webserver to the browser and then runs
in the browser, is:
a) CSS
b) JavaScript
c) PHP
d) HTML
3) An example of server-side scripting, which runs
on the webserver but whose results are sent to
the browser, is:
a) CSS
b) JavaScript
c) PHP
d) HTML
4) A SELECT query may have:
a) a WHERE clause
b) an ORDER BY clause
c) a GROUP BY clause
d) all of the above
5) The Cartesian product of two tables will be:
a) nothing
b) the sum of: every number of the first table multiplied by
every corresponding number on the second table.
c) Every record of the first table, paired with every
record of the second table.
d) Every field that the two tables share in common.
6) A record corresponds, roughly, to a _________ in Excel
a) row
b) column
c) cell
d) formula
7) In an Access query, the wildcard ? will match:
a) any text whatsoever
b) any text whatsoever, including nothing
c) one character
d) only capital letters
8) A field which uniquely identifies a record is called a:
a) foreign key
b) primary key
c) relationship
d) index
9) We can use a foreign key to:
a) lock a database
b) lock a table
c) unlock a record from another table
d) match up information from one table to another table,
by finding the corresponding primary key
10) We can generate a report, a form, and a query, via a:
a) wizard
b) warlock
c) witch
d) sorcerer
1) To change fields in some record, I would use a _____ query:
a) SELECT
b) CHANGE
c) MODIFY
d) UPDATE
2) To choose all records in the Books table, combined with information about the author from the author table, I would write:
a) Select * from Books, Author Where Books.Title = "Beginning Finnish"
b) Select * from Books, Author Where Books.AuthId = Author.AuthID
c) Select * from Books, Author Where Author="Waxman"
d) Select Title, Author from Books, Author Group By Title
3) An example of a calculated field would be:
a) =[Title] & [Author]
b) Books.Title
c) there is no such thing
d) the Expression Builder
4) A form-subform is:
a) a split form with the datasheet on the top and a columnar view of the same data on the bottom
b) usually columnar at the top and related fields from another table in a datasheet at the bottom.
c) A form that uses Sub-routines
d) nothing ... I made it up.
5) An Excel linked table is : __a table which sits in an Excel spreadsheet which you can run queries, etc., upon in Access________________
a) SELECT
b) CHANGE
c) MODIFY
d) UPDATE
2) To choose all records in the Books table, combined with information about the author from the author table, I would write:
a) Select * from Books, Author Where Books.Title = "Beginning Finnish"
b) Select * from Books, Author Where Books.AuthId = Author.AuthID
c) Select * from Books, Author Where Author="Waxman"
d) Select Title, Author from Books, Author Group By Title
3) An example of a calculated field would be:
a) =[Title] & [Author]
b) Books.Title
c) there is no such thing
d) the Expression Builder
4) A form-subform is:
a) a split form with the datasheet on the top and a columnar view of the same data on the bottom
b) usually columnar at the top and related fields from another table in a datasheet at the bottom.
c) A form that uses Sub-routines
d) nothing ... I made it up.
5) An Excel linked table is : __a table which sits in an Excel spreadsheet which you can run queries, etc., upon in Access________________
