Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
Excel Module 1 & 2
| Question | Answer |
|---|---|
| An Excel ____ allows data to be summarized and charted easily. | worksheet |
| A(n) _____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. | indirect |
| The first step in creating an effective worksheet is to make sure you __________. | understand what is required |
| Which of the following calculations multiplies 23 by 0.01? | =23% |
| ______ is/are used to place worksheet, column, and row titles on a worksheet. | Text |
| When Excel follows the order of operations, the formula, 8*3+2, equals_______. | 26 |
| The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. | AutoCorrect |
| The adjusted cell references in a copied and pasted formula are called ______ cell references. | relative |
| The range of cells receiving copied content is called the _____ area. | paste |
| Which of the following Option button gives options for filling cells following a fill operations? | Auto Fill Options |
| The range of cells receiving the content of copied cells is called the ________. | destination area |
| The _______ Options button lists formatting options following an insertion of cells, rows, or columns. | Insert |
| the ___________ button allows you to choose whether you want to copy the values form the source area to the destination area with formatting. | Auto Fill Options |
| The _______________ function determines the lowest number in a range. | MIN |
| You can apply the Bold font style by pressing the _______ keyboard shortcut keys, | CTRL + B |
| The __________________ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign. | Formula |
| Which of the following is the Ribbon path to the cell Styles button? | (HOME tab/ Styles group) |
| You can use the ________ to check which cells are referenced in the formula assigned to the active cell. | Range Finder |
| What effect does the Comma Style format have on the selected cells? | Displays cell contents with two decimal places and commas as thousands seperators |
| The _____________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. | Accounting Number format |
| How many chart types does Excel offer? | 15 |
| When you decrease the row height to ____ the row is hidden. | 0 |
| The date you change a file is an example of an ________ property | automatically updated |
| A _____ is a text and graphics that print at the bottom of every page. | footer |
| You use _____ to view an XPS file | XPS viewer |
| _________ view allows you to create or modify a worksheet while viewing how it will look in printed format. | Page Layout |
| Which of the following key toggles between Insert Mode and Overtype mode? | INSERT |
| To erase an entire entry in a cell and then recenter the data from the begininning, press the ____ key. | ESC |
| Which of the following keys moves the insertion point to the beginning of data in a cell? | HOME |
| Which of the following keys moves the insertion point to the end of the data in the cell? | END |
| The _______ button allows you to erase recent cell entries. | undo |
| Excel remembers the last _______ actions you have completed. | 100 |
| Press _____ to select the entire worksheet. | CTRL+A |
| When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ______________. | mm/dd/yyyy |
| A(n) ___________ conveys a visual representation of data. | chart |
| A formula in a cell that contains a reference back to itself is called a(n) _____________. | circular reference |
| The easiest way to select a cell is to move the block _________ pointer to the cell and then click. | plus sign |
| IN the order of operations, the last operation Excel performs is __________. | subtraction/ addition |
| As you type, Excel displays the entry ( and the Cancel box and Enter box) in the ______________. | formula box |
| The __________ is a small black square in the lower-right corner of the active cell or active range. | fill handle |
| Excel's ____________- function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total. | SUM |
| Of warmer and cooler colors, the kind of colors that tend to reach toward the reader are ____ color. | warmer |
| The automatically adjusted cell reference in a pasted formula is called a (n) | relative reference |
| __________ means that the width of a column will be increase or decreased so the widest entry will fit in the column. | best fit |
| __________________ indicates how characters are emphasized. | font style |
| You can click the Page Layout button on the status bar to switch to ___________view. | Page Layout |
| You can click the Page Layout button on the status bar to switch to _________ view. | Page Layout |
| __________ view shows the worksheet divided into pages. | Page Layout |
| ________________ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related stechnologies. | Green Computing |
| While typing ______ in a cell, you can press the ___________ key to erase all the characters back to including the incorrect character you just typed. | BACKSPACE |
Created by:
gracie.prince07
Popular Computers sets