Where can you set the shading color for a range of cells in Excel?
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above
Correct Answer :
D. All of above
Related Questions
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
When integrating word and excel, word is usually the
Server
Destination
Client
Both b and c
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
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
In a worksheet you can select
The entire worksheet
Rows
Columns
All of the above
Comments put in cells are called
Smart tip
Cell tip
Web tip
Soft tip
Which area in an excel window allows entering values and formulas
Title bar
Menu bar
Formula bar
Standard toolbar
To copy formatting from one area in a worksheet and apply it to another area you would use:
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
There is no way to copy and apply formatting in Excel You have to do it manually
The Format Painter button on the standard toolbar
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
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
What will be the output if you format the cell containing 5436.8 as #,##0.00'?
5430
5436.80
5436.8
6.8
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
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
How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
F8
F9
F10
F11
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Data can be arranged in a worksheet in a easy to understand manner using
auto formatting
applying styles
changing fonts
all of above
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Which would you choose to create a bar diagram?
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
A __________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
Which of the cell pointer indicates that you can fill series?
Doctors symbol (Big Plus)
small thin plus icon
Mouse Pointer with anchor at the tip
None of above
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 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
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
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar