Q.500. Which of the following functions is used to calculate the variance of a range of cells in Excel?
Q.500. Which of the following functions is used to calculate the variance of a range of cells in Excel?
Q.418.To edit in an embedded excel worksheet object in a word document
Q.418.To edit in an embedded excel worksheet object in a word document
Q.417.To copy formatting from one area in a worksheet and apply it to another area you would use:
Q.417.To copy formatting from one area in a worksheet and apply it to another area you would use:
Q.416.To view a cell comment
Q.416.To view a cell comment
Q.415.A circular reference is
Q.415.A circular reference is
Q.414.To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Q.414.To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Q.413.To activate the previous cell in a pre-selected range, press
Q.413.To activate the previous cell in a pre-selected range, press
Q.412.Which of the following is not a basic step in creating a worksheet?
Q.412.Which of the following is not a basic step in creating a worksheet?
Q.411.A worksheet range is a
Q.411.A worksheet range is a
Q.410.To delete an embedded objects, first
Q.410.To delete an embedded objects, first
Q.409.If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Q.409.If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Q.419.You can copy data or formulas
Q.419.You can copy data or formulas
Q.420.You can copy data or formulas
Q.420.You can copy data or formulas
Q.421. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Q.421. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
Q.499.Which of the following functions is used to concatenate two or more strings in Excel?
Q.499.Which of the following functions is used to concatenate two or more strings in Excel?
Q.430. What is the shortcut key to create a new worksheet in Excel?
Q.430. What is the shortcut key to create a new worksheet in Excel?
Q.429. What is the shortcut key to create a new worksheet in Excel?
Q.429. What is the shortcut key to create a new worksheet in Excel?
Q.428. Which of the following functions is used to find the highest value in a range of cells?
Q.428. Which of the following functions is used to find the highest value in a range of cells?
Q.427.What is the shortcut key to display the “Format Cells” dialog box in Excel?
Q.427.What is the shortcut key to display the “Format Cells” dialog box in Excel?
Q.426.You cannot link excel worksheet data to a word document
Q.426.You cannot link excel worksheet data to a word document
Q.425.When you want to insert a blank imbedded excel object in a word document you can
Q.425.When you want to insert a blank imbedded excel object in a word document you can
Q.424.Which of the following is a correct order of precedence in formula calculation?
Q.424.Which of the following is a correct order of precedence in formula calculation?
Q.423.To save a workbook, you:
Q.423.To save a workbook, you:
Q.422.Which of the following methods cannot be used to edit the contents of a cell?
Q.422.Which of the following methods cannot be used to edit the contents of a cell?
Q.408.Which of following is Not one of Excel’s what-if function?
Q.408.Which of following is Not one of Excel’s what-if function?
Q.407.You cannot link excel worksheet data to a word document
Q.407.You cannot link excel worksheet data to a word document
Q.393.In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
Q.393.In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
Q.392.Which tab in Excel is used when importing, querying, outlining, and subtotaling the data placed into a worksheet’s data list?
Q.392.Which tab in Excel is used when importing, querying, outlining, and subtotaling the data placed into a worksheet’s data list?
Q.391.Which tab is used to include pivot tables, charts, and hyperlinks to a spreadsheet
Q.391.Which tab is used to include pivot tables, charts, and hyperlinks to a spreadsheet
Q.390.How are columns named in MS Excel?
Q.390.How are columns named in MS Excel?
Q.389.How are rows numbered in MS Excel?
Q.389.How are rows numbered in MS Excel?
Q.388.Which bar lies at the top of the window in the Excel screen?
Q.388.Which bar lies at the top of the window in the Excel screen?
Q.387.Which bar lies at the top of the window in the Excel screen?
Q.387.Which bar lies at the top of the window in the Excel screen?
Q,.386.What is the maximum limit of columns in MS Excel 2010?
Q,.386.What is the maximum limit of columns in MS Excel 2010?
Q.385.. What is the maximum limit of rows in MS Excel 2010?
Q.385.. What is the maximum limit of rows in MS Excel 2010?
Q.384.How are cells named in MS Excel?
Q.384.How are cells named in MS Excel?
Q.394.In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
Q.394.In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
Q.395.MS-Excel uses the . . . . Function when creating a data table
Q.395.MS-Excel uses the . . . . Function when creating a data table
Q.396.What function displays row data in a column or column data in a row?
Q.396.What function displays row data in a column or column data in a row?
Q.406.Which function will you use to enter current time in a worksheet cell?
Q.406.Which function will you use to enter current time in a worksheet cell?
Q.405.What is the first step for creating a Pivot Table?
Q.405.What is the first step for creating a Pivot Table?
Q.404.What is the purpose of using a pointer in a data table?
Q.404.What is the purpose of using a pointer in a data table?
Q.403. Merge cells option can be applied from
Q.403. Merge cells option can be applied from
Q.402.How can we provide a dynamic range in 'data Source' of pivot tables?
Q.402.How can we provide a dynamic range in 'data Source' of pivot tables?
Q.401.What function displays row data in a column or column data in a row?
Q.401.What function displays row data in a column or column data in a row?
Q.400.Which of the following is NOT a box in the PivotTable Fields List?
Q.400.Which of the following is NOT a box in the PivotTable Fields List?
Q.399.What command allows you to highlight the cell(s) in a data table that matches your set-up information?
Q.399.What command allows you to highlight the cell(s) in a data table that matches your set-up information?
Q.398.Under which tab and in which function group will you find the option to insert a Pivot Table
Q.398.Under which tab and in which function group will you find the option to insert a Pivot Table
Q.397.What dialog box allows you to change a field name in a PivotTable?
Q.397.What dialog box allows you to change a field name in a PivotTable?
Q.383.What is a worksheet also called in Excel?
Q.383.What is a worksheet also called in Excel?