Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
Correct Answer :
D. Document
Related Questions
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
You can copy data or formulas
With the copy, paste and cut commands on the edit menu
With commands on the shortcut menu
With buttons on the standard toolbars
All of the above
Which is used to perform what if analysis?
Solver
Goal seek
Scenario Manager
All of above
Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
Excel files have a default extension of
Xls
Xlw
Wk1
123
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
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
To edit in an embedded excel worksheet object in a word document
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
When you want to insert a blank imbedded excel object in a word document you can
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
Multiple calculations can be made in a single formula using
standard formulas
array formula
complex formulas
smart formula
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
Which of the cell pointer indicates you that you can make selection?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
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
How many worksheets can a workbook have?
3
8
255
none of above
When a range is selected, how can you activate the previous cell?
Press the Alt key
Press Tab
Press Enter
None of above
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
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
Which symbol must all formula begin with?
=
+
(
@
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 information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format >> Cells
Justify in Edit >> Cells
Text Wraping in Format >> Cells, Layout tab
All of above