MS Excel 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 Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder from the menu Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel 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 Alt key None of the listed here 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 the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Alt key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Shift key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Embedded Use the word menu bar and toolbars Hyperlinked placed in a word table Linked Embedded Use the word menu bar and toolbars Hyperlinked placed in a word table Linked ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having number Counts cells having alphabets Counts non-empty cells Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS