Question 1

What performance specification does 2 GHz refer to?

Accepted Answer

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

Question 2

Which type of a computer can be assembled using a monitor,a keyboard,a CPU,speakers,a printer and a mouse?

Accepted Answer

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

Question 3

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?

Accepted Answer

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.

Question 4

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 5

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 6

What is the first step to performing hardware maintenance?

Accepted Answer

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.

Question 7

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 8

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?

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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 14

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?

Accepted Answer

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.

Question 15

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 16

In which format is data finally stored in computers?

Accepted Answer

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

Question 17

Which is the most suitable device to use in a classroom or a conference room to deliver presentations?

Accepted Answer

A)  Printer 
B)  Voice synthesizer 
C)  Headset 
D)  Projector 
A)  Printer 
B)  Voice synthesizer 
C)  Headset 
D)  Projector

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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?

Accepted Answer

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.

Question 20

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

Accepted Answer

A) True 
 B)False

What performance specification does 2 GHz refer to?

Which type of a computer can be assembled using a monitor,a keyboard,a CPU,speakers,a printer and a mouse?

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?

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

Which of these is not an input device?

What is the first step to performing hardware maintenance?

What determines the speed at which data travels?

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?

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

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

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

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

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

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?

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?

In which format is data finally stored in computers?

Which is the most suitable device to use in a classroom or a conference room to deliver presentations?

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

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 device driver is a program that controls a device attached to the computer.

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 performance specification does 2 GHz refer to?

Which type of a computer can be assembled using a monitor,a keyboard,a CPU,speakers,a printer and a mouse?

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?

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

Which of these is not an input device?

What is the first step to performing hardware maintenance?

What determines the speed at which data travels?

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?

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

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

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

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

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

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?

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?

In which format is data finally stored in computers?

Which is the most suitable device to use in a classroom or a conference room to deliver presentations?

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

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 device driver is a program that controls a device attached to the computer.

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