How do you insert a row?
Which of the following is not a basic step in creating a worksheet?
How do you select an entire column?
How can you print three copies of a workbook?
To create a formula, you first:
To center worksheet titles across a range of cells, you must
How do you delete a column?
How can you find specific information in a list?
When integrating word and excel, word is usually the
When a label is too long to fit within a worksheet cell, you typically must
The name box
Comments put in cells are called
Which is used to perform what if analysis?
You can use the horizontal and vertical scroll bars to
Multiple calculations can be made in a single formula using
Hyperlinks can be
To activate the previous cell in a pre-selected range, press
Which button do you click to add up a series of numbers?
When the formula bar is active, you can see
To copy formatting from one area in a worksheet and apply it to another area you would use:
In a worksheet you can select
When you link data maintained in an excel workbook to a word document
Which area in an excel window allows entering values and formulas
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
To edit in an embedded excel worksheet object in a word document
To create a formula, you can use:
Status indicators are located on the
Which of the following is the oldest spreadsheet package?
Rounding errors can occur
You can copy data or formulas
You cannot link excel worksheet data to a word document
Which of the following is a popular DOS based spreadsheet package?
An excel workbook is a collection of
Excel files have a default extension of
You can use the format painter multiple times before you turn it off by
You can use the formula palette to
You can convert existing excel worksheet data an charts to an HTML document by using
A circular reference is
Which of following is Not one of Excel’s what-if function?
When you insert an excel file into a word documentThe data are
Which of the following is not information you can specify using the solver?
Each excel file is called a workbook because
Excel probably considers the cell entry January 1, 2000 to be a
You can enter which types of data into worksheet cells?
All worksheet formula
Which of the following is a correct order of precedence in formula calculation?
The Paste Special command lets you copy and paste:
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Which of the following is not a valid data type in excel
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Which of the following options is not located in the Page Setup dialog box?
You want to track the progress of the stock market on a daily basisWhich type of chart should you use?
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
3rd battle of pannipat was fought between
3rd battle of pannipat was fought in
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
to view a cell comment
When you want to insert a blank imbedded excel object in a word document you can
To save a workbook, you:
You can edit a cell by
You can select a single range of cells by
Which elements of worksheet can be protected from accidental modification
You can use the drag and drop method to
2nd battle of pannipat was fought between
2nd battle of pannipat was fought in
How can you delete a record?
Right clicking something in Excel:
Documentation should include
Files created with Lotus 1-2-3 have an extension
To delete an embedded objects, first
Comments can be added to cells using
Which of the following is not a worksheet design criterion?
To copy cell contents using drag and drop press the
Which of the following is the latest version of Excel
When you copy a formula
The autofill feature
Which menu option can be sued to split windows into two
Which of the following is an absolute cell reference?
What symbol is used before a number to make it a label?
Which symbol must all formula begin with?
Which of the following formulas is not entered correctly?
Which of the following formulas will Excel Not be able to calculate?
A typical worksheet has …Number of columns
How many characters can be typed in a single cell in Excel?
A worksheet can have a maximum of …Number of rows
Which of the following is not an example of a value?
The chart wizard term data series refers to
The Chart wizard term data categories refers to;
A worksheet range is a
Getting data from a cell located in a different sheet is called …
Tab scrolling button
A numeric value can be treated as a label value if it precedes with
Concatenation of text can be done using
Data can be arranged in a worksheet in a easy to understand manner using
You can use drag-and-drop to embed excel worksheet data in a word document
The auto calculate feature
Excel uniquely identifies cells within a worksheet with a cell name
You can zoom a worksheet
You can not link Excel worksheet data to a Word document
This type of software is similar to an accountant’s worksheet
which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
Data marker on a chart are linked to data points in a worksheet, therefore,
When you group worksheets
You can use the format painter multiple times before you turn it off by
The default header for a worksheet is
To drag a selected range of data to another worksheet in the same workbook, use the
When creating a vertical page break
to activate the previous cell in a pre-selected range, press
When the formula bar is activated, you can see
In a worksheet you can select
when you print preview a worksheet
You can group noncontiguous worksheets with
Weight refers to
When you link data maintained in Excel workbook to a Word document
When you see a cell with a red triangle in the top right corner, what does this signify?
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
To edit data in an embedded Excel worksheet object in a Word document
Status indicators are located on the
You can open the scenario Manager dialog box by choosing scenarios from the ….menu.
You can open the Sort dialog box by choosing Sort from the ….menu
when working in the page break preview, you can
A data map is helpful
Rounding errors can occur
You can copy data or formulas
You can activate a cell by
Which of the following setup options can not be set in the page setup dialog box?
What term refers to a specific set of values saved with the workbook?
Got functions? No? You need the insert function dialog boxHow do you get it?
Which of the following describes how to select all the cells in a single column?
when you use the fill effects in the format data series dialog box, you can not
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Which of the following is not a basic step in creating a worksheet?
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
To insert three columns between columns D and E you would
To center worksheet titles across a range of cell, you must
When integrating Ms-Word and Excel, Word is usually the
Charts tips can
The Name box
Which of the following is not a basic step in creating a worksheet?
How do you select an entire column?
How can you print three copies of a workbook?
To create a formula, you first:
To center worksheet titles across a range of cells, you must
How do you delete a column?
How can you find specific information in a list?
When integrating word and excel, word is usually the
When a label is too long to fit within a worksheet cell, you typically must
The name box
Comments put in cells are called
Which is used to perform what if analysis?
You can use the horizontal and vertical scroll bars to
Multiple calculations can be made in a single formula using
Hyperlinks can be
To activate the previous cell in a pre-selected range, press
Which button do you click to add up a series of numbers?
When the formula bar is active, you can see
To copy formatting from one area in a worksheet and apply it to another area you would use:
In a worksheet you can select
When you link data maintained in an excel workbook to a word document
Which area in an excel window allows entering values and formulas
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
To edit in an embedded excel worksheet object in a word document
To create a formula, you can use:
Status indicators are located on the
Which of the following is the oldest spreadsheet package?
Rounding errors can occur
You can copy data or formulas
You cannot link excel worksheet data to a word document
Which of the following is a popular DOS based spreadsheet package?
An excel workbook is a collection of
Excel files have a default extension of
You can use the format painter multiple times before you turn it off by
You can use the formula palette to
You can convert existing excel worksheet data an charts to an HTML document by using
A circular reference is
Which of following is Not one of Excel’s what-if function?
When you insert an excel file into a word documentThe data are
Which of the following is not information you can specify using the solver?
Each excel file is called a workbook because
Excel probably considers the cell entry January 1, 2000 to be a
You can enter which types of data into worksheet cells?
All worksheet formula
Which of the following is a correct order of precedence in formula calculation?
The Paste Special command lets you copy and paste:
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Which of the following is not a valid data type in excel
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Which of the following options is not located in the Page Setup dialog box?
You want to track the progress of the stock market on a daily basisWhich type of chart should you use?
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
3rd battle of pannipat was fought between
3rd battle of pannipat was fought in
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
to view a cell comment
When you want to insert a blank imbedded excel object in a word document you can
To save a workbook, you:
You can edit a cell by
You can select a single range of cells by
Which elements of worksheet can be protected from accidental modification
You can use the drag and drop method to
2nd battle of pannipat was fought between
2nd battle of pannipat was fought in
How can you delete a record?
Right clicking something in Excel:
Documentation should include
Files created with Lotus 1-2-3 have an extension
To delete an embedded objects, first
Comments can be added to cells using
Which of the following is not a worksheet design criterion?
To copy cell contents using drag and drop press the
Which of the following is the latest version of Excel
When you copy a formula
The autofill feature
Which menu option can be sued to split windows into two
Which of the following is an absolute cell reference?
What symbol is used before a number to make it a label?
Which symbol must all formula begin with?
Which of the following formulas is not entered correctly?
Which of the following formulas will Excel Not be able to calculate?
A typical worksheet has …Number of columns
How many characters can be typed in a single cell in Excel?
A worksheet can have a maximum of …Number of rows
Which of the following is not an example of a value?
The chart wizard term data series refers to
The Chart wizard term data categories refers to;
A worksheet range is a
Getting data from a cell located in a different sheet is called …
Tab scrolling button
A numeric value can be treated as a label value if it precedes with
Concatenation of text can be done using
Data can be arranged in a worksheet in a easy to understand manner using
You can use drag-and-drop to embed excel worksheet data in a word document
The auto calculate feature
Excel uniquely identifies cells within a worksheet with a cell name
You can zoom a worksheet
You can not link Excel worksheet data to a Word document
This type of software is similar to an accountant’s worksheet
which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
Data marker on a chart are linked to data points in a worksheet, therefore,
When you group worksheets
You can use the format painter multiple times before you turn it off by
The default header for a worksheet is
To drag a selected range of data to another worksheet in the same workbook, use the
When creating a vertical page break
to activate the previous cell in a pre-selected range, press
When the formula bar is activated, you can see
In a worksheet you can select
when you print preview a worksheet
You can group noncontiguous worksheets with
Weight refers to
When you link data maintained in Excel workbook to a Word document
When you see a cell with a red triangle in the top right corner, what does this signify?
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
To edit data in an embedded Excel worksheet object in a Word document
Status indicators are located on the
You can open the scenario Manager dialog box by choosing scenarios from the ….menu.
You can open the Sort dialog box by choosing Sort from the ….menu
when working in the page break preview, you can
A data map is helpful
Rounding errors can occur
You can copy data or formulas
You can activate a cell by
Which of the following setup options can not be set in the page setup dialog box?
What term refers to a specific set of values saved with the workbook?
Got functions? No? You need the insert function dialog boxHow do you get it?
Which of the following describes how to select all the cells in a single column?
when you use the fill effects in the format data series dialog box, you can not
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Which of the following is not a basic step in creating a worksheet?
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
To insert three columns between columns D and E you would
To center worksheet titles across a range of cell, you must
When integrating Ms-Word and Excel, Word is usually the
Charts tips can
The Name box
No comments:
Post a Comment