Shared Flashcard Set

Details

Excel
Excel
32
Computer Networking
Undergraduate 1
12/20/2010

Additional Computer Networking Flashcards

 


 

Cards

Term
Worksheet
Definition
Electronic spreadsheet you work in, (excel)
Term
Workbook
Definition
is where a worksheet is contained, and it uses file extension .xlsx.
Term
In Excel what do formulas begin with?
Definition
equal sign (=)
Term
Excel recognizes an entry as a value if?
Definition
it is a number or it begins with one of the following symbols.+,-,=,@,#,$
Term
what are ways to move around in excel?
Definition
arrow keys for one cell at a time, Page up or down to move a screen at a time, alt page up, to move a screen to the left.Alt page down, moves a screen to the right.Ctrl Home takes u back to A1, Ctrl end takes u to the end
Term
what does the autosum button on the ribbon do?
Definition
quickly inserts SUM function,the arrow will allow other functions such as Average
Term
When u click insert function button?
Definition
equal sign appears, and insert function dialouge box appears
Term
how do u insert cells?
Definition
click the insert button list arrow in the cells group on the home tab, then click insert cells. Dialogue box appears to verify.
Term
how do u create an absolute cell reference?
Definition
Placing a dollar sign in front of both the column letter and row number of the cell address
Term
workbook extension?
Definition
.xlsx.
Term
Template extension?
Definition
xltx
Term
What does the format of a cell determine?
Definition
how the labels and values look
Term
how do u format a cell or range?
Definition
Select it, then apply formatting by using the ribbon or a keyboard shortcut
Term
when can u apply formatting?
Definition
before or after u enter data
Term
what adds dollar signs and two decimal places to data?
Definition
default Accounting Number
Term
how do u apply attributes and alignment options?
Definition
using home tab, Format Cells dialog box, or mini toolbar
Term
A small red triangle appears in corner
Definition
adding and editing comments
Term
how do u add enhancements?
Definition
use border and fill color, and front group on the home tab of the ribbon and on the mini toolbar
Term
predesigned combinations of formatting attributes?
Definition
Cell styles
Term
How do u do a replace?
Definition
Click home tab,click find and select in editing, then replace
Term
what info goes on x-axis?
Definition
Locations
Term
what goes on y-axis?(vertical)
Definition
sales
Term
where are tick marks?
Definition
L. edge of vertical axis
Term
value in a cell u select?
Definition
data point
Term
Column?
Definition
verticle format, excel default, sometimes referred to as a bar chart
Term
Line
Definition
campares trends over even time intervals,and looks similar to an area chart
Term
Pie
Definition
Compares sizes of pieces as part of a whole,single series number
Term
Bar
Definition
using horizontal format,
Term
area
Definition
shows individual volume changes over time in relation to total volume
Term
scatter
Definition
Compares trends over uneven time.used in scientific and engineering
Term
how do u change the chart type in type group?
Definition
modify the data range and configure in the data group, change layout.choose colors,and location
Term
if u create a pie chart how can u emphasize one data point?
Definition
exploding
Supporting users have an ad free experience!