click below
click below
Normal Size Small Size show me how
EXCEL
| Question | Answer |
|---|---|
| What function is used to round off numbers to a specified number of decimal points? | ROUND |
| Column, pie and bar are types of...... | charts |
| What function is used to count how many numbers are in a list? | count |
| The bar across the top of an Excel screen is called the.... | ribbon |
| what is the default file name extension of an excel file | xlsx |
| A cell reference can be relative, or mixed or ... | absolute |
| What F fumction do you use to insert an absolute reference | F4 |
| What does the C in CSV formatted file stand for? | comma |
| What function is used to count empty cells within a cell range? | countblank |
| What are home, Insert and Page layout examples of | tabs |
| What do all formula begin with? | equal sign |
| When using excel an item such as B12:H12 is known as a.... | range |
| What function is used to return the minimum number from a list? | MIN |
| What function is used to add the contents of selected cells | SUM |
| What function is used to return the maximum number from a list? | MAX |
| Within a formula the + and * are examples of... | operators |
| What function is used to determine the average value of the selected cells contents? | AVERAGE |
| What function is used to count the number of cells that are not empty. | COUNTA |
| What function word allows you to calculate the number of data points that meet a defined criteria | COUNTIF |