Commands and Functions

In Excel, formulas are equations that perform calculations in the spreadsheet. Formulas always begin with an equals sign (=). Functions are Excel-defined formulas. They perform calculations on entered data, and return values.

To work upon an already saved workbook in Excel, choosing Office Button and click on Open. The Open dialog box appears. Select the location and choose the file name and click on Open. To erase a worksheet, select all the cells by clicking on the arrow at the top left. Right click on the arrow and choose Clear Contents. To quit from a workbook, click Office Button and select Close. Sometimes to enter big volume of data it is required to add more cells/rows/columns. This involves operations such as Inserting Blank Cells, Inserting Blank Rows and Inserting Blank Columns.

Functions perform calculations by using specific values, called arguments, in a particular order called syntax. AVERAGE function returns the average of the numbers provided. Functions can be divided into argument and structure. Arguments are the values passed to the function for calculations. A structure begins with function name, followed by an opening parenthesis, the arguments separated by commas and a closing parenthesis. The SUM function adds all the numbers that are specified as arguments. The MAX function returns largest value in a set of value. The MIN function returns smallest value in a set of value.

To Access the full content, Please Purchase

  • Q1

    What value does the MAX() function return when the argument contains no number?

    Marks:1
    Answer:

    The MAX() function returns 0(ZERO) if there is no number in the argument of the function.

    View Answer
  • Q2

    What is the difference between empty cells and zero value Cells?

    Marks:1
    Answer:

    Empty cells are not counted, but zero value cells are counted.

    View Answer
  • Q3

    Which command is used to save a workbook?

    Marks:1
    Answer:

    FILE à SAVE

    View Answer
  • Q4

    Define the term Function.

    Marks:1
    Answer:

    Functions are the pre-set formulas. Formulas in
    Excel-worksheet start with an (=) ‘equal to’ sign.

    View Answer
  • Q5

    What do you mean by command in Excel?

    Marks:1
    Answer:

    Commands are the operations that affect an entire worksheet or a workbook.

    View Answer