GB 310 Lester final review

Toggle between Absolute and Relative cell reference
Click the card to flip 👆
1 / 26
Terms in this set (26)
Toggle between Absolute and Relative cell reference
F4
Absolute cell reference
$A$1 (remains constant) this function locks both the row and column
Relative cell reference
B3 (changes with formula) nothing is locked free range of movement
Mixed cell
locks either row or column but not both
Named ranges
names used to refer to cell references, formula results or values
why is it important to use excel?
It is powerful and commonly used
good for work group settings
a lot of people know how to use
why is it important to lock absolute cells?
Because it reveals constant values in a spreadsheet
what is the tool that mac's dont have that it would be really great if they did
power query editor
DSL (digital subscriber line)
broadband technology that uses the wires of a local telephone network
DNS (domain name service)
internet directory service that allows devices and services to be named and discoverable
TCP (transmission control protocol)works at both ends of internet communication to ensure a perfect copy of a message is sentprotcolEnables communication by defining the format of data and rule for exchangeCacheis a temporary storage space used to speed computing taskscomputer programs making decisions without any human intervention conduct most U.S. stock tradingtrueIP addresses can oftentimes by used to identify a users geographic locationtrueinternet networks arepacket-switched networkspeering refers toa situation when ISPs connect their networking equipment together to share trafficRouters dont have perfect, end- to- end information on all points in the internettruesupporters of net neutrality believeit will improve innovation, it will keep costs lowThe User Datagram Protocol (UDP) acts as a substitute to TCP when there is a need for speed of communication, but where perfect and complete transmission quality can be sacrificedtruethe fault-tolerant nature of the DNS ensures thatthe service continues functioning even if one nameserver goes downDomain name service (DNS)internet directory service that allows devices and services to be named and discoverablelast miletechnologies that connect end users to the internetIP adressvalue used to identify a device that is connected to the internetHypertext transfer protocol (HTTP)allows web browsers and servers to communicate with each otherInternet service provider (ISP)firm that provides access to the internet