A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Correct Answer :
B. Worksheet
Related Questions
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
What is the correct way to refer the cell A10 on sheet3 from sheet1?
sheet3!A10
sheet1!A10
Sheet3.A10
A10
You can check the conditions against __________ when applying conditional formatting
Cell value
Formula
Both of above
None of above
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
How do you display current date only in MS Excel?
date ()
Today ()
now ()
time ()
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
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
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
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
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
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
It is acceptable to let long text flow into adjacent cells on a worksheet when
data will be entered in the adjecent cells
no data will be entered in the adjacent cells
there is no suitable abbrevition for the text
there is not time to format the text
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
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
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
You can use drag-and-drop to embed excel worksheet data in a word document
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
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
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
a and b