Deck 1: Getting Started With Excel

Question 1

The formula bar displays the value or formula of the active cell.

Answer 1

True

Question 2

A common business practice is to include a worksheet named $\underline { \text { Documentation } }$ that contains a description of the workbook,the name of the person who prepared the workbook,and the date it was created._________________________

Answer 2

True

Question 3

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row.

Answer 3

True

Question 4

Speed Fill enters text based on patterns it finds in the data.

Question 5

The worksheet is organized into individual cells.

Question 6

The AutoComplete feature automatically completes an entry based on previous entries in a column.

Question 7

Every function follows a set of rules,or $\underline { \text { syntax } }$ ,which specifies how the function should be written._________________________

Question 8

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon.

Question 9

In the formula,=2+6*2,addition would be calculated $\underline { \text { after } }$ multiplication._________________________

Question 10

When you insert a new row,the existing rows are shifted down and the new row has the same $\underline { \text { width } }$ as the row above it._________________________

Question 11

Numeric data is any number that can be used in a mathematical calculation.

Question 12

A $\underline { \text { keyboard shortcut } }$ is a key or combination of keys that you press to access a feature or perform a command._________________________

Question 13

When text wraps within a cell,the $\underline { \text { column width } }$ increases so that all of the text within the cell is displayed._________________________

Question 14

A formula is written using $\underline { \text { operands } }$ that combine different values,resulting in a single value that is then displayed in the cell._________________________

Question 15

Cutting moves the selected content,whereas $\underline { \text { copying } }$ duplicates the selected content._________________________

Question 16

The name of the active workbook appears in the status bar of the Excel window.

Question 17

Column width is expressed in terms of the number of characters a column can contain or the size of the column in $\underline { \text { points. } }$ _________________________

Question 18

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Question 19

An adjacent range is a collection of separate ranges.

Question 20

$\underline { \text { Normal } }$ view shows how the worksheet will appear when printed._________________________

Question 21

You can move to the previous or next sheet by pressing the ____ keys.

A)Alt + Page Up or Alt + Page Down
B)Ctrl + Page Up or Ctrl + Page Down
C)Tab + Page Up or Tab + Page Down
D)F4 + Page Up or F4 + Page Down

Question 22

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
A group of worksheet cells

Question 23

An Excel worksheet can have a maximum of ____ columns in a worksheet.

A)156
B)256
C)16,384
D)17 million

Question 24

To make A1 the active cell,you should press which of the following keys?

A)Page Up
B)Page Down
C)Home
D)Ctrl + Home

Question 25

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

A)database
B)spreadsheet
C)expression
D)formula

Question 26

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
When you copy a range of cells,you must press this key while you drag the selection to its new location

Question 27

"AZ" is an example of a ____.

A)column heading
B)row heading
C)cell reference
D)Name box

Question 28

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
A preformatted workbook with many design features and some content already filled in.

Question 29

The characters +,-,*,and / are examples of ____.

A)formulas
B)values
C)arithmetic operators
D)calculations

Question 30

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
A named operation that replaces the arithmetic expression in a formula

Question 31

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

A)KeyTips
B)ScreenTips
C)ShortTips
D)shortcuts

Question 32

To go to column A of the current row,press ____.

A)Ctrl + Home
B)Home
C)Shift + Tab
D)Tab + Enter

Question 33

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
Shows the contents of the worksheet

Question 34

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
Multiplication before addition

Question 35

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
Displays the cell reference of the active cell

Question 36

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
Contains a grid of rows and columns into which you can enter text,numbers,dates,and formulas,and display charts.

Question 37

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

A)semi-colon
B)period
C)colon
D)comma

Question 38

In ____,the ribbon increases in height,the buttons are bigger,and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

A)Touch Mode
B)Click Mode
C)Tap Mode
D)Normal Mode

