Shared Flashcard Set

Details

MicroComputerApps
Excel Test 3
40
Other
11/07/2012

Additional Other Flashcards

 


 

Cards

Term
Excel has only two conditional formats-data bars and highlighting.
True or false
Definition
False
Term
A(n)____ is a group of cells
Definition
Range
Term
Auto-fill, which content and formats from a cell or range into an adjacent cell or range. True or False
Definition
True
Term
What takes precedence over multiplication
Definition
exponentiation
Term
a table style treats the table as a single object rather than a collection of cells. True or False
Definition
True
Term
From formula view, press ____ to switch the worksheet back to normal view.
Definition
Ctrl + '
Term
A _____ acts like a line or ruler, making it easier to read a chart's scale.
Definition
major tick mark
Term
What would result in adding the value 'k' to the end of each number on a chart's vertical axis?
Definition
#,##0"k"
Term
Charts can be embedded into worksheets.
True or False
Definition
True
Term
Put the following steps for selecting a nonadjacent range of cells in the proper order

1.select an adjacent range of cells.
2.With Ctrl key still pressed, continue to select other cell ranges until all of the ranges are selected.
3. Release the mouse button and Ctrl key.
4.Press and hold the Ctrl key, and then select another adjacent cell range.
Definition
1,4,2,3

-Select an adjacent range of cells,
-press and hold the control key, and then select another adjacent cell range.
-With the control key still pressed continue to select other cell ranges until all of the ranges are selected.
-release the mouse button and the control key.
Term
in the formula, =2+6*2, addiction would be calculated after multiplication.
true or false
Definition
True
Term
A chart can be displayed ____.
Definition
In a worksheet and in a chart sheet
Term
removing the contents of a cell is known as _____ a cell.
Definition
Clearing
Term
=INT(AVERAGE(A1:A100)) is an example of a(n) _____ function.
Definition
nested
Term
you can open the format cells dialog box by right-clicking a cell or selecting range, and then clicking ____ on the shortcut menu.
Definition
Format cells
Term
a newly inserted row has the same height as the row above it.
TRUE OR FALSE
Definition
true
Term
"AD" is an example of a ______.
Definition
column heading
Term
Although dates and times in Excel appear as text, they are actually numbers.
TRUE OR FALSE
Definition
true
Term
Modifying the number formats affects the value stored int eh workbook.
TRUE OR FALSE
Definition
false
Term
To display Mar 17, 2008 as a custom format, you would type___ in the Format Code:box in Excel
Definition
mmm dd, yyyy
Term
The ____ is a rectangular area that labels the markers or symbols used in a chart.
Definition
legend
Term
Which of the following shows the correct order of steps for adding a data series to a chart?
Definition
Select the chart, Click the Select Data button, Click the Add button, Select the range
Term
By default, Excel inserts a chart as an embedded chart.
Definition
1)
True
Term
When a worksheet is printed, the gridlines that surround the cells are printed by default.
Definition
False
Term
Calculated values too large to fit into the cell are displayed in scientific notation.
Definition
TRUE
Term
Placing a chart in a ____ displays only the chart and no worksheet cells.
Definition
chart sheet
Term
The range reference for nonadjacent ranges separates each adjacent range reference by a colon.
Definition
false
Term
As a general rule, you should ____
Definition

center column titles, left-align text, and right-align numbers
Term
To go to column A of the current row, click ____.
Definition
Home
Term
What is the result of the expression =50/(10*5)?
Definition
1
Term
Italic, bold, bold italic, and underline are examples of ____.
Definition

font styles
Term
In a column chart, you can ____.
Definition
1)
add a gradient fill to columns
2)
reduce gap width between columns
3)
modify the appearance of data markers
Correct Response 4)
all of the above
Term
Excel is an electronic version of a(n) ____.
Definition
spreadsheet
Term
If an optional argument is not included, Excel assumes a(n) ____ value for it.
Definition

default
Term
Removing the contents of a cell is known as ____ a cell.
Definition
clearing
Term
If a formula contains several functions, Excel starts with the outermost function and then moves inward.
Definition
False
Term
In the Function Arguments dialog box, required arguments are in bold type.
Definition

True
Term
In Excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
Definition

False
Term
To view formulas, rather than the resulting values in a worksheet, switch to ____.
Definition

formula view
Term
In the Format Axis dialog box, selecting Fixed 0.10 for the Minor Unit will result in ____.
Definition

minor tick marks appearing at 10% intervals