Shared Flashcard Set

Details

Excel Review
Excel Questions
45
Computer Networking
Undergraduate 1
11/15/2012

Additional Computer Networking Flashcards

 


 

Cards

Term
Formula prefix
Definition
Equal sign preceding a formula
Term
Normal view
Definition
Default view in Excel
Term
Name box
Definition
Part of the Excel program window that displays the active cell address
Term
Cell
Definition
Intersection of a column and a row
Term
Orientation
Definition
Direction in which contents of page will print
Term
Workbook
Definition
File consisting of one or more worksheets
Term
255
Definition
The maximum number of worksheets you can include in a workbook is:
Term
Cell reference
Definition
Using a cell address in a formula is known as:
Term
Scale to Fit
Definition
Which feature could be used to print a very long worksheet on a single sheet of paper?
Term
Range
Definition
A selection of multiple cells is called a:
Term
View
Definition
Which worksheet view shows how your worksheet will look when printed?
Term
[F2]
Definition
Which key can you press to switch to Edit mode?
Term
Page Break Preview
Definition
Which view shows you a reduced view of each page of your worksheet?
Term
Backstage view
Definition
In which area can you see a preview of your worksheet?
Term
Page Layout view
Definition
 
In which view can you see the header and footer areas of a worksheet?
Term
Fill handle
Definition
Lets you copy cell contents or continue a series of data into a range of selected cells.
Term
Dialog box launcher
Definition
Item on the Ribbon that opens a dialog box or task pane
Term
Drag-and-drop method
Definition
Lets you move or copy data from one cell to another without using the Clipboard
Term
[Delete]
Definition
Clears the content of selected cells
Term
Formula AutoComplete
Definition
Displays an alphabetical list of functions from which you can choose
Term
[Ctrl]
Definition
Which key doyou press to copy while dragging and dropping selected cells?
Term
Mixed
Definition
What type of reference is C$19?
Term
Relative
Definition
What type of cell reference changes when it is copied?
Term
[F4]
Definition
Which key do you press to convert a relative cell reference to an absolute cell reference?
Term
Clipboard
Definition
You can use any of the following features to enter a function except:
Term
Conditional Formatting
Definition
Changes formatting of a cell that meets a certain rule.
Term
Spelling button
Definition
Checks for apparent misspellings in a worksheet
Term
[Ctrl][Home]
Definition
Moves cell pointer to cell A1
Term
[$]
Definition
Adds dollar signs and two decimal places to selected data
Term
$5,555.55
Definition
Which of the following is an example of Accounting number format?
Term
Conditional Formatting Rules Manager
Definition
What feature is used to delete a conditional formatting rule?
Term
[I]
Definition
Which button removes the italic font style from selected cells?
Term
AutoFit
Definition
What is the name of the feature used to resize a column to accommodate its widest entry?
Term
Which button increases the number of decimal places in selected cells?
Definition

.00 

 

*if decmial with <- like that it be increasing

Term
the paintbrush icon
Definition
Which button copies multiple formats from selected cells to other cells?
Term
Column
Definition
Compares data using columns
Term
Line
Definition
Compares trends over even time intervals
Term
Combination
Definition
Displays a column and line chart using different scales of measurement
Term
Pie
Definition
Compares data as parts of a whole
Term
Area
Definition
Shows how volume changes over time
Term
Legend
Definition
The object in a chart that identifies the colors used for each data series is a(n):
Term
Chart Tools Format
Definition
Which tab appears only when a chart is selected?
Term
Click a button on the Chart Tools Design tab
Definition
How do you move an embedded chart to a chart sheet?
Term
Insert
Definition
Which tab on the Ribbon do you use to create a chart?
Supporting users have an ad free experience!