Applicationpackage Asg1

1 marks: 1 number entries on an ms excel sheet can be formatted to choose at least one answer. a. a specified number of decimal places b. hide the decimal places c. have a 1000 seprerator d. display the negative numbers in a different colour e. display with a currency symbol 2 marks: 1 to remove a worksheet from the workbook choose at least one answer. a. be on the relevant worksheet and press the delete key b. double click on the worksheet name appearing on the tab and press the delete key c. right click on the sheet tab name and select the option delete from the pop-up menu d. select the option �edit > delete sheet� from the menu bar e. be on the relevant worksheet and select the option delete from the edit menu 3 marks: 1 which of the following statements is/are correct regarding ms excel? choose at least one answer. a. ms excel file is called as a workbook b. a workbook can have any number of worksheets c. an excel worksheet can handle 65,536 rows of records d. columns of a worksheet are named as , a, b, c,..., aa, bb,...,iv e. a worksheet can be named as you want 4 marks: 1 a toolbar can be hidden by choose at least one answer. a. right clicking on the toolbar and selecting the option �hide� on the popup menu. b. right clicking on the toolbar and selecting the its name on the popup menu. c. clicking on the name of the toolbar displaying on the menu, view > toolbars. d. using the customize� option on the view > toolbars. e. using the customize dialog box from tools > customize. 5 marks: 1 which of the following actions cannot be performed on a picture using the picture toolbar in ms word? choose at least one answer. a. change brightness b. set the contrast values c. apply transparency d. wrap with the text e. change some selected colours 6

marks: 1 which of the following error messages show(s) that there is a wrong type of argument or operand in the formula? choose at least one answer. a. #n/a b. #null! c. #ref! d. #num! e. #value! 7 marks: 1 which of the following statements is/are true with macros in ms word? choose at least one answer. a. it is a program consisting of recorded key strokes to do a specific task. b. it can automate tedious tasks and series of procedures. c. a macro can be executed with a shortcut key. d. a macro can be written to harm a word processing document. e. it can be set to auto execute. 8 marks: 1 one cannot apply page orientation change to some pages of a document. choose one answer. a. yes b. no 9 marks: 1 which of the following statements is/are true with respect to the computer applications? choose at least one answer. a. a computer application is a computer program or set of programs. b. an application package is a set of computer applications. c. a computer application is a software d. ms word is an application of the ms office application package. e. you can run any computer application on any computer. 10 marks: 1 what is the technique that is used to format the text in figure 1 to make it appear as in figure 2? choose at least one answer. a. font effect b. change case c. tab setting d. drop cap e. hanging