General Computer Test - 75

 

1. Each excel file is called a workbook because :

(a)    It can contain text and data

(b)    It can be modified

(c)     It can contain many sheets including worksheets and chart sheets

(d)    You have to work hard to create it

(e)    None of these

Ans : (c)

2. Which types of charts can excel produce?

(a)    Line graphs and pie charts only

(b)    Only line graphs

(c)     Bar charts, line graphs and pie charts

(d)    Bar charts and line graphs only

(e)    None of these

Ans : (c)

3. How are data organized in a spreadsheet?

(a)    Lines and spaces

(b)    Layers and planes

(c)     Rows and Columns

(d)    Height and width

(e)    None of these

Ans : (c)

4. What does the VLOOKUP function do?

(a)    Looks up text that contain ‘v’

(b)    Checks whether text is the same in one cell as in the next

(c)     Finds related records

(d)    All of these

(e)    None of these

Ans : (c)

5. Gridlines :

(a)    May be turned off for display but turned on for printing

(b)    May be turned on or off or printing

(c)     The be turned off for display and printing

(d)    All of these

(e)    None of these

Ans : (d)

6. You can print only an embedded chart by

(a)    Moving the chart to a chart sheet before you print.

(b)    Formatting the chart before you print

(c)     Selecting the chart before you print

(d)    Both (a) and (c)

(e)    None of these

Ans : (d)

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

(a)    Multiplication and division, exponential positive and negative value

(b)    Multiplication and division, positive and negative values, addition and subtraction

(c)     Addition and subtraction, positive and negative values, exponentiation

(d)    All of these

(e)    None of these

Ans : (e)

8. A function inside another function is called a function

(a)    Nested

(b)    Round

(c)     Sum

(d)    Text

(e)    None of these

Ans : (a)

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

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

(b)    On the file menu, click print, and then click selection under print what

(c)     On the view menu, click custom views, then click add

(d)    All of these

(e)    None of these

Ans : (b)

10. Your German supplier still invoices for parts in deutsche marks.

(a)    On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.

(b)    On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

(c)     Apply a selected background color

(d)    All of these

(e)    None of these

Ans : (b)

11. Which function calculates your monthly mortgage payment?

(a)    PMT (payments)

(b)    NPER (number of periods)

(c)     PV (present value)

(d)    All of these

(e)    None of these

Ans : (a)

12. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

(a)    Point to speech on the tools menu, and then click show text to speech toolbar.

(b)    Click validation on the data menu

(c)     Point to speech on the tools menu, and then click speech recognition

(d)    All of these

(e)    None of these

Ans : (a)

13. Which of the following methods cannot be used to enter data in a cell?

(a)    Pressing an arrow key

(b)    Pressing the tab key

(c)     Pressing the Esc key

(d)    Clicking the enter button to the formula bar

(e)    None of these         

Ans : (c)

14. Which of the following will not set text in selected cells to italics?

(a)    Pressing Ctrl + I on the keyboard

(b)    Using the Tools – Wizard – Web Form menu item

(c)     Using the Format – Cells – Font menu item

(d)    All of these

(e)    None of these

Ans : (b)

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

(a)    Pressing the Alt key

(b)    Clicking the formula bar

(c)     Pressing F2

(d)    Double clicking the cell

(e)    None of these

Ans : (a)

16. To insert three columns between columns D and E you would :

(a)    Select column D

(b)    Select column E

(c)     Select columns E, F and G

(d)    Select columns D, E, and F

(e)    None of these

Ans : (b)

17. To enter worksheet titles across a range of cell, you must :

(a)    Select the cells containing the title text and use the fill handle to center the text across a range of cells

(b)    Widen the columns

(c)     Select the cells containing the title text and use the fill handle to center the text across a range of cells

(d)    Widen the column

(e)    None of these

Ans : (a)

18. When integrating MS-Word and Excel, Word is usually the :

(a)    Server

(b)    Source

(c)     Client

(d)    All of these

(e)    None of these

Ans : (c)

19. 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)    Both (b) and (c)

(e)    None of these

Ans : (b)

20. The Name box :

(a)    Shows the location of the previously active cell

(b)    Appears the left of the formula bar

(c)     Appears below the status bar

(d)    Appears below the menu bar

(e)    None of these

Ans : (b)

21. How do you change column width to fit the contents?

(a)    Single-click the boundary to the left to the column heading

(b)    Double click the boundary to the right of the column heading

(c)     Press Alt and single click anywhere in the column

(d)    All of these

(e)    None of these

Ans : (b)

22. When you work with large worksheets, you may need to :

(a)    size the worksheet to fit on the specific number of pages

(b)    add and remove page breaks

(c)     specify only certain print areas

(d)    all of these

(e)    None of these

Ans : (d)

23. Hyperlinks cannot be :

(a)    Special shapes like stars and banners

(b)    Drawing objects like rectangles ovals

(c)     Pictures

(d)    All can be hyperlinks

(e)    None of these

Ans : (d)

24. You can use the horizontal and vertical scroll bars to :

(a)    Split a worksheet into two panes

(b)    View different rows and columns

(c)     Edit the contents of a cell

(d)    View different worksheets

(e)    None of these

Ans : (b)

25. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

(a)    Spreadsheet program

(b)    Database program

(c)     Word processor program

(d)    Desktop publisher program

(e)    None of these

Ans : (a)

General Computer Test - 74

 

1. Which of the following is the second step in creating a macro?

(a)    Start recording

(b)    Using your mouse or keyboard, perform the task you want to automate

(c)     Assign a keyboard shortcut to the macro

(d)    Give the macro a name

