A33a

1) Getting data from a cell located in a different sheet is called A. Accessing B. Referencing C. Updating D. Functioning 2) The default header for a worksheet is A. Your name B. The date and time C. None D. The sheet tab name 3) Excel worksheet cells work very similarly to what common element of the windows graphical user interface. A. Option buttons B. List boxes C. Text boxes D. Combo boxes 4) Which element of a worksheet can be protected from accidental modification. A. Contents B. Objects C. Scenarios D. All of the above 5) You can zoom a worksheet A. With the zoom command on the view menu B. With the mouse pointer in print preview C. With the zoom button on the print preview toolbar D. All of the above 6) If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you A. Press the Erase key B. Press the Esc key C. Press Enter button D. Press the Edit Formula button 7) Which of the following not a valid data type in Excel .. A. ...

1) A cell contain up to .. A. 56400 character B. 32000 character C. 45000 character D. None of the above 2) To hold down column titles in place so that they do not scroll when you scroll a worksheet click the A. Unfreeze panes command on the window menu B. Freeze panes command on the window menu C. Hold titles command in the edit menu D. Split command on the window menu 3) You want to track the progress of the stock market on a daily basis which type of chart should you use? A. Pie chart B. Row chart C. Line chart D. Column chart 4) When a formatted number does not fit in a cell, number signs A. ### B. #Div/0! C. #div@ D. All of the above 5) It is acceptable to let long text flow into adjacent cell on a worksheet when A. Data will be entered in the adjacent cells B. No data will be entered in the adjacent cells C. There is no suitable abbreviation for the text D. There is not time to format the text 6) Which is used to perform what if analysis? A. Solver B. Goal seek C. Scenario Manage...

1) You can hyper-links from an Excel Workbook to A. A web page on company Internet B. A web page on the Internet C. Other office application documents D. All of the above 2) To activate the previous cell in a preselected range, press A. The alt key B. The tab key C. The enter key D. None of the above 3) Using the F11 short cut key to crate a chart on a chart sheet creates A. A default chart B. A 2-dimentional column chart C. A 2-dimentional bar chart D. A 3-dimentional line chart 4) 3-D reference in a formula .. A. Can not be modified B. Only appears on summary worksheet C. Limits the formatting options D. Spans worksheets 5) You can select single range of cell by A. Clicking the upper left cell in a group of cells and then pressing the shift key while clicking the lower right cell in a group of cells. B. Pressing the Ctrl key while dragging over the desired cells C. Press the shift key and arrows key D. Dragging over the desired cells 6) When you group worksheets A. You can enter vari...

1) You can insert lebels for A. All the data makers on a chart B. A data series C. A selected data marker D. All of the above 2) Which of the following is not a basic step in creating a worksheet ? A. Save the workbook B. Modify the worksheet C. Enter text and data D. Copy the worksheet 3) Data can be arranged in a worksheet in an easy to understand manner using A. Auto Formatting B. Applying Styles C. Changing fonts D. All of these 4) Chart tips can A. Show the formatting of data lebel B. Show the name of a data series C. Show the value of data point D. Both B and C 5) Tab scrolling buttons .. A. Allow you to view different worksheet B. Allow you to view additional worksheet rows down C. Allow you to view additional worksheet columns to the right D. Allow you to view additional sheet tabs 6) Which area in an excel window allows entering values and formulas A. Title bar B. Menu bar C. Formula bar D. Standard tool bar 7) A data map is helpful A. When you have too much data to chart B. T...

1) You can convert existing Ms Excel Worksheet data and chart to on HTML document by using the .. A. FTP Wizard B. Internet Assistant Wizard C. Internet Wizard D. Import Wizard 2) Which of the following methods cannot be used to edit the contents of a cell? A. Pressing an arrow key B. Clicking the formula bar C. Pressing the F2 key D. Clicking on the formula bar 3) A typical worksheet has .......... number of columns. A. 128 B. 256 C. 512 D. 1024 4) When integrating Ms Word and Excel Word is usually the .. A. Server B. Source C. Client D. None of the above 5) Comments put in cells are called .. A. Smart tip B. Cell tip C. Web tip D. Soft tip 6) You can use the horizontal and vertical scroll bars to .. A. Split a worksheet into two panes B. View different rows and columns edit the contents of a cell C. Edit the contents of a cell D. View different worksheets 7) Hyperlink cannot be A. Special shapes like stars and banners B. Drawing objects like rectangles or ovals C. Pictures D. All of ...

1) Which of the following best describes detect and repair? A. A command on the help menu that detects malfunctioning hardware B. A command on the tools menu that detects missing or damaged files and repairs them C. A command on the help menu that detects missing or damaged files and repairs them D. None of the above 2) The select a whole sentence at once .. A. Hold down shift, and click the sentence B. Hold down ctrl, and click the sentence C. Click anywhere on the sentence, and then press ctrl D. Double click the sentence 3) To add a page number into a document header A. On the file menu, click page number B. Right click the header, and click page number on the shortcut menu C. On the insert menu, click page number D. None of the above 4) Small Business tools can help you .. A. Draft a business plan B. Track Interaction with customers C. Produce mass direct mailings D. All of the above 5) To insert Auto text into a document you'd type the auto text entry and .. A. Press enter B. ...

1) The cropping button is available in the ... A. Standard toolbar B. Picture toolbar C. Border & Table toolbar D. Drawing Toolbar 2) In office programs, personalized menu automatically A. Promote frequently used menu commands B. Demote infrequently used menu command C. Expand to revel more command D. All of the above 3) When you modify a standard, built-in office template, which of the following occurs? A. Nothing, because you are not allowed to modify buit-in templates B. A new document is created, based on the existing office template C. The template is saved separately from the default office template D. The office template is overwritten with you new, customized template 4) The shrink to fit allows you to .. A. Combine two document B. Adjust the text in page C. Highlight the text D. All of the above 5) Using office clipboard, you can .. A. Only store one item at a time in the clipboard B. Store up to 12 items at one time in the clipboard C. Use each item stored in the clipboar...