Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q201
In Excel you can use the drag and drop method to
  • A Copy cel contents
  • B Delete cells contents
  • C Add cell contents
  • D All of above
Answer: Option A
Q202
In Excel to balance your checkbook, your best method is
  • A Copy your check amounts into excel so that you'll have a neat printout to work on
  • B Use Excel to check your arithmetic
  • C Downloads the Checkbook register templates from Templates on Microsoft Office Online
  • D All of above
Answer: Option C
Q203
In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
  • A Count
  • B Average
  • C Sum
  • D None of above
Answer: Option C
Q204
In Excel to name a constant, you use the ................... dialog box
  • A Create names
  • B Define name
  • C Paste name
  • D Format cells
Answer: Option B
Q205
In Excel to cancel the marquee, press
  • A Ctrl + End
  • B End
  • C Esc
  • D Shift + Esc
Answer: Option C
Q206
In Excel the function caculates depreciation at the same amount each year over an asset's useful life
  • A DB (fixed-declining balance)
  • B SLN (straight line)
  • C Single Accounting
  • D Double Accounting
Answer: Option B
Q207
In Excel to center wrksheet titles across a rage of cell, you must
  • A Select the cells containing the title text and use the fill handle to center the text across a range fo cells
  • B Widen the columns
  • C Select the cells containing the title text and use the fill handle to center the text
  • D Widen the column
Answer: Option A
Q208
In Excel when integration Ms-Word and Excel Word is usually the
  • A Server
  • B Source
  • C Client
  • D None
Answer: Option C
Q209
In Excel charts tips can
  • A Shw the formatting of a data label
  • B Show the name f a data series
  • C Show the value of data point
  • D Both (B) and (C)
Answer: Option D
Q210
In Excel the Name box
  • A shows the location of the previously active cell
  • B Appears the left of the formula bar
  • C Appears below the status bar
  • D Appears below the menu bar
Answer: Option B

📚 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