问答题向“卡布奇诺”图表中添加多项式趋势线，该趋势线使用“顺序4”，并且预测趋势前推1个周期。 (Excel练习题组/E03.xlsx)。

问答题试题内容 在工作表“区域销售”的单元格P3中使用COUNTIFS函数，以计算区域“北京”中有多少名销售人员的销售量超过了25000。 准备 打开练习文档(/Excel素材/21.区域销售.xlsx)。 注释 COUNTIFS函数是将条件应用于跨多个区域的单元格，并返回符合所有条件的单元格个数的函数。 函数书写格式为 COUNTIFS(criteria_range1,criteria1,[criteria_range2,criteria2],...) COUNTIFS函数参数说明如下。 criteria_range1：第一个计算关联条件的区域范围。 criteria1：判定条件，条件的形式可为数字、表达式、单元格引用或文本，用来定义将对哪些单元格进行计数。 criteria_range2,criteria2,...：添加附加的区域及其关联条件。

多选题You are the network administrator for Ezonexam.com.You need to upgrade a computer from Windows NT Server 4.0 to Windows 2000 server. The server has dual processors, 2 GB of RAM, a RAID controller with five SCSI hard disks in an array, and a generic 10/100-MB network adapter. You begin the installation of the Windows 2000 Server operating system.During the text portion of the installation, you receive the following error message:"Stop 0x00000078 Inaccessible_boot_device."You want to successfully upgrade the computer.What should you do? (Each answer presents part of the solution. Choose two)

多选题You are the network administrator for Ezonexam.You are planning to upgrade Windows NT Server 4.0 computers to Windows 2000 Server. You want to perform the upgrades by means of a distribution folder. You need to install a custom application as part of the upgrade.You need to include the commands necessary so that the custom application is installed as part of the upgrade process.What should you do? (Each correct answer presents part of the solution. Choose two)

多选题You want to upgrade a Windows NT Server 4.0 computer named Server34 to Windows 2000 Server. Server34 is a member server in a Windows 2000 domain named marketing.fabrikam.local. The domain runs in native mode.You want to change the role of Server34 from a member server to a domain controller in the same domain. What should you do? (Choose Two)

多选题You are the administrator of your company's network. Your network has 20 Windows 2000 server computers in the contoso.com domain. Your network also has 250 Windows 98 computers. You want to perform a clean installation of Windows 2000 Professional on all of the Windows 98 computers. All of the Windows 98 computers are identical models and are PXE complaint.You want to accomplish the following goals:1. An unattended installation of Windows 2000 Professional will be performed.2. An unattended installation of company's standard applications will be performed during the installation of Windows 2000 Professional.3. Each computer will be assigned a unique security identifier description.4. The unattended installation script will be modified so that the computers automatically join the contoso.com domain.You take the following actions:1. Install Windows 2000 Professional on a Windows 98 computer named computer1.2. Install and configure computer standard applications on computer1.3. Use Setup Manager on computer1 to create an unattended.txt file based on the current configuration including domain membership.4. Start the remaining Windows 98 computers and then install Windows 2000 Professional. Use the unattended.txt file to provide the setting for the installation.Which result or results do these actions produce? (Choose all that apply)

多选题You are preparing to install Windows 2000 Professional on 75 new computers. You want to create a standard installation image to use on all the new computers. The computers have several different configurations of hard disks and hardware components.You install Windows 2000 Professional and other standard software on one of the computers. You log on to the computer using the local Administrator account. You configure the standard applications and customize the desktop settings you intend to deploy.You run the Setup Manager and create a Sysprep.inf file. You copy Sysprep.exe and Setupcl.exe to the C:/Sysprep folder. You run Sysprep.exe and run your third party disk imaging software.You copy the image to the several test computers and restart the computers. When the installation is complete, you find that some of the computers do not function at all. You also find that the desktop settings do not appear as you have configured them on the original computer.You want to correct the imaging process and ensure that all computers have the same standard desktop.What should you do? (Choose two)

