Ms. Excel MCQ Bank - MCQ Questions Collection » MCQ Sets

MCQ Bank for MS ExcelVisit http://mcqSets.com for morematerials38. An excel workbook is a collection ofa. Workbooksb. Worksheetsc. Chartsd. Worksheets and charts47. Each excel file is called a workbook becausea. It can contain text and datab. It can be modifiedc. It can contain many sheets including worksheets and chart sheetsd. You have to work hard to create it39. Excel files have a default extension ofa. Xlsb. Xlwc. Wk1d. 12348. Excel probably considers the cell entry January 1, 2000 to be aa. Labelb. Valuec. Formulad. Text string40. You can use the format painter multiple times before you turnit off bya. You can use the format painter button on ly one time when youclick itb. Double clicking the format painter buttonc. Pressing the Ctrl key and clicking the format painter buttond. Pressing the Alt key and clicking the format painter button49. You can enter which types of data into worksheet cells?a. Labels, values, and formulasb. Labe3ls and values but not formulasc. Values and formulas but not labelsd. Formulas only41. You can use the formula palette toa. Format cells containing numbersb. Create and edit formulas containing functionsc. Enter assumptions datad. Copy a range of cells42. You can convert existing excel worksheet data an charts to anHTML document by usinga. FTP wizardb. Internet assistant wizardc. Intranet wizardd. Import wizard43. A circular reference isa. Geometric modeling toolb. A cell that points to a drawing objectc. A formula that either directly or indirectly depends on itselfd. Always erroneousQ. Will you answer my questions if I send them to you?a. There are some pages in MCQ Sets that offers you the formb. If you send me questions using the forms in MCQ Setsc. I will try to include your questions in the respective seriesd. Get the most authentic answers for your subjective questions44. Which of following is Not one of Excel’s what-if function?a. Goal seekb. Solverc. Scenario managerd. Auto Outline45. When you insert an excel file into a word document. The dataarea. Hyperlinked placed in a word tableb. Linkedc. Embeddedd. Use the word menu bar and toolbarsQS. Can I download the MCQ banks in MCQSets.com?a. Yes, do a search in mcqsets.com siteb. Yes, some files are offered to download freec. mcqSets.com has download sectionsd. The downloads are available as PDF filesRR. You can use mcqSets.com fora. Online quizb. MCQ Banksc. Downloadsd. Subjective Questions & answers50. All worksheet formulaa. Manipulate valuesb. Manipulate labelsc. Return a formula resultd. Use the addition operatorlQ. How reliable are MCQs in MCQ Sets?a. I've paid utmost care in correctnessb. These are tested questions and answersc. However, if you discover any mistakesd. Mail me at contact@mcqsets.com51. Which of the following is a correct order of precedence informula calculation?a. Multiplication and division exponentiation positive and negativevaluesb. Multiplication and division, positive and negative values, additionand subtractionc. Addition and subtraction, positive and negative values,exponentiationd. All of aboveQ. Will you answer my MCQ Questions in Facebooka. I don't answer questions in Facebookb. You can post your questions in http://icttrends.com/forumc. Answering in Facebook kills my a lot of timed. If you save my time I'll be able to produce more useful materials52. The Paste Special command lets you copy and paste:a. Multiply the selection by a copied valueb. Cell commentsc. Formatting optionsd. The resulting values of a formula instead of the actual formulaSl. Can I download the MCQ banks in MCQSets.com?a. Yes, do a search in mcqsets.com siteb. Yes, some files are offered to download freed. The downloads are available as PDF files53. The numbers in our worksheet look like this: You want them tolook like this: 1,000.How can you accomplish this?a. None of theseb. Select Format Money from the menuc. Click the Currency Style button on the formatting toolbard. You have to retype everything and manually add the dollar signs,commas, and decimals.54. Which of the following is not a valid data type in excela. Numberb. Characterc. Labeld. Date/timeVisit http://mcqSets.com for more downloads and other study materials.46. Which of the following is not information you can specify usingthe solver?a. Input cellsb. Constraintsc. Target celld. Changing cells55. Excel worksheet cells work very similarly to what commonelement of the windows graphical user interfacea. Option buttonsb. List boxesc. Text boxesd. Combo boxesVisit http://mcqSets.com for more multiple choice questions and download MCQ Banks6

