Intro to Computer Science Test #1
Binary is a base ______ system.
2
0010 0010 in binary is ______ in HEX.
22
A typical machine instruction uses how many bytes of memory?
4
Computer instructions are typically:
4 bytes long
To represent 50 unique characters, _______ bits must be combined.
6
Which is a valid formula in a spreadsheet?
=B2+C2-6.2
When copying the formula =D5 * $A3 from column D to column E (same row), the rusulting formula in column E is:
=E5 * A3
The "ung" in mail.ung.edu is:
A Domain
algorithm
A precise, systematic method for producing a specified result is an
server
A type of computer that specializes in storage of large amounts of data:
The eight-bit character set used on computers to represent letters, numbers and symbols:
ASCII
A key advantage of digital representation of sound:
Ability to edit
If I want to multiply each number in a column by the same figure that resides in a certain cell, then I have to use what type of reference for that certain cell in the formula?
Absolute
program
Another word for software
To narrow down the spreadsheet data in view:
Apply a filter
Which of the following is not an operating system?
Assembly
This type of communication results in the sending and receiving of information to occur at different times
Asynchronous
1011 in binary is ______ in HEX?
B
Computer instruction form directly executable by a computer is the:
Binary object code or machine
When all the RGB color settings are set to 0, the color displayed is:
Black
Communication between one sender and many receivers is called:
Broadcast communication
The basic unit of a spreadsheet is a:
Cell
We can see spreadsheet results graphically by creating:
Charts
A computer is considered a(n) ________ when it gets services from another computer.
Client
The computer requesting services from a server computer is known as the _________ computer.
Client
To refer to a range of cells, specify the first cell, the last cell, and a ______ between.
Colon
To refer to a cell in a spreadsheet, you must put the _______ first and the ______ second
Column, Row
Processes statements written in a high-level programming language and turns them into machine language
Compiler
The processing unit of the CPU that essentially directs the Fetch and Execute Cycle.
Control Unit
The CPU on modern computers often contains:
Control unit, ALU, Cache memory
Which trend should not be associated with modern devices?
Decreased connectivity
true
Digital literacy is the ability to use technology to navigate, evaluate and create information.
What symbol is used to denote absolute cell references?
Dollar sign $
www.ung.edu is an example of a(n):
Domain name
When planning a new business, I should reserve the __________ now and can purchase the __________ when I have built the website.
Domain name, Hosting
Instead of typing in the IP address, we use symbolic names, which are also called:
Domain names
1110 in binary is ______ in HEX.
E
The series of instructions a computer cycles through:
Fetch/execute
Spreadsheets perform calculations with:
Formulas
A network of networks is a good description of the ________.
Internet
Which of the following represents the correct order, from largest to smallest?
Internet, WWW, LAN
From smallest to largest, the correct order of prefixes is:
Kilo, Mega, Giga, Tera
The time it takes for information to be delivered:
Latency
The method of image compression that allows some loss of the image information is called:
Lossy
Stores both program and data while the computer is running:
Memory
Conditional formatting can change the:
More than one of the above
The program counter keeps track of the:
Next instruction to be executed
Technology that enables a computer to "read" printed characters
OCR
linux, Windows, MacOS
Operating systems::
In the url: http://www.mywebsite.com/fun/jokes.html What is to the right of the top level domain?
PATH
The very last part of a URL is the:
Path Name
An example of synchronous communication:
Phone call
Holds address of next instruction to be executed:
Program counter
In a Web address, the http://is the:
Protocol
The parts of a URL are:
Protocol, domain name, path name
When copying formulas in a spreadsheet, _______ references change based on position and _______ references do not change.
Relative, Absolute
What does it mean to digitize information?
Represents with digits 1 and 0
Which of the following are functions built into spreadsheets?
SUM, AVERAGE, COUNTIF
When digitizing sound, _________ plays a major role in the accuracy of the digital representation.
Sampling rate
A(n) ________ is a computer that provides services to another computer.
Server
Customizes the order of spreadsheet data
Sorting
The UDP protocol is used when:
Speed of transmission of the utmost importance
Results of a _______ in Google are put in a spreadsheet by default.
Survey (form)
A telephone conversation is an example of ________ communication because both people in the conversation must perform one of the two parts of the communication (talking or listening) simultaneously.
Synchronous
The internet is fast enough to mimic ________________ communication.
Synchronous
An example of a top-level domain is .edu.
TRUE
By default, a formula in a spreadsheet will automatically recalculate if the value contained in any of the formula's cell references change.
TRUE
Each computer connected to the Internet is given its own unique Internet Protocol address.
TRUE
Home computers typically link to the Internet via an ISP.
TRUE
In TCP/IP transmissions, packets from the same transmission can take different routes to the destination.
TRUE
RGB, the name for a color encoding method, is an acronym for red, green, blue.
TRUE
Spreadsheets can both organize textual data and make computations on numerical data.
TRUE
The ADD instruction adds the values, not the address numbers of the memory locations.
TRUE
The byte is the standard unit for computer memory.
TRUE
Data imported into a spreadsheet should generally be _____.
Tab-Delimited
memory
The CPU (central processing unit) carries out software instructions stored in
The results of a calculation in a spreadsheet cell are displayed in:
The cell where the formula is entered
What determines the rate the fetch and execute cycle is performed?
The computer lock
The meaning of bits depends upon:
The context that the software interprets them
the alto
The first serious personal computer was:
ARPANet
The forerunner of the Internet
In the Fetch and Execute Cycle, after fetching the data:
The instruction is executed
Xerox engineers
The mouse-based graphical user interface was invented by
IBM PC's
The personal computers market in the 1980's was dominated by
http
The protocol developed that allowed the Internet to be used as an online center for information that everyone could access.
World Wide Web
The source for most of our daily information
One binary digit can be used to represent:
True/False, On/Off, Black/White
Spreadsheets recalculate
Whenever a cell is changed
digitizing data
Which of computing's 'Greatest Hits' brought about Kindles, GPS systems and ITunes.
computer
an electronic device that manipulates data
Macintosh computers
are made by Apple
ARM
laptops, tablets, smart phones, mp3 players, anti-lock brakes, and TV remotes all contain what type of processor?
cloud storage
storage accessed via the internet
In addition to fetching instructions, the Fetch and Execute cycle also fetches:
Data
What is loaded in memory when a program is running:
Data and instructions
1s, 0s
Data on a computer is represented as
How many symbols can be represented with 4 bits?
16
Which of the following lists storage in order from fastest to slowest?
1.Cache memory 2.Main memory 3.SSD 4.USB flash drive 5.Magnetic tape
1010 binary is ______ in decimal and _____ in HEX.
10, A
How many digits are there in the hexadecimal system?
16
What does the following machine instruction do? ADD 2200, 2040, 2080
Adds values 2040 and 2080 and puts result in 2200
layered software development
An advancement in software development that made programs easier to understand and maintain
program
An algorithm written in a specific programming language
A(n) is used to convert analog sound to digital values:
Analog to digital converter
If the cell does not start with an equal sign then the cell contains ______.
Data
Translates the hierarchical, human-readable names into the IP address
DNS
A bit is larger than a byte.
FALSE
Asynchronous communication requires that both the sender and the receiver are active at the same time.
FALSE
Computer instructions on current processors are extremely complex and often require many clock cycles to execute.
FALSE
Computer memory is divided into bytes of 9 bits.
FALSE
Data can be copied from one cell to another, but formulas cannot.
FALSE
Higher bandwidth usually means higher latency.
FALSE
Internet communications are sent strictly through telephone lines.
FALSE
Multicasting and point-to-point communication are equivalent terms.
FALSE
Once connected to a Web server, the connection remains in place until the client requests a page from another client.
FALSE
The World Wide Web (WWW) is larger than the Internet.
FALSE
The World Wide Web and the Internet are the same.
FALSE
The term "www" must be included when typing all Web addresses.
FALSE
Traditional hard drives are more efficient than solid state drives because there are no moving parts and they are typically smaller, last longer, and consume less energy
FALSE
You must have a business license to register a .com domain.
FALSE
The hex codes that coorespond to the primary pixel colors of red, green, and blue are:
FF0000, 00FF00, 0000FF
If I want to analyze data in a spreadsheet, I could use:
Functions: CountIF, Sum, Average, Max, Min
Found on current processors to perform operations quickly on multimedia data
GPU
On the computer, one billion clock ticks per second is called:
Gigahertz
The computer's clock speed is measured in:
Hertz
123.2.45.357 is an example of:
IP Address