多选题You are the network administrator for Ezonexam. You are preparing to install Windows 2000 Server on a new computer. The computer is connected to a network that includes Windows 98 computers and Windows 2000 Server computers.You want to install Windows 2000 Server from source files that are located on a shared folder called I386 on a Windows 2000 Server computer named Ezonexam1.What should you do? (Each correct answer presents part of the solution. Choose two)

多选题You are the network administrator for Ezonexam.com. Your network has 210 Windows 2000 Professional computers and eleven Windows 2000 Server computers. Users on the network save their work files in home folders on a network server. The NTFS partition that contains the home folders has Encrypting File System (EFS) enabled. A user named Sandra leaves Ezonexam.com. You decrypt the files for her manager. When the manager attempts to open any of the files, he receives the following error message: "Access is denied."You want the manager to be able to access the files.What should do? (Each correct answer presents a complete solution. Choose two.)

填空题Youaretheadministratorofyourcompany'snetwork.YouwanttoinstallWindows2000Professionalon10non-PXE-compliantcomputersthatareonthemarketingsegmentofyournetwork.YoustartoneofthecomputersbyusingaRISbootdisk.However,youcannotconnecttotheRISserver.Youverifythatexistingclientcomputersonthenetworkcanconnecttonetworkservers,includingtheRISserver.YoudiscoverthatthenetworkrouterdoesnotsupportBOOTP.YouwanttoenablethenewcomputerstoconnecttotheRISserver.Whatshouldyoudo?Toanswer,clicktheselectandplacebutton,andthendragtheappropriateservertotheplaceserverhereboxesonthenetwork(Note:Bothboxesmustbefilled.Ifaboxdoesnotrequireaserver,useNoserverneeded)

单选题如果表中某一条记录的一个字段暂时不具有任何值(未设置默认值)，在其中将保存什么内容?______ A.空格字符 B.0 C.NULL D.不确定的值，由字段类型决定

单选题下面的各项中哪一个正确描述了Oracle数据库的逻辑存储结构?______ A.表空间由段组成，段由盘区组成，盘区由数据块组成 B.段由表空间组成，表空间由盘区组成，盘区由数据块组成 C.盘区由数据块组成，数据块由段组成，段由表空间组成 D.数据块由段组成，段由盘区组成，盘区由表空间组成

单选题在SQL*Plus中执行刚输入的一条命令用______。 A.正斜杠(/) B.反斜杠(/) C.感叹号(!) D.句号(.)

单选题在SQL*Plus中显示EMP表结构的命令是______。 A.LIST EMP B.DESC EMP C.SHOW DESC EMP D.SHOW STRUCTURE EMP

单选题如果一个服务进程非正常终止，Oracle系统将使用下列哪一个进程来释放它所占用的资源?______ A.DBWR B.LGWR C.SMON D.PMON

单选题当用SQL*Plus已经登录到某一数据库，此时想登录到另一数据库，应该用命令______。 A.CONN B.DISC C.LOGIN D.LOGON

单选题假设产品表中包括价格NIMBER(7,2)列，对于下列语句： SELECT NVL(10/价格,'0')FROM 产品; 如果“价格”列中包含空值，将会出现什么情况?______ A.该语句将失败，因为值不能被0除 B.将显示值0 C.将显示值10 D.该语句将失败，因为值不能被空值除

单选题以下哪个说法准确地解释了无法执行SQL语句的原因?______ SELECT 部门标识“部门”，AVG(工资) “平均值” FROM 员工 GROUP BY 部门 A.无法对工资求平均值，因为并不是所有的数值都能被平分 B.不能在GROUP BY子句中使用列别名 C.GROUP BY子句中必须要有分组内容 D.部门表中没有列出部门标识

单选题下列哪些聚合函数可以把一个列中的所有值相加求和?______ A.MAX函数 B.MIN函数 C.COUNT函数 D.SUM函数

单选题下面选项中哪一项不属于数据文件的状态属性?______ A.OFFLINE DROP B.OFFLINE C.READ D.ONLINE