MSExcel—Test 3

Name

True/False—Section 1—Answer each question with a T for True or an F for False—

______1. When a formula contains more than one arithmetic operators, you can change the default

order in which calculations occur by placing parentheses around the expressions to be calculated first.

______2. $A$1 is a relative cell reference.

______3. You cannot use a function as one of the arguments of another function.

______4. You may send a worksheet as an e-mail attachment.

______5. SkyDrive or Cloud Computing may allow you to place an Excel spreadsheet in cyberspace.

______6. To delete a comment, you can right-click the cell, then click Delete Comment.

______7. You can protect the current worksheet with a protected password.

______8. You can require a password to open a workbook or edit a worksheet.

______9. You can merge cells in a worksheet.

_____10. You can set options to track changes in the Highlight Changes dialog box.

_____11. The Function Library group is located on the Insert Tab.

_____12. You can create a custom macro in Excel.

Multiple Choice—Select the letter that best suits the question—

______1. When creating a formula, what is the first thing you type in a cell?

  1. ? (question mark)
  2. Colon
  3. + (Addition Sign)
  4. =(equal sign)

______2. Which operation has an asterisk (*) as an operator?

  1. Multiplication
  2. Division
  3. Percent
  4. Exponentiation

______3. Which function performs the logical test, then returns displays a value if it is true

Or false, such as whether a budget is within limits?

  1. IF
  2. AND
  3. OR
  4. NOT

Page 2

______4. Which expression raises the value in A7 to the fourth power?

  1. A7*4
  2. A7^4
  3. A7+4
  4. A7=4

______5. A chart type shows proportions or percentages of parts to a whole?

  1. Column
  2. Line
  3. Pie
  4. Bar

______6. Which chart type is used to show growth trends over time?

  1. Line
  2. Bar
  3. Area
  4. Scatter

______7. Which illustrations modification can NOT be made in the Adjust group on the Picture Tools

Format tab?

  1. Contrast
  2. Size
  3. Brightness
  4. Color

______8. A cell with a comment is indicated by a______.

  1. Green triangle in the upper-right corner
  2. Green outline around the cell
  3. Red triangle in the upper-right corner
  4. Red outline around the cell

______9. To use the IF function, click the Formulas tab, then click the______button in the

function library group?

  1. Financial
  2. Logical
  3. Text
  4. Date & Time

Matching—Section 1—Select the correct letter

_____1. PictureA. A collection of predesigned art, including movies, drawings,

Sounds, or stock photography

_____2. Clip ArtB. A picture of a computer screen or part of a screen, such as a

Button

_____3. ShapesC. Digital photographs or images stored on your computer

_____4. SmartArtD. Ready-made objects, such as rectangles and circles, arrows,

Lines, flowchart symbols, & callouts

_____5. ScreenshotE. A predesigned diagram made up of shapes containing text

that illustrate a concept or an idea.

Page 3

Matching—Section 2—Select the correct letter for the error messages—

_____1. #DIV/O!A. Invalid cell reference

_____2. #NAME?B. When a formula specifies an intersection of two areas that

Do not intersect

_____3. #NULL!C. Value is divided by zero

_____4. #REF!D. Operand or argument is incorrect

_____5. #VALUE!E. Excel does not recognize text