EXCEL IKM QUESTIONS AND ANSWERS SET A+
✔✔What is the function of Format Painter in Excel? - ✔✔it is feature of Excel and as the
name suggest it formats. It copies the format from area to other.
✔✔What is the difference between absolute and relative reference in Microsoft Excel? -
✔✔Using relative references we can apply the same formula to a lot of cells without
copying and changing the formula. We use Absolute reference when want to drag the
formula but keep a row or column or even both of them consistent.
✔✔What is the Excel VBA and when do you use it? - ✔✔Visual Basic for Applications is
the programming language (macros) of the Excel and it can be utilized for a variety of
use.
✔✔How can you protect Workbook in Excel and why you might consider doing it? -
✔✔We can use the protect workbook option to prevent users from viewing hidden
worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets.
✔✔What is SmartArt in Excel and when would you use it? - ✔✔A smart art is a graphic
representation of information which you use to add more flare to your spreadsheet as it
increases the visual appeal for the document
✔✔What are the tools in Excel to Remove data duplicates? - ✔✔Remove Duplicates
tool, Pivot Table, Filter, Conditional Formatting, Power Query
✔✔How would you use Excel Freeze Panes concept and why you might consider doing
it? - ✔✔To navigate around a data and see the headers of the section all the time
✔✔How can you duplicate Excel Worksheet? - ✔✔right click on worksheet > select
Move or Copy
, ✔✔If you are trying to print Excel Worksheet but data doesn't fit onto the page, what are
the option to make it fit? - ✔✔- fit to the sheet on one page
- Fit all Column on one page
- Fit All Rows on One Page
- Custom Scaling
✔✔How user can check whether the Pivot Table is modified or not? - ✔✔use the
"PivotTableUpdate" in worksheet containing the Pivot Table
✔✔How to update data on a PivotTable after changing the data in database? - ✔✔press
a refresh button on pivotable because after that data will be update in PivotTable
✔✔. What is the purpose of LEFT or RIGHT formula? - ✔✔to extract words from the left
or right side of Cell
✔✔What is the purpose LEN Function? - ✔✔to count the number of characters in any
cell
✔✔What is the purpose of FIND function? - ✔✔to find any word in cell.
✔✔What is the purpose of SEARCH function? - ✔✔to find any word in a cell or between
any word in cell.
✔✔What is the purpose of SUBSTITUTE function? - ✔✔to change any character or
word from a cell.
✔✔What is the purpose of CONCATENATE and & functions? - ✔✔merge any two or
more than two words in a cell
✔✔What is the purpose of TEXT formula? - ✔✔to change the format of any word into
TEXT
✔✔Using which function you can convert data in upper/lower case letter? -
✔✔UPPER/LOWER
✔✔What statement below is relevant to Pivot Table?
a) PIVOT TABLE is used to summarize data
b) PIVOT TABLE is used to find data
c) PIVOT TABLE is used for formatting of the data
d) None of the above. - ✔✔a
✔✔What is the shortcut key combination of Paste special?
a) CTRL + V
b) CTRL + ALT + V
✔✔What is the function of Format Painter in Excel? - ✔✔it is feature of Excel and as the
name suggest it formats. It copies the format from area to other.
✔✔What is the difference between absolute and relative reference in Microsoft Excel? -
✔✔Using relative references we can apply the same formula to a lot of cells without
copying and changing the formula. We use Absolute reference when want to drag the
formula but keep a row or column or even both of them consistent.
✔✔What is the Excel VBA and when do you use it? - ✔✔Visual Basic for Applications is
the programming language (macros) of the Excel and it can be utilized for a variety of
use.
✔✔How can you protect Workbook in Excel and why you might consider doing it? -
✔✔We can use the protect workbook option to prevent users from viewing hidden
worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets.
✔✔What is SmartArt in Excel and when would you use it? - ✔✔A smart art is a graphic
representation of information which you use to add more flare to your spreadsheet as it
increases the visual appeal for the document
✔✔What are the tools in Excel to Remove data duplicates? - ✔✔Remove Duplicates
tool, Pivot Table, Filter, Conditional Formatting, Power Query
✔✔How would you use Excel Freeze Panes concept and why you might consider doing
it? - ✔✔To navigate around a data and see the headers of the section all the time
✔✔How can you duplicate Excel Worksheet? - ✔✔right click on worksheet > select
Move or Copy
, ✔✔If you are trying to print Excel Worksheet but data doesn't fit onto the page, what are
the option to make it fit? - ✔✔- fit to the sheet on one page
- Fit all Column on one page
- Fit All Rows on One Page
- Custom Scaling
✔✔How user can check whether the Pivot Table is modified or not? - ✔✔use the
"PivotTableUpdate" in worksheet containing the Pivot Table
✔✔How to update data on a PivotTable after changing the data in database? - ✔✔press
a refresh button on pivotable because after that data will be update in PivotTable
✔✔. What is the purpose of LEFT or RIGHT formula? - ✔✔to extract words from the left
or right side of Cell
✔✔What is the purpose LEN Function? - ✔✔to count the number of characters in any
cell
✔✔What is the purpose of FIND function? - ✔✔to find any word in cell.
✔✔What is the purpose of SEARCH function? - ✔✔to find any word in a cell or between
any word in cell.
✔✔What is the purpose of SUBSTITUTE function? - ✔✔to change any character or
word from a cell.
✔✔What is the purpose of CONCATENATE and & functions? - ✔✔merge any two or
more than two words in a cell
✔✔What is the purpose of TEXT formula? - ✔✔to change the format of any word into
TEXT
✔✔Using which function you can convert data in upper/lower case letter? -
✔✔UPPER/LOWER
✔✔What statement below is relevant to Pivot Table?
a) PIVOT TABLE is used to summarize data
b) PIVOT TABLE is used to find data
c) PIVOT TABLE is used for formatting of the data
d) None of the above. - ✔✔a
✔✔What is the shortcut key combination of Paste special?
a) CTRL + V
b) CTRL + ALT + V
