Excel Flashcards: Formatting Basics

Questions and Answers

How do you enter a formula to calculate the profit projection for 2017 in cell F6?

You typed =F4-F5 in cell F6 after clicking cell F4 and F5.

How do you calculate monthly payments for a loan in cell B6?

Use the PMT function with the rate in B3/12 and a negative value for Pv.

What command do you use to create named ranges from selected data?

Use the Create from Selection command in the Defined Names group.

How do you find the highest line item cost for the month in cell E15?

Use the MAX function with the range A2:A14. Signup and view all the answers

How do you edit a formula in cell D2 to update references?

Change the formula to =B2+(B2^$B$9) and use AutoFill to copy it. Signup and view all the answers

What steps are needed to create a 3-D pie chart from selected data?

Use the Insert Pie or Doughnut Chart button from the Charts Ribbon. Signup and view all the answers

How do you move a chart to an empty area of the worksheet?

Drag the chart to the left by 5 columns and down by 7 rows. Signup and view all the answers

Which style should be applied to the chart to use Style 3?

Select Style 3 from the Chart Styles menu. Signup and view all the answers

How do you display the data table in a chart?

Check the Data Table option in the Chart Elements menu. Signup and view all the answers

What color scheme is used for the chart's background?

Monochromatic Palette 3. Signup and view all the answers

How can you hide the chart title?

Uncheck the Chart Title option in the Chart Elements menu. Signup and view all the answers

What is the method to resize the chart to be approximately 7 rows tall?

Resize the selected chart manually. Signup and view all the answers

How do you display data labels above the data markers on a chart?

Select the Above option in the Data Labels menu. Signup and view all the answers

How do you clear the selected Sparklines from the worksheet?

Click the Clear button in the Sparkline Tools Design tab. Signup and view all the answers

What is the first stacked bar chart option?

Change the chart type in the Design Ribbon Tab. Signup and view all the answers

How do you move the selected chart to a new chart sheet?

Select Move Chart from the Chart Tools Design tab and choose New Sheet. Signup and view all the answers

How do you switch the rows and columns in a chart?

Click the Switch Row/Column button in the Design Ribbon Tab. Signup and view all the answers

What steps do you take to insert a line chart based on recommended types?

Use the Quick Analysis Tool and select the Line button under the Charts tab. Signup and view all the answers

How do you filter a chart to hide certain lines?

Use the Chart Filter menu and uncheck the desired items. Signup and view all the answers

How do you add column Sparklines to represent values in a specified range?

Select Column from the Sparklines tab in the Quick Analysis Tool. Signup and view all the answers

What is the method to modify the number format so no decimal places are visible after the decimal point?

In the Home Ribbon Tab in the Number Ribbon Group, click the Decrease Decimal button. Signup and view all the answers

How do you apply bold and italic formatting to a selected cell?

In the Home Ribbon Tab in the Font Ribbon Group, click the Italic button and then the Bold button. Signup and view all the answers

How do you enter the number 6745 in cell C7?

Type 6745 in cell C7 and press Enter. Signup and view all the answers

What are the steps to cut cell B7 and paste it to cell E12?

Press Ctrl + X, click cell E12, and then press Ctrl + V. Signup and view all the answers

What method is used to apply the Accounting Number Format to selected cells?

In the Home Ribbon Tab in the Number Ribbon Group, click the Number Format drop-down arrow and select Accounting. Signup and view all the answers

How can you apply the Ion theme to the workbook?

In the Page Layout Ribbon Tab in the Themes Ribbon Group, click the Themes button and select Ion. Signup and view all the answers

Describe the method to use AutoFill to copy the formula and formatting from cell E2 to cells E3:E6.

Click and drag the fill handle from cell E2 to cell E6. Signup and view all the answers

How do you select the cell range A5:D8?

Click cell A5 and select the range A5:D8. Signup and view all the answers

How do you add a Blue, Accent 5 bottom border to selected cells?

On the Home tab, in the Font group, click the Fill Color button arrow and select Blue, Accent 5. Signup and view all the answers

What steps are involved in using Format Painter to copy formatting from cell D1 to E1?

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

How do you change the font size for selected cells to 18?

In the Home Ribbon Tab in the Font Ribbon Group, click the Font Size drop-down arrow and select 18pt. Signup and view all the answers

What is the method to use AutoSum in a selected cell to calculate the total of all contiguous cells above?

In the Home Ribbon Tab in the Editing Ribbon Group, click the AutoSum button arrow and select Sum, then press Enter. Signup and view all the answers

