Unit-3 Spreadsheet Tool
Unit-3 Spreadsheet Tool
Unit-3 Spreadsheet Tool
These MS Excel multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Pressing Ctrl + C
d. Pressing Ctrl+X
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Pressing enter
d. Pressing spacebar
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
5. Text formulas:
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Right-click the row heading where you want to insert the new row and select Insert from
the shortcut menu
b. Select the row heading where you want to insert the new row and select Edit >Row from
the menu
c. Select the row heading where you want to insert the new row and click the Insert Row
button on the standard toolbar
These Microsoft Excel MCQ Questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Save workbook
c. Hold down the shift key as you click anywhere in the column.
d. Hold down the Ctrl key as you click anywhere in the column
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Select File>Properties form the menu and type 3 in the Copies to print text box.
b. Select File >Print from the menu and type 3 in the Number of copies text box.
c. Click the Print button on the standard toolbar to print the document then take it to Kinko’s
and have 2 more copies made
d. Press Ctrl+P+3
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Type the equals sign (=) to tell Excel that you’re about to enter a formula
c. Enter the formula using any input values and the appropriate mathematical operators that
make up your formula
These ms excel mcq questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
c. Select the cells containing the title text plus the range over which the title text is to be
enfettered
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Select the column heading you want to delete and select the Delete Row button on the
standard toolbar
b. Select the column heading you want to delete and select Insert Delete from the menu
c. Select the row heading you want to delete and select Edit>Delete from the menu
d. Right click the column heading you want to delete and select delete from the shortcut
menu
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
d. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria
button
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Server
b. Destination
c. Client
d. Both b and c
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
15. When a label is too long to fit within a worksheet cell, you typically must
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Smart tip
b. Cell tip
c. Web tip
d. Soft tip
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
18. Which is used to perform what if analysis?
a. Solver
b. Goal seek
c. Scenario Manager
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
19. You can use the horizontal and vertical scroll bars to
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. standard formulas
b. array formula
c. complex formulas
d. smart formula
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Text
b. Drawing objects
c. Pictures
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
25. To copy formatting from one area in a worksheet and apply it to another area you
would use:
a. The Edit>Copy Format and Edit>Paste Format commands form the menu.
b. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply
menu.
c. There is no way to copy and apply formatting in Excel – You have to do it manually
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Rows
c. Columns
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
27. When you link data maintained in an excel workbook to a word document
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
28. Which area in an excel window allows entering values and formulas
a. Title bar
b. Menu bar
c. Formula bar
d. Standard toolbar
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
29. To hold row and column titles in place so that they do not scroll when you scroll a
worksheet click the
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Use the excel menu bar and toolbars inside the word application
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
c. Formula bar
d. Status bar
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. VisiCalc
b. Lotus 1-2-3
c. Excel
d. StarCalc
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
d. When you show the results of formulas with different decimal places that the calculated
results
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. With the copy, paste and cut commands on the edit menu
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. With a hyperlink
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Word
b. Smart cell
c. Excel
d. Lotus 1-2-3
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Workbooks
b. Worksheets
c. Charts
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Xls
b. Xlw
c. Wk1
d. 123
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
40. 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
c. Pressing the Ctrl key and clicking the format painter button
d. Pressing the Alt key and clicking the format painter button
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
42. You can convert existing excel worksheet data an charts to an HTML document by
using
a. FTP wizard
c. Intranet wizard
d. Import wizard
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
d. Always erroneous
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Goal seek
b. Solver
c. Scenario manager
d. Auto Outline
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
45. When you insert an excel file into a word document. The data are
b. Linked
c. Embedded
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
46. Which of the following is not information you can specify using the solver?
a. Input cells
b. Constraints
c. Target cell
d. Changing cells
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. It can be modified
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Label
b. Value
c. Formula
d. Text string
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
49. You can enter which types of data into worksheet cells?
d. Formulas only
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Manipulate labels
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Multiplication and division, positive and negative values, addition and subtraction
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
52. The Paste Special command lets you copy and paste:
b. Cell comments
c. Formatting options
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
53. The numbers in our worksheet look like this: You want them to look like this:
$1,000.How can you accomplish this?
a. None of these
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Number
b. Character
c. Label
d. Date/time
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
55. Excel worksheet cells work very similarly to what common element of the windows
graphical user interface
a. Option buttons
b. List boxes
c. Text boxes
d. Combo boxes
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
56. Which of the following options is not located in the Page Setup dialog box?
b. Page Orientation
c. Margins
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
57. You want to track the progress of the stock market on a daily basis. Which type of
chart should you use?
a. Pie chart
b. Row chart
c. Line chart
d. Column chart
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
58. Without using the mouse or the arrow keys, what is the fastest way of getting to cell
A1 in a spreadsheet?
b. Press Home
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
59. Which of the following methods can not be used to edit the contents of a cell?
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
60. If you begin typing an entry into a cell and then realize that you don’t want your
entry placed into a cell, you:
b. Press Esc
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
62. When you want to insert a blank imbedded excel object in a word document you can
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Click the save button on the standard toolbar from the menu
b. Press Ctrl+F5
d. Select Edit>Save
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
d. None of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Clicking the upper-left cell in a group of cells and then pressing the Shift key while
clicking the lower right cell in a group of cells
b. Pressing the Ctrl key while dragging over the desired cells
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Contents
b. Objects
c. Scenarios
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
d. a and b
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
68. It is acceptable to let long text flow into adjacent cells on a worksheet when
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Select Data > Form from the menu to open the Data Form dialog box, find the record and
Click the Delete button
These MCQs are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Nothing the right mouse button is there for left handed people
These multiple choice questions are originally presented in mcqsets.com. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. DOC
b. XLS
c. 123
d. WK1
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
75. Which of the following is not a worksheet design criterion?
a. Efficiency
b. Aditibility
c. Description
d. Clarity
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
76. To copy cell contents using drag and drop press the
a. End key
b. Shift key
c. Ctrl key
d. Esc key
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Excel 2000
b. Excel 2002
c. Excel ME
d. Excel XP
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
80. Which menu option can be sued to split windows into two
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. !A!1
b. $A$1
c. #a#1
d. A1
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. ” (quote)
b. = (equal)
c. _ (underscore)
d. ‘ (apostrophe)
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. =
b. +
c. (
d. @
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. =10+50
b. =B7*B1
c. =B7+14
d. 10+50
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
85. Which of the following formulas will Excel Not be able to calculate?
a. =SUM(Sales)-A3
b. =SUM(A1:A5)*.5
c. =SUM(A1:A5)/(10-10)
d. =SUM(A1:A5)-10
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
86. A typical worksheet has …. Number of columns
a. 128
b. 256
c. 512
d. 1024
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. 256
b. 1024
c. 32000
d. 65535
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. 256
b. 1024
c. 32000
d. 65535
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. 350
c. 0.57
d. Serial Number 50771
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. A chart legend
d. A data label
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. A horizontal axis
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
c. A group of cells
d. A group of worksheets
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Accessing
b. Referencing
c. Updating
d. Functioning
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Apostrophe (&lsquo
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
a. Apostrophe (&lsquo
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
97. Data can be arranged in a worksheet in a easy to understand manner using
a. auto formatting
b. applying styles
c. changing fonts
d. all of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
98. You can use drag-and-drop to embed excel worksheet data in a word document
a. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl
key
b. By dragging a range of excel data to the word button on the taskbar while pressing Shift
key
c. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
d. None of above
These multiple choice questions are originally presented in MCQ Sets. Please visit https://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
b. Provides a quick way to view the result of an arithmetic operation on a range of cells
d. A and c
100. Excel uniquely identifies cells within a worksheet with a cell name
a. Cell names
Answers:
Q.No-Correct Answer
11 - a 12 - d 13 - d 14 - d 15 - b 16 - b 17 - b 18 - d 19 - b 20 - b
21 - d 22 - d 23 - a 24 - d 25 - d 26 - d 27 - b 28 - c 29 - b 30 - a
31 - d 32 - c 33 - a 34 - a 35 - d 36 - d 37 - d 38 - d 39 - a 40 - b
41 - b 42 - b 43 - c 44 - d 45 - b 46 - a 47 - c 48 - b 49 - a 50 - c
51 - a 52 - d 53 - c 54 - b 55 - c 56 - a 57 - c 58 - a 59 - a 60 - b
61 - c 62 - a 63 - a 64 - b 65 - d 66 - d 67 - d 68 - b 69 - b 70 - c
71 - d 72 - c 73 - d 74 - b 75 - c 76 - a 77 - d 78 - b 79 - b 80 - c
81 - b 82 - d 83 - a 84 - d 85 - a 86 - b 87 - d 88 - d 89 - d 90 - b
91 - b 92 - c 93 - b 94 - d 95 - a 96 - d 97 - d 98 - a 99 - b 100 - c