MS Excel You can select a single range of cells by Pressing the Shift key and an arrow key Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Ctrl key while dragging over the desired cells Pressing the Shift key and an arrow key Dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Pressing the Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Date () Now () Today () Time() Date () Now () Today () Time() ANSWER DOWNLOAD EXAMIANS APP
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 Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)*0.5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the latest version of Excel Excel XP Excel 365 Excel 2007 Excel 2016 Excel XP Excel 365 Excel 2007 Excel 2016 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS