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
Correct Answer :
B. You can set condition to look for Bold and apply Italics on them
Related Questions
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Excel displays the current cell address in the ........
Formula bar
Status Bar
Name Box
Title Bar
Which function is not available in the Consolidate dialog box?
Pmt
Average
Max
Sum
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
Edit >> Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Which symbol must all formula begin with?
=
+
(
@
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Comments put in cells are called .....
Smart Tip
Cell Tip
Web Tip
Soft Tip
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
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
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
The quicktotal button
The total button
To remove the content of selected cells you must issue ______ command
Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinkos and have 2 more copies made
Press Ctrl+P+3
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
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
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
You cannot link excel worksheet data to a word document
With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar
MS-EXCEL is based on .........?
WINDOWS
DOS
UNIX
OS/2
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
What symbol is used before a number to make it a label?
( quote )
= ( equal )
_ ( underscore )
( apostrophe )
The spelling dialog box can be involved by choosing spelling from ________ menu.
insert
file
tools
view
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Edit the contents of a cell
view different worksheets
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
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
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