Microsoft Excel 2010 - I

Question 1An assignment was given to Sanjiv and Vibha by their teacher. They were shown the screen shot given below and were asked to answer the...

Question 2Mayur could not complete the assignment given by his teacher which is shown below. Help him to fill the blank cells marked with yellow...

Question 3The class teacher asked Ravi to observe the following worksheet carefully, and answer the questions based on it:(i) Identify the nature of...

Question 4Sahil has been given the hard copy of the following worksheet by his teacher.His teacher has asked him to:(i) Calculate the total...

Question 1Which software lets you perform calculations and manipulate the numeric data?MS ExcelMS WordMS PowerPointAll of these

Question 2Name the element which is identified by a unique row number and column number.CellColumnRowNone of these

Question 3What do we call a group of contiguous cells which form the shape of a rectangle?CellSpreadsheetRangeSheetTab

Question 4Which symbol separates the address of the starting cell address from the ending cell address in a range?SemicolonColonFull StopNone of these

Question 5Which of the following component lies at the top of the document window in MS Excel?Task BarStatus BarFormula BarTitle Bar

Question 6What name do we give to the current cell which has a cell boundary around it?Passive CellActive CellCurrent CellNew Cell

Question 7Which is the last valid column header in MS Excel?XFDAJAZAJM

Question 8What is the default name of a workbook in MS Excel?Book1Sheet1Untitled1All of these

Question 9Which shortcut key combination is used to save a workbook in MS Excel?Ctrl + XCtrl + ZCtrl + CCtrl + S

Question 10Which pair of brackets are used to denote a negative value in MS Excel?ParenthesisCurly BracketsSquare BracketsAll of these

Question 11What is the default alignment for numbers in MS Excel?LeftRightCenterNone of these

Question 12Name the expression which includes numbers, cell addresses, operators, and parenthesis.SymbolEquationFormulaNone of these

Question 13Which symbol marks the beginning of a formula?Equal (=)Plus (+)Asterik (*)Division (/)

Question 14Which data entry is neither a number nor a formula?DateCharacterTextNone of these

Question 15By default, how many worksheets does an excel workbook display?1234

Question 16What separates time elements in Excel?ColonsHyphenSlashEqual to

Question 1If we type the apostrophe symbol before a number, Excel assumes it as a text entry.

Question 2The date entries in Excel are separated by the colon symbol.

Question 3The F3 function key is used to edit the contents of the active cell.

Question 4The Clear All option clears all the contents from the selected range of cell.

Question 5The shortcut key combination to cut a specific range of cells is Ctrl + X.

Question 6The name given to a range of cells is added in the drop-down list of the Name Box.

Question 7The small black square present in the lower right corner of the active cell is called the Cell Handle.

Question 8The Insert dialog box has four different options to choose from.

Question 9The number of blank cells inserted in a worksheet will be same as the number of cells selected initially.

Question 10An expression which includes cell addresses, numbers, operators, and parenthesis is called a Chemical Equation.

Question 11Formulas always begin with the '=' symbol followed by cell references and operators.

Question 12We use the Compound Formulas when we need more than one operator.

Question 13The other name of cell reference in MS Excel is cell address.

Question 14Alphanumeric data cannot be entered in a worksheet.

Question 1What are functions? Explain the different parts of functions.

Question 2Can we find the average of more than one range of cells? If yes, what will be the structure of such a function?

Question 3What is the significance of COUNT() function? What type of data entries does the COUNT() function recognize?

Question 4Which logical values are recognized by most of the functions? What are the corresponding numeric values of those logical values?

Question 5Suggest the Excel functions which can be used for the following:(a) To calculate the average marks obtained by a student in SA1 assuming...