Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Which of the following is not a valid data type in excel
To create a formula, you first:
When you link data maintained in an excel workbook to a word document
Which of the following is not the correct method of editing the cell content?
Which command will you choose to convert a column of data into row?
Ctrl + D shortcut key in Excel will
Give me an example of a cell address.
If particular workbook have to open each time Excel started, where that workbook should be placed?
When you insert an Excel file into a Word document, the data are
You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
To copy cell contents using drag and drop, press the
Which of the following options is not located in the Page Setup dialog box?
If 4/6 entered in a cell without applying any formats, Excel will treat this as
Long text can be broken down into many lines within a cell. You can do this through
A numeric value can be treated as a label value if it precedes with
Which of the cell pointer indicates that you can fill series?
Clear the contents by pressing “DELETE” key from a keyboard will clear
Selecting the Column G & H then choose Insert > Column what will happen?
Which menu option can be used to split windows into two?
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
When integrating word and excel, word is usually the
Which option allows you to Bold all the negative values within the selected cell range:
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called
Which of the following is not a worksheet design criterion?
Can you set 0.5 inch left indentation for a cell in Excel?
Which of the following methods cannot be used to enter data in a cell?
Which is used to perform what if analysis?
“Qtr 1, Qtr 2, Qtr 3” is an example of a
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
Which of the following syntax is correct regarding to SUM function in Excel?
Multiple calculations can be made in a single formula using ________.
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?
Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
You can automatically adjust the size of text in a cell if they do not fit in width by
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed
Worksheet can be renamed by
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.