What function displays row data in a column or column data in a row?
Which of the following will not set text in selected cells to italics?
You can check the conditions against __________ when applying conditional formatting
Getting data from a cell located in a different sheet is called ________.
What is the symbol for dividing?
When you want to insert a blank imbedded excel object in a word document you can
To activate the previous cell in a pre-selected range, press
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
To copy formatting from one area in a worksheet and apply it to another area you would use:
Which of the following is not information you can specify using the solver?
Which symbol must all formula begin with?
Which of the following syntax is correct regarding to SUM function in Excel?
You can automatically adjust the size of text in a cell if they do not fit in width by
How are data organized in a spreadsheet?
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Which of the following series type is not valid for Fill Series dialog box?
Which is used to perform what if analysis?
Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
The command Edit >> Fill Across Worksheet is active only when
MS-EXCEL is based on __________?
Formatting a cell in Currency, you can specify
Getting data from a cell located in a different sheet is called …
How do you tell one cell from another?
Which language is used to create macros in Excel?
Which of the following methods can not be used to edit the contents of a cell?
Which is an example of a formula?
An excel workbook is a collection of
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ________.
How can you remove borders applied in cells?
What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
You can move a sheet from one workbook into new book by
Concatenation of text can be done using
You can print only an embedded chart by
To delete an embedded objects, first
You can activate a cell by
If the cell B1 contains the formula = $A$1, which of the following statements is true
In the formula, which symbol specifies the fixed columns or rows?
When a range is selected, how can you activate the previous cell?
What does the NOW() function return?
Which of the following you can paste selectively using Paste Special command?