Questions and Answers
What single command can be used to clear everything from the selected cell?
Clear All
How do you select column B?
Select column B
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?
Signup and view all the answers
What action is performed to copy cell F3 and paste it into cell F2?
Signup and view all the answers
How can you paste the formula only into cell F5?
Signup and view all the answers
What is the procedure to use AutoSum to total cells above the selected cell?
Signup and view all the answers
What formula would you enter in the selected cell using the SUM function to calculate the total of cells B2 through B6?
Signup and view all the answers
How do you change the font for the selected cell to Cambria?
Signup and view all the answers
What steps are taken to change the font size of selected cells to 18?
Signup and view all the answers
How would you apply bold and italic formatting to the selected cell?
Signup and view all the answers
What command would you use to change the font color of selected cells to Blue?
Signup and view all the answers
What is the procedure to use Format Painter to copy formatting from cell D1 to cell E1?
Signup and view all the answers
How do you apply the Accounting Number Format to the selected cells?
Signup and view all the answers
What steps are required to modify the number format so no decimal places are visible?
Signup and view all the answers
How can you apply the Top and Bottom Border to selected cells?
Signup and view all the answers
What task is done to add a Blue bottom border using the thickest single line style?
Signup and view all the answers
How do you apply the Accent1 cell style to a selected cell?
Signup and view all the answers
What steps are taken to apply the Ion theme to the workbook?
Signup and view all the answers
What actions are necessary to change the width of columns C:H to 14?
Signup and view all the answers
How can you auto-fit column D to best fit the data?
Signup and view all the answers
What command is used to wrap the text in the selected cell?
Signup and view all the answers
How do you merge cells so the text is centered across them?
Signup and view all the answers
What action would you take to insert a column to the left of column E?
Signup and view all the answers
What steps are required to delete row 5?
Signup and view all the answers
How would you hide the column showing 2019 data?
Signup and view all the answers
What do you do to add a new worksheet to the left of the Dec 9 sheet?
Signup and view all the answers
How do you delete the Sheet2 worksheet?
Signup and view all the answers
What do you need to do to rename Sheet1 to Dec 16?
Signup and view all the answers
How can you change the tab color for the Dec 9 worksheet to Dark Red?
Signup and view all the answers
What action is taken to move the Salaries worksheet before the working data worksheet?
Signup and view all the answers
What do you do to switch to Page Break Preview?
Signup and view all the answers
What steps are necessary to view all worksheet elements as they will print?
Signup and view all the answers
How do you change the zoom level of the worksheet to 110%?
Signup and view all the answers
What actions do you take to keep row 1 visible when scrolling?
Signup and view all the answers
What is needed to see four areas of the worksheet and scroll each independently?
Signup and view all the answers
How do you hide the TimeSheets worksheet?
Signup and view all the answers
What steps do you take to arrange all open workbooks in a staggered pattern?
Signup and view all the answers
What do you do to use the spelling checker on your worksheet?
Signup and view all the answers
How do you apply the preset margin option with the least white space?
Signup and view all the answers
What steps are taken to add an element displaying just the current date in the header?
Signup and view all the answers
What do you do to add a footer displaying just the page number?
Signup and view all the answers
How do you insert a page break above row 12 in Page Break Preview?
Signup and view all the answers
What is the procedure to modify your worksheet so gridlines print?
Signup and view all the answers
How do you set row 1 to print on every page?
Signup and view all the answers
What should be done to guarantee all columns print on one page?
Signup and view all the answers
How can you set the print area to only the selected cells?
Signup and view all the answers
What steps are needed to clear the print area?
Signup and view all the answers
What is the action to print the worksheet?
Signup and view all the answers
What do you do to print the entire workbook?
Signup and view all the answers
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.