Where can you change automatic or manual calculation mode in Excel?
Double CAL indicator on status bar
Go to Tools >> Options >> Calculation and mark the corresponding radio button
Both of above
None of above
Correct Answer :
B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
Related Questions
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Ctrl +Home
Press Home
Press Shift + Home
Press Alt + Home
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
What is the short cut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
It is acceptable to let long text flow into adjacent cells on a worksheet when
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
You can use the formula pallette to
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
Concatenation of text can be done using
Apostrophe ( )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Microsoft Excel is a powerful ...........
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
Which of the following series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
Which of the following action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
Which of the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Which key do you press to check spelling?
F3
F5
F7
F9
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning