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
Correct Answer :
C. Column letters and row numbers
Related Questions
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
Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
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
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
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
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Which of the following is invalid statement?
Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
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
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
To create a formula, you can use:
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
The Name box on to the left of formula bar
shows the name of workbook currently working on
shows the name of worksheet currently working on
shows the name of cell or range currently working on
None of above
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
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
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
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
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula