Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
BCIS - Excel 2007
Excel End of Exam Review
| Question | Answer |
|---|---|
| In Excel worksheets, rows are designated using _____________ while columns are designated using letters. | numbers |
| The intersection of a column and a row is called a ________________. | cell |
| Be default, Excel aligns all text to the _________________ when they are first entered into cells. | left |
| Be default, Excel aligns all numbers to the __________ when they are first entered into cells. | right |
| If you change the contents of a cell that is included in a formula, the resulting values from that formula will _______________ be recalculated. | automatically |
| When you click in a cell, it becomes the ______________ cell. | active |
| The spell check feature does not remove the need to ______________ a worksheet. | proofread |
| By default, columns are all the same ____________and rows are all the same height. | width |
| To fill adjacent cells with the same data or consecutive data, use the _____________ at the bottom left corner of the active cell. | fill handle |
| When Excel calculates averages, blank cells or cells containing text are ___________________. | ignored |
| You can insert ______________ such as lines, basic shapes, and block arrows into a orksheet. | shapes |
| In the Page Setup dialog box, you can choose to center a worksheet horizontally and _____________on the page. | vertically |
| To center a title over the spreadsheet width, use the ______________________ feature. | Merge and Center |
| Headers and Footers do not show up in the worksheet area; to see them you have to use ________________ or print the worksheet. | print preview |
| A new workbook will initially contain only ____________ worksheets; more can be added later if needed. | three |
| If you copy data to cells already containing data, the existing data will _____________and the copied data will be added to it. | overwritten |
| A formula with a ________________ reference is used to consolidate data from several worksheets into one worksheet, i.e. a Summary. | 3-D |
| The selected cells being cut or copied are called the ____________________. | source |
| Use the ____________________ to “squeeze” the worksheet down to one page. | Fit to One Page |
| A group of cells that are adjacent in a worksheet is called a ___________ | range |
| In Excel the AutoComplete feature does which of the following? | completes text entries if the first few letters match another entry in the column |
| If you key Sun (for Sunday) in cell C4 and then use the fill handle to place data into cell C5, what will be the resulting entry in cell C5? | Mon |
| If you key Sun (for Sunday) in cell B2, click the Copy button, move to cell B3, and then click the Paste button, what will be the resulting entry in cell B3? | Sun |
| All formulas in an Excel worksheet must begin with this symbol. | = |
| When several consecutive cells are to be used in the calculation of a formula, such as the SUM function, this set of cells is usually referred to as a(n) _______ of cells. | range |
| A group of worksheets in the same file is called a | workbook |
| The arithmetic mean of a range of cells is found by using which function? | AVERAGE |
| If you create a custom header or footer for a worksheet, where can items be placed? | on the left side, left aligned; in the center, centered; or on the right side of the page, right aligned |
| What is the first step that should be taken when creating a chart? | selecting the range of cells that contain the data the chart will use |
| New worksheets are inserted | to the left of the active worksheet |
| Double-clicking a sheet tab will allow you to? | rename the sheet |
| To move a worksheet to a different position | click and drag the sheet tab to the new location |
| When the Format Painter is used what will be copied from one cell to another | fonts |
| Time saving preformatted worksheets used for purposes such as Timecards or Balance Sheets are called | templates |
| Predefined formatting attributes such as “Good, Bad and Neutral” or “Titles & Headings” that can be applied to a cell or cells are called | styles |
| __________format applies a $, comma in the thousands, and two decimal places to each value | Accounting |
| What are the two choices given in the Chart Location dialog box? | As new sheet and As object in |
| If you need to go to cell A1 from anywhere in a worksheet with a single action press these keys | Ctrl + Home |
| The find and Replace dialog box can be used to search for and replace | text, numbers, and formats |
| You can group multiple nonadjacent worksheets by holding down the _____ key while clicking each tab. | Ctrl |
| Which of the following is not one of the options in the “Print What” section of the print dialog box? | Page range |
Created by:
Dawn McCain
Popular Computers sets