AE_Excel and Powerpoint Essentials Review

How can you force a certain order of operations in a formula?

• By using simple formulas

• By using parentheses

• They cannot be forced

• By positioning the operations from left to right

Which of the following is NOT a way to change the column width in Excel?

• Click and drag the column's boundary line to the desired width.

• Double-click the column's boundary line.

• Right-click the column header and then click Column Width.

• Double-click the column header and then click Delete.

• All of the above

3. Which keyboard shortcut underlines text in a cell?

• Ctrl+X

• Ctrl+I

• Ctrl+U

• Ctrl+B

You accidentally delete a large portion of you spreadsheet. How do you get the information back?

• Press Ctrl+C

• Press Ctrl+Z

• Press Ctrl+V

• Press Backspace

• You cannot

Using the correct order of operations, what does this formula equal? =(4-2)*6/2.

• =4

• =6

• =8

• =2

Define the following operator: /

• Addition

• Division

• Subtraction

• Multiplication

What are the pieces of information that describe the appearance of a cell's content?

• Active attributes

• Format attributes

• Edit attributes

• Paste attributes

8. In the formula "=D10+15", what part of the formula is the "15"?

• An operand

• An operator

9. What is the argument in this function? =COUNT(B11:H14)

• H14

• COUNT

• B11:H14

• B11

Which formula is a complex formula?

• =C3+10+E3

• =5+A1*B1

• =10-(A3-D13)

• =D6/5