Deck 6: Excel Module Getting Started With Excel

Question 1

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

Answer 1

False

Question 2

Every function follows a set of rules, or syntax , which specifies how the function should be written.

Answer 2

True

Question 3

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell.

Answer 3

False

Question 4

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

Question 5

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command.

Question 6

Normal view shows how the worksheet will appear when printed.

Question 7

In the formula, =2+6*2, addition would be calculated after multiplication.

Question 8

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

Question 9

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

Question 10

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points .

Question 11

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

Question 12

An adjacent range is a collection of separate ranges. 

Question 13

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

Question 14

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

Question 15

The worksheet is organized into individual cells. 

Question 16

When text wraps within a cell, the column width increases so that all of the text within the cell is displayed.

Question 17

Cutting moves the selected content, whereas copying duplicates the selected content.

Question 18

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it.

Question 19

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

Question 20

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

Question 21

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 22

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 23

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 24

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

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

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

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

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

Question 29

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

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

Question 30

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 31

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

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

Question 32

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 33

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

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

Question 34

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 35

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 36

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 37

"AZ" is an example of a ____.

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

Question 38

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 39

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 40

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

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

Question 41

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

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

Question 42

A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

Question 43

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 44

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 45

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

Question 46

____ 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 47

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 48

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 49

The range reference for a(n) ____________________ range includes the range reference to each range, separated by a semicolon.

Question 50

Which of the following takes precedence over multiplication?

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

Question 51

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

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

Question 52

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 53

When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

Question 54

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 55

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 56

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

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

Question 57

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 58

mm/dd/yyyy is known as ____.

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

Question 59

____ makes it easier to enter repetitive text in cells.

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

Question 60

The active cell is highlighted with a thick green border, its cell reference appears in the ____________________, and the corresponding column and row headings are highlighted.

Question 61

____________________ removes the data from the row or column as well as removes the row or column itself.

Question 63

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

Question 64

A(n) ____________________ of the original range is placed in the new location without removing the original range from the worksheet.

Question 65

A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

Question 66

A(n) ____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.