Computer Fundamentals

Online Exam 5_05C Question 1 2.5/ 2.5 Points You create a formula that adds cells E4 through E19. Three of these cells are blank. What happens? A. Excel alerts you that the formula cannot be performed. B. Excel prompts you for data to input into the blank cells. C. The formula will assign an average value to the blank cells. D. The formula will assign a value of zero to the blank cells. Question 2 2.5/ 2.5 Points Which formula below will add up the numbers in cells A1 and A8? A. SUM(A1+D8) B. =SUM(A1,A8) C. =SUM(A1:A8) D. =SUM(D1+D5) Question 3 2.5/ 2.5 Points Which formula below will add up all of the numbers in cells D1 through D5? A. SUM(D1+D5) B. =SUM(D1,D5) C. =SUM(D1:D5) D. =SUM(D1+D5) Question 4 2.5/ 2.5 Points Which application is ideal to serve as an accompaniment to an oral sales presentation? A. PowerPoint B. Exel C. OneNote D. Access Question 5 2.5/ 2.5 Points You have created a slide for your PowerPoint presentation that you wish to simulate in all of the other slides. What is the easiest way to do this? A. Right-click on the slide and select Copy. B. Right-click on the slide and select “Create Template.” C. Right-click on the slide and select “Export Slide.” D. Right-click on the slide and select “Duplicate Slide.” Question 6 2.5/ 2.5 Points Which selection below represents an entry that would be seen in the active box? A. =sum(A1:A3) B. 15 C. (A1:A4) D. E11 Question 7 2.5/ 2.5 Points You are an inexperienced Excel user and don’t know how to create your own formulas. You want to use one of the preconfigured formulas but it doesn’t appear in the Formulas tab ribbon. What can you do? A. Click the Insert Formula icon on the Formulas tab ribbon. B. Click the Insert Formula icon on the Insert tab ribbon. C. Click the Formula Generator icon on the Formulas tab ribbon. D. Click the Formula Generator icon on the Insert tab ribbon. Question 8 2.5/ 2.5 Points You create a formula in A8 that adds up the numbers listed in A1 through A7. You copy the formula and paste it into C8. What happens in C8? A. The sum of cells A1 through A8 appears. B. The sum of cells C1 through C8 appears. C. The sum of cells A1 through B8 appears. D. The sum of cells A1 through C8 appears. Question 9 2.5/ 2.5 Points You have created a worksheet documenting sales over every quarter since the start of your company. Each column represents a quarter and each row represents a product you sell. Each cell contains the sales generated for that product. You want to find the highest sales figure for one of your products. Which formula will do this? A. Perform the MAX formula for one of the columns. B. Perform the MAX formula for one of the rows. C. Perform the AVERAGE formula for one of the columns. D. Perform the AVERAGE formula for one of the rows. Question 10 2.5/ 2.5 Points You press the “P” key during a PowerPoint presentation. What happens as a result? A. The presentation stops. B. The next slide is presented.

CIS | 100 | Computer Fundamentals | exam | Online Exam 5_05C Question 1 2

VPN doesn't bring up a remote desktop on the local computer. He hasn't enabled Remote Desktop on his Windows 8 computer. Question 1 5 / 5 points Your boss calls you from his home to use the VPN connection you conﬁgured for him on his laptop. He has traditionally depended on Remote Desktop to access the server. Your boss tells you that the VPN connection shows that it is connected but the server's desktop is not appearing on his screen. What do you tell him? Question options: His ISP must not allow encrypted connections through their network. He must be running Windows 8 which doesn't support VPN. The firewall on his home router must be blocking the remote connection. Question 2 5 / 5 points Your dad just purchased a new desktop with Windows 8 Professional. He is calling you, informing you that he is unable to remote into his new computer from the hotel he is at. What is the most likely reason for this? Question options: Remote Desktop only works through a local network. The Professional edition of Windows 8 does not support RDP. He is trying to remote in from a computer running Windows 7. Question 3 5 / 5 points You have a number of digital pictures you recently took on your smartphone. You would like to share these pictures with all of your friends and family. What is a "Cloud"-like example of sharing these pictures with them? Question options: Email them to everyone by way of email attachments. Save them to a fractional website that offers file transfer capabilities. Upload them to and share a link with them. A PC A tablet Save them to your My Pictures folder on your Windows 8 tablet. Question 4 5 / 5 points Your brother is a video producer and is looking to buy some sort of new computing device. He needs a lot of memory and processing power to edit the digital videos he works with. He also has a lot of external equipment he needs to connect to the computer, such as double monitors. Which type of computing device would you recommend to him to purchase? Question options: A tablet A netbook A laptop Question 5 5 / 5 points Your mom wants to purchase a computer. She has heard about how the Windows 8 operating system is best-geared for a touch-enabled computing device. What type of computer do you recommend that she purchase? Question options: A laptop A PC A netbook Question 6 5 / 5 points Your boss wants you to conﬁgure his laptop so that he can access the company network when he is on the road. You suggest a VPN connection to him. He is very concerned about security and asks you how secure VPN is. What do you tell him?

CIS | 100 | Computer Fundamentals | exam | VPN doesn't bring up a remote 

