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
- (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
- (C)Â Formula bar
Which of the following is the oldest spreadsheet package?
- (A)Â VisiCalc
- (B)Â Lotus 1-2-3
- (C)Â Excel
- (D)Â Star Calc
- (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
- (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
- (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.
- (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
- (D)Â Lotus 1-2-3
An excel workbook is a collection of:
- (A)Â Workbooks
- (B)Â Worksheets
- (C)Â Charts
- (D)Â Worksheets and charts
- (B)Â Worksheets
Excel files have a default extension of:
- (A)Â Xls
- (B)Â Xlw
- (C)Â Wkl
- (D)Â 123
- (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
- (B)Â Double clicking the format painter button