MICROSOFT EXCEL Questions and Answers pdf free download,MS EXCEL objective type MS Excel Mcqs Online Quiz Questions in Hindi. Download here the Microsoft Excel MCQ Bank as PDF file. MS Excel MCQ Bank contains multiple choice questions with four options each. MS Excel Questions Answers (MCQ -Multiple Choice, Objective Type) Online test Microsoft Excel quiz question bank in PDf format for download will be added.
|Language:||English, Spanish, Japanese|
|Genre:||Politics & Laws|
|ePub File Size:||27.67 MB|
|PDF File Size:||8.20 MB|
|Distribution:||Free* [*Sign up for free]|
MCQ Bank for MS Excel The downloads are available as PDF files. When integrating Ms-Word and Excel, Word is usually the a. Clicking directly may open it on your browser itself. File Name: ms-excel-mcq- portal7.info File Size: MB. Printed Pages: Number of MCQ Questions: संकलन - ी. अिनल माने(९७६६५९९७८०) यशवंतराव च हाण व ालय, यशवंतनगर ,ता.कराड. MS Excel MCQ Quiz Set 2. 1. You can auto fit the width of column.
Which of the following methods cannot be used to enter data in a cell a. Pressing an arrow key b. Pressing the Tab key c. Pressing the Esc key d. Clicking on the formula bar 2.
Which of the following is not a way to complete a cell entry?
Pressing enter b. Pressing any arrow key on the keyboard c. Clicking the Enter button on the Formula bar d. Pressing space bar 4.
You can activate a cell by a. Pressing the Tab key b. Clicking the cell c. Pressing an arrow key d. All of the above 5. Text formulas: b.
Concatenate and manipulate text d. Show formula error value 6. How do you insert a row? 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 click the Insert Row button on the standard toolbar d.
All of the above 7. Which of the following is not a basic step in creating a worksheet? Save workbook c. Enter text and data d.
Copy the worksheet 8. How do you select an entire column? Click the column heading letter c. Hold down the shift key as you click anywhere in the column. Hold down the Ctrl key as you click anywhere in the column 9. How can you print three copies of a workbook? To create a formula, you first: a. Select the cell you want to place the formula into b.
Enter the formula using any input values and the appropriate mathematical operators that make up your formula d. Choose the new command from the file menu To center worksheet titles across a range of cells, you must a. Select the cells containing the title text plus the range over which the title text is to be centered b. Data will be entered in the adjacent cells b.
To delete an embedded objects. 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. When you want to insert a blank imbedded excel object in a word document you can a. No data will be entered in the adjacent cells c. Copy cell contents b. Click the Delete button on the Standard toolbar Clicking the formula button b. DOC b. Pressing the Ctrl key while dragging over the desired cells c.
Select it and then press the delete key Source of input data c. Click the save button on the standard toolbar from the menu b. Click the import excel command on the file menu Q. Add cell contents d. Column chart Page Orientation c. Clicking the formula bar c. Click the create worksheet button on the formatting toolbar d. Pressing the F2 key d. Which type of chart should you use? Opens a shortcut menu listing everything you can do to the object d.
Scenarios d. You want to track the progress of the stock market on a daily basis. May A chart plot area b. A typical worksheet has …. The Chart wizard term data categories refers to. Which of the following formulas is not entered correctly? Which of the following is not a worksheet design criterion? End key b. When you copy a formula a. Number of columns a. A worksheet can have a maximum of ….
Shift key c. A group of cells d. A horizontal axis c. Which of the following is not an example of a value? Excel edits cell references in the newly copied formula c.
Esc key A1 Number of rows a. Which of the following formulas will Excel Not be able to calculate? Serial Number Excel c. A set of values you plot in a chart d. The chart wizard term data series refers to a. A data label What symbol is used before a number to make it a label? A collection of chart data markers c. Excel adjusts absolute cell references d. Excel b. Excel XP A worksheet range is a a. Which of the following is the latest version of Excel a.
A5 Description d. Which of the following is an absolute cell reference? How many characters can be typed in a single cell in Excel? The data range that supply chart data A command used for data modeling b. Get the most authentic answers for your subjective questions FI. Excel erases the original copy of the formula b.
A range of values such as from 23 to c. Ctrl key d. Excel ME d. To copy cell contents using drag and drop press the a. Which symbol must all formula begin with? Aditibility c. Which menu option can be sued to split windows into two a. The autofill feature a. Clarity Q. Efficiency b. A group of worksheets Visit http: A chart legend b. Spreadsheets d. Pressing Alt key and clicking the format painter button Column letters and row numbers d. The default header for a worksheet is a.
Your name b. You can zoom a worksheet a. Concatenation of text can be done using a. Networkdays d. The date and time c. The sheet tab name By dragging a range of excel data to the word button on the taskbar while pressing Alt key d.
Referencing c. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key b. You can use the format painter button only one time when you click it b. By dragging a range of excel data to the word button on the taskbar while pressing Shift key c. Can only add values in a range of cells b. You can not link Excel worksheet data to a Word document a.
Shift key d. Database c. Hash d. With the zoom button on the Print Preview toolbar c. Tab scrolling button a. You can use drag-and-drop to embed excel worksheet data in a word document a. When you group worksheets a. Data can be arranged in a worksheet in a easy to understand manner using a. Excel uniquely identifies cells within a worksheet with a cell name a. Automatically creates formulas and adds them to a worksheet d.
Accessing b. Cell locator coordinates With the mouse pointer in Print Preview b. Tab key b. You can print more than one worksheet at a time c.
Functioning None d. Ctrl key You can change the position of a data marker and automatically change the data point value in the worksheet c. When creating a vertical page break a. Date c. The auto calculate feature a. You can change a data print value and automatically are draw the chart d.
The active cell must be in column A Updating d. You can enter variable data on multiple worksheets at one time b. Cell names b. Word processing b. A numeric value can be treated as a label value if it precedes with a. Provides a quick way to view the result of an arithmetic operation on a range of cells c.
With the copy and paste buttons on the standard toolbar Data marker on a chart are linked to data points in a worksheet. You can enter common data. With the Zoom command on the view menu d. Allow you to view additional worksheet columns to the right d.
Column numbers and row letters c. I've paid utmost care in correctness d. A and c IOO. Allow you to view additional worksheet rows down c.
To drag a selected range of data to another worksheet in the same workbook. Workday b. The active cell must be in row 1 d. Allow you to view a different worksheet b. Getting data from a cell located in a different sheet is called a.
Alt key c. You can automatically apply formatting to a data series b. Allow you to view additional sheets tabs The active cell must be A1 b. Graphics The active cell can be anywhere in the worksheet c. The Cancel button c. View b. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to d. When you link data maintained in Excel workbook to a Word document a.
When you show the results of formulas with different decimal places than the calculated results A data map is helpful a. Because Excel uses hidden decimal places in computation d. To show a geographic distribution of data c.
Tools d. To show changes in data over time The print density of characters b. A formula cannot be entered into the cell To hold row and column titles in places so that they do not scroll when you scroll a worksheet.
The group button on the standard toolbar b. You can open the scenario Manager dialog box by choosing scenarios from the …. Row and column titles Visit http: To compare data points d.
You can group noncontiguous worksheets with a. To edit data in an embedded Excel worksheet object in a Word document a. Edit the data in a Excel source application d. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? All of above Weight refers to a. Column d. The ctrl key and mouse d. Use the Excel menu bar and toolbars inside the word application b. When you have too much data to chart b.
The Word document cannot be edited b. When the formula bar is activated. The Enter button d. Format c. The height of the printed character c. There is a comment associated with the cell c..
Tools All of above ISS. Use the Word menu bar and toolbars Use Ctrl to select all three cells. With buttons on the standard toolbar d.
Which of the following setup options can not be set in the page setup dialog box? Insert c. Data llP. With commands on a shortcut menu c. You can open the Sort dialog box by choosing Sort from the …. The design and appearance of characters The Word document contains a reference to the original source application c.
Formatting toolbar The font color for text in the cell is red d. Row c. Upright or slanted shape d. Vertical or horizontal placement c. Worksheet b. Orientation d. Copy the selected cell. The Edit Formula button b. Format d. When you see a cell with a red triangle in the top right corner. There is an error in the cell b. The shift key and the mouse c. Printer selection b. Copy the worksheet Widen the column Visit http: Standard b. The Name box a. Select the range you want. Select columns D.
Modify the worksheet c. Database program c. Charts tips can a. View different worksheets Use data — text to columns menu item c. Appears t the left of the formula bar c. Double click the boundary to the right of the column heading c.
Word processor program d. Formatting c. Select the cells containing the title text and use the fill handle to center the text across a range of cells b. Range b. Scenario c. Right click a cell and then click insert b. Drawing d. Select column E c. View different rows and columns c. Source c. All can be hyperlinks Show the value of data point d. None Click the insert menu and then click function c.
Copy the second cell. Save the workbook b. Press Alt and single click anywhere in the column d. Got functions?
You need the insert function dialog box. What term refers to a specific set of values saved with the workbook? To center worksheet titles across a range of cell. When integrating Ms-Word and Excel. Right click on column and select Pick from list b. Which of the following describes how to select all the cells in a single column? What function displays row data in a column or column data in a row?
You can add an image to a template by clicking the Insert Picture From File button on the …. How do you get it? How do you change column width to fit the contents? Show the name of a data series c. What-if analysis Single-click the boundary to the left to the column heading b. Index c. Speed d. None Q. Headings c. What do we call a computer program that organizes data in rows and columns of cells?
You might use this type of program to keep a record of the money you earned moving lawns over the summer. Spreadsheet program b. To insert three columns between columns D and E you would a. Special shapes like stars and banners b.
Select both cells. Select column D b. Word is usually the a. Hyperlinks cannot be a. Select the cells containing the title text and use the fill handle to center the text across a range of cells d. Desktop publisher program Select columns E.
Drawing objects like rectangles ovals c. Hyperlink b. Left click on the gray column title button d. Transpose d. Show the formatting of a data label b. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? Rows and columns b. Rows Visit http: Trend line d. Picture Text Q. Data Q. The be turned off for display and printing d. Apply a selected background color d.
Youar German supplier still invoices for parts in deutsche marks. Point to speech on the tools menu. I've paid utmost care in correctness c. On the view menu. Chinese or Japanese. It can contain text and data b.. Round c. May be turned on or off for printing c. Rows and columns d. Linked d. Clicking the enter button to the formula bar Visit http: Gridlines a. Lines and spaces b. Insert b.
Data NOT Layers and planes c. You have to work hard to create it Visit http: Which types of charts can excel produce? Placed in a word table c. On the tools menu. PV present value d.
AND c. Hyperlinked b. You can print only an embedded chart by a. NPER number of periods c. Bar charts. Pressing the tab key c. You can open the consolidate dialog box byt choosing Consolidate from the ….
Sum d. On the file menu. Which of the following methods can not be used to enter data in a cell? Except for the …… function. If you are working in English US.
Which of the following is a correct order of precedence in a formula calculation? Excel can speak data as you enter it. Embedded Q. How should you print a selected area of a worksheet.
PMT payments b. Selecting the chart before you print d. Height and width Q. Checks whether text is the same in one cell as in the next c. Finds related records d. When you insert an Excel file into a Word document.
Bar charts and line graphs only Formatting the chart before you print c. Click validation on the data menu c. Only line graphs c. The downloads are available as PDF files Q.
Nested b. Moving the chart to a chart sheet before you print. Which function calculates your monthly mortage payment? May be turned off for display but turned on for printing b. A function inside another function is called a …. How can you have Excel convert those sums to Euros? How do you activate this feature? On the Insert menu. Frmat c. Line graphs and pie charts only b. How are data organized in a spreadsheet? G10 c. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
F11 Refresh Data d. Enter b. Series d. Double clicking the cell Q. F2 key c. G1-G10 b. G10 Show Detail To protect a worksheet. Change Formula b.
Which is the correct sequence of events that will do this? F4 key To copy cell contents using drag and drop. Field c. A user wishes to remove a spreadsheet from a workbook.
Function c. Pressing the Alt key b. 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 ….
Menu a. Extends a sequential series of data b. Using the Format — Cells — Font menu item d. If you press …. Edit b. TAB d. You can quickly change the appearance of your work by choosing Auto Format from the …. Using the Tools — Wizard — Web Form menu item c. Right click on the spreadsheet and select Insert — Entire Column d. Data d.
Esc key d. G10 d. What is an expression that tells how the numbers in a determined set of cells are to be calculated? F1 key b. Format Report b. You can edit existing Excel data by pressing the a. Pressing F2 d. Which of the following will not set text in selected cells to italics? Automatically adds a range of cell values c.
Auditability c. Applies a boarder around selected cells d. Which of the following is not an option in the spelling dialog box? What is the keyboard shortcut button or buttons to be pressed for creating a chart from the selected cells? Goal Seek b. Syntax Q. Which of the following methods cannot be used to edit the content of cell? Get the most authentic answers for your subjective questions Visit http: Ignore c.
Scenario Summary report c. F3 key d. Ignore all d. Pivot Table c.. View c. Query Correct Answer: What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed a.
You can open the Highlight Changes dialog box by choosing Track Changes from the …. Trend line Forecasting d. None of above Q. Qtr 2. Insert Decimal Places b. Currency Symbol Zip Code b. Special category of Number tab in Format Cells dialog box can be used to apply formats like a. How can you remove borders applied in cells? None of above SOO. Excel does not have indentation feature b.
Open the list on Border tool in Formatting toolbar then choose first tool no border c. Choose required color on Fill Color tool in Formatting toolbar c. Pivot Table Field List c. From Line Style tool in Drawing toolbar d. Use separator c. You can specify indentation only if you turn the rulers on c. Reviewing Q. Where can you set the shedding color for a range of cells in Excel? Negative numbers d. Which of the following is not a valid Zoom percentage in Excel?
If you need a text to show vertically in a cell. Can you set 0. A spreadsheet Visit http: Graphic program b. None of these c. Word processor d. Which of the following format you can decide to apply or not in AutoFormat dialog box?
HTML b. From Format choose Columns and then Autofit Selection c. Currency Symbol c. Border format c. Pivot Table Report Both of above d. From Border tab in Format Cells dialog box b. Font format d.
Pre-made sheet formats like Simple. None of above lgs. Double clicking on the right border of column header b. You can automatically adjust the size of text in a cell if they do not fit in width by a. From Border tool in Formatting toolbar c. Pivot Table List d. Indentation can be set from Format Cells dialog box d. Excel is a a. Choose None on Border tab of Format cells b. How will you achieve this? To create an interactive Pivot Table for the web.
Formatting a cell in Currency. Formatting toolbar c. Colorful et can be applied from a. From Format Cells dialog box mark Shrink to fit check box d. Choose Distributed from the Vertical drop down list of Format Cells dialog box d.
Choose 90 Degrees in Orientation of Format Cells dialog box c. Merge cells option can be applied from a. You can not set page border in Excel Visit http: You can set Page Border in Excel from a. Number format b. Format Cells dialog box Alignment Tab b. The date value for the day according to system clock b. Phone Number c. Choose required color form Patterns tab of Format Cells dialog box b. Choose Vertical on Text alignment in Format Cells dialog box b.
The time value according to system clock c. Choose required color on Fill Color tool in Drawing toolbar d. The indentation can be specified only when printing Which function will you use to enter current time in a woksheet cell? The selected cells are deleted and cells are shifted up Sheet tabs can be colored b. Tab scroll buttons are place on Excel screen a. The selected cells are deleted and the cells are shifted left d.
Click Gridline tool on Forms toolbar c. From Format Cells dialog box click on Merge Cells check box b. Cell value b. From Format Cells dialog box choose Merge and Center check box d. You can delete any condition from Conditional Formatting dialog box if it is not requried Each excel file is a workbook that contains different sheets. Click on Merge and Center tool on formatting toolbar The Name box on to the left of formula bar a.
You can set condition to look for Bold and apply Italics on them. Word is usually a. Press Enter d. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
When a range is selected. Add b. When all the numbers between 0 and in a range should be displayed in Red Color. Which of the following is not true regarding Conditional Formatting?
Fill Across Worksheet d. Status Bar c. You can add more than one condition to check b. Which tool you will use to join some cells and place the content at the middle of joined cell? Which of the following can not be a sheet in workbook? Click the formula bar d. If you send me questions using the forms in MCQ Sets b. Press Tab c. What will you set to effect that?
You want to set such that when you type Baishakh and drag the fill handle. Auto Fill Options c. Press the F2 key c. Which of the following is not the correct method of editing the cell content? Select the cells that contain number between 0 and then click Red color on Text Color tool d. Divide d. Formula c. All of above SlQ. I will try to include your questions in the respective series You can use the formula pallette to a.
Which of the following option is not available in Paste Special dialog box?