INDIA MCQ

Formulas in Excel start witha. %b. =c. +d. -The default header for a worksheet isa. Usernameb. Date and Timec. Sheet tab Named. NoneWhich of the following is not an option of the spelling dialog box?a. Ignoreb. Ignore allc. Editd. ChangeWhich of the following methods will not enter data in a cell?a. Pressing the Esc keyb. Pressing an arrow keyc. Pressing the tab keyd. Clicking … [Read more...]

You accidentally erased a record in the sheet. What command can be used to restore it immediately?a. Insertb. Copyc. Undod. ReplaceWhere a row and a column meet, what do you call that?a. A cellb. A blockc. A boxd. None of the aboveHow do you tell one cell from another?a. By numbersb. By lettersc. By its addressd. by colorGive me an example of a cell address.a. 11 25b. 911c. … [Read more...]

MS-EXCEL can be used to automatea. Financial statements, Business forecastingb. Transaction registers, inventory controlc. Accounts receivable, accounts payabled. Any of the aboveNOT, AND, OR and XOR area. Logical Operatorsb. Arithmetic operatorsc. Relational operatorsd. None of the aboveIn a report, you need to show the monthly rainfall in India The best way to do this is to … [Read more...]

What are the tabs that appear at the bottom of each workbook called?a. Reference tabsb. Position tabsc. Location tabsd. Sheet tabsWhat is represented by the small, black square in the lower right corner of an active cell or range?a. Copy handleb. Fill handlec. Insert handled. BorderIn Excel, a Data Series is defined as what?a. A type of chart.b. A cell reference.c. A collection … [Read more...]

How many worksheets can a workbook have?a. 3b. 8c. 255d. none of aboveWhich would you choose to create a bar diagram?a. Edit, Chartb. Insert, Chartc. Tools, Chartd. Format, ChartWhich setting you must modify to print a worksheet using letterhead?a. Paperb. Marginc. Layoutd. OrientationWhat do you call the chart that shows the proportions of how one or more data elements relate … [Read more...]