TEST_1docx.docx-Part 1 of 1 - 80.0/

Part 1 of 1 - 90.0/ 100.0 Points Question 1 of 20 5.0/ 5.0 Points Which of the operating systems below is able to join a domain? A. Microsoft Surface Pro B. Microsoft Surface RT C. Google Android D. iPad Question 2 of 20 5.0/ 5.0 Points Your mom wants to purchase a computer. She has heard about how the Windows 8 operating system is best-geared for a touch-enabled computing device. What type of computer do you recommend that she purchase? A. A laptop B. A tablet C. A PC D. A netbook Question 3 of 20 5.0/ 5.0 Points You are configuring a wireless connection on your home router. Because you live in an apartment complex, the security level of the connection is paramount. Which wireless option below is the most secure? A. SSID B. WEP C. WPA D. WPA2 Question 4 of 20 5.0/ 5.0 Points Your boss is very skeptical about the idea of storing his files up in the cloud rather than on a local storage drive. He asks you to give him the various advantages of cloud storage. Which of the selections below would not be a reason you give him? A. He won’t have to worry about backing up his files anymore. B. Cloud storage provides unlimited storage for free. C. He can keep all of his files replicated and uniform on all of his devices. D. He can access his files from anywhere he has an Internet connection. Question 5 of 20 5.0/ 5.0 Points You install TeamViewer on your workstation at home so that you can access it when on the road. How can you be assured that unknown users can’t access your computer through TeamViewer? A. They have to have the same encryption key as you. B. They have to know your User ID and password. C. They have to have a signed certificate by your computer. D. Their computer has to be in the same domain as yours. Question 6 of 20 0.0/ 5.0 Points Your company is trying to get out of the responsibility of purchasing and hosting its own hardware so it won’t have to finance or manage a datacenter anymore. Your boss has told you that you need to install an operating system on all of the cloud-based servers. This is an example of what type of cloud computing? A. Infrastructure as a Service B. Network as a Service C. Platform as a Service D. Software as a Service Question 7 of 20 5.0/ 5.0 Points Why isn’t 802.1X a good choice for home-based wireless networks? A. It only creates open wireless connections. B. It requires an authentication server. C. Its encryption is too easy to hack. D. It requires multiple access points. Question 8 of 20 5.0/ 5.0 Points Your CEO is concerned that too much productivity is lost by having employees call each other, only to be directed to voice mail. He asks you if something can be done to counter this. What do you suggest? A. Integrate Dropbox into the company network. B. Integrate RDP into the company network. C. Integrate Microsoft Lync into the company network. D. Integrate TeamViewer into the company network. Question 9 of 20 5.0/ 5.0 Points

CIS | 100 | Computer Fundamentals | exam | Part 1 of 1 - 90.0/ 100.0 Poin

Question 1 5.0/ 5.0 Points Your mother wants to purchase a larger hard drive for her computer and asks you to see what type of drive interface she has. Her computer is connected to the motherboard by a gray ribbon cable that encases 40 pins. What type of drive interface does she have? A. Solid State B. IDE or EIDE C. SATA D. SCSI Question 2 5.0/ 5.0 Points What type of maintenance is required of a computer’s power supply to ensure that it remains in working order? A. Clean the Molex cables regularly with a damp cloth. B. Regularly change out the NEMA 5-15 cord every 180 days. C. Statically discharge the PSU every 180 days. D. Clean any dust or debris from the air vents in front of the fans. Question 3 0.0/ 5.0 Points Which type of device below would you most likely consider installing a SCSI disk in? A. A server B. A notebook C. A laptop WRONG D. A desktop Question 4 5.0/ 5.0 Points Your brother is always complaining how slow his computer is. What single action can he take that will provide him the biggest performance gain and make his computer faster? A. Purchase a power supply with greater wattage B. Purchase a faster processor C. Purchase more memory to double it D. Replace his HHD drives with SSD Question 5 5.0/ 5.0 Points What type of product does AMD manufacture? A. Power supply B. CPU C. Motherboard D. SATA drive Question 6 5.0/ 5.0 Points What type of memory or storage device is prone to losing data if the power goes out? A. A USB stick B. An External Drive C. A DDR SDRAM module D. A SATA drive Question 7 5.0/ 5.0 Points Where is the BIOS for your computer located? A. Within the CPU B. In the PSU C. In the Motherboard D. In the optical drive Question 8 0.0/ 5.0 Points You are shopping for a new computer. You see the memory listing as 1GBX4. What does this mean? A. 4 DDR first generation DIMMs B. 1 GB of memory made up of 4 DIMMs C. 4 GB of memory made up of 4 DIMMs WRONG D. 1 DDR fourth generation DIMMS Question 9 5.0/ 5.0 Points Your mom found some optical drives that are labeled as “R.” She asks you what that means. What do you tell her? A. The R indicates that the disks are Read Only. B. The R indicates that the disks are Radiant compliant. C. The R indicates that the disks can only be written to once. D. The R indicates that they are 3rd generation and take 64-bit only. Question 10 Which of the objects below is NOT powered by the PSU of your computer? A. A hard drive B. A printer C. A motherboard D. Memory

All courses in CIS

Popular Documents