In Excel you can use drag and drop to embed excel worksheet data in a word document By dragging a range of excel data to the Word button on the taskbar while pressing Shift key By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key A and C Answer 3. Excel probably considers the cell entry January 1, 2000 to be a a. All of above Correct Answer: b 131. What is the file extension of Ms-Word document? Automatically creates formulas and adds them to a worksheet d. All of above Correct Answer: a 117. Hold down the shift key as you click anywhere in the column. When you show the results of formulas with different decimal places that the calculated results 35.
C You can apply Font, border and pattern formats that meets the specified conditions D You can delete any condition from Conditional Formatting dialog box if it is not required 20. How many characters can be typed in a single cell in Excel? None 5 Which of the following is not an option of the spelling dialog box? Which of the following action removes a sheet from workbook? In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values? Use the excel menu bar and toolbars inside the word application b. All of above Correct Answer: b 115. Which of the following operation is valid? Enter the formula using any input values and the appropriate mathematical operators that make up your formula d. How can you accomplish this? Sometimes question from this category are asked as part of the computer operation general knowledge section of basic computer awareness test. A You can add more than one condition to check B You can set condition to look for Bold and apply Italics on them. When you copy a formula a.
Values but not cell references b. On the view menu, click custom views, then click add d. How can you have Excel convert those sums to Euros? Select the range you want, include both cells, point to fill on the Edit menu, and then click down. The word document contains a reference to the original source application c. Which of the following function will use to find the highest number in a series of number? Merge cells option can be applied from A Format Cells dialog box Alignment Tab B Formatting toolbar C Both of above D None of above 12. It applies Italic formatting t the selected text.
Excel files have a default extension of a. Which of the following methods cannot be used to edit the content of cell? Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to d. How do you delete a column? I recently found what I hoped for before you know it at all. Concatenate and manipulate text d. Multiplication and division, positive and negative values, addition and subtraction c. It makes the selected text bold d. It can contain many sheets including worksheets and chart sheets d.
A formula cannot be entered into the cell Correct Answer: b 152. Show formula error value 6. Do you know how to add up columns? Multiple Choice Questions of Microsoft Excel 9-1. Comments can be added to cells using a. To copy cell contents using drag and drop press the a. Which of the following is not a basic step in creating a worksheet? Pressing an arrow key d.
Single Engineering 3 Formulas in Excel start with A. Margins and page length can be adjusted as desired Spelling can be checked and modified through the spell check facility Provides tools such as data consolidation, goal seek, scenario etc. Widen the column Correct Answer: b 139. It can contain text and data b. When you link data maintained in Excel workbook to a Word document a. In this set you will get 10 Multiple Choice Questions of Microsoft Excel and four options to each questions, only one options is correct answer. A You can Find and Replace within the sheet or workbook B Excel does not have option to match case for find C Both are valid D None are valid 18.
You can use the format painter multiple times before you turn it off by a. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify c. By edit the macro in the Visual Basic Editor D. Appears below the menu bar 17. Which of the following shortcut key is used to check spelling? Pressing Ctrl + C b.
When you link data maintained in an excel workbook to a word document a. Hold down the Ctrl key as you click anywhere in the column 9. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. The auto calculate feature a. None of above Correct Answer: d 112. You can use the horizontal and vertical scroll bars to a.
In Excel default header for a worksheet is Your name The date and time None Answer The sheet tab name. Where can you set the shedding color for a range of cells in Excel? Labels and values but not formulas c. Can you find the number of marked squares in a sheet? There is a comment associated with the cell c. Because Excel uses hidden decimal places in computation d. The word document must contain a hyperlink d. All of above Correct Answer: d 129. A worksheet can have a maximum of ….
You can activate a cell by a. It returns the serial number of the current date and time B. When you see a cell with a red triangle in the top right corner, what does this signify? In Excel 3-D reference in a formula Limits the formatting options Cannot be modified Spans worksheets Answer Only appears on summary worksheets 15. Excel worksheet cells work very similarly to what common element of the windows graphical user interface a. Pressing the Esc key B.