When asked general questions about Excel, mention popular Excel features such as pivot tables, vlookups, macros, and text functions. Support your answers with real-life experiences where you applied your knowledge of Excel to solve problems and achieve results in your previous positions.

How do I create a question and answer in Excel?

Creating a quiz in Excel

  1. Rename Sheet 1 to Quiz and Sheet 2 to Answers (Double click the tab)
  2. In the Quiz sheet B1, type Number of Questions.
  3. In B2, type Your Score.
  4. In A4 type Question,
  5. In A5, type the first question.
  6. In A6 type the second question and.

What is the most useful function in Excel interview questions?

VLOOKUP and INDEX MATCH are two of Excel’s most important and commonly-used functions. As veteran Excel users know, they’re used to look up values from an external table, and are important parts of automating your work with dynamic spreadsheets.

How do I impress in Excel?

The following tips will help you get things done faster and impress others in the process.

  1. Eliminate Blank Cells.
  2. Modify the Size of the Rows and Columns.
  3. Add and Remove Columns, Rows, or Cells.
  4. Use Conditional Formatting.
  5. Create a Diagonal Like to Any Cell.
  6. Conceal Your Formulas.
  7. Convert Your Rows into Columns and Vice Versa.

How do Countifs work?

The COUNTIFS function in Excel counts the number of cells in a range that match one supplied criteria. Unlike the older COUNTIF function, COUNTIFS can apply more more than one condition at the same time. Conditions are supplied with range/criteria pairs, and only the first pair is required.

How do I impress my boss in Excel?

Useful Excel Tricks that Will Impress Your Boss

  1. Eliminate Blank Cells.
  2. Modify the Size of the Rows and Columns.
  3. Add and Remove Columns, Rows, or Cells.
  4. Use Conditional Formatting.
  5. Create a Diagonal Like to Any Cell.
  6. Conceal Your Formulas.
  7. Convert Your Rows into Columns and Vice Versa.
  8. Save Charts as Templates.

How do you excel in Microsoft Excel tricks and tips?

So bone up on any or all of these tricks to excel at Excel.

  1. Paint Cells to a New Format.
  2. Line Breaks and Wrapping Text.
  3. AutoFill Your Cells.
  4. Flash Fill, Fastest Fill Alive.
  5. Ctrl+Shift to Select.
  6. Text to Columns.
  7. Paste Special to Transpose.
  8. Multiple Cells, Same Data.

How do I use Countifs to text?

Count if cell contains text or part of text with the COUNTIF function

  1. =COUNTIF(B5:B10,”*”&D5&”*”)
  2. Syntax.
  3. =COUNTIF (range, criteria)
  4. Arguments.
  5. Notes:
  6. =COUNTIF(B5:B10,”*”)
  7. Tip. If you want to have a free trial (60-day) of this utility, please click to download it, and then go to apply the operation according above steps.