A.if(E4>=80andE4< =90,"良好","其他")B.if(E4>=80&&E4< =90,"良好","其他")C.if(or(E4>=80,E4< =90),"良好","其他")D.if(E4>=80,if(E4< =90,"良好","其他"),"其他")E.if(and(E4>=80,E4< =90),"良好","其他")F.if(E4>=80,if(E4< =90,"良好","其他"))
A.選定數(shù)據(jù)列表中任一單元格→“插入”選項卡→“表格”功能組→“數(shù)據(jù)透視表”下拉按鈕→“數(shù)據(jù)透視表”選項→“創(chuàng)建數(shù)據(jù)透視表”對話框。B.⑴創(chuàng)建數(shù)據(jù)透視表;⑵布局?jǐn)?shù)據(jù)透視表;⑶用“數(shù)據(jù)透視表工具”選項卡設(shè)置數(shù)據(jù)透視表。C.數(shù)據(jù)透視表只能創(chuàng)建在新工作表中,不能創(chuàng)建在當(dāng)前工作表中。D.原數(shù)據(jù)列表中的數(shù)據(jù)修改后,必須刷新數(shù)據(jù)透視表,數(shù)據(jù)透視表中的數(shù)據(jù)才能更新。
A.數(shù)據(jù)有效性能保證數(shù)據(jù)輸入沒有錯誤。B.數(shù)據(jù)有效性能對輸入數(shù)據(jù)的要求給出提示信息。C.當(dāng)輸入數(shù)據(jù)違反數(shù)據(jù)有效性規(guī)則時,會給出警告信息。D.數(shù)據(jù)有效性能減少輸入數(shù)據(jù)的錯誤,提高輸入數(shù)據(jù)的正確率。