MS Excel What does COUNTA () function do? Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? Press Tab None Press the Alt key Press Enter Press Tab None Press the Alt key Press Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar Ctrl + Enter Ctrl + C Ctrl + Page Up Ctrl + Space Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top left corner Towards the bottom left corner Towards the top right corner Towards the bottom right corner Towards the top left corner Towards the bottom left corner Towards the top right corner Towards the bottom right corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which area in an Excel window allows entering values and formulas? Menu Bar Standard Tool Bar Title Bar Formula Bar Menu Bar Standard Tool Bar Title Bar Formula Bar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS