Excel Questions

Does Excel supports pdf files

• YES

• NO

• Yes, but opens on an different format

• I don't Know

How do you freeze panes in Excel (top row)

• View >Freeze Top row

• View > Freeze Panes > Freeze Top row

• Data > Freeze Panes > Freeze Top row

• View > Arrange > Freeze Panes > Freeze Top row

What does delimiter do?

• Split the Values

• Merge two cells

• Wrong term

• Acts as a boundary

Mention the order of operations used in Excel while evaluating formulas.

• • Parentheses

  • Exponentiation

  • Division/Multiplication 

  • Addition

  • Subtraction

• • Parentheses

    Division/Multiplication 

  • Exponentiation

  • Addition

  • Subtraction

• Division/Multiplication

  Addition

  Subraction

  Parentheses

• Addition

  Subraction

  Division/Multiplication

How will you bring out the resultant 77.5 by the following formula for the following? - Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2.

• ((A1*10)+5)\2

• ((A1*10)+5/2)

• (((A1)+5)*10)/2

• ((A1*10)+5)/2

What is the difference between count, counta, and countblank?

• Count only numbers,

  Count the blank spaces

• Count only numbers,

  Count all forms of input,

  Count the blank spaces

• Count all forms of input,

  Count only numbers,

  Count the blank spaces

• None of the above

How to create dropdown?

• View > Data Validation > List > Source

• Data > Data Validation > Number > Source

• Data > Data Validation > List > Source

• Insert > Data Validation > List > Source

How to Highlight cells based on conditions?

• Conditional Formating

• Both Can be used

• Data Validation

• None

Short Date VS Long Date (12/08/2023)

• 12 August 2023

  12-08-2023

• 12/08/2023

  12 August 2023

• 12-08-2023

  12 August 2023

• 12-08-2023

  12th August 2023

When there are plenty of datas which chart should be used?

• Pie Chart

• Bar Chart

• Line Chart

• Histogram