MICROSOFT EXCEL REVISION

______ returns the middle value in a group of numbers, separating the higher half of values from the lower half.

• VAR function

• STDEV function

• MODE function

• MEDIAN function

What does the formula “ =AVERAGE(A1:A10) “ do in Excel?

• A.          Adds up the values in cells A1 to A10.

• A.          Calculate the arithmetic mean of the values in cells A1 to A10.

• A.          Multiplies the values in cells A1 to A10.

• A.          Subtracts the value in cells A1 to A10

 ______ is the intersection of a column and a row on a worksheet

• Column

• Cell

• Value

• Address

What is the purpose of the VLOOKUP function in Excel?

• Returns the values from a specified cell in a range based on a matching condition.

• Adds up the values in a specified range of cells.

• Find the highest value in a range of cells.

• Calculates the variance of a range of numbers.

How are rows labelled in Excel?                                                           

• A.          With numbers (1, 2, 3, ….)

• A.          With letters (A, B, C, ….)

• A.          With both numbers and letters

• A.          Rows are not labelled

In Excel, which function are used to combine two or more text strings?

• CONCAT

• MERGE

• JOIN

• CONCATENATE

COUNTIF function is used for ________.

• A.          Counts the total number of cells in a range that meet a specified condition.

• A.          Counts the total number of cells in a range.

• A.          Counts the total number of cells in a range that are blank.

• A.          Count the total number of cells  in a range that contain errors.

How do you freeze panes in Excel?

•  

  A.          Right-click on a cell and select “Freeze Panes”.

• A.          Go to the View tab and click “Freeze Panes”.

• A.          Double-click the cell where you want to freeze the panes.

• A.          Use the shortcut CTRL + F .

Which of the following statements is TRUE about  Pivot Tables in Excel?

• A.          Pivot Tables allow user to summarize and analyze large dataset quickly and easily.

• A.          User can create Pivot Tables from data stored in different worksheets or workbooks.

• A.          Pivot Tables automatically updates when the source data changes.

• All of the above

Functions in Microsoft Excel must begin with______.

• a bracket sign [ ]

• a quotation sign ' '

• a dash sign -

• an equal sign =