Q.1. Shortcut key to insert worksheet in micrsoft excel
(1) Ctrl+W
(2) Ctrl+IW
(3) Alt+1W
(4) Ctrl+N
(5) Alt+NW
Q.2. The default page size for word document is–
(1) letter
(2) legal
(3) A4
(4) All
(5) None of these
Q.3. 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
Q.4. _____ type of software is similar to an accountant’s worksheet.
(1) Word processing
(2) Database
(3) Spreadsheets
(4) Graphics
(5) Presentation
Q.5. 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
Q.6. 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
Q.7. 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) You can print more than one worksheet at a time and enter common data, formats, and formulas on multiple worksheets at one time.
(5) None of these
Q.8. 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
Q.9. 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
Q.10. 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) Page up/down
ANSWERS
Q.1. (4) Ctrl+N
Q.2. (3) A4 paper size which is default in Word Document.
Q.3. (4) With the copy and paste buttons on the standard toolbar.
Q.4. (3) Spreadsheet software is similar to an accountant’s worksheet.
Q.5. (4) All of the above
Q.6. (2) You can change the position of a data marker and automatically change the data point value in the worksheet.
Q.7. (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.8. (2) Double clicking the format painter button.
Q.9. (3) The default header for a worksheet is none.
Q.10. (4) Ctrl key
