Microsoft Excel Questions and Answers
Microsoft Excel questions with answers are frequently asked in campus placements and government exams to test candidates’ data-handling and analytical abilities. As part of programming questions and answers, Excel is not only a spreadsheet tool but a mini-programming environment through its formulas, macros, and data functions. Mastering Excel helps in automating tasks, analyzing large datasets, and building reports efficiently. This topic covers essential Excel MCQs focusing on functions like VLOOKUP, pivot tables, charts, conditional formatting, and data analysis tools. Whether you’re preparing for TCS, Infosys, or SSC exams, practicing Excel questions enhances your technical aptitude and boosts your problem-solving efficiency.
Microsoft Excel
Showing 10 of
255 questions
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