hdhost.blogg.se - Ms excel for mac and formatting legend and make wider

Ms excel for mac and formatting legend and make wider how to#

Use a PivotTable report to analyze numerical data in depth and to answer unanticipated questions about your data. Advanced filter.Ģ2 PIVOT TABLE A PivotTable report is an interactive way to quickly summarize large amounts of data.

The type of filters in this are- Auto filter. All except borders - Pastes everything except the four borders.Ģ1 FILTER It is used to filter the table by which we find about a single person or by a given condition in a large table. All - Pastes the actual contents into the destination cell Formulas - Pastes only the formula.

it is used to make a link between two different sheets or two different workbook.Ģ0 Paste special Paste the value into the cell in the format and operations you specify.

It is used to get a result in a cell according to the given condition.ġ9 V UP Formula:- =vlookup(lookup_value,table_array,col_ index_num….).

It is used to join the two words of different cells in one cell.ġ8 IF Formula:- =if(logical_text,value_if_true,value_if_false).

it is used to write the date & time in any cell.ġ7 CONCATENATE Formula:- =concatenate(text1,text2,……….).

It is used to write the current date in.

It is used to make the sum of numbers according to the given condition.

For ex- If we give condition that- =countif(A1:A9,”>=10”) Then, it count the cells which have its >=10.ġ4 SUMIF Formula:- =sumif(Range,Criteria,sum_range).

it is used to count the number of cells according to a given condition in the selected cells.

If we press only spacebar in any cell, then this cell be counted as unblanked cell.ġ3 COUNTIF Formula:- =countif(Range,Criteria).

It is used to count the blank cells out of the selected cells.

It is used to count the unblanked cells or the cells in which some contents is written out of the selected cells.ġ2 COUNTBLANK Formula:- =countblank(Range).

It is used to count the cells out of the cells in which a number is written.ġ1 COUNTA Formula:- =counta(value1,value2,………………).

It is used to make the sum or additions of the numbers of any two or more cells.ġ0 COUNT Formula:- =count(value1,value2,…………).

However there are some situations where a cell reference inside a formula must ALWAYS refer to the same cell.ĩ SUM S M Formula:- =sum(value1,value2,………….).

Absolute cell References :- When a formula or function is copied or moved to another location, any cell references in the formula or function get adjusted as well. Relative cell references are basic cell references that adjust and change when copied or when using Autofill. Relative cell References :- This is the most widely used type of cell references in formulas. References to cells in other workbooks are called links. The user can also refer to cells on other sheets in the same workbook, and to other workbooks. To Print active file To close the EXCEL document.ħ CELL REFERENCING Cell and Range References :- A reference identifies a cell or a range of cells on a worksheet and tells Microsoft Excel where to looks for the values or data the user wants to use in a formula. To close the active file To save the active file To save file in required format. Name box Formula BAR Active cell ribbon Office button column Letter Row Number sheet tabĥ OFFICE BUTTON NEW OPEN CLOSE SAVE SAVE AS PRINT PREPARE EXITĦ OFFICE BUTTON To create a new file To open a new file Each intersection of a row and a column forms a cell, in which the user can store data. The Excel 2007 worksheet contains rows and columns. It is consists of workbook.Ĥ SPREADSHEET DETAILS Worksheet is a grid made up of horizontal row and vertical columns. xls It is a table format which uses rows & columns to make any report & table. Default Name of MS- EXCEL Workbook: BOOK1 Extension of MS-EXCEL. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications).

Ms excel for mac and formatting legend and make wider how to#

Presentation on theme: "PROJECT ON MS-EXCEL."- Presentation transcript:Ģ HOW TO OPEN MS-EXCEL ? a) START b) PROGRAMS c) MS OFFICE d) MS EXCELģ MS-EXCEL Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsot for Microsoft Windows and Mac OS X.