Shared Flashcard Set

Details

MicroComputerApps
Excel Test 3
40
Other
11/07/2012

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 order1.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
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 markersCorrect Response 4) all of the above
Term
 Excel is an electronic version of a(n) ____.
Definition
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
Supporting users have an ad free experience!