1. Data marker on a chart are linked to data points in a worksheet, therefore,
2. When creating a vertical page break _______.
3. You can use the format painter multiple times before you turn it off by _______.
4. Which function will calculate the number of workdays between 6/9/2005 and 8/12/2005?
5. You can zoom a worksheet ______.
6. When you group worksheets
7. _____ type of software is similar to an accountant’s worksheet.
8. The default header for a worksheet is
9. To drag a selected range of data to another worksheet in the same workbook, use the ______.
10. you can not link Excel worksheet data to a Word document
- (1) You can automatically apply formatting to a data series
- (2) You can change the position of a data marker and automatically change the data point value in the worksheet
- (3) You can change a data print value and automatically are draw the chart
- (4) 1 and 2
- (5) None of these
2. When creating a vertical page break _______.
- (1) The active cell must be A1
- (2) The active cell can be anywhere in the worksheet
- (3) The active cell must be in row 1
- (4) The active cell must be in column A
- (5) None of these
3. You can use the format painter multiple times before you turn it off by _______.
- (1) You can use the format painter button only one time when you click it
- (2) Double clicking the format painter button
- (3) Pressing the Ctrl key and clicking the format painter button
- (4) Pressing Alt key and clicking the format painter button
- (5) Both 2 and3
4. Which function will calculate the number of workdays between 6/9/2005 and 8/12/2005?
- (1) Workday
- (2) Date
- (3) Network days
- (4) All of the above
- (5) None of these
5. You can zoom a worksheet ______.
- (1) With the mouse pointer in Print Preview
- (2) With the zoom button on the Print Preview toolbar
- (3) With the Zoom command on the view menu
- (4) Ctrl and then use the mouse wheel to zoom
- (5) All of the above
6. When you group worksheets
- (1) You can enter variable data on multiple worksheets at one time
- (2) You can print more than one worksheet at a time
- (3) You can enter common data, formats, and formulas on multiple worksheets at one time
- (4) 2, and 3
- (5) None of these
7. _____ type of software is similar to an accountant’s worksheet.
- (1) Word processing
- (2) Database
- (3) Spreadsheets
- (4) Graphics
- (5) Presentation
8. The default header for a worksheet is
- (1) Your name
- (2) The date and time
- (3) None
- (4) The sheet tab name
- (5) 1, 2 and 4
9. To drag a selected range of data to another worksheet in the same workbook, use the ______.
- (1) Tab key
- (2) Alt key
- (3) Shift key
- (4) Ctrl key
- (5) Pageup/down
10. you can not link Excel worksheet data to a Word document
- (1) With the right drag method
- (2) With a hyperlink
- (3) With the copy and paste special commands
- (4) With the copy and paste buttons on the standard toolbar
- (5) None of these