PPSC Computer Science Full Book test With Answers

PPSC Computer Science Full Book test

Sr. # Questions Answers Choice
1 How are data organized in a spread sheet. Lines and spaces Layers and planes Rows and columns Height and width
2 Which types of charts can excel produce. Line graphs and pie charts only Only line graphs Bar charts line graphs and pie charts Bar charts and line graphics only
3 Each excel file is called a workbook because. It can contain text and data It can be modified It can contain many sheets including worksheets and chart sheets you have to work hard to create it.
4 Macros are 'run' or executed from the ...........menu Insert Format Tools Data
5 Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result. IF AND OR NOT
6 When you insert an excel file into a word document the data are. Hyperlinked Placed in a word table Linked Embedded
7 What function displays row data in a column or column data in a row. Hyperink Index Transpose Rows
8 To create an interactive pivot table for the web you use a Microsoft Office web component called. HTML Pivot Table field list Pivot Table list Pivot Table Report
9 Excel is a. Graphic program Word processor A spread sheet None of these
10 What term described a back ground that appears as a grainy non smooth surface. Gradient Pattern Solid Texture
11 What feature enables yo to adjust or back solve the value in a cell to reach a desired outcome in a formula. Goal seek Scenario summary report Forecasting Trend line
12 The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is G1 - G10 B1 ,G10 B1:G10 B1;G10
13 You can edit existing Excel data by pressing the F1 key F2 key F3 key F4 key
14 "tr 1,, tr 2,tr 3" is an example of a Formula Function Series Syntax
15 What is an expression that tells how the numbers in a determined set of cells are to be calculated. Formula Field Data query
16 What Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed. Format Report Pivot table Refresh Data Show detail
17 What is the keyboard shortcut for creating a chart from the selected cells. F3 F6 F11 F7
18 The autofill feature Extends a sequential series of data Automatically adds a range of cell values Applies a boarder around selected cells. None of above
19 If you press ........the cell accepts your typing as the contents. Enter Ctrl + Enter Tab Insert
20 To copy cell contents using drag and drop press the. End key Shift key Esc key None of above
21 Which of the following is not a worksheet design criterion. Efficiency Auditability Description Clarity
22 You can open the Highlight changes dialog box by choosing track changes from the menu. Edit Insert Format Tools
23 To protect a worksheet, you can choose protection and the protect sheet from the menu. Edit Tools Data Format
24 You can quickly change the appearance of your work by choosing Auto format from the Menu. Edit Format View Tools
25 Which is following is not an option in the spelling dialog box. Edit Ignore Ignore all Change
26 You can check the conditions against ______ when applying conditional formating. Cell value Formula Both of above None of above
27 You can set page border in Excel from From border tab in format cells dialog box From Border tool in formatting toolbar From line style tool in Drawing toolbar You can not set page border in Excel
28 Where can you set the shedding color for a range of cells in Excel. Choose required color form patterns tab of format cells dialog box Choose required color on fill color tool in formatting toolbar Choose required color on fill color tool in drawing toolbar All of above
29 How can you remove borders applied in cells. Choose none on border tab of format cells. Open the list on border tool in formatting toolbar then choose fist tool Both of above None of above
30 Which of the following format you can decide to apply or not in auto format dialog box. Number format Border format Font format All of above
Download This Set

Is this page helpful?