MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To add borders To insert a background To select a distribution of figures To add shading or color to a cell range To add borders To insert a background To select a distribution of figures To add shading or color to a cell range ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Scenarios Objects Contents All of the listed here Scenarios Objects Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel In the formula, which symbol specifies the fixed columns or rows ? $ & * % $ & * % 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 Tools > Finder from the menu Select Insert > Find 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 Tools > Finder from the menu Select Insert > Find from the menu Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? !A!1 $A$1 #a#1 A1 !A!1 $A$1 #a#1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home Press Ctrl + Home Press Alt + Home Press Shift + Home Press Home ANSWER DOWNLOAD EXAMIANS APP