C10 Online Exam 1_02 SCORE 100 Percent
Question 1
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 2
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 3
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
D. 1 DDR fourth generation DIMMS
Question 4
You have just changed the system time within your computer's BIOS. You choose to save the settings upon exit. What happens next?
A. The computer will restart the boot process from the beginning.
B. The computer will immediately load the boot loader.
C. The computer will save the changes in the computer's registry also.
D. The computer will check for firmware updates on the Internet.
Question 5
Which type of device below would you most likely consider installing a SCSI disk in?
A. A server
B. A notebook
C. A laptop
D. A desktop
Question 6
What is the purpose of the boot loader during the boot-up process?
A. It finds the computer operating system and loads it into memory.
B. It scans the hard drives for disk errors that will prevent the OS from loading.
C. It loads the BIOS into memory to allow configuration changes to be made.
D. It scans the computer for malware and viruses to protect the BIOS.
Question 7
Which selection below has the greatest storage capacity?
A. 30 CDs
B. 2 DVD DLs
C. 7 DVDs
D. 1 BD
Question 8
Your mom wants to purchase a new tablet. She said she wants her new computer to be able to play her DVDs so she can listen to music and wants to know what type optical drives will play her disk. Which selection below will complete her answer?
A. A CD or DVD drive
B. A DVD or BD drive
C. A CD, DVD, or BD drive
D. A DVD or DDR drive
Question 9
You want to set up your computer so that it attempts to boot from your USB drive before it boots from the internal hard drive. Where would you configure this?
A. Windows Control Panel
B. Windows Computer Manager
C. Computer BIOS
D. The CPU Control Application
Question 10
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 11
Data for which there is temporarily no room in RAM is diverted to where on your computer?
A. The paging file on the hard drive
B. The system file on the hard drive
C. The memory file on the hard drive
D. The CPU cache
Question 12
How does the POST process alert the user if it detects a hardware problem during the POST process?
A. It flashes a report on the screen displaying what the problem is.
B. It emanates a series of beeps which point to a certain type of error.
C. It signals the hard drive LED to begin flashing an error signal.
D. The computer will immediately power off to avoid a potential short.
Question 13
Why is the iPad NOT considered to be an enterprise-worthy device?
A. It doesn't support SATA drives.
B. Not enough technicians are trained for them.
C. It doesn't support multi-user environments.
D. It only uses the Apple protocol
Question 14
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 15
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
Question 16
What type of device is characteristic of an enterprise environment?
A. A workstation used by a retired person
B. A workstation used at an engineering firm
C. A tablet computer used by an elementary school student
D. A notebook used by a college student
Question 17
The different types of DDR modules are easily identifiable because of what factor?
A. Each module has a different length.
B. Each module has a notch located in a different place.
C. Each module is a different industry-standardized color.
D. Each module has a different length.
Question 18
Which type of USB connector is always plugged into the computer to connect an external device?
A. Type A
B. Type B
C. Micro
D. Mini
Question 19
What is the transfer rate of DDR memory?
A. 16 bit
B. 32 bit
C. 64 bit
D. 128 bit
Question 20
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.
C10 Online Exam 2_03 Score 100%
Question 1 of 20
5.0 Points
You are running Windows 8 on your laptop. You install a 64-bit application on it. Where will this application reside on your computer?
A. In the Windows folder
B. In the Windows Applications folder
C. In the Windows (64) folder
D. In the Program Files folder
Question 2 of 20
5.0 Points
Your dad has downloaded an application from the Internet. He calls you up and says he is unable to uninstall the application. He says the file he downloaded has an ISO extension. What do you tell him?
A. Tell him to extract the file using 7-zip.
B. Tell him to open the file using Adobe Reader.
C. Tell him to right-click on the file and select Install.
D. Tell him to open the file using Adobe Flash.
Question-3
Question 3 of 20
5.0 Points
Your dad just gave you his old computer running Windows 7. You want to see how many volumes are contained within it. Which tool would be best-suited for this?
A. Task Scheduler
B. Disk Management
C. Event Viewer
D. Performance Monitor
Question 4 of 20
5.0 Points
You are viewing the desktop of a Windows 8 machine. You want to get back to the Start Screen to access your Tiles. How do you do this?
A. Hit CTRL + ENTER
B. Hit SHIFT + ENTER
C. Point the mouse in the bottom left-hand corner.
D. Point the mouse in the upper right-hand corner.
Question 5 of 20
5.0 Points
You call the help desk to report a problem you are having on your computer. The technician asks you what operating system you are running. You know it is Windows 7 but you forget which version. How can you find out?
A. Administrator Tools
B. System Properties
C. Start Menu
D. Control Panel Properties
Question 6 of 20
5.0 Points
You dad has given you his old digital scanner for your new computer. You plug it into the USB drive on your Windows 8 computer but it fails to install. What is the problem most likely?
A. You can't install external hardware devices over a USB connection.
B. Your computer doesn't have a driver to match the scanner.
C. The scanner is a 64-bit device.
D. The scanner doesn't support NTFS volumes.
Question 7 of 20
5.0 Points
The command prompt found on Windows 7 and Windows 8 is very similar to the interface of what past operating system?
A. DOS
B. Windows 95
C. Windows 98
D. Windows NT
Question 8 of 20
5.0 Points
Your mom is trying to save room on her hard drive and wants to uninstall some of her applications. She asks you how to do this. What do you tell her?
A. Find the application folder in Windows Explore and select Uninstall from the context menu.
B. Right-click on the application execution file and select Delete from the context menu.
C. Go to Task Manager and find the listed application, then right-click on it and select Uninstall.
D. Go to Programs and Features and find the listed application. Then right-click on it and select Uninstall.
Question 9 of 20
5.0 Points
A user calls your help desk to report that the files on her USB stick do not have any permissions associated with them and therefore aren't secure. Why is this?
A. The USB stick is formatted with FAT 32.
B. The USB stick is formatted with FAT 64.
C. The USB stick is formatted with NTFS
D. There is no way to enforce security on a USB.
Question 10 of 20
5.0 Points
Which Microsoft operating system started the process of authenticating users with a username and password?
A. Windows XP
B. Windows 95
C. Windows 98
D. Windows NT
Question 11 of 20
5.0 Points
Which of the selections below is the most secure password?
A. secretpasswords
B. mypa$$word
C. mypa$$worD
D. pa$$worD135
Question 12 of 20
5.0 Points
Your boss is considering a BYOD program for your company. He asks you if there are any negatives to such a program. What do you tell him?
A. It limits the freedom of the user to access websites and applications.
B. It introduces security and control problems.
C. It requires multiple licenses for each computing device.
D. It limits the selection of computers to just a single device.
Question 13 of 20
5.0 Points
Your company has 1,500 desktop computers running Windows 7. You want to upgrade them to Windows 8. Which type of Microsoft license would be best-suited in this situation?
A. Microsoft Volume Licensing
B. Microsoft Perpetual Licensing
C. Microsoft Enterprise Licensing
D. Microsoft Business Licensing
Question 14 of 20
5.0 Points
A user is trying to delete a file located on an NTFS volume on his Windows 8 computer but is unable to do so. Why is this?
A. He is being prevented by FAT32 permissions.
B. He does not have the Modify permission.
C. He does not have the Write permission.
D. He is being restricted by the Full Control permission.
Question 15 of 20
5.0 Points
Which logging category does not appear in Event Viewer by default?
A. Application
B. System
C. Volume
D. Security
Question 16 of 20
5.0 Points
How do you access the context menu for a desktop shortcut or a file in Windows Explorer?
A. Right-Click on it.
B. Left-Click on it.
C. Highlight it and hit Enter.
D. Highlight it and hit Ctrl.
Question 17 of 20
5.0 Points
You want to ghost your network's computers with a fresh desktop that features Windows 8, as your computers currently use Windows 7. You will use Norton Ghost to do this. What source will Norton Ghost utilize to install Windows 8?
A. The ISO installation file downloaded from the Internet
B. An image file featuring the Windows 8 operating system
C. The original factory DVD with the installation files for Windows 8
D. An MSI file created for the Windows 8 operating system
Question 18 of 20
5.0 Points
You need to install an operating system on a computer that will be sharing files for the company employees. You estimate there will be as many as 15 users accessing these files at one time. Which operating system below is ideally suited for this machine?
A. Windows 8 Home 64-Bit Edition
B. Windows 7 Professional 32-Bit Edition
C. Windows 7 Professional 64-Bit Edition
D. Windows Server 2003 Standard Edition
Question 19 of 20
5.0 Points
What is the primary way to access applications in Windows 8?
A. Control Panel
B. Start Menu
C. Desktop Tiles
D. Context Menu
Question 20 of 20
5.0 Points
Which of the selections below is not a benefit of imaging the computers on your network?
A. It saves the time of having to install the required computer applications.
B. It saves the time of having to install the desired operating system.
C. There are fewer licensing fees because the OS is only installed once.
D. It helps to lessen the impact of spyware on the network.
C10 Online Exam 3_05 Score 100%
Question 1 of 20
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 2 of 20
5.0 Points
Your boss calls you from his home to use the VPN connection you configured 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?
A. The firewall on his home router must be blocking the remote connection.
B. His ISP must not allow encrypted connections through their network.
C. He must be running Windows 8 which doesn't support VPN.
D. VPN doesn't bring up a remote desktop on the local computer.
Question 3 of 20
5.0 Points
You have set up Remote Desktop for the company server running Server 2008 so that your users can RDP in from their XP workstations. Users are calling you saying that they are being denied the ability to remote in. What is the most likely reason?
A. XP does not support Remote Desktop by default.
B. Network Level Authentication is being enforced on the RDP connection.
C. Server 2008 does not support Remote Desktop by default.
D. Remote Desktop only works through a web browser over the Internet.
Question 4 of 20
5.0 Points
You have a Bluetooth headset that integrates with your computer so that you can talk to partners through Microsoft Lync. This is an example of what type of wireless networking?
A. WLAN
B. WPAN
C. WMAN
D. WWIRE
Question 5 of 20
5.0 Points
Your boss wants you to configure 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?
A. Only mouse clicks and keyboard commands are transferred over the connection.
B. All traffic that flows between the laptop and VPN server is encrypted.
C. All of the tasks your boss will do will be on the desktop of the remote computer.
D. VPN integrates with NTFS so that only secure files are opened and modified.
Question 6 of 20
5.0 Points
Your sister is considering purchasing a tablet computer that utilizes RT as the operating system. She asks you if RT is any different from her Windows 8 desktop she has at home. What do you tell her?
A. Unlike her Windows 8 PC, RT does not have a tile-based interface.
B. RT is an Android-based operating system so it is completely different.
C. RT isn't touch-enabled so it is a poor choice for a tablet.
D. She won't be able to install regular Windows application on RT.
Question 7 of 20
5.0 Points
Your boss wants you to devise a way for remote contractors to be able to access the server desktop. There is one stipulation, however, in that your boss wants to ensure that the local user can see everything that the remote contractor is doing in real time. What do you suggest?
A. Install TeamViewer on the server.
B. Configure a VPN connection on the server.
C. Install GoToMyPC on the server.
D. Configure RDP within the server's web browser.
Question 8 of 20
5.0 Points
When you connect to a remote VPN server with your laptop running Windows 8, what key item is your computer allocated?
A. The desktop of the VPN server
B. The desktop of the logon server
C. An IP address from the remote network
D. A web browser with an SSL connection
Question 9 of 20
5.0 Points
Your boss calls you from the road. She is trying to connect to the local hotel guest wireless network but there is a yellow shield displayed beside that particular wireless selection. She is asking you what that shield means. What do you tell her?
A. It means the connection is not being broadcasted.
B. It means the connection is an open connection.
C. It means her wireless card doesn't support that connection.
D. It means the wireless connection requires a password.
Question 10 of 20
5.0 Points
You are the IT Manager for a school system. You just went with a new application that teachers will use to record the attendance of their students as well as their grades. The application is hosted by a third party, and teachers access the application through their web browsers. 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 Windows 8 can't find a driver for the scanner
D. Software as a Service
Question 11 of 20
5.0 Points
How does fractional employment differ from the traditional full-time job model of today?
A. Fractional employment demands complete mathematical skills.
B. A work unit in fractional employment is a project or task, not a job.
C. Fractional employment only employs people from outside the United States.
D. Fractional employment is exclusively for IT workers.
Question 12 of 20
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 13 of 20
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-14
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?
A. A laptop
B. A tablet
C. A PC
D. A netbook
Question 15 of 20
5.0 Points
Which of the following is a proper use of the application, NetStumbler?
A. Finding rogue access points within your network
B. Managing multiple access points within a large network
C. Disguising designated broadcast SSIDs on your network
D. Creating open-ended wireless connections for easy access
Question 16 of 20
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 17 of 20
5.0 Points
You have purchased an Apple desktop computer and want to set it up so that you can access your computer desktop when you are on the road. How might you do this?
A. Install Remote Desktop for Apple on your desktop.
B. Install Apple+ VPN on your desktop.
C. Configure your desktop for Platform as a Service.
D. Install the GoToMyPC client on your desktop.
Question 18 of 20
5.0 Points
Making a phone call through Lync from your laptop using only your headset is an example of:
A. a PBX phone connection.
B. an encrypted phone conversation.
C. a legacy phone conversation.
D. a peer-to-peer phone conversation.
Question 19 of 20
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 20 of 20
5.0 Points
In order for your laptop to make a wireless connection, it must first find an available __________ to connect to.
A. SSID
B. VPN
C. RSAT
D. WEP
C10 Online Exam 5_08 Score 97.5 percent
Question 1
Your boss has asked you to edit a document she just created. You want to be able to make suggestions to the document without directly altering any of the text your boss has written. How do you do this?
A. Use the Spelling and Grammar function.
B. Insert comments into the document.
C. Use Microsoft OneNote.
D. Insert a screenshot into the document.
Question 2
A start-up company has hired you to implement an email strategy for its organization. The company wants all of its employees to have an enterprise-level email client and is considering Windows Live. They ask you if there are any limitations about this email solution. Which selection below is a major limitation?
A. Windows Live can't insert signatures.
B. Windows Live can't blind copy recipients.
C. Windows Live can't use the IMAP protocol.
D. Windows Live has limited Exchange Server integration.
Question 3
You are creating a document for your students at school using Word 2013. You are concerned that some of your students have older versions of Word. How can you ensure that your students can open up these Word files in older versions of Word?
A. Save them as a template.
B. Create the document with a template.
C. Save them as .doc files.
D. Save them as .docx files.
Question 4
When would you use a template when working with Word 2013?
A. When you want to create a document that will be saved to the cloud
B. When you want to create a document that will work in Google Docs
C. When you want to create a document that will work in Office 2010
D. When you want to create a document from a ready-made design
Question 5
You mom calls you up. She is creating a book of poetry. Many of these poems only take up the first half of a document. She asks you if there is a way to skip to a new page without having to constantly hit the Enter Key. What do you tell her?
A. Have her create a Page Break by pressing Ctrl+Enter.
B. Have her create a Page Break by pressing Shift+Enter.
C. Have her create a Page Insert by pressing Ctrl+Enter.
D. Have her create a Page Insert by pressing Shift+Enter.
Question 6
Your sister wants to purchase Microsoft Office 2013 for her new laptop. She doesn't want to pay for a subscription and she wants to pay the least amount of money possible. The applications she plans on using are Word, Excel, and Outlook. Which version of Office do you recommend for her?
A. Office Home and Student
B. Office Home and Business
C. Office Professional
D. Office 365
Question 7
You are considering upgrading your Office 2010 to Office 2013. Which of the selections below is not true of either Office 2010 or 2013?
A. Office 2013 can integrate directly with the cloud.
B. Word 2010 can edit PDF files.
C. Office 2010 is not touch-friendly.
D. Office 2013 is more supportive of multiple monitors.
Question 8
Your brother is interested in using Apache OpenOffice as an office productivity suite. He asks you what the advantages are of this application. You list several of them except for which of the following?
A. It is free.
B. It can read Word Files.
C. It can edit Excel files.
D. It has a subscription service.
Question 9
Your boss is trying to modify a PDF file that he made a year ago. He asks you what he can use to do this. Which of the selections below will not allow him to edit this file?
A. Word 2010
B. Office 2013
C. Adobe Acrobat
D. Nuance PDF Converter
Question 10
An employee is setting up an Outlook email account and calls the help desk asking what to put for the incoming mail server. What is the answer?
A. The fully qualified domain name of the mail server
B. The IP address of the mail server
C. The protocol used by the mail server
D. The webmail address used by the webmail server
Question 11
You are writing up a contract agreement for a new work assignment you just got with a local business. You want to create the document so that when you send it to the client, the client can't alter it. How can you do this?
A. Save it as a DOCX file.
B. Save it as a DOTM file.
C. Save it as a PDF file. (Incorrect)
D. Save it as an RTF file.
Question 12
The name of the company you work for has recently changed. Because of this, you will need to go through some of the company Word documents and change the name for every instance that the company appears within the document. What is the easiest way to do this?
A. Use the "Change Name" utility on the Reference tab ribbon.
B. Click the Search command on the Review tab ribbon.
C. Click the Search command on the Home tab ribbon.
D. Click the Replace command on the Home tab ribbon.
Question 13
Your boss calls you in a panic. He said he just deleted three paragraphs and doesn't know how to bring them back. What do you tell him?
A. Press Ctrl + U on the keyboard.
B. Press Ctrl + D on the keyboard.
C. Press Ctrl + Z on the keyboard.
D. Press Ctrl + Y on the keyboard.
Question 14
You told your sister about creating bullet points with Word 2013. She calls you and says that she created a list of six bullet points, but she can't stop creating more bullets because every time she hits the Enter key another bullet is created. She needs your help.
A. Tell her to hold the Shift key as she hits Enter.
B. Tell her to hold the Ctrl key as she hits Enter.
C. Tell her to hold the Alt button as she hits Enter.
D. Tell her to right-click the mouse as she hits Enter.
Question 15
You are training your employees how to save their documents in Word 2013. What menu path do you tell them to use?
A. Home, Save
B. Word, Save
C. File, Save
D. Review, Save
Question 16
Someone calls you at the help desk and complains that his spell-checker isn't working in real time as he types. How can you fix this problem?
A. Click the Review tab and check the box beside "Check Spelling as you Type."
B. Click the Review tab and select Options and then check the box beside "Check Spelling as you Type."
C. Click the File tab and check the box beside "Check Spelling as you Type."
D. Click the File tab and select Options and then check the box beside "Check Spelling as you Type."
Question 17
What type of Microsoft Server serves as an email server?
A. SQL Server
B. IIS
C. Exchange 2013
D. Directory Services
Question 18
Your daughter is trying to send a video file to all of her girlfriends, but most of her emails are being returned. She asks you for help. What do you tell her?
A. Tell her to blind-copy the video files to everyone.
B. Tell her to upload the file to a cloud drive and email the link to everyone.
C. Tell her to hold the CTRL key down when she clicks the Insert File icon.
D. Tell her to zip the file into a compressed file and send it to everyone.
Question 19
Your boss is very concerned about security for Word 2013. He wants to disable Macro settings within his Word documents. How do you instruct him to do this?
A. File, Options, Trust Center, Macro Settings "Disable all macros with notification"
B. Security, Options, Trust Center, Macro Settings "Disable all macros with notification"
C. File, Security, Trust Center, Macro Settings "Disable all macros with notification"
D. File, Options, Security, Macro Settings "Disable all macros with notification"
Question 20
What happens when you click "Reply All" for an email that you received?
A. A single email will be sent to the sender.
B. An email will be sent to everyone in your contacts.
C. An email will be sent to everyone on the email server.
D. An email will be sent to all recipients of the email.
Question 21
Which application is ideal to serve as an accompaniment to an oral sales presentation?
A. PowerPoint
B. Exel
C. OneNote
D. Access
Question 22
You click the spacebar during a PowerPoint presentation. What happens as a result?
A. The presentation stops.
B. The next slide is presented.
C. The first slide is presented.
D. The previous slide is presented.
Question 23
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 C7 appears.
C. The sum of cells A1 through B8 appears.
D. The sum of cells A1 through C8 appears.
Question 24
What is the danger of using too much animation in a PowerPoint presentation?
A. The files become too large.
B. The animated effects can overshadow the content.
C. The slides take too long to play out.
D. Animated slides may not be compatible with older versions of PowerPoint.
Question 25
What third-party application serves as an alternative to OneNote?
A. Access
B. Visio
C. Project
D. Evernote
Question 26
What is the purpose of using templates in PowerPoint?
A. Integrates animation and audio automatically
B. Inserts a consistent look and format to the entire presentation
C. Inserts the required formulas automatically into the presentation
D. Imports fonts and images from CSV files for the presentation
Question 27
OpenOffice has an application that is similar to Excel called:
A. Math.
B. Worksheet.
C. Calc.
D. Evernote.
Question 28
Most of the slides used in a PowerPoint presentation are:
A. content slides.
B. title slides.
C. graphic slides.
D. template slides.
Question 29
You want to create a chart in Excel illustrating the sales growth of your company over the past 10 years. Which graph would be ideal for this?
A. Cell Chart
B. Bar Chart
C. Pie Chart
D. Worksheet Chart
Question 30
You press the "P" key during a PowerPoint presentation. What happens as a result?
A. The presentation stops.
B. The next slide is presented.
C. The first slide is presented.
D. The previous slide is presented.
Question 31
Which option below represents a task that can be conducted in Excel through sorting?
A. Showing all cells that have a number that ends with a 5
B. Showing all cells that have nothing in them
C. Showing all cells that have the word "Widget" in them
D. Displaying the cells from smallest to largest
Question 32
What does the COUNT function do in Excel?
A. Shows the number of cells contained within a worksheet
B. Shows the number of active cells contained within a worksheet
C. Shows the number of formulas contained within a spreadsheet
D. Shows the number of entries within a selected range of cells
Question 33
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 34
How can you identify the Active Cell in Excel?
A. It is outlined in bold fashion.
B. The cell is filled in solid gray.
C. The data inside the cell is in red.
D. The data inside the cell is indented.
Question 35
What does the Screen Clipping function do in OneNote?
A. Creates a new blank OneNote file
B. Captures a screenshot of your computer screen
C. Captures a YouTube video for OneNote
D. Captures an audio file from Media Player for OneNote
Question 36
Where is data input by default?
A. Into cell A1
B. Into the active cell
C. Into the formula bar
D. Into the default data cell
Question 37
How do you change between worksheets inside an Excel Workbook?
A. Press the CTRL+W keys.
B. Hold the Windows Key and press the W key.
C. Click on a different sheet tab at the bottom.
D. Click the worksheet icon on the Home Ribbon.
Question 38
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 39
You are the manager of an independent rental car company. Which application below can aid you in inventorying the cars in your rental fleet?
A. Excel
B. OneNote
C. PowerPoint
D. Evernote
Question 40
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.
C10 Online Exam 7_10 Score 97.5 percent
Question 1 of 405.0 Points
Your laptop doesn't have a serial port. What type of connector will your laptop require?
A. USB
B. RJ45
C. RJ11
D. Console
Question 2 of 405.0 Points
You are trying to network two laptops together using an Ethernet cable but it isn't working. Which of the following selections might explain why it isn't working?
A. You are using an outdated CAT 3 cable.
B. You are using a straight-through cable.
C. You are using a crossover cable.
D. The wireless is interfering with the signal.
Question 3 of 405.0 Points
Your boss wants to know the address of the router that his computer is using. What do you tell him?
A. Find out what the default gateway is of his computer.
B. Find out what the DHCP server is for his computer.
C. Find out what address the RIP protocol is using.
D. Find out what the subnet mask is.
Question 4 of 405.0 Points
You need to know the MAC address of a Windows 8 computer. How can you accomplish this?
A. Look in the system properties.
B. Type ipconfig at a command prompt.
C. Type ipconfig/all at a command prompt.
D. Type arp –m at a command prompt.
Question 5 of 405.0 Points
You boot up a computer that has had network issues and immediately look at its ARP cache to see what MAC addresses it has resolved recently. You find out that the cache has very few addresses in it. How could this be?
A. The ARP cache was cleared when the computer was shut down.
B. The ARP cache is cleared every 15 minutes by default.
C. The HTTP protocol has become corrupted.
D. The computer has a virus attacking the ARP cache.
Question 6 of 405.0 Points
You are advising one of your neighbors about the HomeGroup feature of Microsoft. He wants to make sure that all of his computers support this feature. Which one of the operating systems below does not support HomeGroup?
A. Windows 7
B. Windows RT
C. Windows Vista
D. Windows 8
Question 7 of 405.0 Points
You want to use a terminal emulation program to terminal into a series of Cisco routers. You will be managing these devices remotely. What protocol should you use?
A. FTP
B. FTPS
C. SSH
D. Telnet
Question 8 of 405.0 Points
Your boss wants you to start making your own Ethernet cables to save the company money. What type of connectors will you need to order to make them?
A. NIC
B. E5
C. RJ11
D. RJ45
Question 9 of 405.0 Points
Your boss wants you to get certified in the area of managing and routing switches and routers. Which of the IT certifications below would satisfy this requirement?
A. Microsoft MCP
B. Microsoft MCSE
C. Cisco CCP
D. Cisco CCNA
Question 10 of 405.0 Points
You have just recently been hired as a consultant for a local company. The company has a domain with Active Directory. You are at a workstation and you want to see whether the computer is a member of the domain. Which of the selections below will allow you to do this?
A. Look in the Notifications area on the taskbar.
B. Type "domain /?" at a command prompt.
C. Look in the Computer Management screen.
D. Look in the System Properties.
Question 11 of 405.0 Points
Wendy calls the help desk and reports that she is unable to access her files that are stored on the server. The network is a Windows Domain with Active Directory. Wendy is logged on locally to her workstation that runs Windows 8. You remote into her machine and you can ping the file server. What is most likely the problem?
A. She is being denied access to the files on the domain server.
B. The NIC on her workstation is failing to do ARP requests.
C. The switch her workstation is connected to isn't working.
D. Windows 8 cannot be a member of a Windows domain.
Question 12 of 405.0 Points
Your Windows 8 computer is DHCP enabled. You want to find out what the IP address is for it. How do you do this?
A. Type IP /? at a command prompt.
B. Type IPCONFIG at a command prompt.
C. Look at the manual settings of the Network Interface Card.
D. Type DHCP at a command prompt.
Question 13 of 405.0 Points
Which protocol below is used by email clients to send email?
A. POP3
B. SMTP
C. FTP
D. RIP
Question 14 of 405.0 Points
Which of these devices can completely stop broadcasts from being passed on across the network?
A. An access point
B. A router
C. A switch
D. A hub
Question 15 of 405.0 Points
You recently purchased a brand new firewall for your network. Which port do you need to open in order to allow users to access the Internet?
A. 22
B. 53
C. 80
D. 3389
Question 16 of 405.0 Points
Your boss it trying to console into an old switch that he found in storage and wants to configure it. He asks you to describe what the serial port would look like. What do you tell him?
A. Look for a male connector with 7 pins.
B. Look for a female connector that accommodates 7 pins.
C. Look for a male connector with 9 pins.
D. Look for an RJ11 interface.
Question 17 of 405.0 Points
Which of the selections below is an example of a LAN?
A. The Internet
B. A fiber link connecting different Internet providers
C. A network within a single building location
D. A network comprised of offices in multiple states
Question 18 of 405.0 Points
You are running cable for a temporary network in a large auditorium. What is the maximum length you can have for the Ethernet cabling you are using?
A. 10 meters
B. 100 meters
C. 100 yards
D. 1,000 yards
Question 19 of 405.0 Points
You are the network administrator for a school system. Your boss informs you that she is thinking of implementing a BYOD program. She asks you if there are any disadvantages to BYOD. What do you tell her?
A. BYOD is far more expensive than the organization's supplying the computers.
B. BYOD is currently not supported by the Windows operating system.
C. BYOD is more difficult to support and manage for the IT department.
D. BYOD networks are not able to stop broadcasts from slowing down the network.
Question 20 of 405.0 Points
You have been contracted to design a network for a new business in your area. The business will have 25 computers, and security is very important. They want everyone to be able to share their files in one network storage location, and all of the computers in the network will run Windows. Which network model would be ideal for this situation?
A. Client/server
B. HomeGroup
C. Workgroup
D. Peer-to-peer
Question 21 of 405.0 Points
Which option below is an example of an HTML end tag?
A. <title>
B. <\title>
C. </title>
D. <TITLE>
Question 22 of 405.0 Points
What is the maximum upload speed you can get on an ISDL Internet connection?
A. 56 KB per second
B. 128 KB per second
C. 144 KB per second
D. 100 MB per second
Question 23 of 405.0 Points
You want your home page in your Internet Explorer browser to show multiple tabs so that you can access multiple websites. How can you do this?
A. Hit the ENTER key after each URL in the Home Page box.
B. Hit the TAB key after each URL in the Home Page box.
C. Hit the INSERT key after each URL in the Home Page box.
D. Insert a pipe symbol between each URL in the Home Page box.
Question 24 of 405.0 Points
Which protocol would you utilize to upload files to a web server?
A. TCP
B. IP
C. SMTP
D. FTP
Question 25 of 405.0 Points
You are staying at a hotel and you need to use the computers that are offered to guests in the business center. The computers run Windows 7 and use IE 9 as the default browser. The network policy at the hotel prevents guests from accessing Internet Options. You do not want other hotel guests who may use the computer after you to know where you went on the Internet. Which feature below will prevent users from viewing your Internet history?
A. Enable Protected Mode
B. Pop-up Blocker
C. Internet Security Zone
D. InPrivateBrowsing
Question 26 of 405.0 Points
Which of the selections below represents a Recursive Query?
A. A client asks a DNS server to resolve a domain name.
B. A client asks another client to resolve a domain name.
C. A DNS server asks a client to resolve a domain name.
D. A DNS server asks another DNS server to resolve a domain name.
Question 27 of 405.0 Points
You want to browse various job postings on the Internet from your employer's network. How can you browse these sites without creating a history within the web browser and ISP that your boss might be able to view?
A. Turn on "Enable Protected Mode" within the browser.
B. Use a public proxy site when surfing these ads.
C. Use a public DNS server when surfing these ads.
D. Issue a recursive DNS query before visiting the websites.
Question 28 of 405.0 Points
You want to configure IE 9 so that your browsing history is deleted every time you exit the web browser. Which tab within Internet Options contains this setting?
A. Home
B. General
C. Advanced
D. Security
Question 29 of 405.0 Points
Which version of IP offers users nearly limitless IP addresses?
A. IPv2
B. IPV4
C. IPv6
D. IPv8
You want to bundle your telephone and Internet services into one package from your local phone company. What type of Internet connection will they be offering?
A. DSL
B. Ethernet
C. T3
D. Cable
Question 31 of 405.0 Points
How is it possible to see the HTML code of a website you are viewing in IE 10 on Windows 8?
A. Click View from the Menu Bar and select "Show HTML."
B. Click View from the Menu Bar and select "Show Tags."
C. Click View from the Menu Bar and select "Source."
D. Click View form the Menu Bar and select "Encoding."
Question 32 of 405.0 Points
You still have some XP computers in the network you manage. What is the highest version of Internet Explorer that you can run on those computers?
A. IE 7
B. IE 8
C. IE 9
D. IE 10
Question 33 of 405.0 Points
You need to obtain a public certificate for your new e-commerce site. Where would you go to apply for a trusted certificate?
A. Verisign.com
B. Wordpress.com
C. Megaproxy.com
D. Youtube.com
Question 34 of 405.0 Points
Wikipedia is an example of which version of the web?
A. Web 1.0
B. Web 2.0
C. Web 3.0
D. Web 4.0
Question 35 of 405.0 Points
Where do you access the setting configurations for a Proxy server within IE?
A. LAN Settings
B. WAN settings
C. Network settings
D. General settings
Question 36 of 405.0 Points
Look at the following URL and identify which part of it is optional if you wanted to type it into a web browser. http://www.microsoft.com/windows8
A. http:// This is incorrect. I think www. Is correct option.
B. www.
C. Microsoft
D. com
Question 37 of 405.0 Points
You need to choose a location within your network to install a web filter to keep your users out of undesirable websites. Which server would be ideal to host it?
A. A web-hosting server
B. A DNS server
C. A proxy server
D. An Active Directory server
Question 38 of 405.0 Points
Which web browser integrates directly with the Windows OS control panel to assign your default applications to designated file types?
A. Opera
B. Safari
C. Firefox
D. Internet Explorer
Question 39 of 405.0 Points
Which of the applications below is designed to help a user bypass enforced web-filtering policies?
A. Ultrasurf
B. Opera
C. DNS
D. WordPress
Question 40 of 405.0 Points
You have been hired to advise a local non-for-profit agency in your area about designing a web presence for them. They first need a domain name. What type of domain extension should they specify?
A. .com
B. .pub
C. .org
D. .info
C10; Introduction to Computers
Assignment 4: Business Start Up Proposal for Bill Wilson
Bill Wilson, a close friend of your family wants to start a business. A family member referred him to you since you are presently working on a technology related degree. In your first discussion, you discover the following facts:
· Bill has been a sales representative for a major restaurant supply company for many years.
· His prior skills are very low tech. He drove from city to city, visiting restaurants and either providing his customers with supplies, or visiting new restaurants to try and convince them to purchase supplies from him exclusively. He phoned in his orders to the manufacturer, and other than accounting for his expenses while on the road, he did little or no record keeping.
· Other than basic email skills and a some familiarization with Microsoft Word, Bill has little or no experience with existing communications technologies or software applications.
· Bill's business plan is to start a new restaurant supply business in his home. He wishes to spend more time at home and travel much less than he did in the past. He knows he will sometimes be required to travel to negotiate deals or meet with clients, but he would prefer to be able to do all this at home whenever possible.
Bill has already implemented the following actions:
ü He has found an accountant who has agreed to help him set up his accounting system. (Do not consider any accounting software for this assignment. The accountant will provide that.)
ü He has contacted six different restaurant supply companies and negotiated a fee and commission arrangement that will allow him to represent them and sell their products.
ü Bill understands the basic operation of Windows 7 and Microsoft Word. For any new software applications, be prepared to provide guidance on the appropriate training he can find locally or online.
Although Bill has minimal technical skills, he does know what he wants. You completed your first discussion with Bill, and the following information was provided by Bill or deduced by you:
o Budget: Bill has funds for the start up, but the budget has some limits. He doesn't want the fastest, biggest or best, but he will spend what it takes to have equipment that will suit his needs.
o Security: Bill has heard horror stories about computer information being hacked, and he wants your assurance that his business information will be secure if he follows your suggestions.
o Hardware: Bill knows of no special requirements for hardware, but he does know he will need to store somewhere between two and three terabytes of catalog information from the companies with whom he will be working. He needs to be able to access this info at all times from any location. He has no knowledge or preferences about hardware and says he will go with what you recommend.
o Operating System and Software: Bill feels comfortable with the Windows 7 environment, and prefers not to learn another operating system.
o The Cloud, Wi-Fi, Mobile Computing: Bill has no idea how these technologies tie in to his business, but he does know he needs to be able to do the following from his home office, from his car, or from any remote location: Check his email and compose/send emails at any time, place a supplies order via the Internet to any of his suppliers, be able to answer phone calls, and be able to set up video conferencing phone calls.
The Proposal:
Prepare and submit a written proposal to Bill that gives your suggested solution to his business plan. This report is to be written to Bill. DO NOT write your report to your instructor and talk about Bill. DO NOT speak about Bill in the third person. Write this proposal as a professional business letter directly to Bill. Provide Bill with the details of what he needs to purchase in order to have what he needs to conduct his business using today's technology. Make sure you include the following items in your report:
1. Hardware: What items of hardware (computer, laptop, tablet device, telephone, etc.) should Bill purchase. For items like a computer, include minimum specifications for all major internal components. Justify the need for any major hardware items recommended.
2. Operating System: With the recommended hardware, what operating system choices are available and which would be best? Why?
3. Other Technologies: How will Bill handle communications and mobile computing? Include the details on any peripheral devices and technologies that you propose ("The Cloud", mobile computing devices, Bluetooth, wireless networking, etc.) and explain how they fit into the business plan.
4. Software & Training: List the software applications that should be purchased. Make sure you include at a minimum: Operating System, system utilities, such as defrag apps, virus and malware protection and any system utilities Bill might need. Include the training courses that Bill should attend to gain basic skills in the software packages you recommend.
5. Cost: Provide Bill with an estimated cost for him to implement all of your suggestions. Give an estimate for the individual components and applications, and an approximate cost for all of the items you suggest.
Your proposal will be evaluated using the rubric below. Make sure you read the rubric and have a clear idea of what is expected. If there are any additional questions that you would like to ask Bill, you may also address a memo to "Bill" by posting it in the Week 4 area of the online Forum. Your instructor will answer these memos as Bill might. And all students will be able to see any information posted.
DELIVERABLE: Submit your Business Proposal to your instructor, in the Assignment section of the site, as a Word document.
C10; Introduction to Computers
Assignment 8; Business Consulting
Remember Bill Wilson? He was the gentleman that you helped to start up his restaurant supply business in week 4. Well his business is doing well, but he has come to you with some questions, concerns and a request to assist him in expanding his business. You discuss each of these with Bill and promise to send him a written report with your suggestions and recommendations. Submit your written response to Bill's questions and concerns below.
1. Bill has set up a spreadsheet in Excel that will help him keep track of expenses. So far, he has this:
Tell Bill how to do the following tasks:
· What formula or function does he put in Column F, from cells F5 to F11 that will show the total expenses for each day?
· What formula or function does he put in columns B through F in Row 13 that will give him the total expenses for the week in each category?
· Bill wants the entry in Column G to remind him of expenses that require receipts for the accountant. Tell Bill what to put in Column G, Rows 5 through 11, to do this:
a. Print the word "Yes" in any row of Column G where the total daily expenses in Column F are greater than or equal to $100.00.
b. If the daily expenses total in Column F is less than $100.00, leave the Column G entry for that row blank.
2. Bill's business is already expanding. He thinks that in a few weeks, he will need to hire one or two employees to help him. He knows that each new employee will need their own computer. He is also making the necessary changes so that the new employees will be working in a spare room in Bill's house. Explain to Bill what networking options are available to him. Go through each type or configuration of network possible for him, making sure that you explain the pros and cons of each configuration. Finish with your suggestion for the network that he should set up and explain what new hardware will be required to do this.
3. Bill wants to know what training would be appropriate for himself and his employees.
4. With the possibility of three business computers in his home, and all of his business records possibly vulnerable, this would be a good time to advise Bill on how to set up a routine plan to protect and defend his new network. Provide a list of the five most important concerns for safety and security of the network and the computers in the network. For each concern, specify the action to be taken, and if applicable, what software you recommend be added to the system. Justify each of your recommendations.
DELIVERABLES: For this assignment, there are two deliverables:
1. Your written proposal to Bill in a Word document.
2. An Excel spreadsheet containing the required formulas/functions in the cells shown in the table below. If you do not have Excel, you may type your formulas/functions into the table below and cut and paste this table into your proposal.
|
| A | B | C | D | E | F | G | H |
| 1 |
|
|
|
|
|
|
|
|
| 2 |
|
|
|
|
|
|
|
|
| 3 |
|
|
|
|
|
|
|
|
| 4 |
|
|
|
|
|
|
|
|
| 5 |
|
|
|
|
|
|
|
|
| 6 |
|
|
|
|
|
|
|
|
| 7 |
|
|
|
|
|
|
|
|
| 8 |
|
|
|
|
|
|
|
|
| 9 |
|
|
|
|
|
|
|
|
| 10 |
|
|
|
|
|
|
|
|
| 11 |
|
|
|
|
|
|
|
|
| 12 |
|
|
|
|
|
|
|
|
| 13 |
|
|
|
|
|
|
|
|
Your proposal will be evaluated using the rubric below. Make sure you read the rubric and have a clear idea of what is expected. If there are any additional questions that you would have asked Bill be sure to note them as you explain to Bill what networking options he has so that you can explain what additional information could change your suggestion if any.
C10 Week 1 Threaded Discussion
You told a relative that your computer was working a little slow, but otherwise fine, and you would like to upgrade some of the hardware. You tell the relative that you are considering the following:
1. Increase memory from 4GB to 8GB.
2. Replace your Hard Drive (HDD) with a Solid State Drive (SSD).
3. Get a larger monitor.
4. Replace the motherboard with a quad processor.
Your relative gives you some cash. You decide that with the available funds you can either:
a. Get any two of the first three options, or
b. Replace the motherboard only and not get any of the first three.
Choose either option 4, or pick any two of the first three. Which do you select and why?
C10 Week-3 Threaded Discussion Mobile Computing Environment Choices
Mobile Computing Environment Choices
You decide to start a home-based small business in your city. (Presume here that cost is not a large issue. You can afford to purchase the items that you deem the most beneficial.)
Review the available options. Compare and contrast the benefits of each, and p ick at least three of the services, software applications or technologies mentioned in the readings for this week that would be most beneficial in helping you build and run your new business.
Explain your reasoning behind each of your choices.
C10 Week-5 Discussion - Seven Every Day Spreadsheet Applications
In the reading for the week, there is a link to seven everyday spreadsheet applications that you can select to help you gain proficiency in the use of spreadsheets.
Here is the link: seven-everyday-applications
Review the seven possibilities. Select the two that most appeal to you and explain and discuss why you made those choices.
C10 Week 6 Threaded Discussion
You notice that you now have a number of devices in your home.
You have two desktop computers, two laptops, a printer and several mobile devices (iPhones, iPads, or similar devices.) None of these devices presently can communicate with other.
Based on your readings in this class and/or any other research you conduct, report to the class what you will do to "network" the devices in your home.
(If you have actually done this in the recent past, you can discuss your actual installation, instead of the hardware mentioned above.)
