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 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
2 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
3 How are data organized in a spread sheet. Lines and spaces Layers and planes Rows and columns Height and width
4 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
5 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.
6 Macros are 'run' or executed from the ...........menu Insert Format Tools Data
7 Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result. IF AND OR NOT
8 When you insert an excel file into a word document the data are. Hyperlinked Placed in a word table Linked Embedded
9 What function displays row data in a column or column data in a row. Hyperink Index Transpose Rows
10 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
11 Excel is a. Graphic program Word processor A spread sheet None of these
12 What term described a back ground that appears as a grainy non smooth surface. Gradient Pattern Solid Texture
13 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
14 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
15 You can edit existing Excel data by pressing the F1 key F2 key F3 key F4 key
16 "tr 1,, tr 2,tr 3" is an example of a Formula Function Series Syntax
17 What is an expression that tells how the numbers in a determined set of cells are to be calculated. Formula Field Data query
18 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
19 What is the keyboard shortcut for creating a chart from the selected cells. F3 F6 F11 F7
20 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
Download This Set

Is this page helpful?