Shared Flashcard Set

Details

ElizabethM
Excel Project 1 Study Guide
30
Other
Not Applicable
01/24/2007

Additional Other Flashcards

 


 

Cards

Term
1.At any point while working with an Excel worksheet, a task pane can be opened or closed by clicking the Task pane command on the _____.
Definition
b.View menu
Term
2.The active cell can be identified in all of the following ways except _____.
Definition
d.a block arrow displays in the center of the cell
Term
3.When both the Standard toolbar and Formatting toolbar display on the same row, all of the buttons on either toolbar can be displayed by _____.
Definition
c.double-clicking the move handle on the left of each toolbar
Term
4.When the Language bar is _____, it means it is displayed on the Windows taskbar.
Definition
c.minimized
Term
5.The easiest way to select a cell (make it active) is to _____.
Definition
d.use the mouse to move the block plus sign to the cell and then click
Term
6.To complete an entry into a cell, click the _____.
Definition
a.Enter box
Term
7.In Excel, a number can contain the characters _____.
Definition
0 1 2 3 4 5 6 7 8 9 . + - ( ) , /
. $ % E e
d. all of the above
Term
8.When proposing a range of cells to sum using the SUM button, Excel first looks for a range of cells with numbers _____.
Definition
b.above the active cell and then to the left
Term
9.The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
Definition
b.fill handle
Term
10.When one range is copied to another, Excel displays the _____ that can be used to choose whether to copy the value with formatting, without formatting, or only copy the format.
Definition
c.Auto Fill Options button
Term
11.The _____ defines the appearance and shape of letters, numbers, and special characters.
Definition
a.font type
Term
12.A character with a point size of 10 is about _____ of an inch in height
Definition
c.10/72
Term
13.To display the AutoFormat dialog box shown in the accompanying figure and format a range automatically, use the AutoFormat command on the _____.
Definition
c.Format menu
Term
14.In the AutoFormat dialog box shown in the accompanying figure, the Close button or the _____ terminates the current activity and closes the AutoFormat dialog box.
Definition
a.Cancel button
Term
15.In the AutoFormat dialog box shown in the accompanying figure, the _____ allows additional formats, such as fonts or borders, to be deselected within an autoformat.
Definition
d.Options button
Term
16.The small _____ at the corners and along the sides of the rectangle that encloses an embedded chart indicate the chart is selected.
Definition
a.sizing handles
Term
17.The small box to the right of an embedded column chart contains the legend, which _____.
Definition
b.identifies the colors assigned to each bar in the chart
Term
18.When Excel is installed on a computer, the default chart type is the 2-D (two-dimensional) _____.
Definition
b.Column chart
Term
19.When you click the Tools button in the Save As dialog box, the _____ in the list that displays allows you to save a backup copy of the workbook, create a password to limit access to the workbook to be created, and carry out other functions.
Definition
d.General Options command
Term
20.A password entered in the Save As dialog box is _____ and can be up to 15 characters long.
Definition
c.case-sensitive
Term
21.The _____ can be used to quit Excel
Definition
c.Close button and Control-menu icon on the title bar
Term
22.Clicking None at the top of the AutoCalculate shortcut menu _____.
Definition
a.turns off the AutoCalculate area
Term
23.When a cell containing an error is double-clicked, Excel switches to _____, the active cell contents display in the formula bar, and a flashing insertion point displays in the active cell.
Definition
b.Edit mode
Term
24.Excel provides the Undo command on the _____ and the Undo button on the Standard toolbar, both of which can be used to erase the most recent cell entries.
Definition
a.Edit menu
Term
25.To clear an entire worksheet, click the _____ and then press the DELETE key.
Definition
d.Select All button on the worksheet or press CTRL+A
Term
1._________________________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from We
Definition
Microsoft Office Excel
Term
2.When Excel starts, a(n) _________________________, which is a separate window that enables users to carry out some Excel tasks more efficiently, displays on the screen.
Definition
Task Pain
Term
3.A new blank _________________________ called Book1, such as that illustrated in the accompanying figure, is like a notebook and is created when Excel starts.
Definition
woork book
Term
4.Inside a workbook, such as that shown in the accompanying figure, are _________________________ each of which has a name that displays on a sheet tab at the bottom of the workbook.
Definition
worksheet
Term
5.The intersection of a row and column in the worksheet in the accompanying figure is a(n) _________________________, which is the basic unit into which data is entered.
Definition
cell
Supporting users have an ad free experience!