tap the item |
When using a touchscreen, which of the following actions is the same as clicking an item? |
flash fill |
Which of the following Excel features recognizes a pattern in the data of a worksheet? |
IT SHOWS THE RELATIONSHIP OF EACH PART TO A WHOLE |
Which of the following is TRUE about a pie chart? |
ABSOLUTE CELL REFERENCE |
A(N) __________________ refers to a cell by its fixed position in the worksheet |
$ |
Which symbol represents that a cell is an absolute cell reference in a function or formula? |
CTRL key |
Use the_________ to select A5:A8 and D5:D8 |
TWO RANGES |
You must select ______________on a worksheet to create a pie chart |
A DATA SERIES |
is a group of related data points represented by data markers |
.A DATA LABEL |
in a pie chart identifies the pie slices |
IT IS A GREEN PLUS SIGN |
How can you identify the Chart Elements button when you select a chart? |
HEIGHT |
Which of the following is NOT one of the three spatial dimensions of 3-D? |
UP TO 360 DEGREES |
To what extent can a pie chart be rotated? |
CHART AREA |
A Chart and all of its elements is known as the |
THE PIE SLICES WILL BE AUTOMATICALLY UPDATED |
If you edit data in a worksheet that is associated with a pie chart |
GOAL SEEK |
is an Excel tool that finds the input needed to arrive at a desired result. |
SET CELL |
In Goal Seek,_________ the box contains the formula that calculates the information you seek |
When using a touchscreen, which of the following actions is the same as clicking an item? |
TAP THE ITEM |
Which of the following Excel features recognizes a pattern in the data of a worksheet? |
FLASH FILL |
Which of the following is TRUE about a pie chart? |
IT SHOWS THE RELATIONSHIP OF EACH PART TO A WHOLE. |
A(N) ABSOLUTE CELL REFERENCE |
refers to a cell by its fixed position in the worksheet |
Which symbol represents that a cell is an absolute cell reference in a function or formula? |
$ |
Use the |
CTRL key to select A5:A8 and D5:D8 |
Two RANGES |
you must _____________ on a worksheet to create a pie chart |
A DATA SERIES |
is a group of related data points represented by data markers |
A DATA LABEL |
in a pie chart identifies the pie slices |
How can you identify the Chart Elements button when you select a chart? |
IT IS A GREEN PLUS SIGN |
Which of the following is NOT one of the three spatial dimensions of 3-D? |
HEIGHT |
To what extent can a pie chart be rotated? |
UP TO 360 DEGREES |
A Chart and all of its elements is known as the |
CHART AREA |
If you edit data in a worksheet that is associated with a pie chart |
THE PIE SLICES WILL BE AUTOMATICALLY UPDATED |
GOAL SEEK |
is an Excel tool that finds the input needed to arrive at a desired result. |
set cell |
IN goal seek the ___________box contains the formula that calculates the information you seek |
In Goal Seek, you enter the specific value that you want to achieve in the____________________box |
TO VALUE |
When you print a chart sheet, how is it automatically formatted? |
IT IS CENTERED ON THE PAGE |
The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as |
WHAT IF ANALYSIS |
Which of the following is the first order of operations? |
EXPRESSIONS WITHIN PARENTHESES |
Which of the following is the second order of operations? |
EXPONENTIATION |
Where is the Format Painter button located? |
ON THE MINI TOOLBAR AND THE HOME TAB |
AutoFill will fill a series when you establish a pattern |
WITH TWO OR MORE CELLS |
Which of the following displays trends over time? |
A LINE CHART |
Which of the following resides along the left side of a column chart? |
THE Y AXIS |
To size a chart proportionately, hold down the |
SHIFT key and DRAG A CORNER SIZING HANDLE |
In a line chart, which of the following resides along the bottom of the chart? |
THE X AXIS |
What is the keyboard shortcut for flash fill? |
CTRL + E |
Which of the following is NOT a way to insert the SUM function into a cell? |
CTRL += |
The MEDIAN function finds |
THE MIDDLE VALUE IN A RANGE OF CELLS |
Which symbols does Excel use to indicate that a cell is not a wide enough to display a formula or function result? |
# |
To rotate text in a worksheet in the Format Cells dialog, you can click and drag the |
RED DIAMOND |
The quickest way to repeat an action in Excel is the |
F4 function key. |
The COUNT function counts the number of cells in a range that |
CONTAIN A NUMBER |
The COUNTIF function has two arguments |
THE RANGE OF CELLS TO CHECK AND THE CRITERIA |
The <, >, and can be described as |
COMPARISON OPERATORS |
What does a data bar in a cell represent? |
THE VALUE OF A CELL RELATIVE TO OTHER CELLS |
Where does Excel's NOW function retrieve the date from? |
THE COMPUTER'S CLOCK |
Which of the following is FALSE about the NOW function? |
IT REMAINS CONSTANT EVEN WHEN THE WORKBOOK IS OPENED |
What is a pane bounded by? |
VERTICAL OR HORIZONTAL BARS |
What is an Excel table? |
A SERIES OF ROWS AND COLUMS THAT CONTAINS RELATED DATA THAT CAN BE MANAGED INDEPENDENTLY FROM OTHER DATA IN A WORKSHEET |
How do you know if some rows of a table have been hidden from view when a filter is invoked? |
ROW NUMBERS DISPLAY IN BLUE |
How do banded rows display? |
EVEN ROWS ARE FORMATTED DIFFERENTLY FROM ODD ROWS |
In a large worksheet, which two Excel commands help to make the worksheets attractive and easier to read? |
PRINT TITLES AND SCALE TO FIT |
When formatting a worksheet to be printed, |
DOTTED LINES show where page breaks are located. |
Where do sheet tabs display in a workbook? |
LOWER AREA OF THE WORKBOOK AREA |
What are the default names of worksheets? |
SHEET1, SHEET2, ETC |
Which of the following is FALSE about worksheet tabs? |
THE ACTIVE WORKSHEET TAB DISPLAYS IN RED FONT |
On your keyboard, which two symbols function identically in date formats? |
THE HYPHEN KEY AND THE FORWARD SLASH KEY |
CLIPBOARD |
is the temporary storage location for cell contents copied from a worksheet |
background color |
If a sheet tab has a _________________________ you know that it is not selected |
In the Excel window, where does display when worksheets are grouped? |
ON THE TITLE BAR |
Sheet tab names are ___________________when they are grouped |
UNDERLINED |
What is a summary sheet? |
A WORKSHEET WHERE TOTALS FROM OTHER WORKSHEETS ARE DISPLAYED |
Using a touchscreen, which of the following actions is the same as right-clicking the mouse? |
PRESS AND HOLD FOR A FEW SECONDS |
Which of the following is FALSE about a workbook? |
IT CAN CONTAIN ONLY ONE WORKSHEET |
STATUS BAR |
displays the current cell mode, the page number, and the zoom buttons. |
In Excel 2016, row heading are identified by |
NUMBERS |
A text value in Excel is also referred to as a |
LABEL |
When you type data in a cell and press Enter, what cell becomes the active cell? |
THE CELL BELOW |
When you type text in a cell it is |
LEFT ALIGNED |
Where is the fill handle located? |
IN THE LOWER RIGHT CORNER OF A SELECTED CELL |
Which of the following is the default number format in Excel 2016? |
GENERAL FORMAT, CALIBRI 11 PT |
All formulas begin with a(n) |
= SIGN |
When a cell is part of an active formula, it is surrounded with |
A COLORED BORDER WITH SMALL BOXES ON EACH SIDE |
Which of the following is NOT a way to create a formula? |
BY USING A FUNCTION BUTTON ON THE STATUS BAR |
ROUNDING |
is a procedure that determines which digit to the right of a number will be the last to be displayed. |
A defined set of formatting characteristics such as font, font size, and font color are known as a |
CELL STYLE |
Hold down the |
CTRL key to select nonadjacent cells |
Which of the following is NOT part of the Accounting Number Format? |
THREE DECIMAL PLACES |
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called |
SPARKLINES |
What are the two contextual tabs that display under Chart Tools when a chart is selected? |
FORMAT AND DESIGN |
Which of the following does not display to the right side of a selected chart? |
MOVE CHART BUTTON |
MOVE CHART BUTTON |
Which of the following does not display to the right side of a selected chart? |
Y AXIS |
The value axis is also known as the |
A DATA POINT |
A chart value that originates in a worksheet cell is referred to as |
FILE TAB |
To display the document properties, click the |
VERTICAL DOTTED LIN BETWEEN COLUMNS |
When preparing a document for printing, a __________________ indicates that only the columns to the left will be printed on the first page. |
CTRL+ F2 |
The keyboard shortcut to display Print Preview is |
F7 |
is the keyboard shortcut for the Spelling command. |
TWO DECIMAL PLACES |
Comma Style format displays a number with |
GENERAL |
The default number format for cells is the________ number format |
MAXIMUM |
Which of the following is NOT one of the default calculations displayed by AutoCalculate? |
ZERO DECIMAL PLACES |
The Percent Style button formats selected cells as a percentage with |