Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
Correct Answer :
B. Referencing
Related Questions
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+F5
Click Save on the Windows Start button
Select Edit>Save
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
You can select a single range of cells by
Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
How do you delete a column?
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the column heading you want to delete and select Insert Delete from the menu
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above
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
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
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 function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
You can auto fit the width of column by
double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
To view a cell comment
click the edit comment command on the insert menu
click the display comment command on the window menu
position the mouse pointer over the cell
click the comment command on the view menu
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
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
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
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
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
The short cut key Ctrl + R is used in Excel to
Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above