MS Excel
Which elements of a worksheet can be protected from accidental modification?

Contents
All of the listed here
Objects
Scenarios

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
The name box

Appears below the status bar
Shows the location of the previously active cell
Appears below the menu bar
Appears to the left of the formula bar

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

Apply Conditional Formatting command on Format menu
All of above
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
Use =if() function to format the required numbers red

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
Click on Merge and Center tool on formatting toolbar
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you select an entire column?

Select Edit > Select > Column from the menu
Hold down the Ctrl key as you click anywhere in the column
Click the column heading letter
Hold down the shift key as you click anywhere in the column

ANSWER DOWNLOAD EXAMIANS APP