How do you wrap text in a selected cell?

In the Home Ribbon Tab in the Alignment Ribbon Group, click the Wrap Text button. Signup and view all the answers

What is the method to autofit column D to best fit the data?

Double-click column D's right border. Signup and view all the answers

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

In the Home Ribbon Tab in the Font Ribbon Group, click the Borders button arrow and select Top and Bottom Border. Signup and view all the answers

What method do you use to clear everything from a selected cell?

In the Home Ribbon Tab in the Editing Ribbon Group, click the Clear button and select Clear All. Signup and view all the answers

How do you change the font color of selected cells to Blue-Gray, Text 2?

In the Home Ribbon Tab in the Font Ribbon Group, click the Font Color button arrow and select Blue-Gray, Text 2. Signup and view all the answers

What is the procedure to select column B?

Click on column B. Signup and view all the answers

How do you paste only the formula from cell F4 into cell F5 without formatting?

In the Home Ribbon Tab in the Clipboard Ribbon Group, click the Paste button arrow and select Formulas (F). Signup and view all the answers

What method do you use to apply the Accent 1 cell style to a selected cell?

In the Home Ribbon Tab in the Styles Ribbon Group, click the Cell Styles button and select Accent 1. Signup and view all the answers

How can you change the font for a selected cell to Cambria?

In the Home Ribbon Tab in the Font Ribbon Group, click the Font drop-down arrow and select Cambria. Signup and view all the answers

How do you change the width of selected columns to 14?

In the Home Ribbon Tab in the Cells Ribbon Group, click the Format button, select Column Width, type 14 in the dialog, and click OK. Signup and view all the answers

What are the steps to copy cell F3 and paste it to F2?

Press Ctrl + C, click cell F2, and press Ctrl + V. Signup and view all the answers

How do you center the content in selected cells horizontally?

In the Home Ribbon Tab in the Alignment Ribbon Group, click the Align Center button. Signup and view all the answers

What is the way to enter a formula in a selected cell using the SUM function for cells B2 through B6?

Click AutoSum in the Home Ribbon Tab, then select Sum, and press Enter. Signup and view all the answers

How do you delete a row in Excel?

On the Home tab in the Cells group, click the Delete button arrow and select Delete Sheet Rows. Signup and view all the answers

What is the process to merge cells and center text across them?

In the Home Ribbon Tab in the Alignment Ribbon Group, click the Merge & Center button. Signup and view all the answers

How do you change the color of a worksheet tab for Jul 26 to Green, Accent 6, Lighter 80%?

Right-click the Jul 26 tab and select the desired color option from the Tab Color menu. Signup and view all the answers

What is the method to add a footer displaying the page number in the center section?

In the Design Ribbon Tab, click the Page Number button. Signup and view all the answers

How do you ensure gridlines will print in the Jul 26 worksheet?

In the Page Layout Ribbon Tab, check the Print check box in the Sheet Options Ribbon Group. Signup and view all the answers

What is the procedure to apply preset margins that add the least amount of white space while printing?

In the Page Layout Ribbon Tab, select the Margins button and then choose Narrow. Signup and view all the answers

How do you freeze the first row of a worksheet so it is always visible?

In the View Ribbon Tab, click the Freeze Panes button and select Freeze Top Row. Signup and view all the answers

How can you see four different areas of the worksheet and scroll each independently?

In the View Ribbon Tab, click the Split button. Signup and view all the answers

What is the method to arrange all open workbooks in a staggered diagonal pattern?

In the View Ribbon Tab, click the Arrange All button and select Cascade. Signup and view all the answers

How do you add a new worksheet to the left of the Jul 26 sheet?

In the Home Ribbon Tab, click the Insert button arrow and select Insert Sheet. Signup and view all the answers

What is the method to delete the Timesheets worksheet?

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

How do you print the entire workbook?

Open the backstage view, click the Print navigation button, and select Print Entire Workbook. Signup and view all the answers

What steps do you take to insert a column to the left of a selected cell?

On the Home tab, in the Cells group, click the Insert button arrow and select Insert Sheet Columns. Signup and view all the answers

What is the method to hide the column showing 2013 data?

Click on column B, then go to Format in the Home Ribbon and select Hide Columns. Signup and view all the answers

What are the steps to set the print area so only selected cells will print?

In the Page Layout Ribbon Tab, click Print Area and choose Set Print Area. Signup and view all the answers

