PPSC Computer Science Full Book test With Answers

PPSC Computer Science Full Book test

Sr. # Questions Answers Choice
1 To active the previous cell in a pre selected range press. The Alt key The tab key The Enter key None of above
2 When creating a vertical page break. The active cell must be A1 The active cell can be anywhere in the worksheet. The active cell must be in row 1 The active cell must be in column A
3 To drag a selected range of data to another worksheet in the same workbook use the. Tab key Alt key Shift key Ctrl key
4 You can add an image to a template by clicking the insert picture from file button on the toolbar Standard Formatting Drawing Picture
5 What do we call a computer program that organizes data in rows and columns of cells? You might use the type of program to keep a record of the money you keep a record of the money you earned moving lawns over the summer. Spread sheet program Database program Word processor program Desktop publisher program
6 You can use the horizontal and vertical scroll bars to. Split a worksheet into two panes View different rows and columns Edit the contents of a cell View different worksheets.
7 Hyperlink cannot be Special shapes like stars and banners Drawing objects like rectangles ovals Pictures All can be hyperlinks
8 When you work with large worksheets you may need to Size the worksheet to fit on the specific number of pages. Add and remove page breaks Specify only certain print areas All of above
9 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
10 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
11 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
12 When Integrating MS-Word and Excel, Word in usually the Sever Source Client None
13 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
14 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
15 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
16 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
17 Paper spreadsheets can have all the same advantages as an electronic spread sheet except which of the following. Rows and columns Headings Speed None
18 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
19 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
20 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
21 What term refers to a specific set of values saved with the workbook. Range Scenario Trend line What if analysis
22 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
23 You can activate a cell by Pressing the tab key Clicking the cell Pressing an arrow key All of above
24 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
25 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
26 Which function calculates your monthly mortage payment. PMT (Payment) NPER (Numebr of periods) PV (Present value) All of above
27 A function inside another function is called a ................ function. Nested Round Sum Text
28 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
29 Gridines May be turned off for display but turned on for printing. May be turned on or off for printing The be turned off for display and printing. a, b and c
30 What does the VLOOKUP function do. Looks up text that contain Checks whether text is the same in one cell as in the next Finds related records All of above
Download This Set

Is this page helpful?