[amp_mcq option1=”Hyperlinked placed in a word table” option2=”Linked” option3=”Embedded” option4=”Use the word menu bar and toolbars” correct=”option1″]
Ms excel
2. Which of following is Not one of Excel’s what-if function? A. Goal seek B. Solver C. Scenario manager D. Auto Outline
[amp_mcq option1=”Goal seek” option2=”Solver” option3=”Scenario manager” option4=”Auto Outline” correct=”option4″]
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
[amp_mcq option1=”Geometric modeling tool” option2=”A cell that points to a drawing object” option3=”A formula that either directly or indirectly depends on itself” option4=”Always erroneous” correct=”option3″]
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
[amp_mcq option1=”FTP wizard” option2=”Internet assistant wizard” option3=”Intranet wizard” option4=”Import wizard” correct=”option2″]
5. 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
[amp_mcq option1=”You can use the format painter button on ly one time when you click it” option2=”Double clicking the format painter button” option3=”Pressing the Ctrl key and clicking the format painter button” option4=”Pressing the Alt key and clicking the format painter button” correct=”option3″]
6. 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
[amp_mcq option1=”Format cells containing numbers” option2=”Create and edit formulas containing functions” option3=”Enter assumptions data” option4=”Copy a range of cells” correct=”option2″]
7. Excel files have a default extension of in Excel-2003 A. Xls B. Xlw C. Wk1 D. 123
[amp_mcq option1=”Xls” option2=”Xlw” option3=”Wk1″ option4=”123″ correct=”option1″]
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
[amp_mcq option1=”Workbooks” option2=”Worksheets” option3=”Charts” option4=”Worksheets and charts” correct=”option4″]
9. Which of the following is a popular DOS based spreadsheet package? A. Word B. Smart cell C. Excel D. Lotus 1-2-3
[amp_mcq option1=”Word” option2=”Smart cell” option3=”Excel” option4=”Lotus 1-2-3″ correct=”option4″]
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
[amp_mcq option1=”With the right drag method” option2=”With a hyperlink” option3=”With the copy and paste special commands” option4=”With the copy and paste buttons on the standard toolbar” correct=”option1″]