Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Correct Answer :
B. Insert > Comments
Related Questions
The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a charts data series
The data range that supply chart data
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
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 elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
How many characters can be typed in a single cell in Excel?
256
1024
32000
65535
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
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
Which of the following is the latest version of Excel
Excel 2000
Excel 2002
Excel ME
Excel XP
When a row of data is to be converted into columns
Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
A typical worksheet has …. Number of columns
128
256
512
1024
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
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 Chart can be created in Excel?
Area
Line
Pie
All of the above
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
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
MS Excel provides the default value for step in Fill Series dialog box
0
1
5
10
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
Which of following is Not one of Excels what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that youre about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
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
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
work sheet
chart sheet
module sheet
data sheet
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar