若何应用EXCEL前进数据治理谜底(国外英文资料).docVIP

如何运用EXCEL进行数据管理答案(国外英文资料) How to use EXCEL for data management answers Single topic selection When setting up the cell format, in the customization of data classification, the symbol for numeric values:? Square root A???? Should be @ B???? It should be # C?? It should be D?? It should be zero The right answer:? B The following options are a self-definition of the data format in a cell, which represents the fixed letter ABC followed by any number:? Square root A???? Is ABC @ @ 0 B???? Is # ABC# 0 C?? Is the ABC # D?? Is the ABC @ The right answer:? C When setting up a cell format, if the 0.000 is filled in the custom, enter 3.1415 in the cell, and the return car will be displayed as:? Square root A???? 3.142 B???? 3.000 C?? 3.1415 D?? 3 The right answer:? a. In EXCEL, set the cell content as a shortcut for text formatting:? Square root A???? It should be # B???? Should be @ C?? It should be D?? It should be The right answer:? D When you need an EXCEL spreadsheet to automatically convert the input Arabic Numbers into Chinese uppercase, the method is to set the cell format - the number - (). Square root A???? The date of B???? special C?? currency D?? Scientific count The right answer:? B In the input format of the following dates, the true date is:? x A???? 2012.10.10 B???? 2012, 10, 10 C?? 41192 D??The right answer:? C After typing 5/8 in the cell, click enter to display:? Square root A???? On May 8, B???? August 5, C?? 1.6 D?? 0.625 The right answer:? a. In EXCEL, the shortcut keys for the day date are:? Square root A???? SHIFT +; B???? CTRL + F5 C?? SHIFT + F5 D?? CTRL +; The right answer:? D The accuracy of the EXCEL spreadsheet is (). ? Square root A???? 12 B???? 15 C?? 18 D?? 24 The right answer:? B If you want to set security for content in EXCEL, the tools you should use are:? Square root A???? Data validity B???? Cell style C?? Protection tool table D?? Freeze panes The right answer:? C True or false In EXCEL, when writing code that is not used fo