PLS 21 Midterm
Why might someone consider using spreadsheet software other than Microsoft Excel (select all the apply)? - they want to modify the source code to suit their needs - Excel lacks cloud integration - they want to move toward open source software because it is more stable and less "buggy" - budgetary constraints
- budgetary constraints - they want to modify the source code to suit their needs
Which of the following CPUs is most likely to be able to process data the fastest, all else being equal? - 3.0 GHz, quad-core, Turbo Boost up to 3.2 GHz - They are the same - 3.0 GHz, quad-core, hyperthreaded
3.0 GHz, quad-core, hyperthreaded
Which of the following best describes a MAC address? - A unique static identifier for devices on the world wide web - A convention for identifying devices on a LAN, which has largely been replaced by IP addresses given the abundance of wireless networks - Another name for an Apple ID, which is used to identify MAC computers for features such as "Find My MAC" or decryption - A numerical label assigned to each device connected to a computer network, assigned dynamically by the modem or router to which it is connected - A unique identifier for devices on a network
A unique identifier for devices on a network
What does the "A" in RAM stand for? - Avatar - Access - Arithmetic - Accelerated
Access
Which of the following does modern spreadsheet software typically replace (check all that apply)? - Paper ledger - Absolute referencing - YouTube - Adding machine or calculator
Adding machine or calculator and Paper ledger
Which of the following would be considered photo "editing"? - All of these - Using the blur tool to make it look like an object is fading out - Replacing the background of an image to make it look like it was taken in a different place - Adjusting exposure (in software)
Adjusting exposure (in software)
What do operating systems do? - All of the above - manage the software hardware and resources - provide a stable, consistent environment - hardware layer abstraction
All of the above
Which are the functions of an OS? - Establishes the User Interface - Manages Memory - Manages CPU - Handles Input and Output
All of the above
Which of the following terms refers to an element of a spreadsheet (select all that apply)? - Sheet - Chart - Formula - Cell
All of the above
Which of the following is involved in video editing? - Combining multiple scenes into a single continuous movie - Swapping the order of two clips - Trimming the first 10 seconds off of a clip - All of these
All of these
Which of the following may be a consideration when choosing a GPU? - Primary storage - Clock speed - None of these - Number of cores - All of these
All of these
A typical raster image to be displayed on a computer screen contains which color channels (select all that apply)? - Blue - Red - Green - Black
Blue Red Green
Which of the following is not a component or entity needed for a computer network? - Transfer Protocol - Browser - Data Packet - MAC Address
Browser: A web browser is used to view data on a specific type of network (the Internet), but is not a general component of a computer network.
Which of the following types of storage are fastest in terms of speed at which data is read and written? - RAM - Cache - ROM - Volatile
Cache
Which of the following is not an advantage associated with using a CMS for commercial web development? - Cost savings - Intuitive and rapid development - Hosts website data - The user does not have to know HTML
Cost savings:
Cloud computing has the following benefit for companies: - Improved reliability - Enhanced privacy - Improved security - Cost savings
Cost savings: Cloud computing can reduce costs in many cases because they can pay another company to build and maintain software/infrastructure as a service.
Which of the following best describes "volatile" storage? - Data is lost when power is lost - It uses rapid fluctuations in voltage to write data. - It reads and writes data in random order - It is prone to data corruption
Data is lost when power is lost
Which of the following negative aspect of cloud computing is the least likely to occur under typical conditions? - Data loss due to natural disasters - System outages - Data hacking - Serving as a platform for illegal activity
Data loss due to natural disasters: An advantage of cloud computing is that data is usually distributed across multiple locations, making it less vulnerable to catastrophic losses.
True or False: Data that must be written quickly is often written to ROM rather than to secondary storage because it is much faster.
False
True or False: Pivot tables are a proprietary feature unique to Microsoft Excel.
False
True or False: Word processing based on markup languages adds formatting to text primarily through keyboard shortcuts.
False
True or False: An external link connects to a different page within the same website.
False: An internal link connects within the same websites.
True or False: The Internet primarily uses satellite signals to transmit data between continents.
False: Intercontinental data transfer mostly occurs through submarine cables.
True or False: Magnetic tape storage is outdated technology that is rarely used anymore.
False: It is frequently used for long-term storage because it is cheap, reliable, and consumes no power when not in use
True or False: Moore's Law states that CPU speed doubles roughly every two years.
False: Moore's Law says that the number of transitions that can fit on a given chip area doubles roughly every two years. This doesn't exactly translate into CPU speed, as you could make the CPU smaller with the same performance, or have different performance characteristics other than speed directly.
Which of the following has been shown to increase website effectiveness in terms of user satisfaction, revenue, or retention? - Fewer choices - Slower loading times - Having many menu items - Avoiding photos of people
Fewer choices: Users are less likely to make a decision when they have inadequate time to consider all choices.
What company developed the first operating system? - General Motors - Seimens - SpaceX - Ford - Volkswagen
General Motors
Which of the following was originally developed to be a cloud-based word processing software that prioritized collaboration? - Google Docs - Apple Pages - Microsoft Word - LibreOffice Writer
Google Docs
Which of these is not a type of cloud computing? - Hardware as a Service - Software as a Service - Platform as a Service - Platform as a Service
Hardware as a Service: Correct, "HaaS" is a type of avocado. Use of remote hardware through cloud computing would more commonly be called IaaS.
What HTML file is loaded by default in a website directory? - index - table of contents - browser - overview
Index: Of these choices, the index or index.html file is the only one that is loaded by default within a website directory.
Which of the following is most likely a reason someone would choose to use Adobe Photoshop for image processing rather than other common software options? - It is much easier to use than other options - It has robust and extensive features - It is among the best software for photo sorting/organization/culling - It is free and open source
It has robust and extensive features
Which of the following is most likely to be considered a weakness of Microsoft Excel relative to other spreadsheet software? - It is free for everyone to use - It is not open source, so the base software cannot be modified - It is not available for MacOS - It does not have capability for custom scripting/programming
It is not open source, so the base software cannot be modified
What is the advantage of a cache? - It speeds up data retrieval - It is cheap - It provides a large amount of data storage - It is very compact in physical size
It speeds up data retrieval: A cache speeds up data retrieval by storing network data locally so that it can access them quickly.
Which of the following is an example of open source spreadsheet software? - Microsoft Excel - LibreOffice Calc - Google Sheets - Apple Numbers
LibreOffice Calc
Which devices likely do not have an operating system? - microwaves - laptops - smartphones - tablets
Microwaves
Which of the following is an output technology? - Monitor - Keyboard - Mouse - Stylus
Monitor
A monolithic kernal is... - a single code that is linked into the kernal - a single code or block of program - multiple codes combined to form a kernal - None of the options
None of the options
Spreadsheets primarily deal with what type of data? - Big data - Numerical - Text - Artificial intelligence
Numerical
Where is data usually stored in cloud computing? - On satellites - On your device's solid-state drive - In RAM - On a server
On a server
Which of the following best describes cloud computing? - Weather forecasting software - Long-range wireless communication between computers across satellites - A network comprised of quantum computers - On-demand, remote computing resources
On-demand, remote computing resources
Which of the following is most likely to be a possible disadvantage in choosing Final Cut Pro software for video editing. - PC users cannot run it - It is open source - It has limited to no effects available - It is not cross-compatible with the GIMP file format
PC users cannot run it
Which is not an example of a CMS? - Photoshop - Weebly - WordPress - Wix
Photoshop: Photoshop is image editing/processing software.
In which of the following situations would you be most likely to use spreadsheet software? - Preparing a large group of customized emails - Preparing a budget - All of these - Preparing a memo
Preparing a budget
What is a means for providing uniform formatting of all pages in a website? - Referencing a CSS - Select "format -> document -> apply" from the browser drop-down menu - Using a DNS address - Using an HTML tag
Referencing a CSS: A Cascading Style Sheet applies uniform formatting to all pages in a website that reference the CSS file
Which of the following is not a type of secondary storage? - Register - Flash Drive - Optical Drive - Magnetic Disk
Register
Which of the following types of storage would typically contain data that only needs to be read and written infrequently? - Secondary storage - Cache - Primary storage - RAM
Secondary storage
Which of the following general photo processing tools would be used to remove the background of an image? - Blend tool - Selection tool - Crop tool - Dodge tool
Selection tool
Which of the following types of computers would usually take up an entire large room and have hundreds of thousands of CPUs? - Moore's computer - Quantum computer - Supercomputer - Mainframe computer
Supercomputer
Which useful tool allows you to control paragraph margins and indents? - Break - Widow - Mail merge - Tab
Tab
Which of the following best describes the type of data organization characteristic of a spreadsheet? - Relational - Heath Ledger - Tabular - Document
Tabular
What are HTML Tags? - Text-based formatting instructions that web browsers can read and interpret. - A method for naming and organizing files on a network. - A way for the user to interact with a website. - The command and control center of a website hosted on a server.
Text-based formatting instructions that web browsers can read and interpret.: HTML tags provide "instructions" on how to format plain text on a webpage.
Which of the following has wires and cables? - The internet - The World Wide Web
The Internet: The Internet is a physical network with wires and cables
What is a Kernel? - A computer application used for starting an operating system - The software of the operating system acting as an interface between hardware and software - A Linux-based operating system. - Firmware used to perform hardware initialization during the booting process (power-on startup), and to provide runtime services for operating systems and program
The software of the operating system acting as an interface between hardware and software
What is HTML? - An internet transfer protocol - An encryption standard - A shorthand or alias for an IP address - The standard language for document display in web browsers
The standard language for document display in web browsers
Why might many businesses choose not to use open source photo or video editing software? - There is usually nobody to call if you need help - It is too expensive at the enterprise/business scale - It will often result in low quality photos or videos - It allows you to customize the source code
There is usually nobody to call if you need help
Which of the following is a benefit to using layers when photo editing/processing? - They improve sharpness of the image - They allow you to apply dodge and burn effects - They allow you to work on only a limited portion of the image at a time - They are required in order to crop an image
They allow you to work on only a limited portion of the image at a time
Which of the following might be a reason to pay for "professional" video editing software instead of using cheap or fee software? - They can include custom audio clips within video clips - They include an extensive library of effects - They can overlay text animations on video clips - All of these
They include an extensive library of effects
Which of the following video editing tools allows you to view an entire clip as a linear strip? - Clip splitting - Timeline - Effects toolbar - Clip trimming
Timeline
What is the purpose of operating systems? Please select the best single answer. - To manage hardware and software - To manage hardware - To manage software - To manage other device interfaces
To manage hardware and software
True or False: All computers have an operating system
True
True or False: The central processing unit performs the actual computation or "number crunching" inside a computer.
True
Which of the following would have the largest impact on a computer network bandwidth? - Type of connection between devices - Web browser - Physical distance between computers on the network - Computer hardware
Type of connection between devices: Connections such as wire/cable type will have a big impact on bandwidth, as this is analogous to the size of a pipe in transporting fluids.
Which of the following types of cable is least likely to be used in a LAN? - Twister-Pair - USB - Fiber Optic - Coaxial
USB: Generally not used for network transmission.
Which type of network uses radio waves rather than cables/wires for communication? - WAN - The Internet - WLAN - LAN
WLAN: W stands for wireless
What is the most utilized operating system by market share? - Windows - Mac - Android - IOS
Windows
Which of the following common software types allows users to create and manipulate text-based documents? - Database - Photo editing - Word processing - Spreadsheet
Word processing
A traditional Hard Disk Drive differs from a Solid State Drive in that it: - has faster read/write speeds - has a spinning magnetic platter - contains transistors for storage - is volatile storage
has a spinning magnetic platter
The first spreadsheet software represented a new way of thinking about using computers in that: - spreadsheets provided a way for artificial intelligence to analyze large amounts of data, which was previously unavailable - spreadsheets did not represent the traditional sequential, algorithmic flow of computer programs at the time - spreadsheets allowed for organization of numerical data in tabular format - spreadsheets allowed for fast manipulation of numerical data previously unavailable at the time
spreadsheets did not represent the traditional sequential, algorithmic flow of computer programs at the time
