Explore topic-wise InterviewSolutions in .

A chart is a pictorial representation of some data.

The average(), max() and min() functions are three statistical functions.

The PMT(), FV() and NPER() are three financial functions.

The now(), today(), and year() functions are a few date and time functions.

The sum() and product() and power() functions are three mathematical functions.

The AND(), IF(), OR() are three logical functions.

A macro is a series of instructions which can be issued using a single command.

The Concatenate(), len() and trim() are three text functions.

Bar graph and pie chart are two types of charts.

The short cut keys to select entire worksheet is Ctrl+Z.

A data form is a convenient way to enter or display one complete row of information in a table, without scrolling horizontally and makes data entry easier.

The different categories of charts are column, line, pie, bar, xy scattered, etc.,

The steps to insert chart is a select range of cells, insert a chart, a chart type.

1. The steps to add rows: Click on the row at the left extreme cell and on the insert menu insert a row.

2. The steps to add columns: Click on the column insert columns.

A label cell is a cell that contains alphabets, numbers, and symbols.

A cell that contains numbers with or without a + or – symbol is called a value cell.

The auto fill option can be used to insert a series of values in a range of cells easily.

A formula is an expression or cell entry that performs some sort of a calculation. An equal sign = is always the first part of a formula followed by an expression that calculates a value.

A cell that starts with the = symbol and a value or cell address with a mathematical expression is called a formula cell.

The sum function is used to compute addition of a range of cell values.

The print option can be used to set the number of copies to be printed, selection of printer pages and any selected passage.

A formula is entered by beginning it with the = symbol.

For example, = a1 + a2

The page setup can be used to set the margins, page size and orientation of the page of the worksheet.

The different spreadsheet software are

1. IBM Lotus 1-2-3 for Windows

2. Apple Works and Numbers for Mac OS X.

A spreadsheet is a document which is divided into rows and columns to record such things as items in inventory, income, and expenses, debits and credits, etc.

In a spreadsheet, the COLUMN is defined as the vertical space. Letters are used to name each COLUMN’S location and the ROW is the horizontal space. Numbers are used to assign each ROW’S location.

In a spreadsheet, the CELL is the space where a specified row and column intersect. Each CELL is assigned a name according to its COLUMN letter and ROW number.

Example: C3 is cell in column C row 3.

1. They are used in accounting to prepare balance sheet, auditing, etc.,

2. They are organizations where data can be represented using charts and graphs.

3. They are used for statistical calculations

The print preview shows the content of a spreadsheet in a printable view. It helps save lots of paper as the user can see the actual print as a preview avoiding mistakes and reprints before it is actually printed.

The new option is used to create a new workbook and open option is used to open the saved worksheet.

The ‘save’ option saves the file under the current file name given by the user, and ‘save as’ option allows for change in the filename and location saves the file.

A chart is a pictorial representation of data. The data is first entered in a worksheet in a table format. The table shall contain a heading followed by the numerical values.

The steps in creating a chart are as follows;

Step 1:

Data is entered in the cells of an Excel spreadsheet.

Step 2:

Mouse is used to highlight the block of cells containing data, and then insert chart is clicked on. 

Step 3:

When the chart wizard comes up, column or bar graph and a sub type as clustered or stacked type is chosen as per requirement.

Step 4:

If the user wants to switch what appears on the X and Y axis, right clicking on the bar graph, then on ‘ Select Data,’ and finally on ‘Switch Row/Column’.

Step 5:

Labels and legends of the chart an bead justed if needed. User can on the bar graph, and then click the ‘Layout’ tab. Here you can choose what layout you prefer for the chart title, axis titles, and legend.

Data is information that is stored in a spreadsheet program. Data is stored in the individual cells of a worksheet. Only one piece of data is stored in each cell. In addition to being stored in the spreadsheet, the data can be used in calculations, displayed in graphs, or sorted and filtered to find specific information. There are three types of data in Excel: values, labels, Formula and dates/times.

1. Value cell entry: A cell that contains numbers with or without a + or – symbols is called a value cell. These cells can be used in mathematical calculations. For example marks, age, salary, etc., 

2. Label Cell entry: A cell that contains a to z alphabets, numbers and symbols is called label cell. For example, place name, employee code, etc.,

3. Formula cell entry: A cell where the cell entry begins with a = and a formula appended to calculate something is called a formula cell entry. For example (= a10 + 25).

4. Cell Range: A range is a series of two or more cells. If they are adjoining, they are called as adjacent range on contiguous. If the are non contiguous, they are called a non-adjacent range.

A range is identified by the cell references of the cells in the upper left and lower right comers of the range. These two references are separated by a colon (:) which tells Excel to include all the cells between these start and endpoints. An example of a range of adjacent cells would be B5: D10.

• To select an adjacent range, click on a cell in a corner of your selection and drag the mouse over the remaining cells. For example, A1 through D6, D8 through E9, and B14 through D15 are written as A 1:D6 or D8: E9 or B14: D15.
• To select a non-adjacent range, first select an adjacent range of cells. Now, press and hold down the Ctrl key while you select another adjacent range of cells. Release the mouse button and the Ctrl key.
• The adjacent ranges can be combined into a variety of different non-adjacent ranges. For example, one non-adjacent range is A1 through D6 and D8 through E9 is written as A1: D6; D8: E9.

The different uses of spreadsheets are as follows;

1. Performing basic mathematical operations such as adding columns and rows of figures.

2. Finding values such as profit or loss.

3. Calculating repayment plans for loans or mortgages.

4. Finding the average, maximum, or minimum values in a specified range of data.

5. Graphing or charting data, to assist users in identifying data trends.

6. Sorting and filtering data to find specific information.

7. Creation of simple lists and tables of alphabetic or numerical data.

8. Creation and manipulation of simple (flat-file) databases.

9. Establish relationships between sets of numerical data.

10. Applies arithmetical, mathematical or statistical functions to numerical data sets.

11. Represents data sets in graphical or chart form.

The steps of using the auto-format options are follows Govt format, a auto format, a Select the range of cells, a select the format from the list.

The different options of data menu are sort, filter, validation, subtotal, and pivot table options.

Spellings, error checking, goal seek, and macro autocorrect options are a few options of tools menu.

The normal view, page break preview, full-screen view and enable/disable formula bar and status bar, etc., are the options present in the view menu.

The formatting of cells, modification of row height and column width, auto format, style, etc., are the options present under the format menu.

The insert menu contains inserting cells, charts, rows, columns, clipart, diagram, etc., as options.

The auto format option allows to select predefined formatting options.

Cut, copy-paste, find, and replace are a few options present in the edit menu.

There are 16384 columns and 1048576 rows, in a worksheet in the latest excel software.

Spreadsheets make it easy to display information, and formulas can be inserted to work with the data. Information can also be sorted and filtered. Data can be used be create charts.

Data can be sorted both in rows o columns, either in an ascending or in a descending order.

There are 256 columns and 65536 rows in a worksheet.

The default extension name of an excel file is *.xls or *.xlsx

The cell that is currently open and ready for editing is called the active cell.

A cell address is a unique ID given to a cell represented by column name and row name.

The intersection of a row and a column in a spreadsheet is called a cell.