Excel Quiz 2

What would you type in the Criteria box? Use the COUNTIF function to count the number of times that the values in cell rand B6:B15 "exceed 5000".

• <5000

• >5000

• =5000

• /5000

What would you type in the Range box? Insert a COUNTIF formula to count the data in cell range D43:D51 that is greater than 0.

• D43:D51

• 0

• >0

• D43:D59

What does the concatenate function do?

• allows you to combine text from different cells into one cell.

• allows you to delete text from different cells into one cell.

• used for counting cells within a specified range that meet a certain criterion, or condition.

• perform a logical test and return one value for a TRUE result, and another for a FALSE result.

What do you put in the Logical Test Box? Use the IF function to show Close if the SUM of C9:D9 is greater than 22500 and Not Close if it is less than or equal to 22500.

• SUM(C9:D9)>22500

• Close

• Not Close

• SUM(C9:D9)<22500

In the formulas tab, what button do you click on to insert an IF formula?

• insert function

• autosum

• define name

• more funtions

What would you type in the Criteria box? In cell G5 create an AVERAGEIF formula to calculate the average Amount if the Truck Type if General.

• General

• Amount

• Truck Type

• G5

What do you type in the Text box? Create a formula in cell C2 of the Trucks worksheet that returns the first three letters of the Truck column.

• A2

• 3

• Truck

• C2

What does this red mark mean?

• comment in excel

• spelling error

• red highlight mark

• shape that was inserted in excel

What is this called?

• Sparkline

• Bar Graph

• Sparkchart

• Line Graph

What is this button called?

• Quick Analysis tool

• Insert chart

• Conditional Formatting

• Dialog Box