click below
click below
Normal Size Small Size show me how
CSC EXAM 2
Question | Answer |
---|---|
1. Which is an advantage of networking? a. Increased hardware costs b. Increased autonomy c. Centralized data management d. Increased privacy of network members | centralized data management |
What is the acronym for a computer network within a single residence? | PAN |
Which is a type of network topology? | star |
A ___________ is necessary to make the connection between a local area network and the Internet? | router |
Which of the following statements about peer-to-peer networks is true? | They perform best when connecting 10 or fewer computers. |
Encryption on a wireless network is activated by enabling _____________. | WPA |
7. Which is NOT a hardware device used to attach a device to a wireless network? a. PC card b. NIC c. USB adapter d. PCI card | USB Adapter |
8. Which of the following is a common contention-management technique? a. abandoning data corrupted by a collision b. retransmitting unreceived packets c. generating a new token d. adding terminators to minimize signal loss | abandoning data corrupted by a collision |
Which is a feature of packet switching? a. There is a direct connection between the communicating devices. b. All packets of a message are sent and received in order. c. Packets of a message are split up and reassembled at the destination device. d. | c. Packets of a message are split up and reassembled at the destination device. |
A(n) _____________ is a network device with software that manages network resources like files, e-mails, printers, and databases. | b. server |
1. What is the first step in planning an effective worksheet? | State the purpose of the worksheet. |
What Excel interface item is not displayed until you start typing or editing data in a cell? | Insert Function |
Given the formula =Bl*B2+B3/B4^2 where Bl contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result? | 14 |
Why would you press Ctrl+' in Excel? | To enable the AutoComplete feature |
Which of the following is a nonadjacent range? a. C15:D30 b. L15:L65 c. Al:Z99 d. Al:A10, Dl:D10 | Al:A10, Dl:D10 |
If you want to balance a title over several columns, what do you do? | Merge and center the data over all columns. |
Which of the following characteristics is not applicable to the Accounting Number Format? | Dollar sign immediately on the left side of the value |
If you want to see a preview of how a worksheet will appear on a hard copy, what do you do? | Click the File tab, and then click Print. |
Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page? | Increase the left and right margins. |
What should you do if you see a column of pound signs (###) instead of values or results of formulas? | Increase the column width. |
What is the technology that facilitates meetings that provide voice and video of individuals in different geographical locations? | Videoconferencing |
What communication medium musts have a direct line of sight? | Infrared |
Which wireless technology makes use of short-range radio transmission to connect devices within 30 feet of each other? | Bluetooth |
GPS systems track locations by using which of the following technologies? | Satellite |
Which is NOT a wired method of communication? | WiFi |
Which is an example of convergence? | A smartphone |
Which communication uses light to transmit media? | Fiber optics |
Which of the following is true of VoIP (Internet telephony)? | It is often cheaper than conventional home service. |
Which is NOT an example of a wireless transmission media? | Cable |
When someone makes a cellular phone call to aNOTher cellular phone, which of the following eventually handles the call? | Mobile Switching Center (MSC) |
If cell D15 contains the formula =$C$5*D15, what is the D15 in the formula? | Circular reference |
What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5? | =AVERAGE(B5:F5) |
When you type a function, what appears after you type the opening parenthesis? | Function ScreenTip |
A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location? | =$B5 |
Cell BI0 contains a date, such as 1/1/2012. Which formula will determine how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format? | =TODAY()-B10 |
Given that cells AI, A2, and A3 contain values 2,3, and 10, respectively, and B6, C6, and D6 contain values 10,20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6* Al,D6* A2)? | 90 |
Given the function =VLOOKUP(C6,D15:F18,3), the entries in: | Range D12:D18 are in ascending order. |
The function =PMT(C5,C7,-C3) is stored in cell CI5. What must be stored in cell C7? | Number of payment periods |
Which of the following is not an appropriate use of the SUM function? | =SUM(Dl5-C15) |
Which of the following is not an acceptable range name? | Goal for 2012 |
Which is a characteristic of a strong password? | The use of characters, both upper and lower case, numbers, and special characters |
Which is NOT a benefit of cookies? | They can be used to track a user’s browser activity. |
In public key encryption, which item is kept by the owner of the key? | Private Key |
Who is an individual that deliberately attempts to obtain unauthorized access to a computer or network system with the intent to do harm? | Cracker |
What is the process of observing the behavior of employees, including phone calls, e-mails, and Web browsing habits, with or without the aid of computers? | Employee monitoring |
Which of the following is an example of malware? | Time bombs |
What is a type of software program that records all the keystrokes a user enters—such as passwords, account numbers, or conversations—and relays them to others? | Keylogger |
Which is a form of malware that installs itself on the beginning tracks of a hard drive, where stored code is automatically executed every time you start the computer, and spreads the infection by simply starting the system? | Boot sector virus |
What is the name given to commandeered computers that are often used by botnets to distribute spam and malware? | Zombies |
Which is an online shopping and security standard for merchants and customers? | SET |
Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years? | Pie chart |
What is the typical sequence for creating a chart? | Select the data source, select the chart type, and then size and position the chart. |
Which of the following applies to a sparkline? | Single-cell chart |
If you want to show exact values for a data series in a bar chart, what chart element should you display? | Data labels |
The value axis currently shows increments such as 50,000 and 100,000. What do you select to display increments of 50 and 100? | Show Axis in Thousands |
You want to create a single chart that shows each of five divisions' proportion of yearly sales for each year for five years. Which type of chart can accommodate your needs? | 100% stacked column chart |
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend? | Click Switch Row/Column in the Data group on the Design tab. |
Which tab contains commands to apply a predefined chart layout that controls what elements are included, where, and their color scheme? | Design |
A chart and its related data source are located on the same worksheet. What is the default Print option if the chart is selected prior to displaying the Backstage view? | Print Selected Chart |
Which of the following is NOT a way to display the Format Data Series dialog box for the Arts data series in a column chart? | Press and hold Shift as you click each Arts column. |
Which statement about computer science is NOT true? | Computer science focuses on the technology needed to promote business success. |
Which certification is needed for an entry-level computer technician position? | A+ |
Which of the following is NOT a soft business skill? | Programming skill |
Which of the following statements about management information systems is true? | Finance and marketing skills, communication skills, and interpersonal skills are required for effective teamwork and leadership. |
Which of the following jobs in the Web technology industry designs, develops, tests, and documents new Web-based services for Web sites? | Web application engineer |
Which of the following is a high-end relational database product whose use is considered to be a sought-after technical skill today? | Oracle |
Which of the following is NOT an example of an Internet-based method of training discussed in this chapter? | Trade show |
Which statement is true about an IT professional? | IT professionals continually have to learn new technologies. |
Who manages the details of a software development project? | a. Software Engineer |
Which of the following is a valid certification? | Microsoft Certified IT Professional (MCITP) |
You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confidential information is not printed. You should apply all of the following page setup | Change the print page order. |
You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns X, Y, and Z | Freeze Panes command |
Which statement is not a recommended guideline for planning a table in Excel? | Leave one blank row between records in the table. |
You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highes | Branch office is the primary sort and should be in A to Z order. |
You suspect a table has several identical records. What should you do? | Use the Remove Duplicates command. |
Which check box in the Table Style Options group enables you to apply different formatting to the records in a table? | Banded Rows |
Which date filter option enables you to specify criteria for selecting a range of dates, such as between 3/15/2012 and 7/15/2012? | Between |
You want to display a total row that identifies the oldest date in a field in your table. What function do you select from the list? | min |
What type of conditional formatting displays horizontal colors in which the width of the bar indicates relative size compared to other values in the selected range? | Data Bars |
When you select the _________ rule type, the New Formatting Rule dialog box does not show the Format button. | Format all cells based on their values |