MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Auto fill options Fill series Fill across worksheet Custom List Auto fill options Fill series Fill across worksheet Custom List ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Macro sheet Data sheet Work sheet Chart sheet Macro sheet Data sheet Work sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number Counts cells having alphabets Counts empty cells Counts non-empty cells Counts cells having number ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates that you can fill series ? Mouse pointer with anchor at the tip None of the listed here Doctor's symbol (Big Plus) Small thin plus icon Mouse pointer with anchor at the tip None of the listed here Doctor's symbol (Big Plus) Small thin plus icon ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS