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

xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512"> Subscribe on YouTube
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

Subscribe on YouTube
C. Scenario manager D. Auto Outline" class="read-more button" href="https://exam.pscnotes.com/mcq/which-of-following-is-not-one-of-excels-what-if-function-a-goal-seek-b-solver-c-scenario-manager-d-auto-outline/#more-14722">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

Subscribe on YouTube
points to a drawing object C. A formula that either directly or indirectly depends on itself D. Always erroneous" class="read-more button" href="https://exam.pscnotes.com/mcq/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/#more-14721">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 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

Join Our Telegram Channel

89.4 11.4 132.3c6.3 23.7 24.8 41.5 48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/> Subscribe on YouTube 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" class="read-more button" href="https://exam.pscnotes.com/mcq/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-pressi/#more-14718">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

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

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

74.6 75.5c-23.5 6.3-42 24.9-48.3 48.6-11.4 42.9-11.4 132.3-11.4 132.3s0 89.4 11.4 132.3c6.3 23.7 24.8 41.5 48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/> Subscribe on YouTube
and edit formulas containing functions C. Enter assumptions data D. Copy a range of cells

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

Subscribe on YouTube

C. Charts D. Worksheets and charts" class="read-more button" href="https://exam.pscnotes.com/mcq/an-excel-workbook-is-a-collection-of-a-workbooks-b-worksheets-c-charts-d-worksheets-and-charts/#more-14716">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

Subscribe on YouTube
cell C. Excel D. Lotus 1-2-3" class="read-more button" href="https://exam.pscnotes.com/mcq/which-of-the-following-is-a-popular-dos-based-spreadsheet-package-a-word-b-smart-cell-c-excel-d-lotus-1-2-3/#more-14715">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

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


Test 1Test 2Test 3