Question 1

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 D

Question 2

Which of these is an optical medium of storage?

Accepted Answer

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

Question 3

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 C

Question 4

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?

Accepted Answer

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

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

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

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

What could cause an external drive,like a USB flash drive,to not be recognized when plugged into a computer?

Accepted Answer

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

Question 11

Which of these,though not equally portable,is most powerful and usually easier to upgrade than others?

Accepted Answer

A)  Desktop computers 
B)  Tablets 
C)  Smartphones 
D)  Laptops 
A)  Desktop computers 
B)  Tablets 
C)  Smartphones 
D)  Laptops

Question 12

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 13

Alessandro wants to use his desktop computer to video chat with his mother.What hardware does he need to accomplish this?

Accepted Answer

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.

Question 14

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 15

Where on a computer is the operating system generally stored?

Accepted Answer

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

Question 16

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 17

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 18

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 19

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 20

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.

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

Which of these is an optical medium of storage?

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

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 game controller that is held with both hands and used to control movement of on-screen objects by pressing buttons and moving hardware components?

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

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

What could cause an external drive,like a USB flash drive,to not be recognized when plugged into a computer?

Which of these,though not equally portable,is most powerful and usually easier to upgrade than others?

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

Alessandro wants to use his desktop computer to video chat with his mother.What hardware does he need to accomplish this?

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

Where on a computer is the operating system generally stored?

What is the correct way to update a device driver?

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?

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?

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?

Creating a Worksheet and a Chart

Formulas, functions, and Formatting

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Post-Assessment

Pre-Assessment

Filters

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

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

Which of these is an optical medium of storage?

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

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 game controller that is held with both hands and used to control movement of on-screen objects by pressing buttons and moving hardware components?

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

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

What could cause an external drive,like a USB flash drive,to not be recognized when plugged into a computer?

Which of these,though not equally portable,is most powerful and usually easier to upgrade than others?

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

Alessandro wants to use his desktop computer to video chat with his mother.What hardware does he need to accomplish this?

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

Where on a computer is the operating system generally stored?

What is the correct way to update a device driver?

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?

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?

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?

Creating a Worksheet and a Chart

Formulas, functions, and Formatting

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Post-Assessment

Pre-Assessment

Filters