MS Excel To select an entire column in MS - EXCEL, press ? CTRL + C CTRL + Arrow key None of the listed here CTRL + S CTRL + C CTRL + Arrow key None of the listed here CTRL + S ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =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 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Cell locator coordinates Column letters and row numbers Column numbers and row letters Cell names Cell locator coordinates Column letters and row numbers Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you mean by a Workspace? Group of Columns Group of Workbooks Group of Rows Group of Worksheets Group of Columns Group of Workbooks Group of Rows Group of Worksheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? 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 Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Apply Conditional Formatting command on Format menu Use =if() function to format the required numbers red Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS