Which of following is Not one of Excel’s what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Answer : D
Free Online Test
View More Related Question
1) A numeric value can be treated as a label value if it precedes with
2) Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
View Answer
3) How can you print three copies of a workbook?
Select File>Properties form the menu and type 3 in the Copies to print text box.
Select File >Print from the menu and type 3 in the Number of copies text box.
Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
Press Ctrl+P+3
View Answer
4) When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
View Answer
5) Which dialogue box we can use to name a constant ?
