1.
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.
2.
In MS excel Graphics object on a chart are used to _________________
3.
In MS-Excel you can open the Highlight Changes dialog box by choosing Track Changes from the _________ Menu.
4.
which command will you choose to convert a column of data into row?
5.
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ______ Menu.
6.
How do you remove or delete a Pivot Table?
7.
Which of the following methods cannot be used to edit the contents of a cell In MS-Excel?
8.
What MS-Excel feature can you use if you want to work with one record at a time?
9.
In MS Excel Book1 is an example of how ___________ are numbered and named during each work session.
10.
In MS-Excel to select an individual data marker or data label, you must
11.
you can use the formula pallette for _________.
12.
How can you upadte the values of formula cells if auto calculate mode of excel is disabled?
13.
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?
14.
In MS-Excel the keyboard shortcut for creating a chart from the selected cells is ________
15.
In MS-Excel which is used to perform what if analysis?
16.
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?
17.
In MS-Excel Chart wizard term data categories refers to ___________.