Ms excel

1. When you insert an excel file into a word document. The data are A. Hyperlinked placed in a word table B. Linked C. Embedded D. Use the word menu bar and toolbars

Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars

Detailed SolutionWhen you insert an excel file into a word document. The data are A. Hyperlinked placed in a word table B. Linked C. Embedded D. Use the word menu bar and toolbars

2. Which of following is Not one of Excel’s what-if function? A. Goal seek B. Solver C. Scenario manager D. Auto Outline

Goal seek
Solver
Scenario manager
Auto Outline

Detailed SolutionWhich of following is Not one of Excel’s what-if function? A. Goal seek B. Solver C. Scenario manager D. Auto Outline

3. A circular reference is A. Geometric modeling tool B. A cell that points to a drawing object C. A formula that either directly or indirectly depends on itself D. Always erroneous

Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous

Detailed SolutionA circular reference is A. Geometric modeling tool B. A cell that points to a drawing object C. A formula that either directly or indirectly depends on itself D. Always erroneous

4. You can convert existing excel worksheet data an charts to an HTML document by using A. FTP wizard B. Internet assistant wizard C. Intranet wizard D. Import wizard

FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard

Detailed SolutionYou can convert existing excel worksheet data an charts to an HTML document by using A. FTP wizard B. Internet assistant wizard C. Intranet wizard D. Import wizard

5. You can use the formula palette to A. Format cells containing numbers B. Create and edit formulas containing functions C. Enter assumptions data D. Copy a range of cells

Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells

Detailed SolutionYou can use the formula palette to A. Format cells containing numbers B. Create and edit formulas containing functions C. Enter assumptions data D. Copy a range of cells

6. You can use the format painter multiple times before you turn it off by A. You can use the format painter button on ly one time when you click it B. Double clicking the format painter button C. Pressing the Ctrl key and clicking the format painter button D. Pressing the Alt key and clicking the format painter button

You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button

Detailed SolutionYou can use the format painter multiple times before you turn it off by A. You can use the format painter button on ly one time when you click it B. Double clicking the format painter button C. Pressing the Ctrl key and clicking the format painter button D. Pressing the Alt key and clicking the format painter button

7. Excel files have a default extension of in Excel-2003 A. Xls B. Xlw C. Wk1 D. 123

Xls
Xlw
Wk1
123

Detailed SolutionExcel files have a default extension of in Excel-2003 A. Xls B. Xlw C. Wk1 D. 123

8. An excel workbook is a collection of A. Workbooks B. Worksheets C. Charts D. Worksheets and charts

Workbooks
Worksheets
Charts
Worksheets and charts

Detailed SolutionAn excel workbook is a collection of A. Workbooks B. Worksheets C. Charts D. Worksheets and charts

9. Which of the following is a popular DOS based spreadsheet package? A. Word B. Smart cell C. Excel D. Lotus 1-2-3

Word
Smart cell
Excel
Lotus 1-2-3

Detailed SolutionWhich of the following is a popular DOS based spreadsheet package? A. Word B. Smart cell C. Excel D. Lotus 1-2-3

10. You cannot link excel worksheet data to a word document A. With the right drag method B. With a hyperlink C. With the copy and paste special commands D. With the copy and paste buttons on the standard toolbar

With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar

Detailed SolutionYou cannot link excel worksheet data to a word document A. With the right drag method B. With a hyperlink C. With the copy and paste special commands D. With the copy and paste buttons on the standard toolbar

Page 1Page 2Page 3Page 4Page 5
Test 1Test 2Test 3