When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Correct Answer :
B. Apply Conditional Formatting command on Format menu
Related Questions
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Which of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series
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
Which of the following action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
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
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
Hyperlinks can be
Text
Drawing objects
Pictures
All of above
If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
It is acceptable to let long text flow into adjacent cells on a worksheet when
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
Which key do you press to check spelling?
F3
F5
F7
F9
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
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
When a label is too long to fit within a worksheet cell, you typically must
Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
To activate the previous cell in a pre-selected range, press
The Alt key
The Tab key
The Enter key
None of the above
Which would you choose to create a bar diagram?
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
To edit in an embedded excel worksheet object in a word document
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
Tab scroll buttons are place on Excel screen
towards the bottom right corner
towards the bottom left corner
towards the top right corner
towards the top left corner
The Delete key of keyboard is assigned to which command in Excel?
Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals