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?
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:
To delete an embedded objects, first
To delete an embedded objects, first
A worksheet range is a
A worksheet range is a
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?
To activate the previous cell in a pre-selected range, press
To activate the previous cell in a pre-selected range, press
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
A circular reference is
A circular reference is
To view a cell comment
To view a cell comment
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:
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 copy data or formulas
You can copy data or formulas
Each excel file is called a workbook because
Each excel file is called a workbook because
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 methods cannot be used to edit the contents of a cell?
Which of the following methods cannot be used to edit the contents of a cell?
To save a workbook, you:
To save a workbook, you:
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?
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
You cannot link excel worksheet data to a word document
You cannot link excel worksheet data to a word document
What is the shortcut key to display the “Format Cells” dialog box in Excel?
What is the shortcut key to display the “Format Cells” dialog box in Excel?
Which of the following functions is used to find the highest value in a range of cells?
Which of the following functions is used to find the highest value in a range of cells?
What is the shortcut key to create a new worksheet in Excel?
What is the shortcut key to create a new worksheet in Excel?
What is the shortcut key to create a new worksheet in Excel?
What is the shortcut key to create a new worksheet in Excel?
Which of the following functions is used to concatenate two or more strings in Excel?
Which of the following functions is used to concatenate two or more strings in Excel?
Which of the following functions is used to calculate the variance of a range of cells in Excel?
Which of the following functions is used to calculate the variance of a range of cells in Excel?
What function displays row data in a column or column data in a row?
What function displays row data in a column or column data in a row?
How are cells named in MS Excel?
How are cells named in MS Excel?
What is the maximum limit of rows in MS Excel 2010?
What is the maximum limit of rows in MS Excel 2010?
What is the maximum limit of columns in MS Excel 2010?
What is the maximum limit of columns in MS Excel 2010?
Which bar lies at the top of the window in the Excel screen?
Which bar lies at the top of the window in the Excel screen?
Which bar lies at the top of the window in the Excel screen?
Which bar lies at the top of the window in the Excel screen?
How are rows numbered in MS Excel?
How are rows numbered in MS Excel?
How are columns named in MS Excel?
How are columns named in MS Excel?
Which tab is used to include pivot tables, charts, and hyperlinks to a spreadsheet
Which tab is used to include pivot tables, charts, and hyperlinks to a spreadsheet
Which tab in Excel is used when importing, querying, outlining, and subtotaling the data placed into a worksheet’s data list?
Which tab in Excel is used when importing, querying, outlining, and subtotaling the data placed into a worksheet’s data list?
In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
MS-Excel uses the . . . . Function when creating a data table
MS-Excel uses the . . . . Function when creating a data table
What is a worksheet also called in Excel?
What is a worksheet also called in Excel?
What dialog box allows you to change a field name in a PivotTable?
What dialog box allows you to change a field name in a PivotTable?
Under which tab and in which function group will you find the option to insert a Pivot Table
Under which tab and in which function group will you find the option to insert a Pivot Table
What command allows you to highlight the cell(s) in a data table that matches your set-up information?
What command allows you to highlight the cell(s) in a data table that matches your set-up information?
Which of the following is NOT a box in the PivotTable Fields List?
Which of the following is NOT a box in the PivotTable Fields List?
What function displays row data in a column or column data in a row?
What function displays row data in a column or column data in a row?
How can we provide a dynamic range in 'data Source' of pivot tables?
How can we provide a dynamic range in 'data Source' of pivot tables?
Merge cells option can be applied from
Merge cells option can be applied from
What is the purpose of using a pointer in a data table?
What is the purpose of using a pointer in a data table?
What is the first step for creating a Pivot Table?
What is the first step for creating a Pivot Table?
Which function will you use to enter current time in a worksheet cell?
Which function will you use to enter current time in a worksheet cell?
You cannot link excel worksheet data to a word document
You cannot link excel worksheet data to a word document