Excel Quiz 4

When using formulas, always remember that they need to start with

• A Comma

• An Equal Sign

• Quotation Marks

• A Number

In a formula, you can use the name of a range instead of its

• address

• value

• location

• area

The COUNTA function counts cells with either numbers or text, while the COUNT function only counts cells with numbers in them. 

• True

• False

____________ cells do not count within an average, but zeros do. 

• Equal

• All

• Single

• Blank

The MIN function can be found by clicking More Functions on the ribbon and then pointing to

• Engineering

• Cube

• Statistical

• Information

The IF function can be found under the __________ drop-down button on the Formulas tab of the ribbon. 

• Financial

• Logical

• Text

• Math & Trig

The __________ function will return characters in a cell beginning at a specified starting point. 

• Mid

• Left

• Fixed

• Lower

Using the __________ function will return the number of characters in a text string. 

• Right

• Lower

• Upper

• Len

TEXTSPLIT is a function that combines multiple strings with the option for a separator, such as a comma, to be used. 

• True

• False

Which function joins together two or more strings of text without a separator?

• Proper

• Concat

• Trim

• Upper