Save
Upgrade to remove ads
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


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. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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 Exam

QuestionAnswer
This bar displays entries as they are made and edited in the Excel workbook window. A) Standard B) Format C) Formula D) Title Formula
Symbols used to specify the calculations to be performed in a formula are called: A) addends. B) functions. C) values. D) operators. operators.
You can automatically resize the column to fit the width of the column's contents by ____ on the column boundary line. A) Clicking B) Right-clicking C) Double right-clicking D) Double-clicking Double-clicking
The intersection of a column and row is called a: A) grid. B) box. C) cell. D) field. cell.
Which type of chart organizes categories horizontally and values vertically to emphasize variation over time? A) Bar B) Line C) Area D) Column Column
A workbook sheet that contains only a chart is called a: A) column sheet. B) value sheet. C) chart sheet. D) data sheet. chart sheet.
Which of the following is NOT an element of a pie chart? A) X-axis B) Data labels C) Chart title D) Legend X-axis
All formulas begin with the ____________ sign. A) + (plus) B) * (asterisk) C) - (minus) D) = (equal) = (equal)
Copying the formula =A1*B1 from cell C1 to cell C2 would yield which of the following formulas in cell C2? A) =B1*C1 B) =A2*B2 C) =A1*B1 D) =B2*C2 =A2*B2
Press ____________ to access Microsoft Office Help. A) [F10] B) [F1] C) [F4] D) [F12] [F1]
___________ identify each worksheet in a workbook and are located along the lower left edge of the workbook window. A) Worksheet details B) Format tabs C) Sheet tabs D) File names Sheet tabs
Which of the following is not an example of formatting? A) Formula B) Color C) Text font D) Borders Formula
Combining two or more cells into a single cell creates a: A) combination box B) combined cell C) grouping D) merged cell merged cell
To analyze a group of related data, you can convert a range of cells to a(n): A) grouped workbook. B) Excel table. C) data bar. D) data filter. Excel table.
The keyboard shortcut for the Copy command is: A) [Ctrl] + [C]. B) [Tab] + [C]. C) [Shift] + [C]. D) [Alt] + [C]. [Ctrl] + [C].
Press the ____________ key to cancel a moving border and clear a selection from the Office Clipboard. A) Alt B) Esc C) Delete D) Ctrl Esc
___________ functions perform common business calculations such as calculating a loan payment or calculating how much to save each month in order to buy something. A) PMT B) Logical C) Financial D) Statistical Financial
Which type of chart reverses the X and Y-axes? A) Pyramid chart B) Bar chart C) Cylinder chart D) Radar chart Bar chart
To paste a range of cells, you only need to select the cell in the ____________ corner of the target destination. A) bottom right B) upper right C) bottom left D) upper left upper left
Use the ____________ command to display text on two lines within a cell. A) Merge and Center B) Wrap Text C) Insert Row D) Align Text Wrap Text
Excel's prewritten formulas are called: A) functions. B) commands. C) calculations. D) summations. functions.
To make a cell reference absolute, ____________ are inserted into the cell reference. A) exclamation marks B) parenthesis C) dollar signs D) brackets dollar signs
A ____________ displays between columns to indicate page breaks and what will be printed on a page. A) moving black line B) horizontal double line C) vertical dotted line D) solid black line vertical dotted line
To simultaneously close your workbook and the Excel program click ____________ from the Office menu. A) End B) Exit Excel C) Close D) Minimize Exit Excel
When you start the Excel program, a new blank ____________ displays. A) workbook B) presentation C) database D) document workbook
The ____________ feature can generate a series of values into adjacent cells based on the value of other cells. A) AutoComplete B) Auto Fill C) AutoFormat D) AutoCorrect Auto Fill
Press ____________ to move the active cell one position to the right. A) Shift + Tab B) Enter C) Shift + Enter D) Tab Tab
If you begin typing, the characters will appear in this cell. A) Active cell B) Adjacent cell C) Dominant cell D) Reference cell Active cell
The action of placing cell contents that have been moved to the Office Clipboard to another location is called: A) deleting. B) copying. C) pasting. D) editing pasting.
____________ is the process of changing the appearance of cells and the overall layout of the worksheet. A) Editing B) Formatting C) Printing D) Justifying Formatting
The mathematical rule that Excel follows to perform calculations is called the: A) order of functions. B) order of operations. C) order of the exponents. D) order of expressions. order of operations.
Press ____________ to display the underlying formulas used in the worksheet. A) [Alt] + [`] B) [Alt] + [*] C) [Ctrl] + [*] D) [Ctrl] + [`] [Ctrl] + [`]
From the Save As dialog box, click ____________ to see a list of the available storage drives. A) the Save in arrow B) Create New Folder C) the toolbar D) the Desktop folder the Save in arrow
Excel comes with many simple graphic illustrations called: A) Stock graphics B) Clip art C) Embedded objects D) Scanned objects Clip art
What is a bar, dot, or other chart symbol that represents one number from the worksheet? A) Data marker B) Data series C) Plot area D) Chart gridline Data marker
This function adds all the numbers given in a range of cells. A) DEC B) INC C) ADD D) SUM SUM
The background of a cell is called the: A) paint. B) highlight. C) border. D) fill color. fill color.
On a column chart, the category labels display along the ____________ axis. A) y B) x C) value D) column x
What is a rectangular block of adjoining cells called? A) A discontiguous range B) A bordering range C) A flanking range D) An adjacent range An adjacent range
A chart that is displayed as an object within a worksheet is called a(n): A) embedded chart. B) chart sheet. C) grid chart. D) chart table. embedded chart.
Created by: motherduck1
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards