How many characters can be typed in a single cell in Excel?
How many characters can be typed in a single cell in Excel?
Excel probably considers the cell entry January 1, 2000 to be a
Excel probably considers the cell entry January 1, 2000 to be a
The autofill feature
The autofill feature
Hyperlinks can be
Hyperlinks can be
To copy cell contents using drag and drop press the
To copy cell contents using drag and drop press the
You can use the horizontal and vertical scroll bars to
You can use the horizontal and vertical scroll bars to
The chart wizard term data series refers to
The chart wizard term data series refers to
Which of the following is the oldest spreadsheet package?
Which of the following is the oldest spreadsheet package?
To delete an embedded objects, first
To delete an embedded objects, first
Which elements of worksheet can be protected from accidental modification
Which elements of worksheet can be protected from accidental modification
Concatenation of text can be done using
Concatenation of text can be done using
Which of the following will not cut information?
Which of the following will not cut information?
A worksheet range is a
A worksheet range is a
You can convert existing excel worksheet data an charts to an HTML document by using
You can convert existing excel worksheet data an charts to an HTML document by using
The auto calculate feature
The auto calculate feature
Getting data from a cell located in a different sheet is called ......
Getting data from a cell located in a different sheet is called ......
Which area in an excel window allows entering values and formulas
Which area in an excel window allows entering values and formulas
The Paste Special command lets you copy and paste:
The Paste Special command lets you copy and paste:
The name box
The name box
You can use the format painter multiple times before you turn it off by
You can use the format painter multiple times before you turn it off by
Which of the following is not a worksheet design criterion?
Which of the following is not a worksheet design criterion?
To copy formatting from one area in a worksheet and apply it to another area you would use:
To copy formatting from one area in a worksheet and apply it to another area you would use:
Which button do you click to add up a series of numbers?
Which button do you click to add up a series of numbers?
When you want to insert a blank imbedded excel object in a word document you can
When you want to insert a blank imbedded excel object in a word document you can
A typical worksheet has ..... Number of columns
A typical worksheet has ..... Number of columns
When you copy a formula
When you copy a formula
To center worksheet titles across a range of cells, you must
To center worksheet titles across a range of cells, you must
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
How can you delete a record?
How can you delete a record?
Right clicking something in Excel:
Right clicking something in Excel:
Multiple calculations can be made in a single formula using
Multiple calculations can be made in a single formula using
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Tab scrolling button
Tab scrolling button
Which of the following formulas is not entered correctly?
a.
b.
c.
d.
Which of the following formulas is not entered correctly?
a.
b.
c.
d.
In a worksheet you can select
In a worksheet you can select
Comments can be added to cells using
Comments can be added to cells using
-
-
-
-
Which of the following is not an example of a value?
Which of the following is not an example of a value?
Which of the following is not information you can specify using the solver?
Which of the following is not information you can specify using the solver?
You can use drag-and-drop to embed excel worksheet data in a word document
You can use drag-and-drop to embed excel worksheet data in a word document
Which is used to perform what if analysis?
Which is used to perform what if analysis?
How do you select an entire column?
How do you select an entire column?
When a label is too long to fit within a worksheet cell, you typically must
When a label is too long to fit within a worksheet cell, you typically must
To create a formula, you first:
To create a formula, you first:
Which of following is Not one of Excel's what-if function?
Which of following is Not one of Excel's what-if function?
Which of the following is not a way to complete a cell entry?
Which of the following is not a way to complete a cell entry?
To activate the previous cell in a pre-selected range, press
To activate the previous cell in a pre-selected range, press
The Chart wizard term data categories refers to;
The Chart wizard term data categories refers to;
A worksheet can have a maximum of .... Number of rows
A worksheet can have a maximum of .... Number of rows
Documentation should include
Documentation should include
Which of the following is a correct order of precedence in formula calculation?
Which of the following is a correct order of precedence in formula calculation?
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Text formulas:
Text formulas:
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Data can be arranged in a worksheet in a easy to understand manner using
Data can be arranged in a worksheet in a easy to understand manner using
Excel uniquely identifies cells within a worksheet with a cell name
Excel uniquely identifies cells within a worksheet with a cell name
Status indicators are located on the
Status indicators are located on the
What symbol is used before a number to make it a label?
What symbol is used before a number to make it a label?
Which menu option can be sued to split windows into two
Which menu option can be sued to split windows into two
When the formula bar is active, you can see
When the formula bar is active, you can see
Comments put in cells are called
Comments put in cells are called
An excel workbook is a collection of
An excel workbook is a collection of
When integrating word and excel, word is usually the
When integrating word and excel, word is usually the
You can copy data or formulas
You can copy data or formulas
It is acceptable to let long text flow into adjacent cells on a worksheet when
It is acceptable to let long text flow into adjacent cells on a worksheet when
Which of the following is an absolute cell reference?
Which of the following is an absolute cell reference?
How do you insert a row?
How do you insert a row?
Which of the following is not a basic step in creating a worksheet?
Which of the following is not a basic step in creating a worksheet?
Which of the following is the latest version of Excel
Which of the following is the latest version of Excel
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Files created with Lotus 1-2-3 have an extension
Files created with Lotus 1-2-3 have an extension
Which of the following options is not located in the Page Setup dialog box?
Which of the following options is not located in the Page Setup dialog box?
To save a workbook, you:
To save a workbook, you:
A circular reference is
A circular reference is
All worksheet formula
All worksheet formula
You cannot link excel worksheet data to a word document
You cannot link excel worksheet data to a word document
To view a cell comment
To view a cell comment
Rounding errors can occur
Rounding errors can occur
You can enter which types of data into worksheet cells?
You can enter which types of data into worksheet cells?
Which symbol must all formula begin with?
Which symbol must all formula begin with?
When you link data maintained in an excel workbook to a word document
When you link data maintained in an excel workbook to a word document
Each excel file is called a workbook because
Each excel file is called a workbook because
You can select a single range of cells by
You can select a single range of cells by
How can you find specific information in a list?
How can you find specific information in a list?
To create a formula, you can use:
To create a formula, you can use:
Which of the following methods can not be used to edit the contents of a cell?
Which of the following methods can not be used to edit the contents of a cell?
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:
How do you delete a column?
How do you delete a column?
How can you print three copies of a workbook?
How can you print three copies of a workbook?
When you insert an excel file into a word document. The data are
When you insert an excel file into a word document. The data are
You can use the formula palette to
You can use the formula palette to
To edit in an embedded excel worksheet object in a word document
To edit in an embedded excel worksheet object in a word document
You can activate a cell by
You can activate a cell by
Which of the following is a popular DOS based spreadsheet package?
Which of the following is a popular DOS based spreadsheet package?
A numeric value can be treated as a label value if it precedes with
A numeric value can be treated as a label value if it precedes with
You can use the drag and drop method to
You can use the drag and drop method to
Excel files have a default extension of in Excel-2003
Excel files have a default extension of in Excel-2003
You can edit a cell by
You can edit a cell by
Which of the following formulas will Excel Not be able to calculate?
Which of the following formulas will Excel Not be able to calculate?
