Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
201 Cards in this Set
- Front
- Back
|
(TC/SP/#CE)
|
MID FUNCTION
|
|
|
(LT, RIT, RIF)
|
IF FUNCTION
|
|
|
(TC/TR/C#)
|
VLOOKUP
|
|
|
(R,C)
|
COUNTIF
|
|
|
(R)
|
MIN
MAX |
|
|
the disk inside a hard drive is called
|
hard disk
|
|
|
the surface of the disk will have concentric circles called
|
tracks
|
|
|
tracks are divided into
|
sectors
|
|
|
sectors are divided into
|
clusters
|
|
|
the name of the unit of space required to save 1 file is called a
|
cluster
|
|
|
how many tracks are on a cd or dvd
|
1 or more
|
|
|
what is the internet
|
world wide collection of networks that connects millions of businesses govt. agencies educational institutions and individuals
|
|
|
what is the web
|
world wide collection of electronic documents called web pages, the web is 1 of the more popular services on the internet
|
|
|
The Web is a bunch of "pages" of information connected to each other around the globe, the internet is Internet is the hardware part - it is a collection of computer networks connected through either copper wires, fiber optic cables or wireless connections.
|
the difference between internet and web
|
|
|
what is the difference between the virus and a worm
|
*virus -inserts into files
*worms- searches for holes to copy into and usually only monopolize the CPU and memory. |
|
|
What is a computer?
|
An ELECTRONIC device, operates under the control of instructions stored in it's own memory it inputs DATA, PROCESSES that data, provides INFORMATION for output and stores it to storage for future use.
|
|
|
what is a malicious logic program that hides within or looks like a legitimate program
|
a Trojan horse
|
|
|
who accesses a computer network illegally?
|
Hacker
|
|
|
who accesses a computer network illegally with intent of destroying data, stealing info or other malicious actions
|
Cracker
|
|
|
what is a number that uniquely identifies each computer or device connected to the internet
|
IP Address
|
|
|
field in a database that uniquely identifies each record in a file
|
primary key
|
|
|
what refers to the difference between the pixels
|
Dot Pitch
|
|
|
what kind of database is Access
|
relational database
|
|
|
What is does DBMS stand for
|
Database Management System
|
|
|
what kind of Microsoft program is a DBMS
|
Access
|
|
|
whats the science of incorporating safety, efficiency and comfort into the workplace
|
ergonomics
|
|
|
measures the time it takes to locate an item
|
Access Time
|
|
|
what is application software that allows users to access and view web pages
|
browser
|
|
|
what does NOS stand for
|
Network Operating System
|
|
|
what does NOS do
|
its the software that is used on the server computer to do tasks on the network
|
|
|
What is network protocol
|
set of rules that governs the communications between computers on a network
|
|
|
what kind of cabling would carry pulses of light
|
Fiber Optics
|
|
|
what are 3 kinds of displays devices
|
CRT
LCD Plasma |
|
|
A computer contains many electric, electronic, and mechanical components known as?
|
Hardware
|
|
|
what are some advantages of an LCD over a CRT
|
it uses less power, doesnt put off heat, no radiation, not as heavy, more environmentally friendly
|
|
|
what is an example of business to consumer
|
someone buying a television set from an electronics retailer would be a B2C
|
|
|
what is an example of consumer to consumer
|
online auctions, such as Ebay
|
|
|
give an example of a domain name
|
yahoo
|
|
|
what are some characteristics of a impact printer
|
it forms characters and graphics on a piece of paper by striking against a inked ribbon, they typically are noisy
|
|
|
what is a web page
|
a hypertext document that's connected to the world wide web
|
|
|
what does HTML stand for
|
hypertext makeup language
|
|
|
what is a web site
|
a location connected to the Internet that maintains one or more pages on the World Wide Web.
|
|
|
Pre-designed graphic styles that can be applied to your slides are called __.
|
design templates
|
|
|
what are 4 examples of top level domain?
|
.com
.org .net .edu |
|
|
what network architecture would use NOS
|
client/server
|
|
|
why is bus topology cheaper to set up than a star topology
|
because it requires less cable
|
|
|
what are benefits to having networks vs. stand alone
|
- You can share files .
- You can share printers. - You can also share a router and get internet access for all PCs in the network. |
|
|
what is the difference between extranet and an Intranet
|
intranet can only access information with the company, extranet allows a gateway to public
|
|
|
what view could be used to reorganize a slide show presentation
|
slide sorter
|
|
|
what is nodes in regards to a network
|
Any system or device connected to a network
|
|
|
what is a zombie or (bot)
|
a compromised computer whose owner is unaware the computer is being controlled remotely by an outsider
|
|
|
what does that have to do with denial of service attack
|
zombies form an army to infiltrate computer networks and perform a DOS attack
|
|
|
what is the difference between Extranet and Intranet
|
Intranet doesnt allow the public access only for the company, Extranet allows a gateway to the public
|
|
|
what is nodes in regards to a network
|
Any system or device connected to a network
|
|
|
what is the structure of a database
|
inverse tree
|
|
|
what is the backbone of the internet
|
major carriers of network traffic on the internet
|
|
|
what is a packet
|
small pieces into which message are divided by TCP/IP
|
|
|
what are the 2 parts of a packet
|
header
payload |
|
|
What is the main circuit board of the computer?
|
Motherboard
|
|
|
What are two types of kinds of printers
|
impact and non impact printers
|
|
|
what category is the dot matrix printer
|
impact printer
|
|
|
what category is the laser jet printer
|
non impacter
|
|
|
what is the name of the adapter card i would install in an expansion slot in my pc to communicate wirelessly
|
Wireless network card
|
|
|
What can be found on the motherboard?
|
Many electronic components including:
Processor chips Memory chips Expansion slots slots for memory modules |
|
|
What 5 things are in the system unit?
|
1. Cpu
2. Memory 3. Power Supply 4. Hard drive 5. CD/DVD/ Blu-Ray Drives |
|
|
How to write out 1 character of data
|
1 byte [B]
|
|
|
How to write 1,024 characters?
|
1 Kilobyte [KB or K]
is approximately 1,000 Character |
|
|
How to write 104,8576 or approximately 1 million characters?
|
1 Megabyte [MB]
|
|
|
How to write over 1 Billion Character of data?
|
1 gigabyte [GB]
|
|
|
How to write over 1 trillion characters of data?
|
1 terabyte [TB]
|
|
|
What is a world wide collection of networks that connects millions of business, government agencies educational institutions, and individuals?
|
Internet
|
|
|
Small, high-speed storage locations in a process that temporarily hold data and instructions.
|
Registers
|
|
|
Several files that contain the system configurations information
|
Registry
|
|
|
What is the master program that controls and manages the basic computer operations?
|
The operation system
|
|
|
What is characterized by the 1st generation of computers?
|
vacuum tubes
|
|
|
What does GUI stand for?
|
Graphical user interface
|
|
|
What is the process of setting up software to work with the computer, printer, and other hardware?
|
Installing
|
|
|
The Kernel resides where all the time?
|
in Memory
|
|
|
what makes constant use of a set of files called the registry?
|
the operation system
|
|
|
What is the Kernel?
|
the software that manages the cpu
the core of the operating system |
|
|
________ allows various devices both inside and attached to the system to communicate with each other.
|
Bus
|
|
|
What are some functions of the operating system?
|
1. start & shut down
2. Manage Memory 3. Manage programs 4. Establish Internet connection 5. Administer security |
|
|
what is FIFO?
|
First in First Out
Sequence of data or programs that wait in line |
|
|
________ is the understanding and control of matter at dimensions of roughly 1-100 nano meters. It involves measuring, modeling, manipulating matter at this length scale.
|
Nanotechnology
|
|
|
What directs other programs not in memory to perform task that support application program?
|
The kernel
|
|
|
Where is the OS stored for hand held?
|
It's own flash memory
the older ones is on a ROM chip |
|
|
What incorporates comfort efficiency, and safety into the design of the workplace?
|
Ergonomics
|
|
|
What are the pointing devices?
|
(icon)- pointer
mouse, trackball, touch pad, and pointing stick |
|
|
what is a stationary pointing device with a ball on it's top or side?
|
trackball
|
|
|
What is a small flat rectangular pointing device that is sensitive to pressure and motion?
|
Touch pad
|
|
|
What is a pressure sensitive pointing device shaped like a pencil eraser and is positioned between the B, H, and G keys on a keyboard?
|
Pointing stick
|
|
|
what is the primary text code system, and how is it stored?
|
ASCII (American Standard Code for Information Interchange)
it is stored as 1 byte or 8 BITS |
|
|
in ______________ the control unit fetches an instruction from memory and places it in the register.
|
I-Time
|
|
|
What does ASCII stand for?
|
American Standard Code for Information Interchange
|
|
|
What is the most used coding scheme?
|
ASCII
|
|
|
The processor repeats 4 basic operations which are?
|
1. Fetch
2. Decode 3. Execute 4. Store |
|
|
What is the pace of the clock speed measured in ?
|
Gigahertz
|
|
|
What uses multiple processors simultaneously to execute a single program or task?
|
Parallel Processing
|
|
|
What is electronic components in a computer that store instructions waiting to be executed by the processor or also its a physical location on the motherboard?
|
Memory
|
|
|
What is the Royal Advisory?
|
Cache
|
|
|
What temporarily holds data and instructions?
|
Register (Royal Servants)
|
|
|
What is the King?
|
The control unit
|
|
|
What is the components of the processor that directs and coordinates most operations in the computer?
|
The control unit
|
|
|
What performs arithmetic comparisons and other operations?
|
The Arithmetic Logic Unit
|
|
|
What are the major parts of the CPU?
|
1. ALU
2. Control Unit 3. Registers |
|
|
In _____________ the control unit fetches an instruction from memory to the register, and puts it in the arithmetic logic unit.
|
E-Time
|
|
|
__________ is a type of interface that allows a user to interact with software using text, graphics, and visual images, such as icons.
|
Graphical User Interface (GUI)
|
|
|
__________ a portion of storage medium, usually the hard disk that the operating system allocates to function as additional RAM.
|
Virtual Memory
|
|
|
__________ arranging the text of a document for the printed page including settings margins, tabs, justification, tab lines spacing ect.
|
Document Formatting
|
|
|
________ soft return, automatically moving text from the end of a line to be beginning of the next determined by the left and right margins.
|
Word wrap
|
|
|
________ is the number of bits that a processor can interpret and execute at a given time.
|
Word size
|
|
|
Base _____ is a decimal.
|
10
|
|
|
Base ______ uses binary.
|
2
|
|
|
What generation used Vacuum Tubes?
|
First Generation
|
|
|
What generation used transistors?
|
Second Generation
|
|
|
What generation used Integrated circuits?
|
Third generation
|
|
|
What is a small chip containing thousands of transistors?
|
A Intergrated circuit
|
|
|
Who invented the integrated circuit?
|
Jack Kilby
|
|
|
Who devised away to use layered circuits?
|
Robert Noyce
|
|
|
who created Mark-1
|
Howard Aiken
|
|
|
Who was used Mark-1 and what did they use it for used for?
|
The Navy used it for ballistics calculations
|
|
|
what does ENIAC stand for?
|
Electronic Numerical Integrator and Calculator
|
|
|
Who developed ENIAC?
|
J. Presper Eckert, and John Mauchly
|
|
|
What was considered to be the first general purpose computer?
|
ENIAC
|
|
|
What does TRADIC stand for?
|
Transistor Digital Computer
|
|
|
Who developed TRADIC?
|
Developers in Bell labs
|
|
|
What was the first transistorized computer that replaced vacuum tubes with 800 transistors?
|
TRADIC
|
|
|
what does EDVAC stand for?
|
Electronic discrete variable Automatic Computer
|
|
|
Who created EDVAC?
|
Eckert, Mauchly, Von Neumann, and others
|
|
|
What was the first general purpose computer to use binary arithmetic and to use the stored concept?
|
EDVAC
|
|
|
What is the:
-The software that manages the cpu -the core of the operating system - it directs other programs not in memory to perform task that support application programs |
-The Kernel
|
|
|
What is the components of the processor that directs and coordinates most operations in the computer?
|
The control unit
|
|
|
What is a series of cells in a rectangle
Its measured by top left corner: bottom right hand corner |
Range
|
|
|
what is the black box in the bottom right hand corner in a selected cell used to drag down cell info to multiple cells?
|
Fill Handler
|
|
|
what is the primary text code system most widely used & is stored as 1 byte or 8 BITS?
|
American Standard Code for Information Interchange
|
|
|
what is the smallest unit of data that a computer can process
|
Binary Digit
-BIT is the acronym |
|
|
Small, high-speed storage locations in a process that temporarily hold data and instructions.
|
Register
|
|
|
What is the main circuit board of the computer?
|
The Motherboard
|
|
|
what makes users more productive/ assist them with personal task?
|
Application Software
|
|
|
How to write out 1 character of data
|
1 BYTE [B]
|
|
|
what is a 16 bit coding scheme that has the capability of representing more than 65,000 characters and symbols?
|
Unicode
|
|
|
What is the area of memory that stores the contents of frequently used data or instructions?
|
Cache
|
|
|
What performs arithmetic comparisons and other operations?
|
The Arithmetic Logic Unit
|
|
|
________ allows various devices both inside and attached to the system to communicate with each other.
|
BUS
|
|
|
__________ is a type of interface that allows a user to interact with software using text, graphics, and visual images, such as icons.
|
Graphical User Interface (GUI)
|
|
|
________ is the number of bits that a processor can interpret and execute at a given time.
|
Word size
|
|
|
What do you call the intersection of a column and a row in a worksheet?
|
Cell
|
|
|
what counts the number of cells within a range that meet a given condition?
|
COUNTIF
|
|
|
What is the difference between alpha numeric and numeric data?
|
Numeric means Numbers
Alphabetic means Letters Alphanumeric is the combo of both |
|
|
Why is it better to use CELL Addresses in formulas as opposed to using hard-coded data?
|
because it means that if you change the value in a particular cell, the formula will automatically
|
|
|
what is the name of the function that i would use to perform a search in a vertical table?
|
VLookup
|
|
|
What is the format for the MID function? How is it used?
|
=MID(target cell, starting postition, #of characters to extract)
-used to remove such unwanted characters |
|
|
What does the pointer need to look like before i can "drag and drop" a range of cells or even just a cell?
|
FOUR HEADED ARROW
|
|
|
What does the pointer look like when positioned over the home ribbon and column header in EXCEL 2007?
|
home ribbon- white single headed arrow pointing in upward left direction
column header- black single headed downward pointing arrow |
|
|
what does the floating cursor need to look like before i can use the fill handle?
|
thin black cross
|
|
|
what is the difference between absolute cell referencing and relative cell referencing?
|
absolute- uses a constant in a formula when cell is fill handled downward
relative- adjusts formula relative to its new location when its fill handled downward |
|
|
Where is the quick access toolbar located?
|
in the top left corner next to the windows button it portrays icons
|
|
|
Using cell address in formulas is called?
|
Cell referencing
|
|
|
What is located above the column title to the left of the formula function that shows the cell that is currently activated?
|
NAMEBOX
|
|
|
what is called a separator?
|
Comma
|
|
|
What is the default pointer in excel, for word specific?
|
A White Cross
|
|
|
what do you always start a formula with? otherwise it would be treated as what?
|
An Equal Sign/ Alpha Numeric's
|
|
|
How do i write an IF Statement?
|
=IF(logical test,result if true, then result if its false)
i.e.- =IF(h8="A",5%*G8,6%*G8) |
|
|
How do i write a sum function?
|
=SUM(B12:H12)
|
|
|
How do i write a sum function using data from 2 or more worksheets?
|
=SUM(Cell range from sheet one, click on sheet 2 and select cells then)
* and press enter then excel will take you back to sheet 1 |
|
|
What does the exclamation mark represent?
|
It is the divider
It separates the name of the sheet away from the cell in reference. |
|
|
How to write a count if statement?
|
=CountIF( range, Critieria)
i.e.- =CountIF( A3:L22,5) =CountIF( A3:L22,">5") |
|
|
In which statement do i have to put quotation marks around greater than, equal to and less than statements?
|
Only In the COUNTER IF
|
|
|
What is the only time to use quotations when writing an IF statement?
|
Only Around Alphabetic Characters
("A","B","C","ERROR") |
|
|
How do i write a function to find the minimum of a set of ranges?
|
=MIN(range)
|
|
|
How do i write a function to find the maximum of a set of range?
|
=MAX(Range)
|
|
|
What is absolute cell referencing? What symbol is used?
|
Is when you use the dollar sign to establish a common denominator. It keeps the fill handler from adding 1 to the cell of that equation.
|
|
|
True or False do you have to put a $ in front of both the letter and number in absolute cell referencing?
|
False, because it will never try to change the letter
|
|
|
Can you have a function inside of a function?
|
Yes
|
|
|
What order does your information have to be in to make up a table?
|
Ascending Order- column 1 has to be ascending
|
|
|
How do you write a VLOOKUP equation?
|
=VLookup(Target cell,Table Range, Column #)
|
|
|
What does VLOOKUP stand for?
|
Vertical Lookup
|
|
|
How do i write a mid function?
|
=MID(target cell, starting postion, # of characters to extract)
i.e.- c15 = 1602 =MID(C15,2,2) that gives you 60 |
|
|
What do you have to create to use VLookup?
|
A TABLE
|
|
|
Break down the steps of Vlookup
|
For Vlookup there has to be at least 2 columns first find the cell that i need analyzed, then highlight the entire range, then out of each column do i want the information pulled from.
|
|
|
What is a leader line?
|
when pies slices are to small to be labeled you the leader line will draw a line to connect the data of the pie to the slice.
|
|
|
How do you get the value invested?
|
The number on hand * Cost per Item
|
|
|
How to you use auto sum?
|
Highlight the range of cells including the cell you want the answer to appear in, then click on auto sum button.
|
|
|
What exactly is a Circular Reference Error?
|
Is putting the formula in the range of the formula
|
|
|
How do you sort?
|
1. select everything
2) Home Ribbon 2) Data Ribbon 3) Sub-Cat Editing 3) Sub-Cat Sort&Filter 4. Select Type of Sort you Want |
|
|
How will Excel sort?
|
Excel will always sort by the first column in the range unless you click custom sort and specify deferently
|
|
|
To see the Fill Handler what do you have to do?
|
select a cell
|
|
|
Greater Than
|
>
|
|
|
Less Than
|
<
|
|
|
Not Equal
|
< >
|
|
|
Given : =Sum(c5:c9, Sheet2!J5:J8)
Rewrite if the worksheet title was changed to Blue |
=Sum(C5:C9,"Blue!"J5:J8)
|
|
|
Short for coaxial a single copper wire surrounded by at least 3 layers- 1 an insulating material 2- a woven or braided metal, 3-a plastic outer coating
|
Coax-
Coaxial cable |
|
|
a portion of a storage medium, usually the hard disk, that the OS allocates to function as additional RAM
|
Virtual Memory
|
|
|
When data moves from one set of major connections to another on the Internet, we call these connections the Internet _____.
A) Pathway B) Backbone C) Communications system D) Routers |
Backbone
|
|
|
What type of telecommunications hardware allows you to access the web?
A) Browser B) Modem C) FTP protocol D) IRC |
Modem
|
|
|
What do you create when you need to pose a question to the database?
A) Inquiry B) Rule C) Question D) Query |
Query
|
|
|
What term describes a collection of data that's organized to allow access, retrieval and use of that data?
A) Database B) Web site C) Wiki D) Relation |
Database
|
|
|
What is another name for a shared network?
A) WAP B) Switch C) Broadband router D) Hub |
Hub
|
|
|
What is the term used to describe the amount of space you have to transmit to and from the Internet?
A) Internet speed B) Network speed C) Router D) Bandwidth |
Bandwidth
|
|
|
What type of communication media is infrared?
A) Wireless B) Wired C) Detached D) VoIP |
Wireless
|
|
|
When a computer sends data over the Internet, the data is divided into small pieces called _____.
|
packets
|
