大学计算机基础期末考试复习题(200题).doc

计算机基础期末考试复习题 True/False Indicate whether the statement is true or false. ____ 1. If a label is too long to fit in the current cell, it extends into the cells to the left if they are empty. ____ 2. A formula always begins with a plus sign (+) and can use cell references that point to the contents of other cells. ____ 3. You can edit a formula after you’ve pressed the Enter key in the same way you would edit labels or values—in the cell or in the formula bar. ____ 4. A worksheet can be used for more than simple calculations. You can build complex formulas to calculate statistical, financial, and mathematical equations. ____ 5. If you don’t use parentheses, Excel calculates the result using the standard mathematical order of operations—multiplication and division, then addition and subtraction. ____ 6. Commonly used functions, such as Sum, Average, Minimum, and Maximum, are located in the Equation category. ____ 7. Borders and background colors define areas of a worksheet and call attention to important information. ____ 8. You can apply multiple font attributes to any worksheet cell. ____ 9. To change the width of a cell, you must increase the width of the entire column. ____ 10. To change the alignment of a range of cells, select the range of cells, then click the desired alignment button from the Alignment group on the Edit tab. ____ 11. If you copy or move the data in a range of cells, the pasted data is positioned above and to the left of the active cell. ____ 12. A formula that contains an absolute reference changes when the formula is copied or moved. ____ 13. You can select a row by clicking the row identifier button on the left side of the window. ____ 14. Excel provides tools that allow you to sort data in ascending or descending order. ____ 15. When selecting the cells for a chart, include the cells that contain values and they will be used to identify the lines, columns, or pie slices on the chart. ____ 16. If you are not certain which chart type to use, ho