Home Microsoft Excel Test Preparation Online Mcqs Microsoft Excel Test Preparation Online Mcqs Microsoft Excel Test Preparation Online Mcqs With Answer Start Below 12345678910111213141516171819202122232425Show paginator Hide paginatorUncategorized 1. Each excel file is called a workbook because?You have to work hard to create itIt can contain many sheets including worksheets and chart sheetsIt can contain text and dataIt can be modifiedQuestion 1 of 25 Loading... 2. All worksheet formula?Return a formula resultManipulate labelsUse the addition operatorManipulate valuesQuestion 2 of 25 Loading... 3. Which of the following is not a valid data type in excel?CharacterDate/timeNumberLabelQuestion 3 of 25 Loading... 4. What does the VLOOKUP function do?Checks whether text is the same in one cell as in the nextAll of aboveLooks up text that contain ‘v’Finds related recordsQuestion 4 of 25 Loading... 5. Which of the following options is not located in the Page Setup dialog box? Headers and FootersPage OrientationPage Break PreviewMarginsQuestion 5 of 25 Loading... 6. Which types of charts can excel produce?Bar charts and line graphs onlyOnly line graphsBar charts, line graphs and pie chartsLine graphs and pie charts onlyQuestion 6 of 25 Loading... 7. Macros are “run” or executed from the ….. menu?DataInsertFrmatToolsQuestion 7 of 25 Loading... 8. You can open the consolidate dialog box by choosing Consolidate from the ….. menu?ToolsInsertDataFormatQuestion 8 of 25 Loading... 9. Which of the following methods can not be used to edit the contents of a cell? Double clicking the cellClicking the formula barPressing the F2 keyPress the Alt keyQuestion 9 of 25 Loading... 10. To save a workbook, you? Press Ctrl+F5Click Save on the Windows Start buttonClick the save button on the standard toolbar from the menuSelect Edit>SaveQuestion 10 of 25 Loading... 11. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Ctrl +HomePress Shift + HomePress Alt + HomePress HomeQuestion 11 of 25 Loading... 12. When you insert an Excel file into a Word document, the data are?Placed in a word tableEmbeddedLinkedHyperlinkedQuestion 12 of 25 Loading... 13. Excel worksheet cells work very similarly to what common element of the windows graphical user interface?Combo boxesList boxesOption buttonsText boxesQuestion 13 of 25 Loading... 14. What function displays row data in a column or column data in a row?Hyperlink RowsIndexTransposeQuestion 14 of 25 Loading... 15. When you want to insert a blank imbedded excel object in a word document you can? Click the create worksheet button on the formatting toolbarClick the object command on the insert menuClick the office links button on the standard toolbarClick the import excel command on the file menuQuestion 15 of 25 Loading... 16. You can edit a cell by? Selecting Edit>Edit Cell from the menuDouble clicking the cell to edit it in-placeNone of aboveClicking the formula buttonQuestion 16 of 25 Loading... 17. You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Pie chartLine chartRow chartColumn chartQuestion 17 of 25 Loading... 18. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?You have to retype everything and manually add the dollar signs, commas, and decimalsSelect Format > Money from the menuClick the Currency Style button on the formatting toolbarNone of theseQuestion 18 of 25 Loading... 19. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?ORNotIFANDQuestion 19 of 25 Loading... 20. To view a cell comment? click the display comment command on the window menuposition the mouse pointer over the cellclick the comment command on the view menuclick the edit comment command on the insert menuQuestion 20 of 25 Loading... 21. If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you? Press the Enter buttonPress the Edit Formula buttonPress EscPress the Erase keyQuestion 21 of 25 Loading... 22. Which of the following is a correct order of precedence in formula calculation?All of aboveMultiplication and division exponentiation positive and negative valuesAddition and subtraction, positive and negative values, exponentiationMultiplication and division, positive and negative values, addition and subtractionQuestion 22 of 25 Loading... 23. The Paste Special command lets you copy and paste?Multiply the selection by a copied valueCell commentsThe resulting values of a formula instead of the actual formulaFormatting optionsQuestion 23 of 25 Loading... 24. Gridlines?The be turned off for display and printingA, b and cMay be turned on or off for printingMay be turned off for display but turned on for printingQuestion 24 of 25 Loading... 25. How are data organized in a spreadsheet?Height and widthLayers and planesRows and columnsLines and spacesQuestion 25 of 25 Loading... Loading... Related Study Posts:Excel Labs Medical Report Result OnlineASF Written Test Preparation Online McqsOnline ECAT Test Preparation McqsFPSC SST Test Preparation Mcqs OnlinePPSC Lecturer Test Preparation Online McqsTESCO Jobs Online NTS Test Preparation McqsLecturer Test KPPSC Preparation Mcqs OnlineFIA ASI Sub Inspectors Job 2024 OTS Test Preparation…SPSC SST Test Preparation Mcqs Online with SyllabusFPSC Test Preparation Mcqs Online Subject Wise