Question

How to insert data from any other application software? Write steps.

Answer 1

Answer:

Insert or delete a column

Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.

Alternatively, right-click the top of the column, and then select Insert or Delete.  

Insert or delete a row

Select any cell within the row, then go to Home > Insert > Insert Sheet Rows or Delete Sheet Rows.

Alternatively, right-click the row number, and then select Insert or Delete.

Answer 2

Answer:

LENGTH() function is used to find the length of the string.                (F)

2.2    The floating text (text not associated with objects in the chart) cannot be moved in the chart area.       (F)

2.3    Just as you can preview a worksheet before printing, it is not possible to preview a chart.       (F)

2.4    To insert a header or footer in a worksheet, select Header and Footer option in the File menu.                             (F)

2.5    The Cell/range names are case sensitive.                             (F)

2.6    99 sales is a valid name for a cell or a range.        (F)

2.7    When you create a formula that contains a function, the Insert Function dialog box helps you enter worksheet functions.              (T)

2.8    Different cells with in a row can have different heights.    (F)

2.9    The name box is at the left end of the formula bar             (T)

2.10  In Excel, The delete and clear commands perform the same function.           (T)

2.11  You cannot change the Font style of the entire workbook by a single command. It can change only worksheet by worksheet.         (T)

2.12  Default number of decimal points can be changed with the Increase Decimal and Decrease Decimal buttons. (T)

2.13  To have Microsoft Excel always use a specific currency symbol, change the currency symbol selected in Regional Settings in Control Panel before you start Excel.             (T)

2.14  The name of a cell or range can be same as the cell/range reference.          (T)

2.15  To display the current time, the TIME() function can be used.                          (F)

2.16  3-D charts have a category (x) axis a value (y) axis and a third (z) axis                             (T)

2.17  Pie chart can represent multiple series of data.                  (T)

2.18  It is possible to undo the deletion of a sheet.       (F)

2.19  You can have a different header and footer on each sheet of a workbook. (T)

2.20  It is possible to insert a sheet at the end of the workbook.                               (T)

2.21  The data to be drawn as a chart cannot be selected after the chart wizard is started.                 (F)

2.22  In Excel, standard width of a column is 8.43                         (T)

2.23  In Excel, pressing [Ctrl] + [Spacebar] select the entire row.              (F)

Note: [Ctrl] + [Spacebar]    Select Entire Column           [Shift] + [Spacebar] Select Entire row

2.24  You can enlarge the sheet upto 500% while printing.                        (F)                           Note: Zoom Level is 10% to 400%

2.25  Pressing [Home] moves the active cell to column A of the current row.                        (T)

2.26  Pressing [Shift]+[Spacebar] selects the entire column.      (F)

2.27  You cannot move or copy sheets from one workbook to another   (T)

2.28  [Ctrl] + [End] moves the last cell containing contents in the worksheet in Excel.                          (T)

2.29  When you copy a formula in Excel, relative cell references do not change (F)

2.30  Excel cannot insert multiple rows in its sheet.     (F)

2.31  Microsoft Excel ignores manual page breaks when you use the Fit to option of the Page Setup.              (T)

2.32  Excel moves decimal point one place to the left on clicking Decrease Decimal button on Formatting toolbar.      (F)

2.33  Once you have created a chart you may change everything about the chart.               (T)

2.34  Data can be arranged in ascending or descending order by using Sort command from Data TabàShort & Filter(T)

2.35  Shift + Tab key is used to move to one cell down or to the next cell in sequence.                       (F)

2.36  Up Arrow, Down Arrow, Right arrow, Left Arrow key is used to move to the first cell in the row.                            (F)

2.37  To create a new worksheet, select worksheet from the file menu.(F)

2.38  Cells are named by their positions either by rows or columns.        (F)

2.39  If the Bold and Underline buttons are appearing lighter than before, it means that they are currently in use.      (F)

2.40  Standard width of a column is 18.43.     (F)

2.41  To open a file quickly from the open dialog box. Double click the file’s icon.                (T)

2.42  You can not move the active cell within a selected range.                (F)

2.43  You can simultaneously select an entire row and an entire column.               (F)

2.44  Sheet tab is displayed when you split a sheet.     (T)

2.45  Last column of the worksheet window is XFD.     (T)

2.46  Using the undo command you can undo multiple actions.                 (T)

2.47  Receives the data the user enters in known as active cell.                (T)

2.48  A workbook is a grid with labeled columns and rows         (T)

2.49  Tabs that appear at the bottom of each workbook is called sheet tabs.          (T)

2.50  The first cell in Excel 2010 worksheet is labeled as A0      (F)

Explanation: