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...]

How do you display current date and time in MS Excel?a. date ()b. Today ()c. now ()d. time ()How do you display current date only in MS Excel?a. date ()b. Today ()c. now ()d. time ()How do you wrap the text in a cell?a. Format, cells, fontb. Format, cells, protectionc. format, cells, numberd. Format, cells, alignmentWhat does COUNTA () function do?a. counts cells having … [Read more...]