or

or

taken

why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01

 Flashcards Matching Hangman Crossword Type In Quiz Test StudyStack Study Table Bug Match Hungry Bug Unscramble Chopped Targets

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

# Excel Module 1 & 2

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