Deck 1: Excell: Creating a Worksheet and Charting Data

Question 1

When you type text in a cell it is ________.

A)right-aligned
B)fully justified
C)left-aligned
D)centered

Answer 1

C

Question 2

The ________ displays the current cell mode,the page number,and the zoom buttons.

A)ribbon
B)status bar
C)Formula Bar
D)Quick Access Toolbar

Answer 2

B

Question 3

Where is the fill handle located?

A)In the top right of an active cell
B)In the lower right corner of a selected cell
C)On the Quick Access Toolbar
D)On the Home tab

Answer 3

B

Question 4

What are the two contextual tabs that display under Chart Tools when a chart is selected?

A)Insert and Format
B)Format and Design
C)Insert and Design
D)Home and Design

Question 5

Which of the following is NOT a way to create a formula?

A)By typing
B)By using the point-and-click technique
C)By using a Function button located on the ribbon
D)By using a Function button on the status bar

Question 6

Which of the following does not display to the right side of a selected chart?

A)Chart Styles button
B)Chart Filters button
C)Chart Elements button
D)Move Chart button

Question 7

All formulas begin with a(n)________.

A)= sign
B)% sign
C)+ sign
D)# sign

Question 8

Which of the following is NOT part of the Accounting Number Format?

A)A fixed dollar sign aligned at the left edge of the cell
B)A thousand comma separator
C)Small amount of space at the right edge of the cell
D)Three decimal places

Question 9

Tiny charts embedded in a cell that display a visual trend summary alongside your data are called ________.

A)Sparklines
B)Data labels
C)Data series
D)Data markers

Question 10

When you type data in a cell and press Enter,what cell becomes the active cell?

A)The cell to the right
B)The cell below
C)The cell above
D)The insertion point does not move

Question 11

When a cell is part of an active formula,it is surrounded with ________.

A)a colored border with small boxes on each side
B)a colored background with small circles on each corner
C)a bold,black border with small circles on each side
D)a white border with small boxes on each corner

Question 12

A text value in Excel is also referred to as a ________.

A)label
B)formula
C)constant
D)cell address

Question 13

When using a touchscreen,which of the following actions is the same as clicking an item?

A)Slide right
B)Tap the item
C)Press and hold for a few seconds
D)Touch the item with two fingers

Question 14

Which of the following is the default number format in Excel 2016?

A)General format,Calibri,11 pt
B)Decimal format,Calibri,11 pt
C)General format,Times New Roman,12 pt
D)General format,Cambria,12 pt

Question 15

Which of the following is FALSE about a workbook?

A)It can contain only one worksheet.
B)It contains one or more worksheets.
C)It contains pages called worksheets.
D)It contains one or more worksheets with a series of cells.

Question 16

Using a touchscreen,which of the following actions is the same as right-clicking the mouse?

A)Slide right
B)Slide right and then press
C)Press and hold for a few seconds
D)Touch the screen with two fingers

Question 17

Hold down the ________ key to select nonadjacent cells.

A)Spacebar
B)Ctrl
C)Alt
D)F2

Question 18

In Excel 2016,row heading are identified by ________.

A)uppercase letters
B)lowercase letters
C)roman numerals
D)numbers

Question 19

________ is a procedure that determines which digit to the right of a number will be the last to be displayed.

A)Rounding
B)An absolute cell reference
C)A constant value
D)Cell addressing

Question 20

A defined set of formatting characteristics such as font,font size,and font color are known as a ________.

A)label
B)theme
C)cell style
D)series

Question 21

To indicate a range,include a dash between the two cell references.

Question 22

When preparing a document for printing,a ________ indicates that only the columns to the left will be printed on the first page.

A)vertical dotted line between columns
B)vertical bolded,black line between columns
C)horizontal bolded line between rows
D)vertical red,bold line between columns

Question 23

An outlined cell in a worksheet is the active cell.

Question 24

The default number format for cells is the ________ number format.

A)General
B)Currency
C)Comma Style
D)Accounting Number

Question 25

The Quick Analysis tool displays in the lower right corner of a selected range in a worksheet.

Question 26

The Formula Bar in Excel 2016 displays the value or formula in the active cell.

Question 27

The status bar displays the ribbon as well as the Quick Access Toolbar directly above it.

Question 28

The default font for Excel 2016 is Times New Roman 11 pt.

Question 29

The keyboard shortcut to display Print Preview is ________.

A)Alt + F2
B)F2
C)Ctrl + F2
D)F3

Question 30

________ is the keyboard shortcut for the Spelling command.

A)F1
B)F2
C)F7
D)F12

Question 31

Comma Style format displays a number with ________.

A)two decimal places
B)a dollar sign and two decimal places
C)three decimal places
D)no decimal places

Question 32

A chart value that originates in a worksheet cell is referred to as ________.

A)a data point
B)a data marker
C)a data series
D)the x-axis

Question 33

Auto Fill works only with alphabetic values.

Question 34

Which of the following is NOT one of the default calculations displayed by AutoCalculate?

A)Sum
B)Average
C)Maximum
D)Count

Question 35

The Percent Style button formats selected cells as a percentage with ________.

A)zero decimal places
B)one decimal place
C)two decimal places
D)three decimal places

Question 36

The value axis is also known as the ________.

A)x-axis
B)y-axis
C)category axis
D)legend

Question 37

To display the document properties,click the ________ tab.

A)Design
B)Home
C)Page Layout
D)File

Question 38

Normal view maximizes the number of cells visible on your screen.

Question 39

Auto Fill generates and extends a series of value into adjacent cells in a worksheet.

Question 40

After column Z in an Excel worksheet,the next column is AA.

Question 41

The Sum function is so frequently used that it has its own button on the Quick Access Toolbar.

Question 42

If two cells are merged into one,the cell contents are automatically left justified in the new,merged cell.

Question 43

You can use the Switch/Row Column command to move a chart from a set of rows on one worksheet to a set of columns on another.

Question 44

Scaling often works well for printing formulas since it shrinks the width and/or height of a printed worksheet.

Question 45

When you type in a cell and the cell to the right contains data,the text in the cell to the left is truncated.

Question 46

Typically,you should include totals when creating a chart.

Question 47

A relative cell reference is a reference based on the relative position of a cell that contains the formula and the cells referred to in the formula.

Question 48

The Show Formulas button is a toggle button-it is either on or off.

Question 49

Ctrl + = starts the Sum function in a worksheet.

Question 50

Sparklines cannot be formatted.

Question 51

AutoFit adjusts the width of a column to fit the cell content of the widest cell in the column.

Question 52

The Sum button resides on both the Home tab and the Formulas tab.

Question 53

Text that is typed in a cell that extends into the next cell only displays if the two cells are merged.

Question 54

The category axis is also known as the y-axis.

Question 55

A data series is a collection of related data points.

Question 56

You can create a custom footer in Excel.

Question 57

When two or more cells are merged,the individual cells cannot be selected.

Question 58

A cell style often includes font,font size,font color,and cell borders.

Question 59

Sparklines are tiny charts located within a cell that provide a visual trend summary of data.

Question 60

A data marker is a value that originates in a worksheet cell.

Question 61

A(n)________ is a vertical group of cells in an Excel worksheet.

Question 62

An Excel workbook contains one or more ________ that are stored in the workbook.

Question 63

A(n)________ is a point of light measured in dots per square inch.

Question 64

Text or numbers located in a cell in a worksheet are referred to as ________.

Question 65

The AutoCalculate feature display three calculations by default: Sum,Subtraction,and Multiplication.

Question 66

Selecting the range before you enter data saves time because it confines the movement of the active cell to the selected range.

Question 67

When you delete a column,the remaining columns shift to the left.

Question 68

A cell address is also referred to as a(n)________.

Question 69

The ________ command joins two or more selected cells together into one cell.

Question 70

The asterisk (*)indicates multiplication in Excel 2016.

Question 71

The range finder feature in Excel is useful for verifying formulas.

Question 72

A(n)________ is an Excel document that stores data.

Question 73

The orientation of a worksheet can be changed on the Home tab as well as in Print Preview.

Question 74

The ________ displays the name given to a selected cell,table,chart,or object.

Question 75

The Percent Style can have fewer or more places after the decimal that the default setting.

Question 76

The Wrap Text command displays numbers or formulas on multiple lines as well as text.

Question 77

The spelling checker in Excel performs similarly to other Microsoft Office programs.

Question 78

If you move formulas by inserting additional rows or columns in your worksheet,Excel automatically adjusts the formulas.

Question 79

A(n)________ is a prewritten formula that uses one or more cell references,performs an operation,and then returns a value.

Question 80

Cell content can be one of two things: a constant value or a(n)________.