Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q71
In Excel it is acceptable  of let long text flow into adjacent cells on a worksheet when
  • A Data will be entered in the adjacent cells
  • B No data will be entered in the adjacent cells
  • C There is not suitable abbreviation of the text
  • D There is not time to format the next
Answer: Option B
Q72
In Excel how can you delete a record ?
  • A Delete the column from the worksheet
  • B Select Data > Form from the menu to open the Data form dialog box, fnd the record and click the Delete button
  • C Select Data > Delete Record from the menu
  • D Click the Delete button on the Standard toolbar
Answer: Option B
Q73
Right clicking something in Excel
  • A Deletes the object
  • B Nothing the right mouse button is there ffor left handed people
  • C Opens a shortcut menu listing everything you can do to the object
  • D Selects the object
Answer: Option C
Q74
In Excel documentation should include
  • A Destination and users of the output data
  • B Source of input data
  • C Information on the purpose of the workbook
  • D All of the above
Answer: Option D
Q75
Files created with Lotus 1-2-3 have an extension
  • A DOC
  • B XLS
  • C 123
  • D WK 1
Answer: Option C
Q76
In Excel to delete an embeded objects, first
  • A Double click the object
  • B Select the object by clicking it
  • C Press the Shift + Delete keys
  • D Select it and then press the delete key
Answer: Option D
Q77
In Excel comments can be added to cells using
  • A Edit > Comments
  • B Insert > Comments
  • C File > Comments
  • D View > Comments
Answer: Option B
Q78
In Excel which of the following is not a worksheet design criterion ?
  • A Efficiency
  • B Aditibility
  • C Description
  • D Clarity
Answer: Option C
Q79
In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page ?
  • A Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
  • B Click page setup on the file menu, click the page tab, click the options button, then enter your choices.
  • C Click page setup on the file menu, click the sheet tab, and make a selection under the print heading.
  • D All of above
Answer: Option A
Q80
In Excel a fast way to add up this column of number is to click in the cell below the numbers and then
  • A Click subtotals on the data menu
  • B View the sum in the formula bar
  • C Click the autosum button on the standard toolbar, then press enter
  • D All of above
Answer: Option C

📚 More from Computer Science & Engineering(CSE)

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Computer Science & Engineering(CSE)
Back to Computer Science & Engineering(CSE)
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test