Electronic Spreadsheet – Set 8

Computer Operator

Dear ! This is Electronic Spreadsheet – Set 8 Quiz and it contains 38 questions.

Happy Learning!

1 / 38

1. In a relational database , this is the data structure that holds a single piece of data , such as first name or phone number .

catalog

field

entity

object

2 / 38

2. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the?

Unfreeze panes command on the window menu

Freeze panes command on the window menu

Hold titles command on the edit menu

Split command on the window menu

3 / 38

3. You can use drag and drop to embed excel worksheet data in a word document ?

By dragging a range of excel data to the word button on the taskbar while pressing Ctrl key

By dragging a range of excel data to the word button on the taskbar while pressing Shift key

By dragging a range of excel data to the word button on the taskbar while pressing Alt key

None of these

4 / 38

4. Data can be arranged in a worksheet in a easy to understand manner using?

Auto formatting

Applying styles

Changing fonts

All of these

5 / 38

5. This method of online analytical processing stores data in both a relational and a multi- dimensional database .

HOLAP

ROLAP

OLAP

DIMM

6 / 38

6. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

On the file menu, point to print area, and then click set print area.

On the file menu, click print, and the click selection under print what

On the view menu, click custom views, then click add

All of these

7 / 38

7. At this level of normalization , each column in a table that is not a determiner of the contents of another column , must itself be a function of the other columns in the table .

1NF

2NF

3NF

DKNF

8 / 38

8. 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

9 / 38

9. What term refers to a specific set of values saved with the workbook?

Range

Scenario

Trend line

What if analysis

10 / 38

10. Which of the following methods cannot be used to edit the content of cell?

Press the Alt key

Clicking the formula bar

Pressing F2

Double clicking the cell

11 / 38

11. You xan open the consolidate dialog box by choosing consolidate from the……menu?

Insert

Format

Tools

Data

12 / 38

12. When you link data maintained in Excel workbook to a word document ?

The word document cannot be edited

The word document contains a reference to the orginal source application

The word document must contains a hyperlink

The word document contains a copy of the actual data

13 / 38

13. You can open the scenario Manager dialog box by choosing scenarios from the ….menu?

View

Insert

Format

Tools

14 / 38

14. This is an organized selection of data from a database that allows you to look at it from a particular perspective

Venn diagram

Gantt chart

view

splay tree

15 / 38

15. What does the VLOOKUP function do?

Looks up text that contain 'v'

Check whether text is the same in one cell as in the next

Finds related records

All of these

16 / 38

16. Which technology was Microsoft’s first attempt at an object – oriented database interface ?

MQ Series

ADO

DAO

UDA

17 / 38

17. Charts tips can?

A.Show the formatting of a data label

B.Show the name of a data series

C.Show the value of data point

D.B and C

18 / 38

18. You can zoom a worksheet?

With the mouse pointer in print preview

With the zoom button on the print preview toolbar

With the zoom command on the view menu

All of the above

19 / 38

19. A data map is helpful ?

When you have too much data to chart

To show a geographic distribution of data

To compare data points

To show changes in data over time

20 / 38

20. This type of software is similar to an accountant’s worksheet?

Word processing

Database

Spreadsheets

Graphics

21 / 38

21. When intergrating Ms Word and Excel, Word is usually the ?

Server

Source

Client

None of these

22 / 38

22. This term , used to describe a database that occupies magnetic storage in the terabyte range , describe a database that contains billions of table rows

Very Large database

holographic storage

Cold Fusion

giant

23 / 38

23. When you group worksheets?

A.You can enter variable data on multiple worksheets at one time

B.You can print more than one worksheet at a time

C.You can enter common data, formats, and formulas on multiple worksheets at one time

D.B and C

24 / 38

24. What function displays row data in a column or column data in row?

Hyperlink

Index

Transpose

Rows

25 / 38

25. This is a common standard language used to update and get information from a database

TMQL

PHP

SQL

26 / 38

26. In a worksheet you can press Shift+Space to select entire?

Worksheet

Row

Column

All of these

27 / 38

27. Which of the following setup options cannot be set in the page setup dialog box?

Printer selection

Vertical or horizontal placement

Orientation

Row and column titles

28 / 38

28. Which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004?

Workday

Date

Network days

All of these

29 / 38

29. When you see a cell with a red triangle in the top right corner, what does this signify?

There is an error in the cell

There is a comment associated with the cell

The font color for text in the cell is red

A formula cannot be entered into the cell

30 / 38

30. To protect a worksheet, you can choose protection and the pretect sheet from the…..menu?

Edit

Format

Tools

Data

31 / 38

31. This is a file format that contains the values in a table in which column values separated by a common and each rows starts a new line .

ASCII

CSV file

virtual organization

None

32 / 38

32. Which of the following is a correct order of precedence in a formula calculation?

Multiplication and division, exponential positive and negative value

Multiplication and division, positive and negative values, addition and subtraction

Addition and subtraction, positive and negative values, exponentiaton

None of these

33 / 38

33. 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 anywhere in the column

All of these

34 / 38

34. 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 Aa

35 / 38

35. What is the name given to the database management system which is able to handle full text data , image data , audio & video

full media

multimedia

text database

Relationship

36 / 38

36. This is a standard interactive and programming language for getting information from and updating a database .

dynamic data exchange

Structured Query Language

ASCII

Enlarge programming language

37 / 38

37. Which types of charts can excel produce ?

Line graphs and pie charts only

Only line graphs

Bar chart, line graphs and pie charts

Bar chart and line graphs only

38 / 38

38. This is a family of relational database management system product from IMB that server a number of different operating system platforms

Cognos

DB2

ADO

Universal Data Access

Your score is

Exit

Happy Learning!

Share this Quiz with your friends!

Follow Us @