2

Question 1

The value axis is known as what?

Answer 1

The y axis

Question 2

What is not a part of accounting number format?

Answer 2

Three decimal places

Question 3

All formulas begin with a what sign?

Answer 3

=

Question 4

What displays the current cell mode, the page number, and he zoom buttons?

Answer 4

The status bar

Question 5

What is not a default calculation displayed by autocalculate?

Answer 5

Maximum

Question 6

A text value in excel is also referred to as what?

Answer 6

A label

Question 7

When you type data in a cell and presenter what sell becomes active?

Answer 7

The cell below

Question 8

Where is the fill handle located?

Answer 8

In the Lower right corner of a selected cell

Question 9

In excel 2016 row headings re identified by what?

Answer 9

Numbers

Question 10

When formatting a worksheet to be printed what shows where page breaks are located?

Answer 10

Dotted lines

Question 11

What does a data bar in a cell represent?

Answer 11

The value of a cell relative to other cells

Question 12

True or false A pie chart should b considered when you have just one data series t plot?

Answer 12

True

Question 13

Autofit will fill a series when you establish a pattern when ?

Answer 13

You establish a pattern with two or more cells

Question 14

True or false a % sign designates that a cell in a formula is an absolute

Answer 14

False

Question 15

Which symbol represents that a cell is an absolute cell reference in a function formula?

Answer 15

$

Question 16

You must select how many ranges on a worksheet to create a pie chart?

Answer 16

Two ranges

Question 17

True or false, the chart elements allows you to add, remove or change chart elements?

Answer 17

True

Question 18

What does a pie chart do?

Answer 18

It shows the relationship of each part to a whole

Question 19

What is the first order of operation?

Answer 19

Expressions in parentheses

Question 20

The default number format for cells is what?

Answer 20

General

Question 21

What does the median function find?

Answer 21

The middle value on the range of cells

Question 22

What symbol does excell use to indicate that a dell is not side enough to display a formula or function result

Answer 22

#

Question 23

Cell c3 contains the formula =B3/$b$10 when you copy this formula down to c4 the formula will be what?

Answer 23

=B4/$b$10

Question 24

What key has to be held down to select nonadjacent cells?

Answer 24

Ctrl

Question 25

If you edit data in a worksheet that is associated with a pie chart what happens?

Answer 25

The pie slices will be updated automatically

Question 26

A what refers to a cell by its fixed position ?

Answer 26

Absolute cell reference

Question 27

Tiny charts embedded in a cell that display a visual trend summary alongside the your data are called what?

Answer 27

Sparklines

Question 28

In the excel window where does (group) display when worksheets are grouped ?

Answer 28

On the title bar

Question 29

What feature in excel recognizes a pattern in the data worksheet?

Answer 29

Flash fill