In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Correct Answer :
A. $
Related Questions
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
When you copy a formula
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesnt adjust relative cell references
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
A typical worksheet has …. Number of columns
128
256
512
1024
How can you delete a record?
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
A worksheet can have a maximum of …. Number of rows
256
1024
32000
65535
You can use the formula pallette to
format cells containing numbers
create and edit formula containing functions
enter assumptions data
copy a range of cells
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
Getting data from a cell located in a different sheet is called ......
Accessing
Referencing
Updating
Functioning
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
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
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
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
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
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
Multiple calculations can be made in a single formula using .......
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
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
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
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
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
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
Which of the following Excel screen components can NOT be turned on or off?
Formula Bar
Status Bar
Tool Bar
None of above
Which command will you choose to convert a column of data into row?
Cut and Paste
Edit >> Paste Special >> Transpose
Both of above
None of above
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Comments can be added to cells using ......
Edit -> Comments
Insert -> Comment
File -> Comments
View > Comments
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
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
Right clicking something in Excel:
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object