MCQ Bank for MS ExcelVisit http://mcqSets.com for morematerials56. Which of the following options is not located in the Page Setupdialog box?a. Page Break Preview.b. Page Orientationc. Marginsd. Headers and Footers65. You can select a single range of cells bya. Clicking the upper-left cell in a group of cells and then pressing theShift key while clicking the lower right cell in a group of cellsb. Pressing the Ctrl key while dragging over the desired cellsc. Pressing the Shift key and an arrow keyd. Dragging over the desired cells57. You want to track the progress of the stock market on a dailybasis. Which type of chart should you use?a. Pie chartb. Row chartc. Line chartd. Column chart66. Which elements of worksheet can be protected from accidentalmodificationa. Contentsb. Objectsc. Scenariosd. All of aboveQ. Will you answer my questions if I send them to you?a. There are some pages in MCQ Sets that offers you the formb. If you send me questions using the forms in MCQ Setsc. I will try to include your questions in the respective seriesd. Get the most authentic answers for your subjective questions67. You can use the drag and drop method toa. Copy cell contentsb. Move cell contentsc. Add cell contentsd. a and b58. Without using the mouse or the arrow keys, what is the fastestway of getting to cell A1 in a spreadsheet?a. Press Ctrl Homeb. Press Homec. Press Shift Homed. Press Alt HomeQ. Where can you find best quality multiple choice questions?a. icttrends.comb. psexam.comc. prepare.icttrends.comd. mcqsets.com59. Which of the following methods can not be used to edit thecontents of a cell?a. Press the Alt keyb. Clicking the formula barc. Pressing the F2 keyd. Double clicking the cell60. If you begin typing an entry into a cell and then realize that youdon’t want your entry placed into a cell, you:a. Press the Erase keyb. Press Escc. Press the Enter buttond. Press the Edit Formula button61. to view a cell commenta. click the edit comment command on the insert menub. click the display comment command on the window menuc. position the mouse pointer over the celld. click the comment command on the view menu62. When you want to insert a blank imbedded excel object in aword document you cana. Click the object command on the insert menub. Click the office links button on the standard toolbarc. Click the create worksheet button on the formatting toolbard. Click the import excel command on the file menuQ. How reliable are MCQs in MCQ Sets?a. I've paid utmost care in correctnessb. These are tested questions and answersc. However, if you discover any mistakesd. Mail me at contact@mcqsets.com63. To save a workbook, you:a. Click the save button on the standard toolbar from the menub. Press Ctrl F5c. Click Save on the Windows Start buttond. Select Edit SaveQ. You can use mcqSets.com fora. Online quizb. MCQ Banksc. Downloadsd. Subjective Questions & answers64. You can edit a cell bya. Clicking the formula buttonb. Double clicking the cell to edit it in-placec. Selecting Edit Edit Cell from the menud. None of above68. It is acceptable ot let long text flow into adjacent cells on aworksheet whena. Data will be entered in the adjacent cellsb. No data will be entered in the adjacent cellsc. There is nt suitable abbreviation of the textd. Tehere is not time to format the next69. How can you delete a record?a. Delete the column from the worksheetb. Select Data Form from the menu to open the Data Form dialogbox, find the record and Click the Delete buttonc. Select Data Delete Record from the menud. Click the Delete button on the Standard toolbar70. Right clicking something in Excel:a. Deletes the objectb. Nothing the right mouse button is there for left handed peoplec. Opens a shortcut menu listing everything you can do to the objectd. Selects the object71. Documentation should includea. Destination and users of the output datab. Source of input datac. Information on the purpose of the workbookd. All of the above72. Files created with Lotus 1-2-3 have an extensiona. DOCb. XLSc. 123d. WK1Q. Will you answer my MCQ Questions in Facebooka. I don't answer questions in Facebookb. You can post your questions in http://icttrends.com/forumc. Answering in Facebook kills my a lot of timed. If you save my time I'll be able to produce more useful materials73. To delete an embedded objects, firsta. Double click the objectb. Select the object by clicking itc. Press the Shift Delete keysd. Select it and then press the delete key74. Comments can be added to cells usinga. Edit Commentsb. Insert Commentsc. File Commentsd. View CommentsVisit http://mcqSets.com for more multiple choice questions and download MCQ BanksVisit http://mcqSets.com for more downloads7

MCQ Bank for MS ExcelVisit http://mcqSets.com for morematerials75. Which of the following is not a worksheet design criterion?a. Efficiencyb. Aditibilityc. Descriptiond. ClarityQ. Will you answer my questions if I send them to you?a. There are some pages in MCQ Sets that offers you the formb. If you send me questions using the forms in MCQ Setsc. I will try to include your questions in the respective seriesd. Get the most authentic answers for your subjective questions76. To copy cell contents using drag and drop press thea. End keyb. Shift keyc. Ctrl keyd. Esc key84. Which of the following formulas is not entered correctly?a. 10 50b. B7*B1c. B7 14d. 10 50Q. Will you answer my questions if I send them to you?a. There are some pages in MCQ Sets that offers you the formb. If you send me questions using the forms in MCQ Setsc. I will try to include your questions in the respective seriesd. Get the most authentic answers for your subjective questionsFI. Can I download the MCQ banks in MCQSets.com?a. Yes, do a search in mcqsets.com siteb. Yes, some files are offered to download freec. mcqSets.com has download sectionsd. The downloads are available as PDF files77. Which of the following is the latest version of Excela. Excel 2000b. Excel 2002c. Excel MEd. Excel XP85. Which of the following formulas will Excel Not be able tocalculate?a. SUM(Sales)-A3b. SUM(A1:A5)*.5c. SUM(A1:A5)/(10-10)d. SUM(A1:A5)-1078. When you copy a formulaa. Excel erases the original copy of the formulab. Excel edits cell references in the newly copied formulac. Excel adjusts absolute cell referencesd. Excel doesn’t adjust relative cell referencesSl. How reliable are MCQs in MCQ Sets?a. I've paid utmost care in correctnessb. These are tested questions and answersc. However, if you discover any mistakesd. Mail me at contact@mcqsets.com79. The autofill featurea. extends a sequential series of datab. automatically adds range of cell valuesc. applies a boarder around the selected cellsd. none of the aboveQ. Can I download the MCQ banks in MCQSets.com?a. Yes, do a search in mcqsets.com siteb. Yes, some files are offered to download freec. mcqSets.com has download sectionsd. The downloads are available as PDF files80. Which menu option can be sued to split windows into twoa. Format windowb. View window splitc. Window splitd. View splitIO. You can use mcqSets.com fora. Online quizb. MCQ Banksc. Downloadsd. Subjective Questions & answers81. Which of the following is an absolute cell reference?a. !A!1b. A 1c. #a#1d. A182. What symbol is used before a number to make it a label?a. “ (quote)b. (equal)c. (underscore)d. ‘ (apostrophe)83. Which symbol must all formula begin with?a. b. c. (d. @86. A typical worksheet has . Number of columnsa. 128b. 256c. 512d. 102487. How many characters can be typed in a single cell in Excel?a. 256b. 1024c. 32000d. 65535I. Where can you find best quality multiple choice questions?a. icttrends.comb. psexam.comc. prepare.icttrends.comd. mcqsets.com88. A worksheet can have a maximum of . Number of rowsa. 256b. 1024c. 32000d. 65535Q. Can I download the MCQ banks in MCQSets.com?a. Yes, do a search in mcqsets.com siteb. Yes, some files are offered to download freec. mcqSets.com has download sectionsd. The downloads are available as PDF files89. Which of the following is not an example of a value?a. 350b. May 10, 2001c. 0.57d. Serial Number 5077190. The chart wizard term data series refers toa. A chart legendb. A collection of chart data markersc. A set of values you plot in a chartd. A data label91. The Chart wizard term data categories refers to;a. A chart plot areab. A horizontal axisc. The organization of individual values with a chart’s data seriesd. The data range that supply chart data92. A worksheet range is aa. A command used for data modelingb. A range of values such as from 23 to 234c. A group of cellsd. A group of worksheetsVisit http://mcqSets.com for more multiple choice questions and download MCQ Banks8

