Microsoft Excel MCQ Question and Answer
Microsoft Excel MCQ Question and Answer
181. In Excel you an convert existing excel worksheet data an charts to an HTML document by using
- FTP wizard
- Internet assistant wizard
- Intranet wizard
- Import wizard
182. In Excel circular reference is
- Geometric modeling tool
- A cell that points to drawing object
- A formula that either directly or indirectly depends on itself
- Always errneous
183. In excel when you insert an excel file into a word document. The data are
- Hyperlinked placed in a word table
- Linked
- Embedded
- Use the Word menu bar and toolbars
184. In excel the following is not information you an specify using the solver
- Input cells
- Constraints
- Target cell
- Changing cells
185. In Excel each excel file is called a workbook because
- It can contain text and data
- It can be modified
- It can contain many sheets including worksheets and chart sheets
- You have to work hard to create it
186. in Excel you can enter which types of data into worksheet cells ?
- Labels, values, and formulas
- Labels and values but not formulas
- Values and formulas but not labels
- Formulas only
187. In Excel all worksheet formula
- Manipulate values
- Manipulate labels
- Retrun a formula result
- Use the addition operator
188. In excel which of the following is a correct order of precedence in forkula caculation ?
- Multiplication and division exponentiation positive and negative values
- Multiplication and division, positive and negative vaues, addition and substraction
- Addition and subtraction, positive and negative values, exponentiation
- All of above
189. In Excel the Paste Special command lets you copy and paste
- Multiply the selection by a copied value
- Cell comments
- Formatting options
- The resulting values of a formula Instead of the actual formula
190. 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 ?
- None of these
- Select Format > Money from the menu
- Click the Currency style button on the formatting toolbar
- You have to retype everything and manually add the dollar signs, commans, and decimals