How do you rename Sheet1 to Jul 31?

Double-click the Sheet1 tab, type 'Jul 31', and press Enter. Signup and view all the answers

What is the process to set row 1 to print on every page?

In the Page Layout Ribbon Tab, click Print Titles and select the row 1 header. Signup and view all the answers

How do you move the Salaries worksheet before the working data worksheet?

Click the Salaries tab and drag it in front of the working data tab. Signup and view all the answers

What method is used to find and change all instances of misspelled words?

In the Review Ribbon Tab, click the Spelling button and follow the prompts to make changes. Signup and view all the answers

How do you add a current date element in the center section of the header?

Click in the center section of the header and select Current Date from the Header & Footer Elements. Signup and view all the answers

What is the method to change the zoom level for the worksheet to 110%?

Click the Zoom In button. Signup and view all the answers

What are the steps to clear the print area?

In the Page Layout Ribbon Tab, click Print Area and select Clear Print Area. Signup and view all the answers

How can you switch to a view that shows all worksheet elements as they will print?

Click the Page Layout button. Signup and view all the answers

What method is used to insert a page break above a selected cell from Page Break Preview view?

In the Page Layout Ribbon Tab, click the Breaks button and select Insert Page Break. Signup and view all the answers

How do you print a specific worksheet?

Open the backstage view, click the Print navigation button, and select Print Selection. Signup and view all the answers

What is the procedure to ensure that all columns will print on one page without adjusting widths?

In the Page Layout Ribbon Tab, click the Width: drop-down arrow and select 1 page. Signup and view all the answers

What method is used to hide all dependency tracer arrows at once?

In the Formulas Ribbon Tab, click the Remove Arrows button. Signup and view all the answers

Describe how to enter a formula in cell B3 using the VLOOKUP function.

In the Formulas Ribbon Tab, click Lookup & Reference, select VLOOKUP, select cell A3 for lookup, and set the parameters. Signup and view all the answers

What is the process to enter a formula in cell B8 to display the value of cell B7 from the Expenses sheet?

Type = in cell B8, click the Expenses tab, select cell B7, and press Enter. Signup and view all the answers

How do you insert the current date in cell A1 without including the time?

In the Formulas Ribbon Tab, click Date & Time, select TODAY, and click OK. Signup and view all the answers

Describe how to enter a formula in cell B15 to find the lowest item cost for cells B2:B14.

In the Formulas Ribbon Tab, click More Functions, select MIN, specify the range B2:B14, and click OK. Signup and view all the answers

What are the steps to enter a formula in cell D16 to count the number of blank cells in the D2:D14 column?

In the Formulas Ribbon Tab, click More Functions, select COUNTBLANK, specify range D2:D14, and click OK. Signup and view all the answers

How do you show the tracer arrows from cell E7 to dependent cells?

In the Formulas Ribbon Tab, click Trace Dependents. Signup and view all the answers

What method do you use to enter a formula in cell E15 to count the numbers in the Cost column?

In the Formulas Ribbon Tab, click More Functions, select COUNT, specify the range E2:E14, and click OK. Signup and view all the answers

How do you insert the current date and time in cell B1?

In the Formulas Ribbon Tab, click Date & Time, select NOW, and click OK. Signup and view all the answers

How do you enter a formula in cell B10 to return a value based on Net Profit After Tax?

In the Formulas Ribbon Tab, click Logical, select IF, and specify conditions with values for true and false cases. Signup and view all the answers

What are the steps to enter a formula in cell G7 to calculate the average for G2:G6?

In the Formulas Ribbon Tab, click More Functions, select AVERAGE, and specify the range G2:G6. Signup and view all the answers

How do you show tracer arrows from precedent cells to cell C7?

In the Formulas Ribbon Tab, click Trace Precedents. Signup and view all the answers

What is the method to enter a formula displaying the owner's draw percentage in a selected cell?

Specify the owner's draw calculation directly in the selected cell. Signup and view all the answers

Study Notes

Excel Flashcards Overview

Modify number format to hide decimal places using the Decrease Decimal button in the Home Ribbon Tab.
Apply bold and italic formatting through the Font group in the Home Ribbon Tab.
Enter specific values in designated cells by directly typing and then pressing Enter.
Perform cut and paste operations using keyboard shortcuts Ctrl + X and Ctrl + V.
Apply Accounting Number Format from the Number Format drop-down in the Home Ribbon Tab.

Formatting and Styling

