Computer Excel Mid Term

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

Computer Excel Mid Term - Subjecto.com

Computer Excel Mid Term

Your page rank:

Total word count: 1548
Pages: 6

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

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 [Group] 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

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending