Course 132A

By default, are cell references that you create absolute or relative?

• Absolute

• Relative

What symbol is used to create an absolute cell reference?

• #

• @

• $

• &

What is the shortcut key to toggle between a relative and absolute reference?

• F1

• F2

• F3

• F4

It is a cell reference that dynamically changes as it moved.

• Absolute cell reference

• Relative cell reference

Do named rages use relative or absolute cell references?

• Absolute cell reference

• Relative cell reference

What is the shortcut command to open the Name Manager?

• Ctrl F1

• Ctrl F2

• Ctrl F3

• Ctrl F4

It is a function that returns true if all conditions are true.

• IF Function

• AND Function

• OR Function

• SUMIF Function

It is a function when we need to find things in a table or a range by row.

• VLOOKUP Function

• HLOOKUP Function

• XLOOKUP Function

It is use to get the characters starting from any location in the text.

• LEFT Function

• RIGHT Function

• MID Function

• CONCAT Function

It capitalized the first letter in a text string and converts all other letters to lowercase.

• PROPER Function

• UPPER Function

• LOWER Function

• TRIM Function