MS Excel Review

Spreadsheet application used to perform mathematical equations without manual computation.

• Microsoft Excel

• Microsoft Word

• Microsoft Powerpoint

• Microsoft Publisher

What type of operator will you use for mathematical operations?

• text concatenation operator

• reference operator

• comparison operator

• arithmetic operator

Specialized operations with assigned names of actions that use formulas and return values.

• Formula

• Functions

• Workbook

• Worksheet

Which of the following statements is correct about the difference between a workbook and spreadsheet?

• Workbook only contains one sheet while a spreadsheet is the whole document.

• Workbook can contain several sheets while a spreadsheet is one page or a portion of your document.

• Workbook cannot contain any sheet while a spreadsheet can contain several pages.

• Workbook is a single page in a sheet while a spreadsheet contains the whole workbook.

Which of the following statements is correct about the difference between a formula and a function?

• Formula is a named arithmetic operation in Excel that starts with a plus (+) sign while a function is a simple operation that returns a value.

• Formula is the symbol of mathematical operation in Excel while a function is a specialized operation with a name of action.

• Formula is a named arithmetic operation in Excel while a function is a specialized operation without a name of action.

• Formula is a simple arithmetic operation in Excel that starts with an equal (=) sign while a function is a specialized operation that uses predefined functions.