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 What does COUNTA () function do? 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 Counts cells having alphabets ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Statistical Math & Trigonometry Logical Financial Statistical Math & Trigonometry Logical ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from From Border tool in Formatting toolbar From Line style tool in Drawing toolbar From Border tab in Farmat cells dialog box You can not set Page Border in Excel From Border tool in Formatting toolbar From Line style tool in Drawing toolbar From Border tab in Farmat cells dialog box You can not set Page Border in Excel ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a range is selected, how can you activate the previous cell ? None Press the Alt key Press Enter Press Tab None Press the Alt key Press Enter Press Tab ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Copy handle Fill handle Insert handle Border Copy handle Fill handle Insert handle Border ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS