郑州大学远教计算机期末考试复习题及答案（Zhengzhou University distance education computer final exam review questions and answers）.docVIP

郑州大学远教计算机期末考试复习题及答案（Zhengzhou University distance education computer final exam review questions and answers） 1, try the four steps to create a chart in Excel. (10 points) Answer: (1) to start the wizard icon: Click the view and Toolbar to chart menu command to bring up the chart toolbar. (2) determine the icon in the source data: Select the data used to create the charts (3) set the icon option: Click the chart toolbar in the chart type button, click the down arrow button to select the type of chart; (4) to determine the location and size of graphics, create a chart. The storage capacity of 2, 1 single-sided single-layer DVD-5 CD 4.7G, 1 Chinese characters occupy 2 bytes of space. Does the DVD CD can store many million Chinese characters? Asked to write the calculation process and the basis for accurate calculation results to the whole digital. (10 points) Answer: 4.7G =.7*1024*1024*1024 byte=5046586572.8 byte 5046586572.8 in addition to the 2=2523293286.4 Chinese characters 3, the computer two into why the use of notation? (10 points) Answer: binary can be relatively easy to achieve with the level two level. While the other band is not easy to achieve. The computer to identify the signals by the current transform, the current signal is only two, so the computer can identify the machine language is only two digits, the most simple is 0 and 1. 4, what is the network protocol? Please briefly explain the. Please write down five kinds of commonly used network protocol. (10 points) Answer: the network protocol is all equipment (computers and network servers, switches, routers, firewall) between the set of communication rules, it defines the message format and the format of these must use significance. Most of the network using a layered architecture, each layer is built on its lower level, to provide a certain service, and how to realize the service details of a layer of shielding. The N layer N layer on one device and another device of communication rules is the n prot