Podcast
Questions and Answers
What single command can be used to clear everything from the selected cell?
What single command can be used to clear everything from the selected cell?
Clear All
How do you select column B?
How do you select column B?
Select column B
How can you use AutoFill to copy a formula from E2 to E6?
How can you use AutoFill to copy a formula from E2 to E6?
Click and drag the fill handle from E2 to E6.
What steps are taken to cut cell B7 and paste it to cell E12?
What steps are taken to cut cell B7 and paste it to cell E12?
What action is performed to copy cell F3 and paste it into cell F2?
What action is performed to copy cell F3 and paste it into cell F2?
How can you paste the formula only into cell F5?
How can you paste the formula only into cell F5?
What is the procedure to use AutoSum to total cells above the selected cell?
What is the procedure to use AutoSum to total cells above the selected cell?
What formula would you enter in the selected cell using the SUM function to calculate the total of cells B2 through B6?
What formula would you enter in the selected cell using the SUM function to calculate the total of cells B2 through B6?
How do you change the font for the selected cell to Cambria?
How do you change the font for the selected cell to Cambria?
What steps are taken to change the font size of selected cells to 18?
What steps are taken to change the font size of selected cells to 18?
How would you apply bold and italic formatting to the selected cell?
How would you apply bold and italic formatting to the selected cell?
What command would you use to change the font color of selected cells to Blue?
What command would you use to change the font color of selected cells to Blue?
What is the procedure to use Format Painter to copy formatting from cell D1 to cell E1?
What is the procedure to use Format Painter to copy formatting from cell D1 to cell E1?
How do you apply the Accounting Number Format to the selected cells?
How do you apply the Accounting Number Format to the selected cells?
What steps are required to modify the number format so no decimal places are visible?
What steps are required to modify the number format so no decimal places are visible?
How can you apply the Top and Bottom Border to selected cells?
How can you apply the Top and Bottom Border to selected cells?
What task is done to add a Blue bottom border using the thickest single line style?
What task is done to add a Blue bottom border using the thickest single line style?
How do you apply the Accent1 cell style to a selected cell?
How do you apply the Accent1 cell style to a selected cell?
What steps are taken to apply the Ion theme to the workbook?
What steps are taken to apply the Ion theme to the workbook?
What actions are necessary to change the width of columns C:H to 14?
What actions are necessary to change the width of columns C:H to 14?
How can you auto-fit column D to best fit the data?
How can you auto-fit column D to best fit the data?
What command is used to wrap the text in the selected cell?
What command is used to wrap the text in the selected cell?
How do you merge cells so the text is centered across them?
How do you merge cells so the text is centered across them?
What action would you take to insert a column to the left of column E?
What action would you take to insert a column to the left of column E?
What steps are required to delete row 5?
What steps are required to delete row 5?
How would you hide the column showing 2019 data?
How would you hide the column showing 2019 data?
What do you do to add a new worksheet to the left of the Dec 9 sheet?
What do you do to add a new worksheet to the left of the Dec 9 sheet?
How do you delete the Sheet2 worksheet?
How do you delete the Sheet2 worksheet?
What do you need to do to rename Sheet1 to Dec 16?
What do you need to do to rename Sheet1 to Dec 16?
How can you change the tab color for the Dec 9 worksheet to Dark Red?
How can you change the tab color for the Dec 9 worksheet to Dark Red?
What action is taken to move the Salaries worksheet before the working data worksheet?
What action is taken to move the Salaries worksheet before the working data worksheet?
What do you do to switch to Page Break Preview?
What do you do to switch to Page Break Preview?
What steps are necessary to view all worksheet elements as they will print?
What steps are necessary to view all worksheet elements as they will print?
How do you change the zoom level of the worksheet to 110%?
How do you change the zoom level of the worksheet to 110%?
What actions do you take to keep row 1 visible when scrolling?
What actions do you take to keep row 1 visible when scrolling?
What is needed to see four areas of the worksheet and scroll each independently?
What is needed to see four areas of the worksheet and scroll each independently?
How do you hide the TimeSheets worksheet?
How do you hide the TimeSheets worksheet?
What steps do you take to arrange all open workbooks in a staggered pattern?
What steps do you take to arrange all open workbooks in a staggered pattern?
What do you do to use the spelling checker on your worksheet?
What do you do to use the spelling checker on your worksheet?
How do you apply the preset margin option with the least white space?
How do you apply the preset margin option with the least white space?
What steps are taken to add an element displaying just the current date in the header?
What steps are taken to add an element displaying just the current date in the header?
What do you do to add a footer displaying just the page number?
What do you do to add a footer displaying just the page number?
How do you insert a page break above row 12 in Page Break Preview?
How do you insert a page break above row 12 in Page Break Preview?
What is the procedure to modify your worksheet so gridlines print?
What is the procedure to modify your worksheet so gridlines print?
How do you set row 1 to print on every page?
How do you set row 1 to print on every page?
What should be done to guarantee all columns print on one page?
What should be done to guarantee all columns print on one page?
How can you set the print area to only the selected cells?
How can you set the print area to only the selected cells?
What steps are needed to clear the print area?
What steps are needed to clear the print area?
What is the action to print the worksheet?
What is the action to print the worksheet?
What do you do to print the entire workbook?
What do you do to print the entire workbook?
Study Notes
Clear Commands and Cell Selection
- Clear all contents and formatting from a selected cell using the Clear All option in the Editing group.
- To select a specific column, simply click or drag over the column header (e.g., column B).
Copying and Moving Data
- Use AutoFill to extend formulas and formatting by dragging the fill handle from the starting cell (e.g., E2) to the target range (E3:E6).
- To cut and paste, click Cut, select the target cell (e.g., E12), and click Paste from the Clipboard group.
- Copy a cell (e.g., F3) by right-clicking and selecting Copy, then right-click the target cell (e.g., F2) to Paste.
- You can paste only a formula from one cell (e.g., F4) to another (e.g., F5) without formatting.
Using Functions and Formats
- Use AutoSum to quickly calculate totals from contiguous cells by clicking AutoSum and pressing Enter.
- Manually enter a SUM formula in a selected cell to add a specific range (e.g., B2:B6).
- Change font to Cambria and font size to 18 through the Font dialog and Font Size drop-down menus.
Text Formatting and Alignment
- Apply bold and italic formatting using buttons in the Font Ribbon Group.
- Change font color by selecting the desired color option from the Font Color menu.
- Use the Format Painter to copy formatting from one cell to another (e.g., from D1 to E1).
- Apply the Accounting Number Format in the Number group for financial data.
Border and Cell Styles
- Apply Top and Bottom Borders with a single command from the Borders menu.
- To add a colored bottom border, access More Borders for options on style and line color.
- Apply a specific cell style (e.g., Accent1) from the Cell Styles menu.
Worksheet Management
- Insert new columns or delete rows and columns through the Cells Ribbon Group options.
- Hide specific columns or rows to streamline your data view.
- Add or delete worksheets by using the right-click context menus on sheet tabs.
Workbook Views and Layout
- Switch to Page Break Preview to manipulate page breaks when printing.
- Adjust zoom levels by dragging the zoom slider in the application footer.
- Enable Freeze Panes to keep the first row visible while scrolling.
Page Setup and Printing
- Change margins by selecting the Narrow option for minimal whitespace on printed pages.
- Set specific rows to print on every page using the Print Titles feature.
- Define a print area to limit printing to selected cells only and clear the print area when necessary.
Additional Features
- Use the spelling checker to identify and fix misspelled words within the document.
- Adjust print settings to ensure the document meets your formatting requirements before printing.
- Manage worksheet header and footer elements by adding relevant information like page numbers or dates.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of Excel commands and functions from Chapter 1. This quiz includes practical flashcards to help reinforce your understanding of basic Excel operations, including clearing cells and using AutoFill. Perfect for beginners looking to master the essentials of Excel.
