Intro-Chapter 5
List two ways a graphic can be added to a worksheet.
1- Click INSERT- Pictures to display the Insert Picture dialog box with a list of saved graphic files 2- Click INSERT- Online Pictures to insert a picture from an online source
Describe one way to copy the values stored in cells A1, A2, and A3 to cells T1, T2, and T3.
1- Select the range to be duplicated 2-Click home and then copy 3-Select the upper-left cell of the range where the data is to be pasted 4-Click home and then paste
Explain what a formula is and give two examples
A formula is a mathematical statement used to calculate values. For example, =5+3
What is a template?
A master file that includes the basic formatting and elements for a particular style of document, workbook, presentation or publication.
What is a range?
A selection of two or more cells
Give an example of a cell reference?
A12 B6
If 10/20 is entered into a cell, Excel considers it a label. How must the entry be changed so that 10 will be divided by 20?
An equal sign would have to be added to the start of the formula.
What is a circular reference?
An error that occurs when a formula references the cell it is stored in
What is a cell?
An intersection of a row and a column.
Give an example of a worksheet that would be best saved as a template.
An invoice
How can the order of operations within a formula be changed?
By adding parentheses
List two ways to change which cell is active
By clicking it manually or using the arrow keys.
What are two ways to change the width of a column?
By double clicking the cell border or moving it manually
Where can a description of an invalid formula error be found?
Click The error checking button
List the steps to size a graphic.
Click a graphic to select it and display handles: Point to a corner handleand then drag to size the graphic.
List the steps required to move the contents of cell B4 into cell A9.
Click the range to be moved Click Home and then Cut Select the upper-left cell of the range where the data is to be placed Click Home and then Paste
Which numeric format has been applied for 120,450.00?
Comma
Which numeric format has been applied for $12.50?
Currency
List three example uses for a spreadsheet application.
Data collection, personal budget, cost calculations
List two ways to select the range B3 through C12
Drag the pointer from cell B3 to cell C12 or select cell B3, hold down the Shift key, and then select cell C12.
Which specific order of operations does Excel use to evaluate a mathematical expression?
Exponents, multiplication and division, addition and subtraction. (EMDAS)
T/F A cell reference consists of a column letter only.
False, it also contains the row number.
T/F Excel automatically checks the spelling of a worksheet.
False. Click Review>Spelling to check the spelling of text in a worksheet
T/F The Metro theme is applied by default to a new workbook.
False. The office theme is applied by default
T/F The Accounting and Currency formats are the same.
False. They are both different.
T/F The width of just a single cell can be changed
False. You can change the width of any cell you choose.
T/F Cell references must be typed in capital letters.
False; Cell references can be typed in upper, lower, or mixed case.
T/F Headers are visible in Normal view.
False; Headers are visible in Page Layout View.
How can a cell be formatted so that =10/20 will appear in the cell?
Formatted as text
Which numeric format has been applied for 1/2?
Fraction
Where are headers and footers printed?
Headers are printed at the top and footers are printed at the bottom of each worksheet page.
Describe two conditional formats that can be applied to a range of cells
Home> conditional formatting> Top/Bottom Rules includes options such as highlighting the Top 10 Items, Bottom 10%, and Below Average values. For example, the Below Average rule was applied to cells B3 through B8 Home> Conditional Formatting> Data Bars illustrate the value of a cell relative to other cells. The bar length is scaled between the lowest and highest values in the specified range.
If a cell contains the wrong data, how can it be corrected?
If a cell contains the wrong data, select the cell, edit the data on the formula bar, and then press the enter key.
What does the formula bar display?
It displays the active cell's contents.
What does the name box display?
It displays the cell reference of the active cell at the top of the worksheet
How are individual columns identified on a worksheet?
Letters
List two ways to adjust cells that contain long column headings?
Long column headings can be adjusted by wrapping text or changing the text orientation.
How are individual rows identified on a worksheet?
Numbers
How many worksheets does a new workbook contain?
One worksheet
Which view displays a worksheet as a printed page?
Page Layout view displays a worksheet as a printed page.
Which numeric format has been applied for 23%?
Percentage, 0 decimals
What is usually the best method for entering cell references in a formula? Why?
Pointing is the best method for entering cell references into a formula because typing errors are avoided
Which numeric format has been applied for 1.20E+05?
Scientific
When does a cell display ####?
The ### appears when a cell isn't wide enough to display the formatted number.
What button selects the entire worksheet?
The Select All button selects the entire worksheet.
After selecting a cell and typing data, what happens when you press the enter key?
The cell below is selected
After selecting a cell and typing data, what happens when you press the tab key?
The cell to the right is selected
After selecting a cell and typing data, what happens when you press the escape key?
The data that was entered in the cell is erased
What button is displayed when a cell with an error value is selected?
The error checking button
After selecting a cell and typing data, what happens when you click enter✅?
The next cell is selected
Give one reason why a worksheet should be previewed before printing.
To check the margins
How can the formulas stored in the cells of a worksheet be displayed instead of the values they calculate?
To display the formulas stored in cells, press Ctrl+` (grave accent) or click FORMULAS → Show Formulas
T/F A cell can contain only one line of text.
True
T/F A graphic can be recolored in Excel.
True
T/F A range can consist of non-adjacent cells.
True
T/F An open workbook can be attached to an email message from Excel.
True
T/F Selected cell and active cell mean the same thing.
True
T/F The character style Underline should be used sparingly because it could be confused with a hyperlink.
True
T/F The contents of the active cell are displayed in the name box.
True
T/F The length of a Data Bar depends on the value in the cell relative to other cells.
True
T/F There are over a million rows on a worksheet.
True
What is an excel file called?
Workbook
Is it possible to copy and paste a table of data from a Word document to an Excel worksheet? If so, how will the data be organized in the worksheet?
Yes. To copy and paste selected cells from a worksheet to a Word Document, click HOME- copy, display the Word Document , place the insertion point where the data is to appear, and then click HOME- paste
What is a relative cell reference?
cell references that reflect the row or column they have been copied to are called relative cell references.
What is displayed in a cell if an invalid formula is entered?
displays an error value and a green triangle in the upper left corner of a cell.
When worksheet data is needed in a Word document, would it be best to retype the data into the document or copy and paste the data from the worksheet? Why?
it would be better to copy and paste the data directly because if you retype it there could be errors.
What key is pressed to remove the dashed border from the source cells once the cells have been pasted?
press the Esc key to remove the dashed border