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 1

QuestionAnswer
in an Excel worksheet, where is the address of the active cell displayed Name Box
After clicking in a cell in an Excel worksheet, what happens to that cell? It is active cell
Which of the following elements is unique for each cell in an Excel worksheet? Cell address
Which of the following statements best defines "fill" in an Excel worksheet? Background color for a cell
What does the [Ctrl] + [Home] keyboard combination do in an Excel worksheet? Moves the insertion point to cell A1
When you see a value or percentage within a pie slice on an Excel chart, which of the following objects has been added to the chart? Data labels
If you see # # # # # in a column in an Excel worksheet, what is wrong? Column is too narrow
What is the name for the toolbar that appears when you select text in a cell or right-click a cell? Mini toolbar
Which of the following views for an Excel worksheet includes margins, headers/footers, and the rulers? Page layout
How can you make a row in an Excel worksheet taller? Drag the border between it and the row below it
As data is keyed in an Excel worksheet, in which of the following locations is it visible? Formula bar
Which of the following addresses is a valid cell range address in an Excel worksheet? A1:C4
Which of the following arithmetic operations is represented by an asterisk (*) in an Excel workbook? Multiplication
Which Excel chart type is good for depicting a single set of values? Pie
What two font categories are included in a document theme for an Excel workbook? Headings and Body
Which group on the Home command tab includes commands for formatting how a date is displayed in an Excel worksheet? Number
Which of the following steps completes a cell entry in an Excel worksheet and moves the pointer one cell to the right? Pressing [Tab]
In an Excel worksheet, what does B3:D15 represent or indicate? A cell range
Which of the following Excel features displays a list of functions that begin with the letter that you key after an = sign? Formula AutoComplete
Which of the following categories best describes the two basic data types used in an Excel worksheet? Labels and values
With three rows and five columns of labels selected, which of the following Excel commands would center all labels across a selected range? Center Across Selection
Which of the following alignment commands moves data away from the cell's edge for better readability of values and labels in an Excel worksheet? Indent
What are three data visualization types available for an Excel worksheet? Data bars, Color scales, and Icon sets
Which of the following commands combines a range of cells into one cell that occupies the same amount of space in an Excel worksheet? Merge and Center
In an Excel worksheet, how do you display the drag-and-drop pointer for a cell? Hover over the cell's border
How many cut or copied items can be stored in the Office Clipboard for an Excel Worksheet? 24
Which of the following statements is trues about cells to be merged using the Merge and Center command in an Excel worksheet? The range should be empty except for the top-left cell
In an Excel worksheet, which of the following objects is checked by the Spelling command/ Labels
If a zero in a value does not affect the actual number in a cell, which of the following terms is used to describe the zero in an Excel worksheet? Insignificant
In a custom Excel number format, which of the following characters or symbols signify that a digit is required? 0
Which of following Excel formulas is the correct representation of a formula that is to be entered in cell C5? =B6+B15
Which of the following commands both belong to the conditional format group for an Excel worksheet? Data bars and highlight cells rules
Which of the following cell references is an example of a mixed reference in an Excel worksheet? $B1
Which of the following arithmetic operators will; be calculated first if all of them are used in the same Excel formula? ^ (exponentiation)
Which of the following is a reason to display Excel formulas in a worksheet instead of the formula results? They provide documentation of the work
Which of the following definitions is correct for a whole number in an Excel worksheet? A value with no decimal positions
How could the Excel formula =B3*B4+B12 be shown so that the result of adding cells B4 and B12 is multiplied by the value in cell B3? =B3*(B4+B12)
What would be the result of this Excel formula: =2*4/4? 2
What does the keyboard shortcut [Ctrl] + [~] do in an Excel worksheet? Displays formulas in a worksheet
What type of Excel formula would be best suited to calculating a percentage result for a business problem? Division
Created by: Abby Whitman
 

 



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