Q.40.You cannot set the increment between neighboring values of your series.
Q.40.You cannot set the increment between neighboring values of your series.
Q.06.
_______ tab, in the Editing group, click Find & Select, and then click Go To.
Q.06.
_______ tab, in the Editing group, click Find & Select, and then click Go To.
Q.07.What type of chart will you use to compare performance of sales of two products ?
Q.07.What type of chart will you use to compare performance of sales of two products ?
Q.08.It is a collection of data that is stored electronically as a series of records in a table.
Q.08.It is a collection of data that is stored electronically as a series of records in a table.
Q.09.An Excel file is generally called a / an :
Q.09.An Excel file is generally called a / an :
Q.10.In Excel, which one denoted a range from B1 through E5
Q.10.In Excel, which one denoted a range from B1 through E5
Q.11.How many sheets are there, by default, when we create a new Excel file ?
Q.11.How many sheets are there, by default, when we create a new Excel file ?
Q.12.The basic unit of a worksheet into which you enter data in Excel is called a
Q.12.The basic unit of a worksheet into which you enter data in Excel is called a
Q.21.What type of chart is good for single series of data ?
Q.21.What type of chart is good for single series of data ?
Q.05.Open a new, blank workbook
Q.05.Open a new, blank workbook
Q.03.On the ------------tab, in the Sparklines group, click the type of sparkline that you want to create
Q.03.On the ------------tab, in the Sparklines group, click the type of sparkline that you want to create
Q.690. function is used to count the number of numerical values in a range?
Q.690. function is used to count the number of numerical values in a range?
Q.689.How do you start a formula in Excel?
Q.689.How do you start a formula in Excel?
Q.688. What is the purpose of the Filter feature in Excel?
Q.688. What is the purpose of the Filter feature in Excel?
Q.687.What function is used to calculate the sum of a range of cells?
Q.687.What function is used to calculate the sum of a range of cells?
Q.686.What is the default file extension for an Excel workbook?
Q.686.What is the default file extension for an Excel workbook?
Q.685.Who invented MS Excel and in which year?
Q.685.Who invented MS Excel and in which year?
Q.683. What is Microsoft Excel?
Q.683. What is Microsoft Excel?
Q.02.On the------------ tab, in the Clipboard group, click Copy
Q.02.On the------------ tab, in the Clipboard group, click Copy
Q.20.How will you graphically represent expenditure in different departments ?
Q.20.How will you graphically represent expenditure in different departments ?
Q.19.What do you use to create a chart?
Q.19.What do you use to create a chart?
Q.28."To apply a 3D effect, you would first activate the Drawing toolbar, click on the 3D button and then click on the AutoShape button to choose a predefined shape."
Q.28."To apply a 3D effect, you would first activate the Drawing toolbar, click on the 3D button and then click on the AutoShape button to choose a predefined shape."
Q.27.You can use the re-sizing handle also to change the shape of an object.
Q.27.You can use the re-sizing handle also to change the shape of an object.
Q.26."After an object has been drawn, you cannot re-size it."
Q.26."After an object has been drawn, you cannot re-size it."
Q.25.The procedure to create graphic objects is similar to the procedure to draw lines or arrows.
Q.25.The procedure to create graphic objects is similar to the procedure to draw lines or arrows.
Q.24.You can draw a line by dragging your mouse across the screen and then click on the Line button.
Q.24.You can draw a line by dragging your mouse across the screen and then click on the Line button.
Q.23.. "It is not necessary to display the Drawing toolbar, to create graphics."
Q.23.. "It is not necessary to display the Drawing toolbar, to create graphics."
Q.22."A PivotTable is comprised of three areas: ROW, COLUMN and DATA.
Q.22."A PivotTable is comprised of three areas: ROW, COLUMN and DATA.
Q.41.You can also specify the maximum value in the series.
Q.41.You can also specify the maximum value in the series.
Q.29.You cannot move or change the shape of a 3D object.
Q.29.You cannot move or change the shape of a 3D object.
Q.30."You can only abandon the chart in the fourth step by clicking on the Cancel button, otherwise you would click on the Finish button to create the chart."
Q.30."You can only abandon the chart in the fourth step by clicking on the Cancel button, otherwise you would click on the Finish button to create the chart."
Q.18.The process of arranging the items of a column in some sequence or order is known as :
Q.18.The process of arranging the items of a column in some sequence or order is known as :
Q.17.What type of chart is useful for showing trends or changes over time ?
Q.17.What type of chart is useful for showing trends or changes over time ?
Q.34."Range names can be removed, as well as added, by selecting the Define command from the Insert/Name menu."
Q.34."Range names can be removed, as well as added, by selecting the Define command from the Insert/Name menu."
Q.16.The Greater Than sign (>) is an example of _____ operator.
Q.16.The Greater Than sign (>) is an example of _____ operator.
Q.15.Which function in Excel checks whether a condition is true or not ?
Q.15.Which function in Excel checks whether a condition is true or not ?
Q.14.Functions in MS Excel must begin with ___
Q.14.Functions in MS Excel must begin with ___
Q.13.What type of chart will you use to compare performance of two employees in the year 2016 ?
Q.13.What type of chart will you use to compare performance of two employees in the year 2016 ?
Q.31.A features that displays only the data in column according to specified criteria
Q.31.A features that displays only the data in column according to specified criteria
Q.691.How do you insert a new worksheet in an Excel workbook?
Q.691.How do you insert a new worksheet in an Excel workbook?