Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q181
In Excel you an convert existing excel worksheet data an charts to an HTML document by using
  • A FTP wizard
  • B Internet assistant wizard
  • C Intranet wizard
  • D Import wizard
Answer: Option B
Q182
In Excel circular reference is
  • A Geometric modeling tool
  • B A cell that points to drawing object
  • C A formula that either directly or indirectly depends on itself
  • D Always errneous
Answer: Option C
Q183
In excel when you insert an excel file into a word document. The data are
  • A Hyperlinked placed in a word table
  • B Linked
  • C Embedded
  • D Use the Word menu bar and toolbars
Answer: Option B
Q184
In excel the following is not information you an specify using the solver
  • A Input cells
  • B Constraints
  • C Target cell
  • D Changing cells
Answer: Option A
Q185
In Excel each excel file is called a workbook because
  • A It can contain text and data
  • B It can be modified
  • C It can contain many sheets including worksheets and chart sheets
  • D You have to work hard to create it
Answer: Option C
Q186
in Excel you can enter which types of data into worksheet cells ?
  • A Labels, values, and formulas
  • B Labels and values but not formulas
  • C Values and formulas but not labels
  • D Formulas only
Answer: Option A
Q187
In Excel all worksheet formula
  • A Manipulate values
  • B Manipulate labels
  • C Retrun a formula result
  • D Use the addition operator
Answer: Option C
Q188
In excel which of the following is a correct order of precedence in forkula caculation ?
  • A Multiplication and division exponentiation positive and negative values
  • B Multiplication and division, positive and negative vaues, addition and substraction
  • C Addition and subtraction, positive and negative values, exponentiation
  • D All of above
Answer: Option D
Q189
In Excel the Paste Special command lets you copy and paste
  • A Multiply the selection by a copied value
  • B Cell comments
  • C Formatting options
  • D The resulting values of a formula Instead of the actual formula
Answer: Option D
Q190
In Excel the numbers in our worksheet look like this : 1000. You want them to look like this: $1, 000.00 How can you accomplish this ?
  • A None of these
  • B Select Format > Money from the menu
  • C Click the Currency style button on the formatting toolbar
  • D You have to retype everything and manually add the dollar signs, commans, and decimals
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