Change themes in a workbook by selecting the desired option in the Themes menu under the Page Layout Ribbon Tab.
Use AutoFill for copying formulas by dragging the fill handle across the desired range.
Select cell ranges by clicking and dragging from the starting cell to the ending cell.
Add borders with specific styles and colors by navigating through the Font group in the Home tab.

Clipboard Functions

Utilize the Format Painter to replicate formatting from one cell to another using the Clipboard group in the Home Ribbon Tab.
Change font sizes and colors by selecting the options from the Font group in the Home Ribbon Tab.
Clear content and formatting from cells using the Clear button in the Editing group on the Home Ribbon Tab.

Data Structure and Cell Management

Use AutoSum for quick calculations of total values in adjacent cells by clicking the AutoSum button.
Wrap text in cells for better visibility using the Wrap Text button under the Alignment group in the Home Ribbon Tab.
Autogenerate column widths by double-clicking on the column borders for optimal data fitting.

Apply top and bottom borders to selected cells with a single command from the Borders menu.
Rename worksheets by double-clicking the worksheet tabs and entering the desired name.
Set print titles to repeat specific rows on every printed page through the Page Layout Ribbon Tab options.

Workbook and Worksheet Operations

Control print areas to selectively print parts of a worksheet using the Print Area button in the Page Layout Ribbon Tab.
Insert new worksheets and move existing ones by utilizing the appropriate options in the Cells group in the Home Ribbon Tab.
Delete rows or columns with the Delete option in the Cells group, ensuring proper data management.

Formulas and Functions

Implement common formulas such as VLOOKUP and SUM by using the Function Library group in the Formulas Ribbon Tab.
Count, find maximum, minimum, or average values using counting functions within specific cell ranges.
Use logical functions like IF for conditional calculations based on cell values.

Date and Time Functions

Insert current dates or times in specific cells using Date & Time options from the Formulas Ribbon Tab.
Automate future calculations, projections, and data manipulations using cell references.

Visual and Data Auditing Tools

Track dependencies and precedents using tracer arrows from the Formulas Ribbon Tab for effective data auditing.
Manage dependencies for error checking with tools like the Remove Arrows button to keep workbooks organized and error-free.

Documenting and Printing

Use various print options to ensure desired formats are captured when sending documents to printers.
Preview document prints to assess how the final output will look with options in the Page Layout Tab.

General Tips

Familiarize with keyboard shortcuts for efficiency in performing common tasks.
Explore ribbon tabs comprehensively for available features that enhance productivity in Excel usage.### Formulas and AutoFill
Edit formulas in cell D2 to dynamically reference cell C2, while keeping cell B9 constant using $ to lock its reference.
Use AutoFill to extend the updated formula from D2 to D6 to quickly recalculate values.

Creating Charts

Insert a 3-D pie chart via the Charts Ribbon Group by selecting the appropriate chart type from the Pie or Doughnut Chart options.
Move charts by dragging them to designated worksheet areas to maintain organization and clarity.
Apply a specific Quick Style (Style 3) to enhance the visual appearance of charts from the Chart Styles menu.
Display data tables on charts to provide additional context, including legend keys, using the Chart Elements menu.

Chart Design and Customization

Change color schemes by selecting the Monochromatic Palette 3 option, enhancing the chart's aesthetic appeal.
Hide chart titles when deemed unnecessary, streamlining the presentation of data by unchecking options in the Chart Elements menu.
Resize charts for optimal visibility and spacing, ensuring data representation is clear and easily interpretable.
Add data labels to charts, positioning them above data markers for clear value display, accessed via the Chart Elements menu.

Sparkline Management

Clear selected Sparklines from a worksheet using the Sparkline Tools Design tab to declutter the view.

Chart Types and Data Organization

Change the chart type to the first stacked bar option, providing a different visualization approach to represent data.
Move selected charts to new sheet locations to separate and organize different visual data representations.
Switch rows and columns in a chart to regroup data points by year, facilitating better comparison and analysis.

Chart Analysis and Filtering

Insert Line charts based on recommended types by using the Quick Analysis Tool for insightful trend visualization.
Filter chart data to hide specific lines, such as those representing Dr. Femur and Tibia Robinson, enabling focused analysis of remaining data.

Sparklines

Add column Sparklines in specified cells (F2:F11) to visually represent values from another range (B2:E11), helping to highlight trends in small formats.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge of basic Excel formatting techniques with these flashcards. Learn how to modify number formats and apply text styles like bold and italic. Perfect for beginners looking to enhance their Excel skills.