Ø
Create suitable chart to plot given data: - For e.g., Pie, bar, column, line
chart etc.
Ø
Use formula to satisfy given condition: - 1. Using AND, IF, OR, NOT, SUMIF
operator etc. >, <, >=, <=, = etc. 2. Sum, Average, Max, Min
function etc.
Ø
Sort and Filter: - Sort data in specific column
or all in ascending order or descending order on values, cell color etc.
Ø
What if Analysis (Goal Seek): - For
e.g. if you know result that you want from a formula, but not the input value
then you needs to get that result.
Ø
Table formatting, cell formatting: - To format cell, table giving
conditions.
Ø
Insert header or footer in a sheet.
Ø
Use Conditional Formatting: - For
e.g. Use Conditional formatting to display cell in giving condition.
Ø
Inserting comments (Notes) on cell.
Ø
Consolidate Sheets:
- For e.g.
Consolidate means combine the data using function (sum, average) from different
sheet or workbook in other sheet or workbook.
Ø
Data Validation:
- For e.g.
Configure a cell such that it not accepts values satisfying condition that are
given in question.
Ø
Rang Names:
- For e.g.
giving a name for range of cell or a cell so that it uses further for
calculations or used for easier.
Ø
Format the cells:
- For e.g. to display cell value in Rupees or Dollar, or Pound within two
decimal places, alignment the value; left, right, middle, top, middle, bottom,
align, Merge cells, wrap text t he cell value, rotating text.
Ø
Format Painter:
- For e.g. it uses as to format the cell from one to another range or a single
cell.
Ø
Hyperlink:
- For e.g. to insert hyperlink in a cell or in sheet.
Ø
Insert External Data from other files: - For e.g. If insert data from
access file, text file, web etc to calculate.
No comments:
Post a Comment