1.
Which of the following methods cannot be used to edit the contents of a cell In MS-Excel?
2.
The ‘Lookup_value’ should be the topmost row of the ‘table_array’ when we are using HLOOKUP. If we need to look somewhere else, then we must use another Excel formula.
3.
In MS-Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?
4.
What MS-Excel feature can you use if you want to work with one record at a time?
5.
How do you remove or delete a Pivot Table?
6.
In MS-Excel to select an individual data marker or data label, you must
7.
In MS-Excel the keyboard shortcut for creating a chart from the selected cells is ________
8.
you can use the formula pallette for _________.
9.
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ______ Menu.
10.
The Sum function is applied to values in a Pivot Table by default. How can I change this so that values are automatically counted and not summed?
11.
How can you upadte the values of formula cells if auto calculate mode of excel is disabled?
12.
In MS excel Graphics object on a chart are used to _________________
13.
In MS-Excel Chart wizard term data categories refers to ___________.
14.
In MS-Excel you can open the Highlight Changes dialog box by choosing Track Changes from the _________ Menu.
15.
In MS Excel Book1 is an example of how ___________ are numbered and named during each work session.
16.
In MS-Excel which is used to perform what if analysis?
17.
which command will you choose to convert a column of data into row?
Call Now Button
