1. To change the name of a sheet tab, ________ on the tab and type in the new name then press Enter.
A. press Shift + click B. double-click C. click D. press Ctrl + click E. None of above
2 2. Use the ________ dialog box to insert a footer on a chart sheet.
A. Print Preview B. Insert C. Page Format D. Page Setup E. None of above
3 3. The ________ is the target destination for data that has been cut or copied using the Office Clipboard.
A. add content area B. paste area C. insert field area D. copy area E. None of above
4 4. When cells are selected and the Copy or Cut command is performed on them, the data is placed on the:
A. Format Painter. B. Insert dialog box. C. Office Clipboard. D. Copy table. E. None of above
5 5. A ________ will display to indicate a cell contains an error message.
A. moving border around the cell B. blue outline around the cell C. green triangle in the upper left corner of the cell D. red square in the lower right corner of the cell E. None of above
True / False:
1 1. Each worksheet in a workbook must have the same header and footer.
2 2. Make sure to save all changes before exiting Excel because you will NOT be prompted to save any changes made to the worksheet.
3 3. If you make changes to numbers used within a formula, Excel will automatically re-calculate the value.
4 4. When you save a workbook, each worksheet will have a different file name.
5 5. You can insert the SUM function from the Math & Trig button.
This is excel btw... will rep
Thread: Misc need help please
10-27-2009, 12:17 PM #1
Misc need help please
10-27-2009, 12:20 PM #2
10-27-2009, 12:21 PM #3
10-27-2009, 12:23 PM #4
10-27-2009, 12:25 PM #5
10-27-2009, 12:27 PM #6
10-27-2009, 12:29 PM #7
1 This bar displays entries as they are made and edited in the Excel workbook window.
2 Which of the following would result from setting a cell's number style to Comma ?
3 Which of the following is NOT an element of a pie chart?
4 If the formula =A1+B1, which of the following is the operator?
5 Row and column _____ are entries that are used to create the structure of the worksheet and describe other worksheet entries.
6 The intersection of a row and a column is referred to as a(n):
7 To save an existing file with a new name, what command should you use?
8 When you point to different areas in the chart, __________ identifies the chart element that will be affected by your action.
the Mini toolbar
a context menu
the status bar
9 This view shows you how the worksheet will appear when printed.
Page Break Preview
10 The black box in the lower-right corner of a selection that is used to copy cells is called the:
11 Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2?
12 You can jump directly to a cell by typing its reference in the __________ .
13 You can automatically resize the column to fit the width of the column's contents by ____ on the column boundary line.
14 When a column is not wide enough to display a result or a negative date or time is used, what will display?
15 You can show more or less of a worksheet by using:
16 To select nonadjacent cells or cell ranges, hold down this key after selecting the first cell or range while selecting each additional range:
17 When saving a file, you can specify the kind of file to save using _____.
Save as type
18 The place where one printed page ends and the next begins is called what?
19 Charts that are inserted into a worksheet are _____ objects.
20 The eight squares and circles that surround a selected picture are called:
21 What is a visual representation of data used to convey information in an easy-to-understand and attractive manner called?
22 You can display different sections of a worksheet at the same time by creating:
23 Which of the following functions is written in the correct syntax?
24 A pie chart is limited to how many data series?
25 Which type of chart organizes categories horizontally and values vertically to emphasize variation over time?
26 Which of the following is not an example of formatting?
27 What is used to change the appearance of a range of cells based on their value?
28 Which reference would display the entry in cell A4 of Sheet3 in the active cell of the current sheet?
29 The function that calculates the arithmetic average of a range of values is:
30 Combining two or more cells creates a:
10-27-2009, 12:32 PM #8
10-27-2009, 12:33 PM #9
10-27-2009, 12:39 PM #10
10-27-2009, 12:41 PM #11
10-27-2009, 12:43 PM #12
10-27-2009, 01:00 PM #13
10-27-2009, 01:02 PM #14
By jonnymontag in forum Misc.Replies: 9Last Post: 10-27-2009, 01:11 PM
By dave.mc in forum Misc.Replies: 16Last Post: 07-23-2009, 03:10 PM
By elinas in forum Misc.Replies: 7Last Post: 02-16-2009, 07:56 PM
By raventaz13 in forum ExercisesReplies: 5Last Post: 02-22-2002, 01:53 AM
By KevinB123 in forum Teen BodybuildingReplies: 23Last Post: 12-01-2001, 02:56 AM