excel mcqs.docx

1. You can use the formula pallette to A) format cells containing numbers B) create and edit formula containing functions C) enter assumptions data D) copy a range of cells 2. When a range is selected, how can you activate the previous cell?A) Press the Alt key B) Press Tab C) Press Enter D) None of above 3. Which tool you will use to join some cells and place the content at the middle of joined cell?A) From Format Cells dialog box click on Merge Cells check box B) From Format Cells dialog box select the Centered alignment C) From Format Cells dialog box choose Merge and Center check box D) Click on Merge and Center tool on formatting toolbar 4. Tab scroll buttons are place on Excel screenA) towards the bottom right corner B) towards the bottom left corner C) towards the top right corner D) towards the top left corner 5. The Name box on to the left of formula barA) shows the name of workbook currently working on B) shows the name of worksheet currently working on C) shows thename of cell or range currently working on D) None of above 6. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?A) work sheet B) chart sheet C) module sheet D) data sheet 7. Which of the following is not the correct method of editing the cell content?A) Press the Alt key B) Press the F2 key C) Click the formula bar D) Double click the cell 8. You can merge the main document with data source in Excel. In mail merge operation, Word is usuallyA) server B) source C) client D) none 9. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?A) F8 B) F9 C) F10 D) F11 10. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?A) Custom List B) Auto Fill Options C) Fill Across Worksheet D) Fill Series 11. Where can you change automatic or manual calculation mode in Excel?A) Double CAL indicator on status bar B) Go to Tools Options Calculation and mark the corresponding radio button C) Both of above D) None of above 12. How can you show or hide the gridlines in Excel Worksheet?A) Go to Tools Options View tab and mark or remove the check box named Gridline B) Click Gridline tool on Forms toolbar C) Both of above D) None of above 13. Which of the following Excel screen components can NOT be turned on or off?A) Formula Bar B) Status Bar C) Tool Bar D) None of above 14. What happens when you press Ctrl + X after selecting some cells in Excel?A) The cell content of selected cells disappear from cell and stored in clipboard B) The cells selected are marked for cutting C) The selected cells are deleted and the cells are shifted left D) The selected cells are deleted and cells are shifted up 15. Which of the following option is not available in Paste Special dialog box?A) Add B) Subtract C) Divide D) SQRT 16. Which command will you choose to convert a column of data into row?A) Cut and Paste B) Edit Paste Special Transpose C) Both of above D) None of above 17. It is acceptable to let long text flow into adjacent cells on a worksheet whenA) data will be entered in the adjecent cells B) no data will be entered in the adjacent cells C) there is no suitable abbrevition for the text D) there is not time to format the text 18. Which of the cell pointer indicates you that you can make selection?A) Doctors symbol (Big Plus) B) small thin plus icon C) Mouse Pointer with anchor at the tip D) None of above 19. Which of the cell pointer indicates that you can fill series?A) Doctors symbol (Big Plus) B) small thin plus icon C) Mouse Pointer with anchor at the tip D) None of above 20. Which of the cell pointer indicate that you can move the content to other cell?A) Doctors symbol (Big Plus) B) small thin plus icon C) Mouse Pointer with anchor at the tip D) None of above Answers1-B, 2-D, 3-D, 4-B, 5-C, 6-D, 7-A, 8-C, 9-B, 10-A, 11-B, 12-C, 13-D, 14-B, 15-D, 16-B, 17-B, 18-A, 19-B, 20-C,Percentage in Excel?A) 10B) 100C) 300D) 5002. The spelling tool is placed on _ toolbarA) StandardB) FormattingC) DrawingD) Reviewing3. If you need a text to show vertically in a cell. How will you achieve this?A) Choose Vertical on Text alignment in Format Cells dialog boxB) Choose 90 Degrees in Orientation of Format Cells dialog boxC) Choose Distributed from the Vertical drop down list of Format Cells dialog boxD) Choose Center Across Selection from Horizontal combo box in Format Cells dialog box4. Can you set 0.5 inch left indentation for a cell in Excel?A) Excel does not have indentation featureB) You can specify indentation only if you turn the rulers onC) Indentation can be set from Format Cells dialog boxD) The indentation can be specified only when printing5. You can automatically adjust the size of text in a cell if they do not fit in width byA) Double clicking on the right border of column headerB) From Format choose Columns and then Autofit SelectionC) From Format Cells dialog box mark Shrink to fit check boxD) All of above6. Formatting a cell in Currency, you can specifyA) Decimal PlacesB) Currency SymbolC) Both of aboveD) None of above7. Formatting a cell in Number format you cant setA) Decimal PlacesB) Use 1000 separatorC) Negative numbersD) Currency Symbol8. What is entered by the function =today()A) The date value for the day according to system clockB) The time value according to system clockC) Todays date as Text formatD) All of above9. Which function will you use to enter current time in a woksheet cell?A) =today()B) =now()C) =time()D) =currentTime()10. Special category of Number tab in Format Cells dialog box can be used to apply formats likeA) Zip CodeB) Phone NumberC) Both of aboveD) None of above11. Merge cells option can be applied fromA) Format Cells dialog box Alignment TabB) Formatting toolbarC) Both of aboveD) None of above12. Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied fromA) from Fromat CellsB) from Format AutoformatC) from Table AutoformatD) All of above13. Which of the following format you can decide to apply or not in AutoFormat dialog box?A) Number formatB) Border formatC) Font formatD) All of above14. How can you remove borders applied in cells?A) Choose None on Border tab of Format cellsB) Open the list on Border tool in Formatting toolbar then choose first tool (no border)C) Both of aboveD) None of above15. Where can you set the shedding color for a range of cells in Excel?A) Choose required color form Patterns tab of Format Cells dialog boxB) Choose required color on Fill Color tool in Formatting toolbarC) Choose required color on Fill Color tool in Drawing toolbarD) All of above16. You can set Page Border in Excel fromA) From Border tab in Format Cells dialog boxB) From Border tool in Formatting toolbarC) From Line Style tool in Drawing toolbarD) You can not set page border in Excel17. When all the numbers between 0 and 100 in a range should be displayed in Red Color, applyA) Use =if() function to format the required numbers redB) Apply Conditional Formatting command on Format menuC) Select the cells that contain number between 0 and 100 then click Red color on Text Color toolD) All of above18. You can check the conditions against _ when applying conditional formattingA) Cell valueB) FormulaC) Both of aboveD) None of above19. Which of the following is not true regarding Conditional Formatting?A) You can add more than one condition to checkB) You can set condition to look for Bold and apply Italics on them.C) You can apply Font, border and pattern formats that meets the specified conditionsD) You can delete any condition from Conditional Formatting dialog box if it is not requried20. Which of the following is invalid statement?A) Sheet tabs can be coloredB) Some picture can be applied as a background of a sheetC) You can set the column width automatically fit the amount of textD) The width of a row and be specified manually or fit automaticallyAnswers1-D, 2-A, 3-B, 4-C, 5-C, 6-C, 7-D, 8-A, 9-B, 10-C, 11-A, 12-B, 13-D, 14-C, 15-D, 16-D, 17-B, 18-C, 19-B, 20-D,1. Which of the following is an absolute cell reference?a. !A!1b. $A$1c. #a#1d. A1Correct Answer: b2. What symbol is used before a number to make it a label?a. “ (quote)b. = (equal)c. _ (underscore)d. (apostrophe)Correct Answer: b3. Which symbol must all formula begin with?a. =b. +c. (d. Correct Answer: a4. Which of the following formulas is not entered correctly?a. =10+50b. =B7*B1c. =B7+14d. 10+50Correct Answer: d5. Which of the following formulas will Excel Not be able to calculate?a. =SUM(Sales)-A3b. =SUM(A1:A5)*.5c. =SUM(A1:A5)/(10-10)d. =SUM(A1:A5)-10Correct Answer: a6. A typical worksheet has . Number of columnsa. 128b. 256c. 512d. 1024Correct Answer: b7. How many characters can be typed in a single cell in Excel?a. 256b. 1024c. 32,000d. 65,535Correct Answer: d8. A worksheet can have a maximum of . Number of rowsa. 256b. 1024c. 32,000d. 65,535Correct Answer: d9. Which of the following is not an example of a value?a. 350b. May 10, 2001c. 57%d. Serial Number 50771Correct Answer: d10. 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 labelCorrect Answer: b11. The Chart wizard term data categories refers to;a. A chart plot areab. A horizontal axisc. The organization of individual values with a charts data seriesd. The data range that supply chart dataCorrect Answer: b12. 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 worksheetsCorrect Answer: c13. Getting data from a cell located in a different sheet is called a. Accessingb. Referencingc. Updatingd. FunctioningCorrect Answer: b14. 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 tabsCorrect Answer: d15. A numeric value can be treated as a label value if it precedes witha. Apostrophe (&lsquob. Exclamation (!)c. Hash (#)d. Ampersand (&Correct Answer: a16. Concatenation of text can be done usinga. Apostrophe (&lsquob. Exclamation (!)c. Hash (#)d. Ampersand (&Correct Answer: d17. Data can be arranged in a worksheet in a easy to understand manner usinga. auto formattingb. applying stylesc. changing fontsd. all of aboveCorrect Answer: d18. You can use drag-and-drop to embed excel worksheet data in a word documenta. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl keyb. By dragging a range of excel data to the word button on the taskbar while pressing Shift keyc. By dragging a range of excel data to the word button on the taskbar while pressing Alt keyd. None of aboveCorrect Answer: a19. The auto calculate featurea. Can only add values in a range of cellsb. Provides a quick way to view the result of an arithmetic operation on a range of cellsc. Automatically creates formulas and adds them to a worksheetd. A and cCorrect Answer: b20. Excel uniquely identifies cells within a worksheet with a cell namea. Cell namesb. Column numbers and row lettersc. Column letters and row numbersd. Cell locator coordinatesCorrect Answer: c1. Which of the following is not an option in the spelling dialog box?a. Editb. Ignorec. Ignore alld. ChangeCorrect Answer: a2. You can quickly change the appearance of your work by choosing Auto Format from the . Menua. Editb. Viewc. Formatd. ToolsCorrect Answer: c3. To protect a worksheet, you can choose Protection and the Protect Sheet from the . menua. Editb. Formatc. Toolsd. DataCorrect Answer: c4. You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu.a. Editb. Insertc. Formatd. ToolsCorrect Answer: d5. Which of the following is not a worksheet design criterion?a. Efficiencyb. Auditabilityc. Descriptiond. Clarity Correct Answer: c6. To copy cell contents using drag and drop, press thea. End keyb. Shift keyc. Esc keyd. None of aboveCorrect Answer: d7. If you press ., the cell accepts your typing as its contents.a. Enterb. Ctrl + Enterc. TABd. InsertCorrect Answer: a8. The autofill featurea. Extends a sequential series of datab. Automatically adds a range of cell valuesc. Applies a boarder around selected cellsd. None of aboveCorrect Answer: a9. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?a. F3b. F5c. F7d. F11Correct Answer: D10. you can use the formula palette toa. format cells containing numbersb. create and edit formulas containing functionsc. entered assumptions datad. copy a range of cellsCorrect Answer: b11. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changeda. Format Reportb. Pivot Tablec. Refresh Datad. Show DetailCorrect Answer: c12. What is an expression that tells how the numbers in a determined set of cells are to be calculated?a. Formulab. Fieldc. Datad. Query Correct Answer: Correct Answer: A13. “Qtr 1, Qtr 2, Qtr 3” is an example of aa. Formulab. Functionc. Seriesd. SyntaxCorrect Answer: c14. You can edit existing Excel data by pressing thea. F1 keyb. F2 keyc. F3 keyd. F4 keyCorrect Answer: b15. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is .a. G1-G10b. B1.G10c. B1;G10d. B1:G10Correct Answer: d16. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?a. Go to File-Save As Save As Type Excel worksheetb. Right click on the spreadsheet tab and select DELETEc. Right click on the spreadsheet and select Insert Entire Columnd. None of aboveCorrect Answer: b17. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?a. Goal Seekb. Scenario Summary reportc. Forecastingd. Trend lineCorrect Answer: d18. what term describes a background that appears as a grainy, non smooth surfacea. gradientb. patternc. solidd. textureCorrect Answer: a19. Excel is aa. Graphic programb. None of thesec. Word processord. A spreadsheetCorrect Answer: d20. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component calleda. HTMLb. Pivot Table Field Listc. Pivot Table Listd. Pivot Table ReportCorrect Answer: d41. You can use the formula palette toa. Format cells containing numbersb. Create and edit formulas containing functionsc. Enter assumptions datad. Copy a range of cellsCorrect Answer: b42. You can convert existing excel worksheet data an charts to an HTML document by usinga. FTP wizardb. Internet assistant wizardc. Intranet wizardd. Import wizardCorrect Answer: b43. 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 erroneousCorrect Answer: c44. Which of following is Not one of Excels what-if function?a. Goal seekb. Solverc. Scenario managerd. Auto OutlineCorrect Answer: d45. When you insert an excel file into a word document. The data area. Hyperlinked placed in a word tableb. Linkedc. Embeddedd. Use the word menu bar and toolbarsCorrect Answer: b46. Which of the following is not information you can specify using the solver?a. Input cellsb. Constraintsc. Target celld. Changing cellsCorrect Answer: a47. 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 itCorrect Answer: c48. Excel probably considers the cell entry January 1, 2000 to be aLabelValueFormulaText stringCorrect Answer: b49. 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 onlyCorrect Answer: a50. All worksheet formulaa. Manipulate valuesb. Manipulate labelsc. Return a formula resultd. Use the addition operatorCorrect Answer: c51. Which of the fol