Excel Module 2 Study Guide
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| show | it lets you see and evaluate different formats as you develop your workbook
🗑
|
||||
| Typeface is the specific design used for characters and includes ____ | show 🗑
|
||||
| A ____ is not a type of font | show 🗑
|
||||
| show | non-theme
🗑
|
||||
| show | font styles
🗑
|
||||
| To change the font size one point at a time, in the Font group on the Home tab, click the ____ button. | show 🗑
|
||||
| ____ theme colors are designated for text and background, ____ colors are used for accents and highlights, and ____ colors are used for hyperlinks. | show 🗑
|
||||
| show | custom
🗑
|
||||
| show | fill color
🗑
|
||||
| show | 10 theme colors, standard color bar,
🗑
|
||||
| show | format, content
🗑
|
||||
| When creating an Excel document, you should avoid using ____ text and background together, since this is the most common form of color blindness. | show 🗑
|
||||
| By default, numbers appear in the ____ and generally display values exactly as you type them. | show 🗑
|
||||
| Because Excel stores dates and times as ____, you can apply different formats without affecting the date and time value. | show 🗑
|
||||
| show | January 1, 1900 12:00 am
🗑
|
||||
| In Excel, dates are ____-aligned in the cell by default, regardless of date format. | show 🗑
|
||||
| As a general rule, you should ____ column titles, ______ align text, and ____ align numbers. | show 🗑
|
||||
| show | merge across.
🗑
|
||||
| In Excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the merged cell. | show 🗑
|
||||
| show | orientation.
🗑
|
||||
| You can add a border in Excel ____. | show 🗑
|
||||
| In the Format Cells dialog box, the ____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays. | show 🗑
|
||||
| The Format Cells dialog box has six tabs that does NOT include: ____ | show 🗑
|
||||
| When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to ____. | show 🗑
|
||||
| In the Paste Special dialog box, you can __________, ____________, and __________ | show 🗑
|
||||
| You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking ____ on the shortcut menu | show 🗑
|
||||
| show | Microsoft word, excel and powerPoint.
🗑
|
||||
| show | excel table.
🗑
|
||||
| show | table style.
🗑
|
||||
| The most efficient way to format an entire table is to ____. | show 🗑
|
||||
| A table ____ applies alternating row colors to the entire Excel table and adjusts the banded rows effect as needed if you add or delete rows. | show 🗑
|
||||
| show | ability to sort data, external, filter
🗑
|
||||
| In Excel, the table style ____ inserts a new row at the bottom of the table that adds the column values. | show 🗑
|
||||
| show | banded columns.
🗑
|
||||
| To remove banded rows from an Excel table, first you need to select the ____ tab on the Ribbon. | show 🗑
|
||||
| In Page Layout view, the worksheet is displayed as it will appear on the ____. | show 🗑
|
||||
| A ____ is the space between the page content and the edges of the page | show 🗑
|
||||
| One way to ensure that you are using consistent formats is to copy and paste your formats using the Format ____. | show 🗑
|
||||
| In conditional formatting, to highlight only cells that contain a specific date, select the rule____. | show 🗑
|
||||
| Fonts, colors, and cell styles are organized in ____ categories. | show 🗑
|
||||
| To view certain columns on a large worksheet, a good option is to ____. | show 🗑
|
||||
| show | position of the report on the page, orientation, include headers and footers.
🗑
|
||||
| show | print range.
🗑
|
||||
| show | pagebreak.
🗑
|
||||
| show | select first cell below the row where you want to insert a page break.
🗑
|
||||
| show | solid blue line.
🗑
|
||||
| show | print title.
🗑
|
||||
| show | &[File].
🗑
|
||||
| The header and footer sections include ____ , ______ and ______ sections. | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
galvanl
Popular Computers sets