The Cancel and Enter buttons appear in the: Title bar Menu bar Formula bar Sheet tabs TRUE ANSWER : ? YOUR ANSWER : ?
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 enfettered Widen the columns Format the cells with the comma style Select the cells containing the title text plus the range over which the title text is to be centered TRUE ANSWER : ? YOUR ANSWER : ?
What does COUNTA () function do? Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets TRUE ANSWER : ? YOUR ANSWER : ?
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 click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar TRUE ANSWER : ? YOUR ANSWER : ?
What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 6.8 5436.8 TRUE ANSWER : ? YOUR ANSWER : ?
An excel workbook is a collection of Worksheets and charts Charts Worksheets Workbooks TRUE ANSWER : ? YOUR ANSWER : ?
A worksheet range is a A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling TRUE ANSWER : ? YOUR ANSWER : ?
How do you wrap the text in a cell ? Format, cells, protection Format, cells, font Format, cells, number Format, cells, alignment TRUE ANSWER : ? YOUR ANSWER : ?
To create a formula, you first: Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula TRUE ANSWER : ? YOUR ANSWER : ?
When you link data maintained in an excel workbook to a word document The word document contains a copy of the actual data The word document contains a reference to the original source application The word document cannot be edit The word document must contain a hyperlink TRUE ANSWER : ? YOUR ANSWER : ?