MS Excel Concatenation of text can be done using Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) Exclamation (!) Hash (#) Apostrophe (') Ampersand (&) 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? Data sheet Work sheet Macro sheet Chart sheet Data sheet Work sheet Macro sheet Chart sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? XY Chart Pie Chart Column Chart Line Chart XY Chart Pie Chart Column Chart Line Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Automatically creates formulas and adds them to a worksheet Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Receives the data the user enters Only A and B It is the formula bar Is defined by a bold border around the cell Receives the data the user enters Only A and B It is the formula bar Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS