Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Correct Answer :
D. All of above
Related Questions
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
The active cell:
is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
Which symbol must all formula begin with?
=
+
(
@
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
XY Chart
Line Chart
Pie Chart
Column Chart
Concatenation of text can be done using
Apostrophe (&lsquo
Exclamation (!)
Hash (#)
Ampersand (&
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and c
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
How can you find specific information in a list?
Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
The name box
Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar
Which menu option can be sued to split windows into two
Format > window
View > window > split
Window > split
View > split
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
Which key do you press to check spelling?
F3
F5
F7
F9
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
work sheet
chart sheet
module sheet
data sheet
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
Which of the following is not true about Find and Replace in Excel
You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar