How can we help?

You can also find more resources in our Help Center.

25 terms

Excel Final Exam

chapter 1-5 in Microsft Excel 2010 Edition
STUDY
PLAY
The First step in creating an effective workseet is to make sure you __________.
Understand what is required
In Excel, a number can contain the charaters ________.
0 1 2 3 4 5 6 7 8 9
The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________.
receiving range
You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand.
Format
Pressing the _________ keyboard shorcut key(s) selects cell A1.
CTRL + HOME
How many chart types does Excel offer?
11
Which of the following keys is an alternative to double-clicking the cell to edit it?
F2
Which of the following Opton buttons gives options for filling cells following a fill operation?
Auto Fill Options
A ________ cell in Excel has a numerical value of zero.
Blank
The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign.
Formula
The most popular background color is _______.
White
________ text often provides a strong visual appeal.
Underlined
To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________.
Dialog Box Launcher
Which of the following is an extension of the fill patten Sunday, Tuesday?
Thursday, Saturday, Monday
Which of the following formula contains the absolute cell reference?
=$B$4
A(n) _______ chart provides a simple way to show trends and variatons in a range of data whithin a single cell.
Sparkline
The path to the Format Painter button is _______.
Home tab | Clipboard Group
You should use a _______ chart to show the relationship or proportions of parts of a whole.
pie
________ examines the formulas in a workbook in a manner similar to the way the spell checker examines a worknook for misspelled words.
The Fourmula Checker
The data _______ section of a workbook includes data items entered by a user of a worksheet.
Table
A cell _______ often is created from colum or row titles.
Data Table
Which of the following is the path to the Borders button?
Home tab | Font Group
Which of the following is the path to the Name Maneger button?
Formulas tab | Defined Names Group
You can delete a data table by selecting the data table and then _________.
Pressing the DELETE key
When building a worksheet for novice users, you should _________ the cells in the worksheet that you dont want to change, such as cells that contain text or formulas.
Protect