Chapter 1 Excel – Flashcards
Unlock all answers in this set
Unlock answersquestion
Chart
answer
A _____ conveys a visual representation of data.
question
Planning
answer
Careful _____ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.
question
Mouse Pointer
answer
The easiest way to select a cell is to move the block plus sign _______ to the cell and then click.
question
Columns
answer
Worksheet _____ typically contain descriptive info about items in rows or contain info that helps to group the data in the worksheet.
question
Name Box
answer
You can select any cell by entering its cell reference in the ______.
question
Active
answer
The cell into which data is being entered is referred to as the ____ cell.
question
BACKSPACE
answer
While typing in a cell, you can press ____ to delete all the characters back to and including the incorrect character you just typed.
question
Formula Bar
answer
As you type, excel displays the entry in the ____ and also displays the cancel box and the enter box on the formula bar.
question
Autocorrect
answer
____ corrects two initial capital letters by changing the second letter to a lowercase.
question
Arrow
answer
If the next entry you want to make is in an adjacent cell, us the ___ keys to complete the entry in the current cell and activate the adjacent cell.
question
SUM Function
answer
Excel's ____, which adds all the numbers in a range of cells, provides a convenient means to calculate a total.
question
Sum
answer
You can click the ___ button arrow (Home Tab | Editing Group) to view a list of often used functions.
question
Relative Reference
answer
Automatically adjusted cell reference in a pasted formula
question
Auto Fills Option
answer
Allows you to choose whether you want to copy the values from the source area to the destination area or without formatting it.
question
Font Size
answer
An increased ____ gives more impact to the text in a cell.
question
Font Style
answer
Indicates how text characters are emphasized
question
Calibri
answer
Default font for a news workbook is ____ 11 point regular black.
question
Merging
answer
Involves creating a single cell by combining 2 or more selected cells
question
Line
answer
Chart often used to illustrate data over time.
question
Sheet
answer
You click the ____ tab of the worksheet you want to view in the excel window.