MCQ Bank for MS ExcelVisit http://mcqSets.com for morematerialsQ. How reliable are MCQs in MCQ Sets?a. I've paid utmost care in correctnessb. These are tested questions and answersc. However, if you discover any mistakesd. Mail me at contact@mcqsets.com102. You can not link Excel worksheet data to a Word documenta. With the right drag methodb. With a hyperlinkc. With the copy and paste special commandsd. With the copy and paste buttons on the standard toolbar93. Getting data from a cell located in a different sheet is calleda. Accessingb. Referencingc. Updatingd. Functioning103. This type of software is similar to an accountant’s worksheeta. Word processingb. Databasec. Spreadsheetsd. Graphics94. Tab scrolling buttona. Allow you to view a different worksheetb. Allow you to view additional worksheet rows downc. Allow you to view additional worksheet columns to the rightd. Allow you to view additional sheets tabs104. which function will calculate the number of workdaysbetween 6/9/2004 and 8/12/2004?a. Workdayb. Datec. Networkdaysd. All of the above95. A numeric value can be treated as a label value if it precedeswitha. Apostrophe (&lsquob. Exclamation (!)c. Hash (#)d. Ampersand (&96. Concatenation of text can be done usinga. Apostrophe (‘)b. Exclamation (!)c. Hash (#)d. Ampersand (&)Q. You can use mcqSets.com fora. Online quizb. MCQ Banksc. Downloadsd. Subjective Questions & answers97. Data can be arranged in a worksheet in a easy to understandmanner usinga. auto formattingb. applying stylesc. changing fontsd. all of above98. You can use drag-and-drop to embed excel worksheet data in aword documenta. By dragging a range of excel data to the word button on thetaskbar while pressing the Ctrl keyb. By dragging a range of excel data to the word button on thetaskbar while pressing Shift keyc. By dragging a range of excel data to the word button on thetaskbar while pressing Alt keyd. None of above99. The auto calculate featurea. Can only add values in a range of cellsb. Provides a quick way to view the result of an arithmetic operationon a range of cellsc. Automatically creates formulas and adds them to a worksheetd. A and cIOO. How reliable are MCQs in MCQ Sets?a. I've paid utmost care in correctnessd. Mail me at contact@mcqsets.com if you discover any error100. Excel uniquely identifies cells within a worksheet with a cellnamea. Cell namesb. Column numbers and row lettersc. Column letters and row numbersd. Cell locator coordinates101. You can zoom a worksheeta. With the mouse pointer in Print Previewb. With the zoom button on the Print Preview toolbarc. With the Zoom command on the view menud. All of the above105. Data marker on a chart are linked to data points in aworksheet, therefore,a. You can automatically apply formatting to a data seriesb. You can change the position of a data marker and automaticallychange the data point value in the worksheetc. You can change a data print value and automatically are draw thechartd. a and bIOI. Where can you find best quality multiple choice questions?a. icttrends.comb. psexam.comc. prepare.icttrends.comd. mcqsets.com106. When you group worksheetsa. You can enter variable data on multiple worksheets at one timeb. You can print more than one worksheet at a timec. You can enter common data, formats, and formulas on multipleworksheets at one timed. b, and c107. You can use the format painter multiple times before youturn it off bya. You can use the format painter button only one time when youclick itb. Double clicking the format painter buttonc. Pressing the Ctrl key and clicking the format painter buttond. Pressing Alt key and clicking the format painter button108. The default header for a worksheet isa. Your nameb. The date and timec. Noned. The sheet tab name109. To drag a selected range of data to another worksheet in thesame workbook, use thea. Tab keyb. Alt keyc. Shift keyd. Ctrl key110. When creating a vertical page breaka. The active cell must be A1b. The active cell can be anywhere in the worksheetc. The active cell must be in row 1d. The active cell must be in column A111. to activate the previous cell in a pre-selected range, pressa. the Alt keyb. the Tab keyc. the Enter keyd. none of aboveIOD. Can I download the MCQ banks in MCQSets.com?a. Yes, do a search in mcqsets.com siteb. Yes, some files are offered to download freeVisit http://mcqSets.com for more multiple choice questions and download MCQ Banks9

MCQ Bank for MS ExcelVisit http://mcqSets.com for morematerials112. When the formula bar is activated, you can seea. The Edit Formula buttonb. The Cancel buttonc. The Enter buttond. All of aboveISS. Will you answer my MCQ Questions in Facebooka. I don't answer questions in Facebookb. You can post your questions in http://icttrends.com/forumc. Answering in Facebook kills my a lot of timed. If you save my time I'll be able to produce more useful materials113. In a worksheet you can press Shift Space to select entirea. Worksheetb. Rowc. Columnd. a, b, and c122. Status indicators are located on thea. Vertical scroll barb. Horizontal scroll barc. Formula bard. Formatting toolbar114. when you print preview a worksheeta. the entire worksheet is displayedb. the selected range is displayedc. the active portion of the worksheet is displayedd. a, b and cISE. Where can you find best quality multiple choice questions?a. icttrends.comb. psexam.comc. prepare.icttrends.comd. mcqsets.comIIS. You can use mcqSets.com fora. Online quizb. MCQ Banksc. Downloadsd. Subjective Questions & answers123. You can open the scenario Manager dialog box by choosingscenarios from the . menu.a. Viewb. Insertc. Formatd. Tools115. You can group noncontiguo

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 d. The Format