TAMU ISTM 210 EXAM 2 Exam Study Questions with 100% Correct Answers Already Graded A+

TAMU ISTM 210 EXAM 2 Exam Study Questions with 100% Correct Answers Already Graded A+ 1. Phinney's Fav formula - ANSWER CONCATENATE 2. CONCATENATE function - ANSWER CONCATENATE (text1,[text2],...) - combines blocks of text 3. SEARCH function - ANSWER NOT case sensitive 4. COUNT function - ANSWER A function that determines how many cells in a range contain a number. 5. RATE - ANSWER calculates interest rate earned for an investment given the number of payments made as part of the investment, payment amount, and current value. 6. EFFECT - ANSWER calculates effective annual percentage rate for an interest rate given the number of periods per year that interest is charged. 7. NPER - ANSWER calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount. 8. PMT - ANSWER Function that calculates the periodic payment for an installment loan. 9. A rule that governs computer or network usage - ANSWER Protocol 10.The most common form of ethernet cable wire - ANSWER Twisted Wire 11.The central location of the computer network - ANSWER Network Hub 12.Protocol that guarantees the reliability of the computer file received by the network's end user; will not send unless all packets are available - ANSWER Transmission Control Protocol/Internet Protocol 13.Protocol used primarily for streaming videos - ANSWER User Datagram Protocol 14.Who developed HTML? - ANSWER Sir Tim Berners-Lee 15.The current form of HTML - ANSWER HTML5 16.Which university began the ARPANET project? - ANSWER UCLA 17.Where did Sir Tim Berners-Lee develop HTML? - ANSWER Center for European Nuclear Research (CERN) 18.The Internet is a ____________________ Network model - ANSWER Client/Server 19.People who produce websites - ANSWER Webmasters 20.The three aspects of a good website - ANSWER Content, Interactivity, Design 21.The user can easily use the website - ANSWER Interactivity 22.The customer's first impression of a business is the ________________ of the website - ANSWER design 23.The act of a browser storing copies of previously viewed pages - ANSWER Caching 24.Text files used for tracking and maintaining user information - ANSWER Cookies 25.The two most common types of graphic files - ANSWER GIF, JPEG 26.Programming language that allows the browser to run certain applications - ANSWER JavaScript 27.A business that provides people a way to connect to the internet - ANSWER Internet Service Provider 28.Technology used by ISPs for services like web hosting and domain names - ANSWER Digital Subscriber Line 29.UDP (does or does not) need all packets in order for the file to be viewed - ANSWER does not 30.Software the controls an entire network - ANSWER Network Operating System 31.A company that the book used as an example of an NOS provider - ANSWER Cisco Systems, Inc. 32.Oversees the NOS and is responsible for authenticating all users of a network; also ensures the network is running smoothly and is secure - ANSWER Network Administrator 33.The mapping of a physical network and logical interconnections between nodes - ANSWER Network Topology 34.Topology in a line - called the "backbone" - with two endpoints; anyone on the network can receive data simultaneously - ANSWER Bus Topology 35."It is important that network administrators have a _________________________________________________." - ANSWER strong business background nce population - ANSWER Measures the square of the population standard deviation EX. Spread or dispersion of salaries for employees in similar positions in an organization. 37.No calculation - ANSWER this is the default option. As the name implies, no calculation will be performed.