CISM 1110 - Excel Exam

Excel displays a series of ________________ symbols if a cell width is too narrow to display an entire number.

#

Text or numbers in a cell.

Data

=

Equal to

A cell surrounded by a black border and ready to receive the data is the:

Active cell

Which of the following is NOT a way to create a formula? a. By using a Function button b. By typing c. By using a data marker d. By using point-and-click

By using a data marker

The area along the bottom of a chart that identifies the categories of data is the:

Category axis

The intersection of a column and a row.

Cell

Another name for a cell reference.

Cell address

Anything typed into a cell.

Cell content

The graphic representation of data in a worksheet.

Chart

A vertical group of cells in a worksheet.

Column

The worksheets that contain the specifics of the information summarized on a summary sheet are called ______________ sheets.

Detail

To rename a worksheet, you _________________ its sheet tab and type a new name.

Double-click

This key moves down one cell.

Enter

The operator symbol ^ denotes that ___________________.

Exponentiation

True or False: A summary sheet is a series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet.

False

True or False: A theme is a predefined set of colors, fonts, line and fill effects that are applied to a range of cells.

False

True or False: A totals worksheet displays and summarizes totals from other worksheets.

False

True or False: An absolute cell reference is a reference based on the relative position of the cell that contains a formula and the cells that are referred to in the formula.

False

True or False: Changing the theme colors of a workbook also changes the theme fonts and effects.

False

True or False: Clicking the Spelling Button begins the spell check in A1.

False

True or False: Ctrl + P is the keyboard shortcut for Paste.

False

True or False: F2 is the shortcut key to display Print Preview.

False

True or False: The Task Bar displays information such as the current cell mode, page number, and common calculations such as Sum and Average for numerical data.

False

True or False: The default width of a column is 100 pixels.

False

Predefined formula that performs calculations using specified values.

Function

When pasting, the Paste Options _________________ uses Live Preview to preview Paste formatting options.

Gallery

The default format that Excel applies to numbers is the:

General format

>

Greater than

>=

Greater than or equal to

This key moves to Column A of the current row.

Home

<

Less than

<=

Less than or equal to

The _________________ function retrieves the date and time from the computer's calendar and clock and inserts the information into the selected cell.

NOW

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:

Name box

_____________ view maximizes the number of cells displayed on the screen, keeping column letters and row numbers close to the columns and rows.

Normal

Constant values consisting only of numbers.

Number values

Which of the following keyboard shortcuts moves the location of the active cell up one full screen? a. Control + Home b. Home c. PageUp d. Control + PageUp

PageUp

Bounded by and separated from other portions by vertical and horizontal bars.

Pane

A ________________ chart shows the relationship of each part to a whole.

Pie

To group all worksheets in a workbook, ______________________________.

Point to one of the tabs, right-click, and click Select All Sheets

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

Quick Analysis tool

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Range finder

The Spelling Button is located on the ____________________.

Review tab in the Proofing group

The _____________ ______________ ________________ button displays various ways you can display the ribbon - the default is Show Tabs and Commands.

Ribbon Display Options

A horizontal group of cells in a worksheet.

Row

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Select all box

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

Sparklines

In a chart, another name for the y-axis is __________________.

The value axis

True or False: A text value in a cell is also called a label.

True

True or False: An absolute cell reference refers to a cell by its fixed location in the worksheet.

True

True or False: Clearing the contents of a cell deletes the cell's value or formula but does not clear the cell's formatting.

True

True or False: In Excel, all formulas begin with the = sign.

True

True or False: Sheet tabs are used to navigate among worksheets.

True

True or False: Sparklines are tiny charts embedded in a cell alongside the data that provide a visual trend summary.

True

True or False: The Freeze Panes command enables you to select one or more rows or columns and then lock them into place.

True

True or False: The Show Formulas command is used to display the formula in each cell instead of the resulting value.

True

True or False: When a change is made to the value in a cell that is referenced in a formula, Excel recalculates the result.

True

To print all the worksheets in a workbook, while in Print Preview, ____________________________.

Under Settings, click Print Active Sheets, and then click Print Entire Workbook.

The data that displays in the Formula Bar is referred to as the:

Underlying value

Another name for a constant value.

Value

Which of the following statements about dates is FALSE?

When entering dates, a two-digit year value of 30 through 99 is interpreted by Windows as the four-digit years of 1930 through 2099.

An Excel file that contains one or more worksheets.

Workbook

The process of specifying the appearance of cells and the overall layout of a worksheet is referred to as _______________.

Formatting

An equation that performs mathematical calculations on values in a worksheet.

Formula

The symbols with which you can specify the type of calculation you want to perform is an Excel formula are:

Operators

True or False: To rotate text, point to the red diamond and drag the diamond upward until the Degrees box indicates the desired number of degrees.

True

True or False: When moving a sheet tab, a caret and a small paper icon attached to the pointer appear.

True

True or False: When using a function, the values in parentheses are called parameters.

True

On startup, Excel displays a new blank:

Workbook

Numbers, text, dates, or times of day that you type into a cell.

Constant value

Which of the following shortcut keys displays Print Preview? a. Shift + F2 b. Control + F4 c. Control + F2 d. Shift + F4

Control + F2

Conditions specified in a logical function.

Criteria

This key combination moves to cell A1.

Ctrl + Home

Cell format that provides a visual indication about the value of a cell relative to other cells.

Data bar

True or False: When worksheets are grouped, [Group] appears in the status bar.

False

True or False: ≠ is the comparison operator for not equal to.

False

The small black square in the lower right corner of a selected cell.

Fill handle

The ________________ ________________ displays the value or formula contained in the active cell; permits entry or editing of the active cell.

Formula Bar

The underlying formula is displayed in the ____________ ____________.

Formula Bar

The labels along the lower border of the Excel window that identify each worksheet.

Sheet tabs

This key combination moves up one cell.

Shift + Enter

This key combination moves left one cell.

Shift + Tab

The _________________ command divides the window into multiple resizable panes that contain views of your worksheet.

Split

Another name for a worksheet.

Spreadsheet

The ________ _________ displays the view and zoom buttons.

Status bar

A cell _________ is a set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Style

The _____________ ________________ _______________ displays the columns and rows that intersect to form the worksheet's cells.

Worksheet grid area

_______________ changes the appearance of a cell based on criteria.

A conditional format

In a chart, another name for the x-axis is _________________.

The category axis

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Absolute

__________-__________ ____________ minimize, close, or restore the previous size of the displayed workbook.

Application-level buttons

Values that an Excel function uses to perform calculations or operations.

Arguments

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:

Auto Fill

The _______________ feature creates and extends values into adjacent cells based on the values of selected cells.

Auto Fill

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

AutoFit

You would apply a __________________ to a table to display a portion of the data matching the criteria you specify.

Filter

Excel's _______________ feature recognizes a pattern in data and automatically fills in values when you enter examples of desired output.

Flash Fill

An element in the Excel window that displays the value or formula contained in the active cell is the:

Formula Bar

Which of the following is NOT a common Excel chart type? a. Line b. Matrix c. Pie d. Column

Matrix