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
