1. which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?
Workday
Date
Networkdays
All of above

2. Data marker on a chart are linked to data points in a worksheet therefore
You can automatically apply formatting to a data series
You can change the position of a data marker and automatically change the data point value in the worksheet
You can change a data print value and automatically are draw the chart
a and b

3. You can use the format painter multiple times before you turn it off by
You can use the format painter button only one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing Alt key and clicking the format painter button

4. The default header for a worksheet is
Your name
The date and time
None
The sheet tab name

5. To drag a selected range of data to another worksheet in the same workbook use the
Tab key
Alt key
Shift key
Ctrl key

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

7. to activate the previous cell in a pre-selected range press
the Alt key
the Tab key
the Enter key
none of above

8. When the formula bar is activated you can see
The Edit Formula button
The Cancel button
The Enter button
all of above

9. In a worksheet you can select
The entire worksheet
Rows
Columns
a b and c

10. when you print preview a worksheet
the entire worksheet is displayed
the selected range is displayed
the active portion of the worksheet is displayed
a b and c

11. You can group noncontiguous worksheets with
The group button on the standard toolbar
The shift key and the mouse
The ctrl key and mouse
The alt+enter key

12. Weight refers to
The print density of characters
The height of the printed character
Upright or slanted shape
The design and appearance of characters

13. 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 original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data

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

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

16. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Use Ctrl to select all three cells then click the paste button on the standard toolbar
Copy the selected cell then select the other two cells click style on the Format menu then click Modify
Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
all of above

17. To edit data in an embedded Excel worksheet object in a Word document
Use the Excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a Excel source application
Use the Word menu bar and toolbars

18. Status indicators are located on the
Vertical scroll bar
Horizontal scroll bar
Formula bar
Formatting toolbar

19. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
View
Insert
Format
Tools

20. You can open the Sort dialog box by choosing Sort from the ….. Menu
View
Format
Tools
Data

21. when working in the page break preview you can
view exactly where each page break occurs
add or remove page breaks
change the print area
all of above

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

23. Rounding errors can occur
When you use multiplication division or exponentiation in a formula
When you use addition and subtraction in a formula
Because Excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places than the calculated results

24. You can copy data or formulas
With the copy paste and cut commands on the edit menu
With commands on a shortcut menu
With buttons on the standard toolbar
All of above

25. You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
all of above

26. Which of the following setup options can not be set in the page setup dialog box?
Printer selection
Vertical or horizontal placement
Orientation
Row and column titles

27. What term refers to a specific set of values saved with the workbook?
Range
Scenario
Trend line
What-if analysis

28. Got functions? No? You need the insert function dialog box. How do you get it?
Right click a cell and then click insert
Click the insert menu and then click function
Type = in a cell
all of above

29. Which of the following describes how to select all the cells in a single column?
Right click on column and select Pick from list
Use data – text to columns menu item
Left click on the gray column title button
Pressing Ctrl + A on the keyboard

30. when you use the fill effects in the format data series dialog box you can not
rotate text on the chart
select a fore ground color
select a pattern
select a background color

31. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
Rows and columns
Headings
Speed
None

32. Which of the following is not a basic step in creating a worksheet?
Save the workbook
Modify the worksheet
Enter text and data
Copy the workshee

33. What’s a quick way to extend these numbers to a longer sequence for instance 1 through 20?
Select both cells and then drag the fill handle over the range you want for instance 18 more rows
Select the range you want include both cells point to fill on the Edit menu and then click down.
Copy the second cell click in the cell below it on the standard toolbar click the down arrow on the Paste button and then click Paste Special
all of above

34. To insert three columns between columns D and E you would
Select column D
Select column E
Select columns E F and G
Select columns D E and F.

35. 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
Select the cells containing the title text and click on Center button
Select the cells in range containing the title text and use the Merge and Center tool
Widen the colum

36. When integrating Ms-Word and Excel Word is usually the
Server
Source
Client
None

37. Charts tips can
Show the formatting of a data label
Show the name of a data series
Show the value of data point
b and c

38. The Name box
Shows the location of the previously active cell
Appears t the left of the formula bar
Appears below the status bar
Appears below the menu bar

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

40. when you work with large worksheets you may need to
size the worksheet to fit on the specific number of pages
add and remove page breaks
specify only certain print areas
All of above

41. Hyperlinks cannot be
Special shapes like stars and banners
Drawing objects like rectangles ovals
Pictures
All can be hyperlinks

42. You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns
Edit the contents of a cell
View different worksheets

43. 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.
Spreadsheet program
Database program
Word processor program
Desktop publisher program

44. You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Standard
Formatting
Drawing
Picture

45. What function displays row data in a column or column data in a row?
Hyperlink
Index
Transpose
Rows

46. When you insert an Excel file into a Word document the data are
Hyperlinked
Placed in a word table
Linked
Embedded