Study sets, textbooks, questions
Upgrade to remove ads
Chapter 5 Review Q's - Computer
Terms in this set (79)
List three example uses for a spreadsheet application.
Payroll, inventory, and personal budgets
What is an Excel file called?
How many worksheets does a new workbook contain
How are individual columns identified on a worksheet?
Individual columns are lettered from A to Z and then AA to XFD
How are individual rows identified on a worksheet
Individual rows are numbered from 1 to 1,048,576.
What is a cell?
A cell is the intersection of a row and column
Give an example of a cell reference
What does the name box display?
The name box displays the cell reference of the active cell.
What does the formula bar display?
The formula bar displays the active cell contents.
What are the three steps in the worksheet planning process
1. Determine what information the worksheet is to produce.
2. Determine the data to include.
3. Determine which data should be in rows and what data should be in columns.
After selecting a cell and typing data, what happens when you:
a) click Enter ?
The data is entered in the active cell.
press the Enter key?
The data is entered and the next cell in the column becomes the active cell
press the Tab key?
The data is entered and the next cell in the row becomes the active cellpress
press the Esc key?
Data entry is cancelled and the original contents of the active cell are restored
What are two ways to change the width of a column?
To change the width of a column, drag the column boundary to the right or double-click the right boundary of the column
List two ways to change which cell is active
Press the arrow keys to move to the cell or use the mouse to click a cell.
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 is displayed when in is clicked?
A list of the last actions performed is displayed.
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.
Which numeric format has been applied to each of the following?
When does a cell display ####?
a cell displays #### when the cell is not wide enough to display the formatted number
What is a range?
A range is a selection of two or more cells.
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
What button selects the entire worksheet?
The Select All button selects the entire worksheet.
What is a theme?
A theme is a predefined set of color, fonts, and effects used to format a worksheet
How is the formatting removed from a cell
To remove the formatting from a cell, click Home > Cell Styles > Normal or click Home > Clear > Clear Formats.
How can a theme be previewed?
A theme can be previewed by resting the pointer on a theme
Which view displays a worksheet as a printed page?
Page Layout view displays a worksheet as a printed page.
Give one reason why a worksheet should be previewed before printing.
nswers will vary. To check margins.
Where are headers and footers printed
Headers and footers are printed at the top and bottom of each worksheet page, respectively.
Explain what a formula is and give two examples.
A formula is a mathematical statement used to calculate values. =5+3 and =13/2.
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 added to start of the formula.
How can a cell be formatted so that =10/20 will appear in the cell?
A cell would have to be formatted as Text to have =10/20 appear in the cell.
Which specific order of operations does Excel use to evaluate a mathematical expression?
Exponentiation is performed first, multiplication and division next, and then addition and subtraction. Two operators of the same precedence are evaluated in order from left to right
How can the order of operations within a formula be changed?
The order of operations within a formula can be changed by adding parentheses
What is displayed in a cell if an invalid formula is entered?
A cell will display an error value and a green triangle in the upper-left corner of a cell if an invalid formula is entered.
What button is displayed when a cell with an error value is selected?
The Error Checking button is displayed when an error value is selected
Where can a description of an invalid formula error be found?
A description of an invalid formula can be found in the menu displayed when the Error Checking button is clicked
How can the formulas stored in the cells of a worksheet be displayed instead of the values they calculate
Press Ctrl+` or click Formulas > Show Formulas to display formulas instead of values
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
What is a circular reference?
A circular reference is an error that occurs when a formula references the cell it is stored in.
Describe one way to copy the values stored in cells A1, A2, and A3 to cells T1, T2, and T3.
Select cells A1 through A3, click Home > Copy, select cell T1, and click Home > Paste
List the steps required to move the contents of cell B4 into cell A9.
Select cell B4, click Home > Cut, select cell A9, and click Home > Paste.
What key is pressed to remove the dashed border from the source cells once the cells have been pasted?
The Esc key is pressed to remove the dashed border from the source cells.
What is a relative cell reference?
A relative cell reference is a cell reference that reflects the row or column it has been copied to.
What are the contents of cells D22 and E22 after copying cell C22, which stores the formula =C5 + C6, into cells D22 and E22?
The contents of cell D22 is =D5 + D6 and the contents of cell E22 is =E5 +E6.
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?
Rather than retype the data, which could introduce typing errors, the data should be copied and pasted directly into the document from the worksheet
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?
Information organized in a table in a Word document can be copied to an Excel worksheet. Pasted data is automatically arranged into rows and columns similar to the way it appeared in the Word document.
Describe two conditional formats that can be applied to a range of cells.
Answers will vary. Conditional formats include Data Bars and Top/Bottom Rules.
List two ways a graphic can be added to a worksheet
Two ways a graphic can be added to a worksheet are by clicking Insert > Picture and by clicking Insert > Clip Art.
Would a company logo likely be clip art? Explain.
Clip art is an image file with a general-purpose picture created by an artist using illustration software. Therefore, a company logo would most likely not be clip art
List two ways to enter a Web site address in a cell
Type a Web site address in a cell or click Insert > Hyperlink
Describe a situation where it would be important to protect worksheet data
Answers will vary. A situation where worksheet data should be protected is when the worksheet contains payroll figures
List the steps required to e-mail a workbook as an attachment
1. Select Office Button > Send > E-mail to display an e-mail message window with the address boxes and the workbook as an attachment.
2. Type text in the message box if additional information should appear in the e-mail message.
3. Type the e-mail address of the recipient in the To box.
4. Click Send to send the message.
Describe two proofing tools that can be used to check text on a worksheet.
Two proofing tools that can be used to check text on a worksheet are Review > Spelling to check the spelling of the text in the active worksheet and Review > Thesaurus to look up words with similar meanings
Explain how worksheet modifications can be noted if more than one person is working on a worksheet
Modifications made to a worksheet can be tracked. The original creator can later decide which changes to keep and which to discard. To track modifications, click Review > Track Changes > Highlight Changes
How is e-mail important to worksheet collaboration
Answers will vary. E-mail is a fast and efficient message delivery system. When collaborating on a worksheet, the worksheet changes can be tracked.
Explain why a worksheet would be saved in HTML format
Answers will vary. A worksheet would be saved in HTML format to create a copy of the file to be viewed on the Web.
What software is required to view an HTML document
A Web browser, such as Internet Explorer, is required to view an HTML document
What is a template?
A template is a master worksheet that includes the basic elements for a particular type of worksheet
Give an example of a worksheet that would be best saved as a template.
Answers will vary. An invoice and an income statement are two types of worksheets that might be based on templates.
A cell reference consists of a column letter only.
Selected cell and active cell mean the same thing.
The contents of the active cell are displayed in the name box.
There are over a million rows on a worksheet
The width of just a single cell can be changed
A cell can contain only one line of text
The Accounting and Currency formats are the same
A range can consist of non-adjacent cells
The Metro theme is applied by default to a new workbook.
Headers are visible in Normal view
Cell references must be typed in capital letters
The length of a Data Bar depends on the value in the cell relative to other cells
A clip art graphic can be recolored in Excel
The character style Underline should be used sparingly because it could be confused with a hyperlink
Excel automatically checks the spelling of a worksheet
An open workbook can be attached to an e-mail message from Excel
Sets with similar terms
review question chapter 5
Intro to Computers: CH. 5 test
Chapter 5 Vocab
Other sets by this creator
The Great Divorce vocab
Government Unit 2 Test
FORENSIC ch 1&2 test
government unit 1 test
Other Quizlet sets
AQA Biology Unit 7 Key Terms
Unit 3 Agency, Brokerage and Ethical Consideration…
duchess of malfi act 2
1. Neuro 1 Chapter 8 - Nervous Tissue