Question 39

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
Press Ctrl + ` to switch to this view

Question 40

MATCHING
Identify the letter of the choice that best matches the phrase or definition.a.function
f.sheet tabs
b.Name box
g.Ctrl
c.worksheet
h.Normal view
d.range
i.formula view
e.order of operations
j.template
Displays the name of the sheets in the workbook

Question 41

____ makes it easier to enter repetitive text in cells.

A)Editing mode
B)AutoFit
C)AutoComplete
D)AutoFill

Question 42

Which of the following takes precedence over multiplication?

A)division
B)exponentiation
C)addition
D)subtraction

Question 43

According to the order of operation in Excel:

A)Excel performs exponentiation, then multiplication and division, then addition, and subtraction.
B)Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction.
C)Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition.
D)Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.

Question 44

To switch to ____ mode,you double-click the cell.

A)Insert
B)Copy
C)Edit
D)Paste

Question 45

In the figure above Box 3,points to color coded ____ references.

A)cell
B)formula
C)row
D)function

Question 46

An Excel formula always begins with a(n)____.

A)parentheses
B)equals sign
C)plus sign
D)colon

Question 47

When you insert a new column,the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

A)right
B)up
C)down
D)left

Question 48

In ____ orientation,a page is taller than it is wide.

A)natural
B)landscape
C)portrait
D)basic

Question 49

In the figure above,Box 2 points to a formula in ____ multiplying the values in cells F13 and G13.

A)cell F13
B)cell H13
C)cell G13
D)cell H13

Question 50

____ displays the location of the different page breaks within the worksheet.

A)Normal
B)Page Preview
C)Page Break Preview
D)Page Break Layout

Question 51

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

A)shrink
B)size
C)scale
D)scroll

Question 52

The formula used to multiply cell A1 by cell C1 is ____.

A)=A1*C1
B)C1*A1
C)=A1/C1
D)A1*C1

Question 53

To change the order of operations,enclose part of the formula in ____.

A)brackets
B)italics
C)parentheses
D)quotation marks

Question 54

If you want to create a new line within a cell,press the ____ keys to move the insertion point to the next line within the cell.

A)Ctrl + Enter
B)Alt + Enter
C)Alt + E
D)Ctrl + E

Question 55

____ enters text based on patterns it finds in the data.

A)AutoComplete
B)Flash Fill
C)AutoFit
D)Fill

Question 56

What is the result of the expression =50+20/10*5?

A)60
B)1
C)25
D)50

Question 57

A(n)____ is a group of cells in a rectangular block.

A)cluster
B)adjunct
C)selection
D)range

Question 58

In the figure above,Box 1 points to the formula =F13*G13 in the ____.

A)address box
B)address bar
C)formula box
D)formula bar

Question 59

To change a column width,you can click ____ on the Column submenu to make the column(s)as wide as the longest entry of the cells in the column.

A)QuickFit
B)AutoFit
C)Full Column
D)Longest

Question 60

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

A)color coding
B)bolding
C)highlighting
D)italicizing

Question 61

To move or copy a range of cells,select the correct order:
1)Move the pointer over the border of the selection until the pointer changes shape.
2)Select the cell or range you want to move or copy.
3)To move the range,click the border and drag the selection to a new location,or to copy the range,hold down the Ctrl key and drag the selection to a new location.

A)1,2,3
B)3,2,1
C)1,3,2
D)2,1,3

Question 62

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
Tyler wants to include the years that each client has been with him.He wishes to insert a new column called "Year" between Column C (Phone Number)and Column D (Number of Days ).To do this,Tyler selects ____.

A)Column C, then clicks the Insert button in the Cells group
B)Columns C and D, then clicks the Insert button in the Cells group
C)Column D, then clicks the Insert button in the Cells group
D)Columns C and D, then clicks the Insert Column Between button in the Cells group

Question 63

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
Samantha will add the number of orders.She chooses to use the ____ function from the AutoSum feature.

A)MAX
B)ADD
C)SUM
D)TOTAL

Question 64

Ctrl + G is used to access the ____.

A)Go to Next worksheet command
B)G column
C)Go to a location in the worksheet command
D)formula view

Question 65

Which of the following will not change the location of the active cell?

A)drag and drop
B)scrolling
C)clicking another cell
D)clicking a column heading

Question 66

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys,the workbook file is updated to reflect the latest content.

A)Ctrl + V
B)Ctrl + G
C)Ctrl + C
D)Ctrl + S

Question 67

mm/dd/yyyy is known as ____.

A)a text string
B)text data
C)a date format
D)number data

Question 68

In the figure above,which box displays the range references?

A)2
B)4
C)5
D)6

Question 69

To move the active cell up one row,press ____.

A)Shift + Enter
B)Ctrl + Tab
C)Shift + Tab
D)Ctrl + Enter

Question 70

In the above figure,which box displays the ScreenTip displaying the syntax of the SUM function?

A)1
B)4
C)5
D)6

Question 71

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
One of the entries Tyler enters into the spreadsheet automatically right-aligns in the cell.Which entry does this?

A)customer phone number
B)customer name
C)number of days
D)customer address

Question 72

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
Column B in Tyler's spreadsheet contains the addresses of his clients.Some of the addresses are truncated so Roger ____.

A)uses the AutoComplete command to allow for complete entries
B)uses the AutoFit command to remove unwanted space
C)resizes the column width until all addresses are visible
D)switches to Edit mode

Question 73

In the above figure,which box displays the formula in the formula bar?

A)1
B)2
C)5
D)6

Question 74

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
Tyler inserts a new column between columns C and D.The newly inserted column has the ____.

A)same width as the original column C
B)same width as the original column D
C)default width which is applied to all new columns
D)average width of all columns in the worksheet

Question 75

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

A)an outline of the new location of the selected range
B)the range
C)a cell reference of the old location
D)shortcut tip

Question 76

What is the syntax for a SUM formula adding the values of cell F6 to F9?

A)/SUM(F9:F6)
B)=SUM(F6/F9)
C)=END(F6:F9)
D)=SUM(F6:F9)

Question 77

In the figure above,which box displays the highlighted cells used in the function?

A)1
B)3
C)5
D)6

Question 78

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
Samantha decides to rename her worksheet "Samantha's Jewelry Business Worksheet" but she is unable to complete the word "Worksheet" because Excel ____.

A)only allows for three words in a sheet name
B)only allows for 31 characters in a sheet name
C)only allows one word in a sheet name
D)does not allow for symbols such as the apostrophe in Sam's in sheet names

Question 79

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
To activate the AutoSum feature,Samantha clicks in the ____.

A)cell below the group of cells she wants to add
B)cell to the right of the last cell in the group of cells she wants to add
C)formula bar
D)active cell

Question 80

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
Tyler notices that the Address column is too wide.He could use that extra space for other columns so he ____.

A)autofits the column by double-clicking the cell with the longest entry
B)autofits the column by double-clicking its border
C)autofits the column by selecting it, then clicking the AutoFit button in the Cells group
D)places the mouse pointer on the column border and drags to the right