2017 Office Office Software Exam Training Questions "with answers"
I. Multiple Choice Questions
1. In Excel 2010, a cell is known to be formatted as a numeric decimal digit 2, then the value of ?21.555? is displayed as ( C ).
A. 21.555
B. 21.55
C. 21.56
D. 21.55#
2. In Excel 2010 does not have the function ( D ).
A. Statistical operations
B. Charts
C. Database management
D. Automatic summary writing
3. Generally, Excel 2010 defaults to a right-justified display format ( A ).
A. Numeric and date data
B. Character data
C. Logical data
D. Uncertain
4. In general, Excel 2010 defaults to a centered display format ( C ).
A. Numeric and date data
B. Character data
C. Logical data
D. Uncertain
5. Generally, Excel 2010 defaults to displaying left-aligned ( B ).
A. Numeric and date data
B. Character data
C. Logical data
D. Not sure
6. If you want to refer to the region of the cell should be entered to refer to the reference region of the upper-left corner of the cell reference ( C ) and the region of the lower-right corner of the cell reference.
A. ? ! ?
B. ? [ ] ?
C. ? : ?
D. ? , ?
7. In Excel state, successively in order to open the S1.xlsx, S2.xlsx, S3.xlsx, S4.xlsx four workbook files after the current activity of the window is ( D ) workbook window.
A. S1.xlsx
B. S2.xlsx
C. S3.xlsx
D. S4.xlsx
8. In the following operations can be made so that the selected cell area to enter the same data is ( D ).
A. Press Ctrl+Space after entering the data
B. Press Enter after entering the data
C. Press Shift+Enter after entering the data
D. Press Ctrl+Enter after entering the data
9. The following symbols do not belong to the comparison operator ( B ).
A. 〈=
B. =〈
C. 〈〉
D. 〉
10. The display window for a split worksheet can use a split box, which is in ( B ).
A. Title Bar
B. Scroll Bar
C. Toolbar
D. Row Label
11. The following operations can move the position of the worksheet is ( A ).
A. Drag the sheet tab
B. Click the sheet tab and then click the destination location
C. Press Ctrl to drag the sheet tab
D. Press Shift to drag the sheet tab
12. Generate a chart worksheet In the default state the name of the chart is ( C ).
A. Untitled
B. Sheet1
C. Chart1
D. Chart1
13. The columns of an EXCEL 2010 data list are equivalent to ( B ) in a database.
A. Record
B. Field
C. Record Number
D. Data Sheet
14. In EXCEL 2010, the following statements are wrong in ( C ).
A. Hiding rows and columns in a worksheet does not delete them
B. Once the rows and columns in a worksheet have been hidden, they can be displayed
C. Once the rows and columns in a worksheet have been hidden, any operation on the worksheet does not affect these rows and columns
D. To re-display the hidden rows and columns, you can use ? Unhide? unhide? command to restore
15. In EXCEL 2010, the charts and data created ( B ).
A. Only in the same worksheet.
B. Both in the same worksheet and in different worksheets of the same workbook.
C. Cannot be in the same worksheet.
D. Can be in the same worksheet only if the worksheet has enough display area on the screen.
16. EXCEL 2010 worksheet column labeling is indicated as ( B ), and row labeling is indicated as ( A ).
A. 1, 2, 3
B. A, B, C
C. A, B, C
D. Ⅰ, Ⅱ, Ⅲ
17. Cell C1 has the formula = A $ 1 + $ B1, will be copied from the formula in C1 to the D3 cell, the formula in the D3 cell is ( A ).
A. =B$1+$B3
B. =B1+B3
C. = A$1+$B1
D. = A$3+$B3
18. There are two worksheets and a chart in a workbook, and if you want to save them, it will produce ( A ) files.
A. 1
B. 2
C. 3
D. 4
19. When you use the Del key to delete data from a selected cell, it deletes the cell's ( A ).
A. Content
B. Format
C. Notes
D. All
20. The content of cell A1 is 100, and the cell B1. Formula is =A1, cut and paste A1 into cell B2, the formula of cell B1 becomes ( A ).
A. =B2
B. =A1
C. #DEF
D. 0
Second, judgment questions
1. ( False ) EXCEL 2010 can only be opened 3 worksheets at a time.
2. ( Wrong ) EXCEL 2010 worksheets are three-dimensional tables.
3. ( Right ) An EXCEL 2010 workbook is a file.
4. ( Right ) When you copy a formula to another cell, the relative address of the formula reference changes accordingly.
5. ( Right ) EXCEL 2010 workbook both general worksheets and charts, when saving the file is the worksheet and charts as a whole, a file to save.
6. ( Wrong ) EXCEL 2010, it is known that there is a formula = D2 * $ E3 in A1, insert a blank column between columns D and E, and insert a blank row between rows 2 and 3, then the formula of A1 is adjusted to D2 * $ E4.
7. ( Right ) Hiding rows or columns on EXCEL 2010 worksheets does not remove them.
8. ( Right ) The rows and columns in the worksheet can be referenced after they are hidden.
9. ( Wrong ) Once the rows and columns are hidden in the worksheet, any action taken on the worksheet will not affect these rows and columns.
10. ( Right ) To redisplay the hidden rows and columns, you can use the ? Unhide? command to restore them.
11. ( Wrong ) A standalone chart is a table that is not related to the worksheet.
12. ( False ) Separate charts are worksheet data and corresponding charts stored in separate workbooks.
13. ( Right ) A separate chart is a sheet that stores worksheet data and the corresponding chart in separate worksheets.
14. ( Right ) EXCEL 2010 can convert worksheets into HTML format for Web pages.
15. ( Wrong ) EXCEL 2010 can run under DOS.
16. ( Wrong ) When you set the row height of EXCEL 2010 to increase, the characters in each cell of the row are also automatically increased.
17. ( Right ) In the case of not adjusting the row height, EXCEL 2010 system defaults to set the row height automatically to the highest character in the row
18. ( Wrong ) EXCEL 2010 can only be adjusted at a time a single line of the row height.
19. ( Right ) In EXCEL 2010, constants, cells, regions, region names, logical values, text, formulas, functions, etc. can be used as parameters.
20. ( Wrong ) Formulas and functions can not be used as parameters.
;