CL 5-2.4 Formulae functions and sorting

1. _______________ are equations that are used to analyse and calculate numeric values.

• Formulas
• Equations
• Calculations
• Symbols

2. Formula begins with an _________ sign.

• equal sign (=)
• plus sign (+)
• hash sign (#)
• At sign (@)

3. ________________ are predefined formulas that perform calculations by using specific values called arguments in a particular order or structure.

• Formulas
• Functions
• Equations
• Calculations

4. _________ allows you to organize data based on some criteria, usually alphabetically (A-Z or Z-A) or numerically (lowest to highest or highest to lowest).

• Formatting
• Sorting
• Functioning
• Inserting

5. The ________ operator used to combine or join the data from two different cells and display the combined text in a new cell.

• Plus (+)
• Equal (=)
• Text Concatenation (&)
• Hash (#)

6. The COUNTA and COUNTIF are_________ in Excel that is categorized as Statistical Functions.

• designed functions
• built-in functions
• equations
• calculator

7. The _______ function counts the number of cells in a range that meets a given criteria.

• COUNTIF
• COUNTA
• COUNT
• SUM

8. Identify the formula for the Gross salary.

• =(C4+D4)
• =(C4+D4+E4+F4)
• =(C4+F4)
• =(C4*D4*F4)

9. Identify the formula for the Net Salary.

• =(G4-K4)
• =(H4+I4+J4)
• =(G4*K4/J4)
• =(K4*30)

10. In MS Excel, the most recently used functions will always be listed at the top in Insert Function, under the Recently Used category.

• True
• False