Excel Units – A B C D – Flashcards

In Excel, MAX and AVERAGE are examples of ____.

When cells are copied using Excel's copy function, what happens to the data in the copied cells?

In the formula =ROUND(D4:F4,0), what does the zero indicate?

Which method of entering a function requires the user to know the name and initial characters of a function?

Which formula contains a mixed cell reference?

Functions can be entered for formulas using all of the following methods except ____.

All functions begin with the formula prefix ____.

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

The default file extension for an Excel 2013 workbook is ____.

To insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click Insert Cells.

An Excel user should use a relative cell reference when it is important to ____.

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

The file extension .xltx indicates what type of Excel file?

You can create an absolute cell reference by placing a ____ in front of both the column letter and the row number of the cell address.

Which of the following is NOT a Paste list arrow option?

Once the Office Clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

In the formula =D1+C1/F3, which calculation will be performed first?

Which tab and group will allow the insertion of rows and columns in a worksheet?

You can use ____ to move around in a document that is too large to fit on the screen at once.

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

You can use the ____ key(s) on the keyboard to navigate a worksheet

In a worksheet, the ____ is called the formula prefix.

A(n) ____ is an entry in a cell that contains text such as "2013 Sales" or "Travel Expenses."

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

The ____ option helps fit the data on a single page without making changes to individual margins.

In Excel, the electronic spreadsheet you work in is called a ____.

Excel recognizes an entry as a value if it is a number or it begins with ____.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

To move one screen to the left press ____.

The Undo button allows you to reverse up to ____ previous actions, one at a time.

____ operators perform mathematical calculations such as adding and subtracting.

In Excel, a worksheet is contained in a file called a ____.

The Excel operator for division is ____.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

To quickly jump to the first cell in a worksheet press ____.

Which keyboard shortcut turns on Edit mode?

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

Which type of cell reference preserves the exact cell address in a formula?

Excel templates include which of these common documents?

The COUNTA function is used to count the number of cells in a range that contain which type of data?

Which of the following is a complex formula?

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

The Excel operator for exponent is ____.

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.

You can change, or ____, the contents of an active cell at any time.

To quickly jump to the last cell in a worksheet press ____.

Each value in a cell selected for a chart is called a ____.

To add a shadow to an object, click the ____ button in the Format Chart Title pane, click Shadow, and make the desired selections.

____ lets you create diagram types including List, Process, Cycle, Hierarchy, Relationship, Matrix, and Pyramid.

The x-axis and y-axis are, respectively, the ____.

An example of a(n) ____ chart is a column chart with a line chart.

Shape ____ make it possible to apply multiple formats to a data series, such as an outline, fill color, and text color, all with a single click.

You can change a column chart to a clustered bar chart using the ____ dialog box.

You can add a text box using the CHART TOOLS ____ tab.

Which of the following will NOT be affected or rearranged by choosing a new layout on the CHART TOOLS DESIGN tab?

Which chart type is the best candidate for emphasizing sales trends over a period of 6 months?

____ marks indicate the scale of measure for each value on the y-axis.

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

A collection of related data points is called a ____.

You can ____ the chart title text to select it.

Which two charts compare trends over time intervals?

A combination chart can add a(n) ____ axis to chart related data.

Text annotations are ____ that you can add to further describe the data in your chart.

The default border color around a chart title is ____.

Which chart type is the best candidate for spotting trends and extrapolating information based on research data?

In a pie chart, slices that are pulled away are said to be ____.

To show how individual volume changes over time in relation to total volume, use a(n) ____.

A scatter chart ____.

____ shows you how a fill color will look before you apply it.

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____.

$

To format a cell or range, first you select it, and then you apply the formatting using the ____, the Mini toolbar, or a keyboard shortcut.

###### in a cell means that the ____.

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

____ formatting is automatically updated if you change data in the worksheet.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

The default Accounting number format adds dollar signs and ____ decimal places to the data.

The ____ of a cell determines how the labels and values look.

A ____ is an individual media file, such as art, sound, animation, or a movie.

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

Which of the following removes only the contents of a selected row or column?

The default format for cells that meet a condition with conditional formatting is ____.

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

You can apply font styles and alignment options using the ____ dialog box.

The Format Painter button is found in the ____ group on the HOME tab of the Ribbon.

You can change the ____ of labels and values in cells to be left, right, or center.

Cell ____ are predesigned combinations of formats.

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the HOME tab, and then click a style in the gallery.

You can add multiple worksheets to a workbook by clicking the HOME tab on the Ribbon, pressing and holding ____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clicking the Insert list arrow in the Cells group on the HOME tab, then clicking Insert Sheet.

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

The ____ size is the physical size of the text.

Cells and ranges in a worksheet can be formatted ____.

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

A pie chart ____.

A(n) ____ identifies each data series in a chart, generally with a different color.

Which chart type do you use to compare distinct objects over time using horizontal bars?