(e)    None of these

Ans : (c)

2. The spelling tool is placed on………….

(a)    Standard

(b)    Formatting

(c)     Drawing

(d)    Reviewing

(e)    None of these

Ans : (a)

3. If you need a text to show vertically in a cell. How will you achieve this?

(a)    Choose Vertical on Text alignment in Format Cells dialog box

(b)    Choose 90 Degrees in Orientation of Format Cells dialog box

(c)     Choose Distributed from the Vertical drop down list of Format Cells dialog box

(d)    Choose Center across Selection from Horizontal combo box in Format Cells dialog box

(e)    None of these

Ans : (b)

4. Can you set 0.5 inch left indentation for a cell in Excel?

(a)    Excel does not have indentation feature

(b)    You can specify indentation only if you turn the rulers on

(c)     Indentation can be set from Format Cells dialog box

(d)    The indentation can be specified only when printing

(e)    None of these

Ans : (c)

5. You can automatically adjust the size of text in a cell if they do not fit in width by :

(a)    Double clicking on the right border of column header

(b)    From Format choose Columns and then Auto fit selection

(c)     From Format Cells dialog box mark shrink to fit check box

(d)    All of these

(e)    None of these

Ans : (c)

6. Formatting a cell in Currency, you can specify

(a)    Decimal Places

(b)    Currency Symbol

(c)     Country name

(d)    Both (a) and (b)

(e)    None of these

Ans : (d)

7. Formatting a cell in Number format you can’t set

(a)    Decimal Places

(b)    Use 1000 separator

(c)     Negative numbers

(d)    Currency Symbol

(e)    None of these

Ans : (d)

8. What is entered by the function = today ( ) ?

(a)    The date value for the day according to system clock

(b)    The time value according to system clock

(c)     Today’s date as Text format

(d)    All of these

(e)    None of these

Ans : (a)

9. Which function will you use to enter current time in a worksheet cell?

(a)    = today( )

(b)    = now ( )

(c)     = time ( )

(d)    = current Time ( )

(e)    None of these

Ans : (b)

10. Special category of Number tab in Format cells dialog box can be used to apply formats like :

(a)    Zip Code

(b)    Phone Number

(c)     Postal Address

(d)    Both (a) and (b)

(e)    None of these

Ans : (d)

11. Merge cells option can be applied from :

(a)    Format Cells dialog box Alignment Tab

(b)    Formatting toolbar

(c)     Formatting Cells

(d)    All of these

(e)    None of these

Ans : (a)

12. Pre-mde sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from:

(a)    from Format > Cells

(b)    from Format > Auto format

(c)     from Table > Auto format

(d)    All of these

(e)    None of these

Ans : (b)

13. Which of the following format you can decide to apply or not in AutoFormat dialog box?

(a)    Number format

(b)    Border format

(c)     Font format

(d)    All of these

(e)    None of these

Ans : (d)

14. How can you remove borders applied in cells?

(a)    Choose None on Border tab of Format cells

(b)    Open the list on Border tool in Formatting toolbar then choose first tool (no border)

(c)     Choose remove on Border tab of Format cells

(d)    Both (a) and (b)

(e)    None of these

Ans : (d)

15. Where can you set the shedding color for a range of cells in Excel?

(a)    Choose required color form Patterns tab of Format Cells dialog box

(b)    Choose required color on Fill color tool in Formatting toolbar

(c)     Choose required color on Fill Color tool in Drawing toolbar

(d)    All of these

(e)    None of these

Ans : (d)

16. You can set Page Border in Excel from:

(a)    From Border tab in Format Cells dialog box

(b)    From Border tool in Formatting toolbar

(c)     From Line Style tool in Drawing toolbar

(d)    You cannot set page border in Excel

(e)    None of these

Ans : (d)

17. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply :

(a)    use = if ( ) function to format the required numbers red

(b)    Apply Conditional Formatting Command on Format Menu

(c)     Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

(d)    All of these

(e)    None of these

Ans : (b)

18. You can check the conditions against…….. when applying conditional formatting :

(a)    Cell value

(b)    Formula

(c)     Alignment

(d)    Both (a) and (b)

(e)    None of these

Ans : (d)

19. Which of the following is not true regarding Conditional Formatting?

(a)    You can add more than one condition to check

(b)    You can set condition to look for Bold and apply Italics on them.

(c)     You can apply Font, border and pattern formats that meets the specified conditions

(d)    You can delete any condition from Conditional Formatting dialog box if it is not required

(e)    None of these

Ans : (b)

20. Which of the following is invalid statement?

(a)    Sheet tabs can be colored

(b)  Some picture   can be applied as a background of a sheet

(b)    You can set the column width automatically fit the amount of text

(c)     The width of a row and be specified manually or fit automatically

(d)    None of these

Ans : (d)

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

(a)    Hyperlink

(b)    Index

(c)     Transpose

(d)    Rows

(e)    None of these

Ans : (c)

22. When you insert an Excel file into a word document, the data are :

(a)    Hyperlinked

(b)    Placed in a word table

(c)     Linked

(d)    Embedded

(e)    None of these

Ans : (d)

23. Except for the……….function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result :

(a)    IF

(b)    AND

(c)     OR

(d)    NOT

(e)    None of these

Ans : (a)

24. Macros are “run” or executed from the …………..menu.

(a)    Insert

(b)    Format

(c)     Tools

(d)    Data

(e)    None of these

Ans : (c)

25. You can open the consolidate dialog box byt choosing consolidate from the…….menu.

(a)    Insert

(b)    Format

(c)     Tools

(d)    Data

(e)    None of these

Ans : (d)