MICROSOFT EXCEL

To create a formula, you can use:

  • (A) Values but not cell references
  • (B) Cell references but not values
  • (C) Values or cell references although not both at the same time
  • (D) Value and cell references
Check Answer
  • (D) Value and cell references

Status indicators are located on the:

  • (A) Vertical scroll bar
  • (B) Horizontal scroll bar
  • (C) Formula bar
  • (D) Standard toolbar
Check Answer
  • (C) Formula bar

Which of the following is the oldest spreadsheet package?

  • (A) VisiCalc
  • (B) Lotus 1-2-3
  • (C) Excel
  • (D) Star Calc
Check Answer
  • (A) VisiCalc

Rounding errors can occur:

  • (A) When you use multiplication, division, or exponentiation in a formula
  • (B) When you use addition and subtraction in a formula
  • (C) Because excel uses hidden decimal places in computation
  • (D) When you show the results of formulas with different decimal places that the calculated results
Check Answer
  • (A) When you use multiplication, division, or exponentiation in a formula

You can copy data or formulas:

  • (A) With the copy, paste and cut commands on the edit menu
  • (B) With commands on ta shortcut menu
  • (C) With buttons on the standard toolbars
  • (D) All of the above
Check Answer
  • (D) All of the above

You cannot link excel worksheet data to a word document:

  • (A) With the right drag method
  • (B) With a hyperlink
  • (C) With the copy and paste special commands
  • (D) With the copy and paste buttons on the standard toolbar.
Check Answer
  • (D) With the copy and paste buttons on the standard toolbar.

Which of the following is a popular DOS based spreadsheet package?

  • (A) Word
  • (B) Smart cell
  • (C) Excel
  • (D) Lotus 1-2-3
Check Answer
  • (D) Lotus 1-2-3

An excel workbook is a collection of:

  • (A) Workbooks
  • (B) Worksheets
  • (C) Charts
  • (D) Worksheets and charts
Check Answer
  • (B) Worksheets

Excel files have a default extension of:

  • (A) Xls
  • (B) Xlw
  • (C) Wkl
  • (D) 123
Check Answer
  • (A) Xls

You can use the format painter multiple times before you turn it off by:

  • (A) You can use the format painter button only one time when you click it
  • (B) Double clicking the format painter button
  • (C) Pressing the Ctrl key and clicking the format painter button
  • (D) Pressing the Alt key and clicking the format painter button
Check Answer
  • (B) Double clicking the format painter button

You cannot copy content of this page

Scroll to Top