PPSC Computer Science Chapter 4 Microsoft Excel Online Test With Answers

PPSC Computer Science Chapter 4 Microsoft Excel Online Test

Sr. # Questions Answers Choice
1 How do you change column width to fit the contents. Single click the boundary to the left to the column heading Double click the boundary to the right of the column heading Press Alt and single click any ware is the column All of above
2 The name box Show the location of the previously active cell Appears the left of the formula bar Appears below the status bar Appears below the menu bar
3 Charts tips can Show the formatting of a data label Show the name of a data series Show the value of data point B and C
4 When Integrating MS-Word and Excel, Word in usually the Sever Source Client None
5 To center worksheet titles across a range of cell you must. Select the cells containing the title text and use the fill handle to center the text across a range of cells. Widen the columns Select the cells containing the title text and use the fill handle to center the text across a range of cells. Widen the column
6 To insert three columns between columns D and E you would. Select column D Select column E Select columns E, F and G Select column D , E and F
7 What is a quick way to extend these numbers to a longer sequence for instance 1 through 20 Select both cells and then drag the fill handle over the range you want for instance 18 more rows. Select the range you want include both cells point to till on the edit menu, and then click down. Copy the second cell click in the cell below it on the standard toolbar click the down arrow on the paste button and than click paste special All above
8 Which of the following is not a basic step in creating a worksheet. Save the workbook Modify the worksheet Enter text and data Copy the worksheet
9 Paper spreadsheets can have all the same advantages as an electronic spread sheet except which of the following. Rows and columns Headings Speed None
10 When yu use the fill effects in the format data series dialog box you can not. Rotate text on the chart Select a fore ground color Select a pattern Select a background color
11 Which of the following describes how to select all the cells in a single column. Right click on column and select pick from list Use data text to columns menu item Left click on the gray column title button Pressing Ctrl + A on the keyboard
12 Got function? No ? you need the insert function dialog box. How do you get it. Right click a cell and then click insert. Click the insert menu and then click function Type = in a cell As of the above
13 What term refers to a specific set of values saved with the workbook. Range Scenario Trend line What if analysis
14 Which of the following setup options can not be set in the page setup dialog box. Printer selection Vertical or horizontal placement Orientation Raw and column titles
15 You can activate a cell by Pressing the tab key Clicking the cell Pressing an arrow key All of above
16 Which of the following methods cannot be used to edit the content of cell. Pressing the Alt key Clicking the formula bar Pressing F2 Double clicking the cell
17 Which of the following methods can not be used to enter data in a cell. Pressing an arrow key Pressing the tab key Pressing the Esc key Clicking the enter button to the formula bar
18 Which function calculates your monthly mortage payment. PMT (Payment) NPER (Numebr of periods) PV (Present value) All of above
19 A function inside another function is called a ................ function. Nested Round Sum Text
20 You can print only an embedded chart by Moving the chart to a chart sheet before you print. Formatting the chart before you print Selecting the chart before you print a and c
Download This Set

Is this page helpful?