Computer Midterm Test for M1 - Term 2

IF statements can be written to carry out an action, such as: IF a value in a cell is greater than or equal to another value, insert the word "Pass" in a cell.

• True

• False

The shortcut key for AutoSUM is:

• Ctrl + =

• Alt =

• = SUM

• Shift +

The absolute cell reference uses which symbol:

• $

• %

• *

• &

In formulas, spaces count as characters.

• TRUE

• FALSE

When creating an IF function, a ____ separates the logical test from the value if true/false.

• colon

• semicolon

• comma

• dash

it allows you to make logical comparisons between a value and what you expect

• IF condition
• vlookup
• sum
• count

If you see a series of "######" in a cell, that means the following:

• You keyed in an incorrect number
• The row height is too high
• The text is incorrectly spelled
• The column width is not wide enough

You can only work in one cell at a time. The actual cell that you are working in is called what?

• Column
• Name Box
• Active Cell
• Row

When entering text in Excel, it is automatically (by default):

• Left Justified
• Right Justified
• Center Justified
• Full Justified

When entering numbers in  Excel, they are automatically (by default):

• Left Justified
• Right Justified
• Center Justified
• Full Justified