Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q31
The AutoFill feature
  • A extends a sequential series of data
  • B automatically adds a range of cell values
  • C selects a range of cells
  • D none of the above
Answer: Option D
Q32
You can copy data or formulas
  • A with the copy, paste and cut commands on the edit menu
  • B with commands on a shortcut menu
  • C with buttons on the standard toolbar
  • D all of the above
Answer: Option D
Q33
To view a cell comment
  • A click the edit comment command on theinsert menu
  • B click the display comment command on the window menu
  • C position the mouse pointer over the cell
  • D click the comment command on the view menu
Answer: Option C
Q34
To hold row and column titles in place so that they do not scroll when you scroll when you scroll a worksheet, click the
  • A unfreeze panes command on the window menu
  • B freeze panes command on the window menu
  • C hold titles command on the edit menu
  • D split command on the window menu
Answer: Option B
Q35
In Excel default header for a worksheet is
  • A Your name
  • B The date and time
  • C None
  • D The sheet tab name
Answer: Option C
Q36
In Excel which of the following is not an option in the spelling dialog box
  • A Edit
  • B Ignore
  • C Ignore all
  • D Change
Answer: Option A
Q37
Excel uses the ............. Function when creating a data table
  • A Average
  • B Count
  • C Sum
  • D Table
Answer: Option D
Q38
In Excel you can copy cell formats from one cell to another by using the
  • A Backspace key
  • B Default font
  • C Format painter
  • D Formatting toolbar
Answer: Option C
Q39
In Excel accounting style shows negative numbers in
  • A Bold
  • B Brackets
  • C Parentheses
  • D Quotes
Answer: Option C
Q40
In Excel you can use drag and drop to embed excel worksheet data in a word document
  • A By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
  • B By dragging a range of excel data to the Word button on the taskbar while pressing Shift key
  • C By Displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
  • D (A) and (C)
Answer: Option D

📚 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