Deck 3: Performing Calculations With Formulas and Functions
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Question
Unlock Deck
Sign up to unlock the cards in this deck!
Unlock Deck
Unlock Deck
1/50
Play
Full screen (f)
Deck 3: Performing Calculations With Formulas and Functions
1
While naming a file on the computer,if we press the key corresponding to letter A on the keyboard,what process is carried out inside the CPU to display the letter on the screen?
A) 'A' is stored as alphabet 'A' on the memory unit and displayed back.
B) 'A' is directly displayed on monitor from keyboard,without passing through any memory unit.
C) 'A' is converted to its ASCII binary code and stored in the memory unit.Then it is converted back to 'A' for display.
D) 'A' is converted to its special characters and stored in the memory unit.Then it is converted back to 'A' for display.
A) 'A' is stored as alphabet 'A' on the memory unit and displayed back.
B) 'A' is directly displayed on monitor from keyboard,without passing through any memory unit.
C) 'A' is converted to its ASCII binary code and stored in the memory unit.Then it is converted back to 'A' for display.
D) 'A' is converted to its special characters and stored in the memory unit.Then it is converted back to 'A' for display.
C
2
Which of these is an optical medium of storage?
A) Blu-ray discs
B) Solid state drive
C) Cloud storage
D) HDD
A) Blu-ray discs
B) Solid state drive
C) Cloud storage
D) HDD
A
3
A joystick is a pen-type input device used to draw and tap on icons.
False
4
Which of the following types of storage is/are used to transfer data from one computer to another?
A) Read-Only Memory
B) Random Access Memory
C) External Hard Drive
D) Optical Media
A) Read-Only Memory
B) Random Access Memory
C) External Hard Drive
D) Optical Media
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
5
Daniel wants to buy a desktop to use for playing games after work.He loves racing games and wants to make sure his laptop has all the specifications needed to run them smoothly and efficiently.Which of these factors should he consider?
A) RAM capacity - it provides temporary storage that applications use to run smoothly
B) Processor core - some applications,especially games,have greater processor requirements
C) Size - larger desktops provide more physical space for memory storage,increasing efficiency
D) External hard disk capacity - provides additional temporary storage needed to run heavy applications
A) RAM capacity - it provides temporary storage that applications use to run smoothly
B) Processor core - some applications,especially games,have greater processor requirements
C) Size - larger desktops provide more physical space for memory storage,increasing efficiency
D) External hard disk capacity - provides additional temporary storage needed to run heavy applications
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
6
Peripheral devices,like a USB flash drive,are generally connected to your computer through ports.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
7
Which of the following should you take into consideration when purchasing a computer?
A) Form factor
B) Software and applications you intend to use
C) Platform or Operating System
D) Storage capacity
A) Form factor
B) Software and applications you intend to use
C) Platform or Operating System
D) Storage capacity
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
8
What are the two important components of CPU that help in processing the input into output?
A) Control Unit and RAM
B) Hard Drive and Arithmetic Logic Unit
C) Hard Drive and RAM
D) Control Unit and Arithmetic Logic Unit
A) Control Unit and RAM
B) Hard Drive and Arithmetic Logic Unit
C) Hard Drive and RAM
D) Control Unit and Arithmetic Logic Unit
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
9
In which format is data finally stored in computers?
A) Letters of English alphabet
B) Even numbers
C) Binary digits
D) Special characters
A) Letters of English alphabet
B) Even numbers
C) Binary digits
D) Special characters
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
10
In which of the following storage device(s)does memory need to be constantly recharged to retain the contents?
A) Dynamic RAM (DRAM)
B) Static RAM (SRAM)
C) Magnetoresistive RAM (MRAM)
D) Flash Memory
A) Dynamic RAM (DRAM)
B) Static RAM (SRAM)
C) Magnetoresistive RAM (MRAM)
D) Flash Memory
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
11
Where on a computer is the operating system generally stored?
A) RAM
B) Internal hard drive
C) Flash drive
D) Virtual memory
A) RAM
B) Internal hard drive
C) Flash drive
D) Virtual memory
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
12
Which of these,though not equally portable,is most powerful and usually easier to upgrade than others?
A) Desktop computers
B) Tablets
C) Smartphones
D) Laptops
A) Desktop computers
B) Tablets
C) Smartphones
D) Laptops
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
13
Jason takes many photographs on his smartphone while on vacation in Italy.If Jason wants to access these pictures across multiple devices,including his computer,smartphone,and tablet,where should he store them?
A) RAM
B) ROM
C) Cloud storage
D) Compact disk
A) RAM
B) ROM
C) Cloud storage
D) Compact disk
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
14
We can use Unicode coding scheme to support a larger variety of characters including Chinese,Japanese,and Arabic.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
15
Ryan wants to install a new operating system on his laptop,but first he needs to safely store all his data - over 80 GB - so he doesn't lose any of his files.How should Ryan back up all his data?
A) He should use a memory card to store the data if his laptop has a slot for one,because they are very small and handy.
B) He should use the internal hard drive of his laptop to store the data because since it is not detachable,it will ensure maximum safety.
C) He should use an external hard drive to store the data because the amount of data he needs to store is quite large.
D) He should use a DVD to store his data because other handy storage devices,like flash drives and memory cards,cannot store such a sizeable amount of data.
A) He should use a memory card to store the data if his laptop has a slot for one,because they are very small and handy.
B) He should use the internal hard drive of his laptop to store the data because since it is not detachable,it will ensure maximum safety.
C) He should use an external hard drive to store the data because the amount of data he needs to store is quite large.
D) He should use a DVD to store his data because other handy storage devices,like flash drives and memory cards,cannot store such a sizeable amount of data.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
16
All-in-one computers are easier to service and upgrade but occupy more space than desktop computers.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
17
The hard disk drive on Joyce's laptop can store up to 500 GB of data.She usually only saves official documents and a few songs that she listens to while she works.However,when she uses more than three applications at the same time,her laptop responds more slowly.What should she do to optimize her storage?
A) Use an external hard disk drive to store data so that there is more free memory on her laptop's hard disk drive
B) Save all her data on a DVD so that the space on her hard disk drive is completely available to run her applications smoothly
C) Increase the RAM on her laptop so that more space for temporary storage of data is available,hence,increasing the performance
D) Replace her hard disk drive with one that provides lesser storage capacity so that the amount of memory available is optimal and performance is increased
A) Use an external hard disk drive to store data so that there is more free memory on her laptop's hard disk drive
B) Save all her data on a DVD so that the space on her hard disk drive is completely available to run her applications smoothly
C) Increase the RAM on her laptop so that more space for temporary storage of data is available,hence,increasing the performance
D) Replace her hard disk drive with one that provides lesser storage capacity so that the amount of memory available is optimal and performance is increased
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
18
Jack needs a convenient way to browse the Internet,read emails,and store basic data when he travels.Which of the following would be the best option for him?
A) He should be using an all-in-one computer.
B) He should always find a desktop computer.
C) He should make sure to bring a tablet.
D) He should be sure to carry his laptop.
A) He should be using an all-in-one computer.
B) He should always find a desktop computer.
C) He should make sure to bring a tablet.
D) He should be sure to carry his laptop.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
19
Manny copied a table from a MS Excel file,closed the file,and then pasted the table in an MS Word document.Where did the copied table get stored after he copied it?
A) In the ROM
B) In the RAM
C) In the ALU
D) In the core
A) In the ROM
B) In the RAM
C) In the ALU
D) In the core
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
20
Alex needs to email his graduation certificate to a prospective employer.He has only physical copies of the certificate.What device could he use to perform the task?
A) He should use a scanner,which would convert an image into an electronic file.
B) He should use a plotter to produce a high-quality image to send.
C) He should use a digital pen,which can help create an online image of his certificate.
D) He should use a projector to display the output.
A) He should use a scanner,which would convert an image into an electronic file.
B) He should use a plotter to produce a high-quality image to send.
C) He should use a digital pen,which can help create an online image of his certificate.
D) He should use a projector to display the output.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
21
Surya's computer monitor display does not seem to work despite repeated attempts to fix the issue.Which of the following is most likely to be causing display problems?
A) Faulty power or video cable
B) Improperly connected keyboard
C) Dysfunctional UPS
D) Power fluctuation
A) Faulty power or video cable
B) Improperly connected keyboard
C) Dysfunctional UPS
D) Power fluctuation
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
22
Alice stored a memory card in her wallet that had all the photographs of a recent trip she took.When she inserted the card into her laptop,her computer wasn't able to read it.Alice tried to access its contents on her other devices but could not.Based on this,which of the following is/are likely to be true?
A) Though the memory card may be damaged,its contents can be retrieved using a different device.
B) The memory card is damaged and storing it in a protective case could have avoided the damage.
C) The memory card is damaged and its contents are permanently lost.
D) All of her devices have faulty memory card slots and her memory card is not damaged at all.
A) Though the memory card may be damaged,its contents can be retrieved using a different device.
B) The memory card is damaged and storing it in a protective case could have avoided the damage.
C) The memory card is damaged and its contents are permanently lost.
D) All of her devices have faulty memory card slots and her memory card is not damaged at all.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
23
Rocco runs a software firm that creates database management systems for other businesses.How can he ensure that his employees' computers remain protected from viruses and other malware?
A) He should have additional RAM installed on all the computers.
B) He should have the hard disks on all the computers defragmented periodically.
C) He should have periodic anti-virus scanning and software upgraded on all computers.
D) He should have the hardware components like the monitor,keyboard,and CPU vents periodically cleaned.
A) He should have additional RAM installed on all the computers.
B) He should have the hard disks on all the computers defragmented periodically.
C) He should have periodic anti-virus scanning and software upgraded on all computers.
D) He should have the hardware components like the monitor,keyboard,and CPU vents periodically cleaned.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
24
What printer is commonly used to produce high-quality professional drawings such as architectural blueprints?
A) Ink-jet printer
B) Laser printer
C) Plotter
D) Mobile printer
A) Ink-jet printer
B) Laser printer
C) Plotter
D) Mobile printer
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
25
What could cause an external drive,like a USB flash drive,to not be recognized when plugged into a computer?
A) A faulty port
B) A dusty computer vent
C) Insufficient space on the hard disk drive
D) An issue with internet connectivity
A) A faulty port
B) A dusty computer vent
C) Insufficient space on the hard disk drive
D) An issue with internet connectivity
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
26
When should a user consider restoring the operating system?
A) When the programs or apps do not start properly
B) When the monitor does not display anything
C) When the system slows down
D) When the internet does not connect
A) When the programs or apps do not start properly
B) When the monitor does not display anything
C) When the system slows down
D) When the internet does not connect
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
27
What is the correct way to update a device driver?
A) Run the update within the OS or the latest software from the device manufacturer's website.
B) Replace the driver.
C) Run an update from a web browser.
D) Obtain the driver update from a friend,and run it from a USB Flash drive.
A) Run the update within the OS or the latest software from the device manufacturer's website.
B) Replace the driver.
C) Run an update from a web browser.
D) Obtain the driver update from a friend,and run it from a USB Flash drive.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
28
What is the first step to performing hardware maintenance?
A) Turn off the computer and remove its power source.
B) Install anti-virus software.
C) Disconnect all the input and output devices.
D) Disconnect the UPS and surge suppressor.
A) Turn off the computer and remove its power source.
B) Install anti-virus software.
C) Disconnect all the input and output devices.
D) Disconnect the UPS and surge suppressor.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
29
What determines the speed at which data travels?
A) Bus width
B) Clock speed
C) Instructions per cycle (IPC)
D) RAM capacity
A) Bus width
B) Clock speed
C) Instructions per cycle (IPC)
D) RAM capacity
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
30
A CPU converts the data entered through the keyboard into output displayed on the monitor.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
31
What device do e-learning applications usually use to help users with visual impairment read digital content?
A) Projector
B) Plotter
C) Motion-sensing controller
D) Voice synthesizer
A) Projector
B) Plotter
C) Motion-sensing controller
D) Voice synthesizer
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
32
What is the recommended solution if a computer performs slowly?
A) Uninstall the programs and apps that are not needed.
B) Install anti-virus software.
C) Install additional RAM.
D) Verify if the AC adapter is connected properly.
A) Uninstall the programs and apps that are not needed.
B) Install anti-virus software.
C) Install additional RAM.
D) Verify if the AC adapter is connected properly.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
33
Most computers can operate normally in extreme temperatures and withstand high humidity and power fluctuations.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
34
What devices do not need device drivers to be manually installed,and start to function as soon as they are connected to a computer?
A) Printers
B) Monitors
C) Plug-and-play devices
D) Video cards
A) Printers
B) Monitors
C) Plug-and-play devices
D) Video cards
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
35
Which of the following is a game controller that is held with both hands and used to control movement of on-screen objects by pressing buttons and moving hardware components?
A) Joystick
B) Gamepad
C) Digital Pen
D) Stylus
A) Joystick
B) Gamepad
C) Digital Pen
D) Stylus
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
36
Which of the following factors can affect processor performance of a CPU?
A) Clock speed
B) Bus width
C) Hard drive space
D) Number of peripheral devices connected
A) Clock speed
B) Bus width
C) Hard drive space
D) Number of peripheral devices connected
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
37
Which is the most suitable device to use in a classroom or a conference room to deliver presentations?
A) Printer
B) Voice synthesizer
C) Headset
D) Projector
A) Printer
B) Voice synthesizer
C) Headset
D) Projector
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
38
What performance specification does 2 GHz refer to?
A) Speed at which the processor executes instructions
B) Speed at which data travels
C) Time taken to fetch and decode instructions
D) Time taken to store the instructions on RAM
A) Speed at which the processor executes instructions
B) Speed at which data travels
C) Time taken to fetch and decode instructions
D) Time taken to store the instructions on RAM
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
39
It is advised to fully charge the battery of a laptop before using it for the first time.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
40
Which type of a computer can be assembled using a monitor,a keyboard,a CPU,speakers,a printer and a mouse?
A) A laptop
B) An all-in-one computer
C) A desktop computer
D) A tablet
A) A laptop
B) An all-in-one computer
C) A desktop computer
D) A tablet
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
41
A device driver is a program that controls a device attached to the computer.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
42
What is the correct sequence of processing instructions in a machine cycle?
A) Fetch decode execute store
B) Fetch store decode execute
C) Fetch execute decode store
D) Decode fetch store execute
A) Fetch decode execute store
B) Fetch store decode execute
C) Fetch execute decode store
D) Decode fetch store execute
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
43
Which of the following is/are classified as input device(s)?
A) Webcam
B) Mouse
C) Touchpad
D) Speakers
A) Webcam
B) Mouse
C) Touchpad
D) Speakers
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
44
To resolve major computer issues,computer professionals often suggest restoring the operating system.Which of the following should happen before this step?
A) Disconnect all output devices.
B) Transfer contents to an external storage device.
C) Disconnect the UPS.
D) Remove the internal hard drive on which the operating system is stored.
A) Disconnect all output devices.
B) Transfer contents to an external storage device.
C) Disconnect the UPS.
D) Remove the internal hard drive on which the operating system is stored.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
45
Alessandro wants to use his desktop computer to video chat with his mother.What hardware does he need to accomplish this?
A) Use a webcam and scanner to ensure that the quality of the call is good.
B) Use his webcam and speakers so that he and his mother can both see and hear each other.
C) Use his keyboard,monitor,and speakers so that both he and his mother can see,hear,and even text each other.
D) Use his projector and webcam so that both he and his mother can clearly see and hear each other.
A) Use a webcam and scanner to ensure that the quality of the call is good.
B) Use his webcam and speakers so that he and his mother can both see and hear each other.
C) Use his keyboard,monitor,and speakers so that both he and his mother can see,hear,and even text each other.
D) Use his projector and webcam so that both he and his mother can clearly see and hear each other.
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
46
Which of the following is a necessary step in maintaining computer hardware?
A) Connecting peripheral devices to computer
B) Rebooting the computer often
C) Using a UPS or a surge processor
D) Cleaning air vents
A) Connecting peripheral devices to computer
B) Rebooting the computer often
C) Using a UPS or a surge processor
D) Cleaning air vents
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
47
Jennifer recently bought a new computer to type a new manuscript she's been working on.She also stored a lot of movies on it to watch during her free time.Though the performance was good at the beginning,it deteriorated quickly over a small period of time.Which of these is the most likely cause?
A) Declining free space on the hard drive
B) Declining clock speed of the core processor
C) Fault plug-n-play devices like USB flash drives
D) Dysfunctional AC adapter
A) Declining free space on the hard drive
B) Declining clock speed of the core processor
C) Fault plug-n-play devices like USB flash drives
D) Dysfunctional AC adapter
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
48
Which of these hardware components can you use to store videos?
A) External RAM
B) Floppy disk
C) Hard drive
D) Motherboard
A) External RAM
B) Floppy disk
C) Hard drive
D) Motherboard
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
49
Which of these is not an input device?
A) Stylus
B) Scanner
C) Printer
D) Webcam
A) Stylus
B) Scanner
C) Printer
D) Webcam
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck
50
Which of the following refers to a condition in which the CPU performs well but the bus speed is slow?
A) Bottlenecking
B) Clock speed
C) Reboot
D) Instructions per cycle (IPC)
A) Bottlenecking
B) Clock speed
C) Reboot
D) Instructions per cycle (IPC)
Unlock Deck
Unlock for access to all 50 flashcards in this deck.
Unlock Deck
k this deck