MS Excel
What is the short cut key to highlight the entire column?

Ctrl + Space Bar
Ctrl + C
Ctrl + Page Up
Ctrl + Enter

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which tool you will use to join some cells and place the content at the middle of joined cell?

From Format Cells dialog box choose Merge and Center check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box click on Merge Cells check box
Click on Merge and Center tool on formatting toolbar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Which of the following is not true regarding Conditional Formatting?

You can apply Font, border and pattern formats that meets the specified conditions
You can set condition to look for Bold and apply Italics on them
You can delete any condition from Conditional Formatting dialog box if it is not requried
You can add more than one condition to check

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How can you print three copies of a workbook?

Press Ctrl+P+3
Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
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

ANSWER DOWNLOAD EXAMIANS APP