Excel Exam Study Guide

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

A pie chart can be rotated up to

360 degrees.

Cell style

A defined set of formatting characteristics such as font, font size, and font color.

Use the Home tab to

AutoFit column widths.

The keyboard shortcut to display Print Preview is

Ctrl + F2.

3

D is short - for three-dimensional.

You can create a custom footer in

Excel.

Using a Function button on the status bar is

NOT a way to create a formula.

Alt + =

SUM function

In Goal Seek, you enter the specific value that you want to achieve in the

To value box.

Data series

a group of related data points.

Value

a number, date, or time of day.

Excel table

a series of rows and columns that contains related data that can be managed independently from other.

Data bar

a shaded bar that provides a visual cue about the value of a cell relative to other cells.

Fund

a sum of money set aside for a specific purpose.

Label

a text value.

Data point

a value that originates in a worksheet cell and is used in a chart.

Chart sheet

a worksheet that contains only a chart.

AVERAGE function

adds a range of cells and divides by the number of values in the range.

SUM function

adds a range of cells.

Worksheet

also known as a spreadsheet.

Formula

an equation that performs mathematical calculations.

A logical test is

any value or expression that you can evaluate as true or false.

Logical test

any value or expression with a true or false result.

Sort

arranges data in a specific order.

If two cells are merged into one, the cell contents are

automatically centered in the new, merged cell.

In a line chart, the x

axis resides - along the bottom of the chart.

Axis

border a chart plot area.

The <, >, and <>

can be described as comparison operators.

Use the Page Layout tab to

change a worksheet to landscape orientation.

Relative cell reference

changes when a formula is copied and pasted.

A chart and all of its elements is known as the

chart area.

IF function

checks whether a condition is met and returns a true or false value.

Comparison operator

compares values in an Excel function or formula.

The COUNT function

counts the number of cells in a range that contain a number.

COUNT function

counts the number of cells in a range that contain numbers.

COUNTIF function

counts the number of cells in a range that meet the given Condition.

Use the Insert tab to

create a recommended chart.

Ctrl + X

cut

You can use the Switch/Row Column command to swap data over the axis

data being charted on the vertical axis will move to horizontal axis and vice versa.

Use the Formulas tab to

display formulas on the screen.

Filter

displays only a portion of data that matches a criteria

The status bar

displays the current cell mode, the page number, and the zoom buttons.

Spreadsheet

displays upon startup of Excel.

Workbook

displays upon startup of Excel.

Absolute cell reference

does not change when a formula is copied and pasted.

Move Chart button

does not display to the right side of a selected chart.

You can edit the data or a label in a cell by

doubleclicking the cell and then positioning the insertion point within the cell.

The Freeze Panes command

enables you to select one or more rows or columns and then (lock) them into place.

Chart area

entire chart and all of its elements.

Banded rows display when

even rows are formatted differently from odd rows.

Use the File tab to

export a document as a PDF file.

Conditional format

formatting applied to a cell based on criteria.

On your keyboard, the hyphen key and the forward slash key

function identically in date formats.

Row

group of horizontal cells on a worksheet.

Column

group of vertical cells on a worksheet.

Legend

identifies the data markers in a chart.

The # symbol in Excel is used to

indicate that a cell is not wide enough to display a formula or function result.

Alt + = is a way to

insert the SUM function into a cell.

Cell

intersection of a row and column.

A data series

is a group of related data points represented by data markers.

Freeze

keeps rows or columns fixed.

Consecutive operators with the same level of precedence are calculated from

left to right.

When you type text in a cell it is

left-aligned.

MEDIAN function

locates the middle value in a range of cells.

The sheet tabs display on the

lower area of the workbook window.

Enterprise fund

money for municipal services for which a fee is charged.

General fund

money set aside for the normal operating activities of a city.

In Excel 2016, row headings are identified by

numbers.

The Format Painter button is located

on the mini toolbar and the Home tab.

Ctrl + V

paste

Ctrl + F2

print preview

The Flash Fill function in Excel

recognizes a pattern in the data of a worksheet.

When you copy a formula to another cell and the cells in the formula change, the cells are known as

relative cell references.

F4

repeat

Excel's NOW function

retrieves the date from the computer's clock.

Hold down the Ctrl key to

select nonadjacent cells.

Split

separates a window into panes.

Pie chart

shows the relationship of parts to a whole.

When using a touchscreen,

tapping the item is the same as clicking an item.

The $ symbol represents

that a cell is an absolute cell reference in a function or formula.

A filter icon indicates

that a filter is applied to the data in the table.

A green plus sign identifies

the Chart Elements button when you select a chart.

To size a chart proportionately, hold down

the Shift key and drag a corner sizing handle.

An outlined cell in a worksheet is

the active cell.

General format, Calibri, 11 pt is

the default number format in Excel 2016.

In Goal Seek, the Set cell box contains

the formula that calculates the information you seek.

A pie chart shows

the relationship of each part to a whole.

When a new column is inserted into a worksheet

the remaining columns move to the right.

Data marker

the representation in a chart of a value from a worksheet.

To indicate a range, include a colon between

the two cell references.

You must select two ranges on a worksheet

to create a pie chart.

Volatile

updates automatically.

You can leave the year off entirely

when typing a date into a cell.

If a sheet tab has a background color

you know that it is not selected.

The Percent Style button formats selected cells as a percentage with

zero decimal places.


Ensembles d'études connexes

Test 3 - Otitis media and conjunctivitis

View Set

Management Chapter 4 Practice Questions

View Set

16th Century Northern Europe III: England, 16th Century Northern Europe II: Spain, Portugal, and the Netherlands, Art Chinese and korean., Japanese art

View Set