南京财经大学计算机实用技术练习第3章（Nanjing University of Finances and Economics practical computer technology exercises third chapters）.docVIP

南京财经大学计算机实用技术练习第3章（Nanjing University of Finances and Economics practical computer technology exercises third chapters） 1, radio questions In Excel, if you want to get the values from B2 to F2 in the G2 unit, you should enter () in the G2 unit (A) ERROR 0 V (B) 9 (C) ERROR 15 (D) SUM (B2:F) Reference: B my answer: Score: 2 points: 0 In Excel, when you modify the data in an active cell, you can insert the insertion point in (), modify the location of the data, and then modify it V (A) editor (B) name column (C) the menu bar (D) toolbar Reference: A my answer: Score: 2 points: 0 In Excel, if you want to center all the data in the cell, you should first click () and then click the middle button Please select the box (A) (B) edit box (C) name box (D) A1 unit Reference: A my answer: Score: 2 points: 0 Excel represents the formula for the B6 cell of the worksheet Sheet1 as () (A) Sheet1:B6 (B) Sheet1+B6 V (C) Sheet1! B6 (D) Sheet1, B6 Reference: C my answer: Score: 2 points: 0 If the number of cells is too large to display, a group () is displayed in the cell. (A)! (B)? V (C) # (D) * Reference: C my answer: Score: 2 points: 0 After selecting the auto filter command, a drop-down button icon appears on the list. V (A) at the field name (B) within all cells (C) within a blank cell (D) bottom Reference: A my answer: Score: 2 points: 0 If you want to take a number as a text (e.g., postal, telephone number, product code encoding, etc.) as long as the input (plus one), Excel will put the number as a text processing, it will be left aligned along the cell. (A) double apostrophes V (B) single apostrophe (C) semicolon (D) comma Reference: B my answer: Score: 2 points: 0 If you want to sort out the data list, you must first pair the data (). V (A) sorted by field classification, thus making the same record together (B) automatic screening (C) sort by any field. (D) formatting Reference: A my answer: Score: 2 points: 0 To find the average value of the nine numeric cell regions in a c