Computer Quiz - 7

Q.1. 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

Ans. (5) All of the above

Q.2. 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

Ans. (4) with the copy and paste buttons on the standard toolbar

Q.3. _____ type of software is similar to an accountant’s worksheet.

(1) Word processing

(2) Database

(3) Spreadsheets

(4) Graphics

(5) Presentation

Ans. (3) Spreadsheet software is similar to an accountant’s worksheet.

Q.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

Ans. (4) All

Q.5. Data marker on a chart are linked to data points in a worksheet, therefore,

(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

Ans. (2) You can change the position of a data marker and automatically change the data point value in the worksheet

Q.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

Ans. (4) You can print more than one worksheet at a time and enter common data, formats, and formulas on multiple worksheets at one time.

Q.7. 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

Ans. (2) Double clicking the format painter button

Q.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

Ans. (3) The default header for a worksheet is none.

Q.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

Ans. (4) To drag a selected range of data to another worksheet in the same workbook, use the control key.

Q.10. 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

Ans. (3) The active cell must be in row 1