Microsoft Excel Multiple Choice Questions - Set 01 - ObjectiveBooks

Microsoft Excel Multiple Choice Questions - Set 01

Practice Test: Question Set - 01

1. The name box
    (A) Shows the location of the previously active cell
    (B) Appears to the left of the formula bar
    (C) Appears below the status bar
    (D) Appears below the menu bar

2. Hyperlinks can be
    (A) Text
    (B) Drawing objects
    (C) Pictures
    (D) All of above

3. To copy formatting from one area in a worksheet and apply it to another area you would use:
    (A) The Edit > Copy Format and Edit > Paste Format commands form the menu
    (B) The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
    (C) There is no way to copy and apply formatting in Excel – You have to do it manually
    (D) The Format Painter button on the standard toolbar

4. To edit in an embedded excel worksheet object in a word document
    (A) Use the excel menu bar and toolbars inside the word application
    (B) Edit the hyperlink
    (C) Edit the data in a excel source application
    (D) Use the word menu bar and toolbars

5. You can copy data or formulas
    (A) With the copy, paste and cut commands on the edit menu
    (B) With commands on the shortcut menu
    (C) With buttons on the standard toolbars
    (D) All of the above

6. You can convert existing excel worksheet data an charts to an HTML document by using
    (A) FTP wizard
    (B) Internet assistant wizard
    (C) Intranet wizard Intranet wizard
    (D) Import wizard

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

8. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?
    (A) Select Format > Money from the menu
    (B) Click the Currency Style button on the formatting toolbar
    (C) You have to retype everything and manually add the dollar signs, commas, and decimals
    (D) None of these

9. Which of the following methods cannot be used to edit the contents of a cell?
    (A) Press the Alt key
    (B) Clicking the formula bar
    (C) Pressing the F2 key
    (D) Double clicking the cell

10. To save a workbook, you:
    (A) Click the save button on the standard toolbar from the menu
    (B) Press Ctrl + F5
    (C) Click Save on the Windows Start button
    (D) Select Edit>Save

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: