Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
50 Cards in this Set
- Front
- Back
|
Excel is an electronic version of a(n) ____.
|
Speadsheet
|
|
|
Excel stores its documents as files called ____.
|
Books
|
|
|
By default, an Excel workbook is made up of ____ worksheets.
|
3
|
|
|
Row headings identify each row using a different ____.
|
Number
|
|
|
The intersection of a row and column is known as a ____.
|
Cell
|
|
|
To go to column A of the current row, click ____.
|
Home
|
|
|
To make A1 the active cell, press which of the following keys?
|
Control+Home
|
|
|
The active cell has a ____ border.
|
Thick
|
|
|
To complete a cell entry, press the ____ key.
|
Enter
|
|
|
The characters +, -, *, and / are examples of ____.
|
Arithmetic Operators
|
|
|
The expression used to calculate values displayed in a worksheet is called a(n) ____.
|
Formula
|
|
|
An Excel formula always begins with a(n) ____.
|
Equals Sign
|
|
|
The formula used to multiply cell A1 by cell C1 is ____.
|
=A1*C1
|
|
|
To divide the value of a cell by some number, use the ____ operator.
|
/
|
|
|
The contents of the active cell shown as item 2 in the figure above can also be seen in the ____.
|
Formula Bar
|
|
|
Which describes the nonadjacent range shown in the figure above?
|
Which describes the nonadjacent range shown in the figure above?
|
|
|
To select a nonadjacent range, select an adjacent range, press and hold ____ and then select other adjacent ranges.
|
Control
|
|
|
To select a large range of cells, click the first cell in the range, press and hold ____, and then click the last cell in the range.
|
Shift
|
|
|
To insert a new column, select a column, then click the Insert button in the ____ group on the Home tab.
|
Cells
|
|
|
What is the result of the expression =50/(10*5)?
|
1
|
|
|
To change the order of operations, enclose part of the formula in ____.
|
Parenthesis
|
|
|
The Undo and Redo buttons are found on the ____.
|
Quick Access Tool Bar
|
|
|
In ____ orientation, a page is taller than it is wide.
|
Portrait
|
|
|
Put the following steps for entering multiple lines of text within a cell in the proper order:
1. Press and hold the Alt key, and then press the Enter key to move the insertion point to a new line within the cell, enter the next line of text. 2. Press the Alt + Enter keys for each new line of text you need to enter within the cell. 3. Click the cell in which you want to enter the text. 4. Enter the line of text. |
3,4,1,2
|
|
|
What type of operation does the formula “C9/B10” use?
|
Division
|
|
|
Which of the following will not change the location of the active cell?
|
Scrolling
|
|
|
What is the syntax for a SUM formula adding the values of Cell F6 to F9?
|
=SUM(F6:F9)
|
|
|
Ctrl + G is used to access the ____.
|
The Go-To Dialogue Box
|
|
|
mm/dd/yyyy is known as ____.
|
A Date format
|
|
|
Item 2 and Item 3 in the figure above display the same contents. Why?
|
Because cell H6 is the active cell and it contains a formula
|
|
|
In order for cell H6 to show a value, rather than a formula in the figure above, what needs to happen?
|
The Enter key must be pressed
|
|
|
How would you define the formula shown in the figure above?
|
The number of DVDs ordered multiplied by the price per DVD
|
|
|
Case 2
Sam is a distributor of ceramics. He uses Excel 2007 to record his inventory and order forms. Sam’s worksheet for his company’s monthly orders needs to display summary information including total number of items ordered, and the amount of revenue generated from those orders. First Sam will add the number of orders. He chooses to use the ____ function from the AutoSum feature |
SUM
|
|
|
Case 2
Sam is a distributor of ceramics. He uses Excel 2007 to record his inventory and order forms. Sam’s worksheet for his company’s monthly orders needs to display summary information including total number of items ordered, and the amount of revenue generated from those orders. Sam decides to rename his worksheet “Sam’s Ceramic Business Worksheet” but he is unable to complete the word Worksheet because ____. |
Excel only allows for 31 characters in a sheet name
|
|
|
Case 2
Sam is a distributor of ceramics. He uses Excel 2007 to record his inventory and order forms. Sam’s worksheet for his company’s monthly orders needs to display summary information including total number of items ordered, and the amount of revenue generated from those orders. Sam wants to now find out how much money he will make on his largest order, which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the price per item. An appropriate formula would be ____. |
=E4*E5
|
|
|
In the figure above, Item 1 points to the ____.
|
Font Arrow
|
|
|
In the above figure, the ____ indicates the font is 11pt.
|
Font size arrow
|
|
|
You can create a ____ color by specifying a mixture of red, blue, and green color values.
|
Custom
|
|
|
By default, values appear in the ____ and generally display numbers exactly as you type them.
|
General Number Format
|
|
|
As a general rule, you should ____.
|
center column titles, left-align text, and right-align numbers
|
|
|
Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.
|
Orientation
|
|
|
In the above figure, you can choose a border line style from the area indicated by Item ____.
|
2
|
|
|
Item 3 in the figure above shows green as the selected background ____ for the cells.
|
Color
|
|
|
To see a preview of the selected border style, look to the area indicated by Item ____ in the above figure.
|
6
|
|
|
The bottom border of the selected cells is indicated by Item ____ in the above figure
|
7
|
|
|
Item 5 in the above figure adds ____.
|
Lines within the cell range
|
|
|
If you don’t want to add any lines around the cell or range, click the button indicated by Item ____ in the above figure.
|
4
|
|
|
A ____ sheet is a worksheet that provides information about the content and purpose of the workbook.
|
One of:
A)Glossary B)Documentation C)Precedence D)Planning Analysis **UNSURE OF WHICH ONE** |
|
|
____ makes it easier to enter repetitive text in cells.
|
One of:
A)Editing Mode B)AutoFill C)AutoComplete D)AutoFit **UNSURE OF WHICH ONE** **Not D or A** |
|
|
Cutting a selection sends it to the ____ until you paste it.
|
One of:
A)Sheet1 B)Clipboard C)Active Cell D)Formula Bar **UNSURE OF WHICH ONE** **Not A** |
