Deck 3: Working With Large Worksheets, charting, and What-If Analysis

Question 1

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.

Answer 1

C

Question 2

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.

Answer 2

C

Question 3

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

Answer 3

B

Question 4

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

Question 5

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

Question 6

Which of these is an optical medium of storage?

A) Blu-ray discs
B) Solid state drive
C) Cloud storage
D) HDD

Question 7

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

Question 8

Where on a computer is the operating system generally stored?

A) RAM
B) Internal hard drive
C) Flash drive
D) Virtual memory

Question 9

A joystick is a pen-type input device used to draw and tap on icons.

Question 10

We can use Unicode coding scheme to support a larger variety of characters including Chinese,Japanese,and Arabic.

Question 11

All-in-one computers are easier to service and upgrade but occupy more space than desktop computers.

Question 12

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.

Question 13

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

Question 14

Peripheral devices,like a USB flash drive,are generally connected to your computer through ports.

Question 15

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

Question 16

In which format is data finally stored in computers?

A) Letters of English alphabet
B) Even numbers
C) Binary digits
D) Special characters

Question 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

Question 18

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.

Question 19

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

Question 20

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

Question 21

Which of these is not an input device?

A) Stylus
B) Scanner
C) Printer
D) Webcam

Question 22

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.

Question 23

Which of these hardware components can you use to store videos?

A) External RAM
B) Floppy disk
C) Hard drive
D) Motherboard

Question 24

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

Question 25

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

Question 26

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

Question 27

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.

Question 28

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.

Question 29

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)

Question 30

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

Question 31

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

Question 32

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

Question 33

A CPU converts the data entered through the keyboard into output displayed on the monitor.

Question 34

Most computers can operate normally in extreme temperatures and withstand high humidity and power fluctuations.

Question 35

It is advised to fully charge the battery of a laptop before using it for the first time.

Question 36

What determines the speed at which data travels?

A) Bus width
B) Clock speed
C) Instructions per cycle (IPC)
D) RAM capacity

Question 37

What is the correct sequence of processing instructions in a machine cycle?

A) Fetch $\rightarrow$ decode $\rightarrow$ execute $\rightarrow$ store
B) Fetch $\rightarrow$ store $\rightarrow$ decode $\rightarrow$ execute
C) Fetch $\rightarrow$ execute $\rightarrow$ decode $\rightarrow$ store
D) Decode $\rightarrow$ fetch $\rightarrow$ store $\rightarrow$ execute

Question 38

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

Question 39

A device driver is a program that controls a device attached to the computer.

Question 40

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.

Question 41

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.

Question 42

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