Computer

• You can reorganize a worksheet by sorting your data
• When sorting data, it is important to first decide if u want the sort to apply to the entire worksheet or just a cell range
• Sortsheet organizes all of the data in your worksheet by one column
• Sort range sorts the data in a range of cells. which can be helpful when working with sheet that contains several tables
• If your data is not sorting properly double check your cell values to make sure they are entered into the worksheet correctly
• TRUE when sorting by colors, no such order exists so it is the user who defines the color sort order in the sort dialog box
• TRUE sorting by color can be useful when using conditional formatting
• TRUE Before data can be sorted excel needs to know the exact range that is to be sorted
• FALSE when excel finds a different cell background colors in the selected data it disregard those colors to the options listed under the order heading
• TRUE the advanced number filter gives you the flexibility to manipulate numbered data in different ways
• TRUE in advanced number filter, u can compare different numeric values using different comparison operators
• TRUE the custom auto filter dialog box will appear when you are using number filters
• TRUE Regardless of the date format used you should always specify the full date in the advanced filter criteria range.
• FALSE the number filters is always available even the column selected do not have numeric data
• in any worksheet, what will you notice when you type the equal sign in a cell?

  The value entered will be calculated
• In creating a formula, you can enter the referenced cell or you can point and click to the referenced cell
• most of the time you will use this to create a formula. EQUAL SIGN
• What is needed to combine with cell references to create a variety of simple formulas in excel?

  Mathematical Equation
• What will appear in the cell if the result of a formula is too large to be displayed in a cell?

  Pound signs
• a Predefined formula that perfoms calculations using specific values in a particular order?

  Function
• function that calculates the sum of the cells and then divides that value by the number of cells in the argument?

  average
• command allows you to automatically return results for common fuctions like Sum,average and count?

  Auto sum
• This function command allows you to search for functions using keywords?

  Insert
• is a predefined formula that performs calculation using specific values in a particular order?

  Function
• In order to work correctly a function must be written a specific way which is called the?

  Syntax
• is a part of function that contain info you want to calculate

  arguments
• is a function which is useful for quickly counting items in a cell range

  count
• IS a function that adds all of the values of the cells in the argument

  SUM
• Is a function that determines the highest cell value included in the argument

  MAX
• Is a function that determines the lowest cell value included in the argument

  Min
• to access the function library select the ______ tab on the ribbon

  Editing
• Auto sum command can be also found on the home tab in the _______ group

  Function