Question 1

What is the correct way to update a device driver?

Accepted Answer

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.

Question 2

In which of the following storage device(s) does memory need to be constantly recharged to retain the contents?

Accepted Answer

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

Question 3

To resolve major computer issues, computer professionals often suggest restoring the operating system. Which of the following should happen before this step?

Accepted Answer

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.

Question 4

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?

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

What determines the speed at which data travels?

Accepted Answer

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

Question 7

Which of the following refers to a condition in which the CPU performs well but the bus speed is slow?

Accepted Answer

A)  Bottlenecking 
B)  Clock speed 
C)  Reboot 
D)  Instructions per cycle (IP
C)  
A)  Bottlenecking 
B)  Clock speed 
C)  Reboot 
D)  Instructions per cycle (IP
C)

Question 8

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?

Accepted Answer

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.

Question 9

What devices do not need device drivers to be manually installed, and start to function as soon as they are connected to a computer?

Accepted Answer

A)  Printers 
B)  Monitors 
C)  Plug-and-play devices 
D)  Video cards 
A)  Printers 
B)  Monitors 
C)  Plug-and-play devices 
D)  Video cards

Question 10

Which of the following is a necessary step in maintaining computer hardware?

Accepted Answer

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

Question 11

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?

Accepted Answer

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.

Question 12

What printer is commonly used to produce high-quality professional drawings such as architectural blueprints?

Accepted Answer

A)  Ink-jet printer 
B)  Laser printer 
C)  Plotter 
D)  Mobile printer 
A)  Ink-jet printer 
B)  Laser printer 
C)  Plotter 
D)  Mobile printer

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Which of these is not an input device?

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

What are the two important components of CPU that help in processing the input into output?

Accepted Answer

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

Question 17

Which of the following is/are classified as input device(s)?

Accepted Answer

A)  Webcam 
B)  Mouse 
C)  Touchpad 
D)  Speakers 
A)  Webcam 
B)  Mouse 
C)  Touchpad 
D)  Speakers

Question 18

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?

Accepted Answer

A)  RAM 
B)  ROM 
C)  Cloud storage 
D)  Compact disk 
A)  RAM 
B)  ROM 
C)  Cloud storage 
D)  Compact disk

Question 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?

Accepted Answer

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

Question 20

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?

Accepted Answer

A)  Joystick 
B)  Gamepad 
C)  Digital Pen 
D)  Stylus 
A)  Joystick 
B)  Gamepad 
C)  Digital Pen 
D)  Stylus

What is the correct way to update a device driver?

In which of the following storage device(s) does memory need to be constantly recharged to retain the contents?

To resolve major computer issues, computer professionals often suggest restoring the operating system. Which of the following should happen before this step?

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 joystick is a pen-type input device used to draw and tap on icons.

What determines the speed at which data travels?

Which of the following refers to a condition in which the CPU performs well but the bus speed is slow?

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?

What devices do not need device drivers to be manually installed, and start to function as soon as they are connected to a computer?

Which of the following is a necessary step in maintaining computer hardware?

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?

What printer is commonly used to produce high-quality professional drawings such as architectural blueprints?

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

Which of these is not an input device?

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

What are the two important components of CPU that help in processing the input into output?

Which of the following is/are classified as input device(s)?

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?

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?

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?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Filters

Exam 3: Performing Calculations With Formulas and Functions

What is the correct way to update a device driver?

In which of the following storage device(s) does memory need to be constantly recharged to retain the contents?

To resolve major computer issues, computer professionals often suggest restoring the operating system. Which of the following should happen before this step?

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

What determines the speed at which data travels?

Which of the following refers to a condition in which the CPU performs well but the bus speed is slow?

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?

What devices do not need device drivers to be manually installed, and start to function as soon as they are connected to a computer?

Which of the following is a necessary step in maintaining computer hardware?

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?

What printer is commonly used to produce high-quality professional drawings such as architectural blueprints?

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

Which of these is not an input device?

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

What are the two important components of CPU that help in processing the input into output?

Which of the following is/are classified as input device(s)?

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?

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?

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?

Getting Started With Excel

Formatting Workbook Text and Data

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Filters