CS Excel Chapter 1 Practice

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?

Cut from B7 and then paste it to E12. Signup and view all the answers

What action is performed to copy cell F3 and paste it into cell F2?

Right-click F3 and select Copy, then right-click F2 and select Paste. Signup and view all the answers

How can you paste the formula only into cell F5?

Use Paste Special and select Formulas. Signup and view all the answers

What is the procedure to use AutoSum to total cells above the selected cell?

Click the AutoSum button and press Enter. 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?

SUM(B2:B6) Signup and view all the answers

How do you change the font for the selected cell to Cambria?

Select Cambria from the Font dialog. Signup and view all the answers

What steps are taken to change the font size of selected cells to 18?

Select 18pt from the Font Size menu. Signup and view all the answers

How would you apply bold and italic formatting to the selected cell?

Click the Bold and Italic buttons. Signup and view all the answers

What command would you use to change the font color of selected cells to Blue?

Select the Blue color from the Font Color menu. Signup and view all the answers

What is the procedure to use Format Painter to copy formatting from cell D1 to cell E1?

Click the Format Painter button and then click E1. Signup and view all the answers

How do you apply the Accounting Number Format to the selected cells?

Click the Accounting Number Format button. Signup and view all the answers

What steps are required to modify the number format so no decimal places are visible?

Change the Decimal places to 0 in the Format Cells dialog. Signup and view all the answers

How can you apply the Top and Bottom Border to selected cells?

Select the Top and Bottom Border menu item. Signup and view all the answers

What task is done to add a Blue bottom border using the thickest single line style?

Select Double Thick Underline in the More Borders menu. Signup and view all the answers

How do you apply the Accent1 cell style to a selected cell?

Select Accent 1 from the Cell Styles menu. Signup and view all the answers

What steps are taken to apply the Ion theme to the workbook?

Select Ion from the Themes menu. Signup and view all the answers

What actions are necessary to change the width of columns C:H to 14?

Set column width to 14 in the Column Width dialog. Signup and view all the answers

How can you auto-fit column D to best fit the data?

Select AutoFit Column Width from the Format menu. Signup and view all the answers

What command is used to wrap the text in the selected cell?

Click the Wrap Text button. Signup and view all the answers

How do you merge cells so the text is centered across them?

Click the Merge & Center button. Signup and view all the answers

What action would you take to insert a column to the left of column E?

Insert a column left of column E. Signup and view all the answers

What steps are required to delete row 5?

Select Delete Sheet Rows from the Delete menu. Signup and view all the answers

How would you hide the column showing 2019 data?

Right-click and select Hide. Signup and view all the answers

What do you do to add a new worksheet to the left of the Dec 9 sheet?

Click the New Sheet button. Signup and view all the answers

How do you delete the Sheet2 worksheet?

Right-click Sheet2 and select Delete Sheet. Signup and view all the answers

What do you need to do to rename Sheet1 to Dec 16?

Right-click Sheet1 and select Rename. Signup and view all the answers

How can you change the tab color for the Dec 9 worksheet to Dark Red?

Select the Dark Red color in the Tab Color menu. Signup and view all the answers

What action is taken to move the Salaries worksheet before the working data worksheet?

Drag the Salaries tab in front of the working data tab. Signup and view all the answers

What do you do to switch to Page Break Preview?

Click the Page Break Preview button. Signup and view all the answers

What steps are necessary to view all worksheet elements as they will print?

Access the Print Preview option. Signup and view all the answers

How do you change the zoom level of the worksheet to 110%?

Drag the zoom slider to 110%. Signup and view all the answers

What actions do you take to keep row 1 visible when scrolling?

Select Freeze Top Row from the Freeze Panes menu. Signup and view all the answers

What is needed to see four areas of the worksheet and scroll each independently?

Click the Split button in the View Ribbon. Signup and view all the answers

How do you hide the TimeSheets worksheet?

Right-click the TimeSheets tab and select Hide. Signup and view all the answers

What steps do you take to arrange all open workbooks in a staggered pattern?

Select Cascade in the Arrange Windows dialog. Signup and view all the answers

What do you do to use the spelling checker on your worksheet?

Click the Spelling button in the Review Ribbon. Signup and view all the answers

How do you apply the preset margin option with the least white space?

Select the Narrow option from the Margins menu. Signup and view all the answers

What steps are taken to add an element displaying just the current date in the header?

Insert date element in the center section of the header. Signup and view all the answers

What do you do to add a footer displaying just the page number?

Insert page number in the center section footer. Signup and view all the answers

How do you insert a page break above row 12 in Page Break Preview?

Select Insert Page Break from the Breaks menu. Signup and view all the answers

What is the procedure to modify your worksheet so gridlines print?

Check the Print option in the Sheet Options group. Signup and view all the answers

How do you set row 1 to print on every page?

Set Rows to repeat at top in the Page Setup dialog. Signup and view all the answers

What should be done to guarantee all columns print on one page?

Select Fit All Columns on One Page in the Scaling menu. Signup and view all the answers

How can you set the print area to only the selected cells?

Set Print Area from the Print Area menu. Signup and view all the answers

What steps are needed to clear the print area?

Select Clear Print Area from the Print Area menu. Signup and view all the answers

What is the action to print the worksheet?

Click the Print button in the Print menu. Signup and view all the answers

What do you do to print the entire workbook?

Select Print Entire Workbook from the Print selection menu. 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.