Deck 18: Excel: Introduction to Excel: What Is a Spreadsheet

Question 1

A value:

A)controls the sequence in which Excel performs arithmetic operations.
B)is a number that represents a quantity and can be the basis of calculations.
C)includes letters,numbers,and spaces.
D)is a combination of cell references,operators,values,and/or functions used to perform calculations.

Answer 1

B

Question 2

A cell address:

A)identifies the active cell and worksheet.
B)identifies a cell by a column letter and a row number.
C)contains a column letter,a row number,and a worksheet tab name.
D)identifies a worksheet by its column letter and row number.

Answer 2

B

Question 3

Auto Fill in Excel 2013:

A)enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle.
B)is the fastest way to type A1 in the name box.
C)is adjustable so you can display more or fewer characters in a column.
D)helps carry over the fill to the remaining worksheets.

Answer 3

A

Question 4

Press ________ to enter data into a cell and keep that cell as the active cell.

A)F2
B)Ctrl+F2
C)Shift+F4
D)Ctrl+Enter

Question 5

An input area is defined as:

A)a range of cells containing results based on the output area.
B)a display of the name of a worksheet within a workbook.
C)a range of cells containing values for variables used in formulas.
D)the active cell within a workbook.

Question 6

Column width:

A)is adjustable so you can display more or less characters in a column.
B)is not adjustable so keep the formulas as short as possible.
C)always switches back to default.
D)is best left unchanged unless you absolutely have to.

Question 7

What does a sheet tab display?

A)The worksheet and workbook name
B)All formulas included on that worksheet
C)The address of the current cell
D)The name of a worksheet within a workbook

Question 8

You should use cell references in formulas instead of constant values so that:

A)you can easily include letters,numbers,and spaces.
B)it is easier to debug the errors.
C)you can change the input values without changing the formulas.
D)you can control the sequence in which Excel performs arithmetic operations.

Question 9

A spreadsheet is:

A)the core of a slide presentation.
B)an electronic file that is used to write text and graphics on the Web.
C)an electronic file of a grid of columns and rows of related data.
D)another word for a letter written on a computer.

Question 10

To display a long text label on two or more lines within a single cell:

A)type the first line,press Enter,and type the remaining line.
B)insert a line break with Alt+Enter.
C)insert a line break with Ctrl+Enter.
D)use F2 to insert a line break after the first line.

Question 11

The order of precedence in Excel 2013:

A)includes letters,numbers,and spaces.
B)controls the sequence in which Excel performs arithmetic operations.
C)is a software application used to create and modify business communications.
D)includes formulas,functions,and formatting.

Question 12

Which of the following is NOT a way to insert a new worksheet?

A)Click New sheet to the right of the last tab
B)Press Ctrl+F11
C)Right-click a tab,select Insert from the shortcut menu,click Worksheet
D)Click the Insert arrow in the Cells group,select Insert Sheet

Question 13

AutoComplete:

A)adds all numbers in the row automatically.
B)searches for and displays any other similar label in the current column when you begin typing.
C)adds numbers within a column automatically.
D)searches for and displays any other similar label in the current row when you begin typing.

Question 14

A formula is:

A)a number that represents a date and can be the basis of calculations.
B)a combination of cell references,operators,values,and/or functions used to perform calculations.
C)a number that represents a quantity and can be the basis of calculations.
D)entered into a cell by pressing F2.

Question 15

An output area is defined as:

A)a region of a worksheet with formulas dependent on values from an input area.
B)a display of the range name and tab name within a workbook.
C)a range of cells containing values for variables used in formulas and functions within a worksheet.
D)the active cell on an active worksheet.

Question 16

Which of the following is NOT a standard interface of Microsoft Office applications?

A)Quick Access Toolbar
B)Scroll bars
C)Ribbon
D)Input area

Question 17

Using the fill handle on a cell containing a formula:

A)cannot complete a sequence of dates in a column.
B)changes the background color of the selected cells to yellow.
C)copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula.
D)has two or more sub-commands related to the command.

Question 18

A workbook is defined as:

A)similar to a spreadsheet but hard copy rather than electronic.
B)an unchangeable picture of data.
C)the address of the current cell.
D)a file containing related worksheets.

Question 19

The fill handle:

A)is a red bolded circle at the bottom-right of an active cell.
B)helps carry over the fill in an active cell to another range.
C)is the same action as pressing the Enter key.
D)is a small green square at the bottom-right corner of a cell.

Question 20

The Formula Bar:

A)displays the name of a worksheet within a workbook.
B)is located at the intersection of a column and a row.
C)identifies the address of the current cell in a worksheet.
D)displays the formula or contents of an active cell.

Question 21

The wrap text feature in Excel:

A)can be downloaded as an add-on to Excel 2013.
B)enables long formulas to wrap to two or more lines within a single cell.
C)is most useful with very short titles or column headings.
D)enables data to appear on two or more lines within a cell.

Question 22

A range:

A)cannot be selected with the mouse.
B)is the numbers that fall between the smallest and largest in a formula or function.
C)is another word for the active worksheet.
D)refers to a group of adjacent or contiguous cells.

Question 23

The Print Preview feature in Excel 2013 is available:

A)on the Quick Access Toolbar.
B)on the Page Layout tab.
C)in Microsoft Office Backstage view.
D)on the View tab.

Question 24

To select a range by using the name box:

A)click in the name box and type the range address such as B15:D25 and then press Enter.
B)select the name box from the File menu and choose Range.
C)position the mouse pointer over the column headings holding the Alt key.
D)click in the first cell of the range,hold the Ctrl key,and then click in the last cell of the range.

Question 25

To display cell formulas,press Ctrl and the asterisk (*).

Question 26

In Excel 2013,it is only possible to add a new worksheet when the workbook is created.

Question 27

To begin a formula in a cell,first type the # symbol.

Question 28

Copy as Picture can be a useful command when:

A)you do not have a printer available.
B)the formulas,functions,and headings need to be tested even if it's been pasted into a Word document.
C)you simply want to paste (and not edit)into a Word document.
D)you need to edit the data quickly even if it has been pasted into PowerPoint of Word.

Question 29

When you hide a column or row,the data is not deleted,it is just hidden.

Question 30

Which of the following is NOT a way to unhide column A in a worksheet?

A)Type A1 in the name box and then press the Enter key
B)Right-click the hidden column heading and select Unhide
C)Click Select All and use the Hide & Unhide submenu
D)Click Unhide on the View tab

Question 31

Double-clicking a worksheet tab allows you to rename the tab.

Question 32

Formatting data makes it difficult to read and tends to obscure meaningful details.

Question 33

Which of the following is FALSE pertaining to Excel number formats?

A)When you apply a number format,you can specify the number of decimal places.
B)Changing number formats changes the way a number displays in a cell.
C)Values have no special formatting when you enter data into cells.
D)The default number format is Comma.

Question 34

Excel data can be copied and pasted into a Word or PowerPoint document.

Question 35

A border:

A)is data from another cell that is only temporarily residing in an active cell.
B)is a line that surrounds a cell or a range of cells.
C)never prints.
D)is preset and weight cannot be adjusted.

Question 36

To help manage your worksheets within a workbook,worksheets tabs can be assigned unique patterns and even icon pictures.

Question 37

The order of precedence in Excel is the same as the basic order of operations in math.

Question 38

Which of the following is NOT an option available on the Page Layout tab of Excel 2013?

A)Select the print area
B)Select the number format
C)Select orientation
D)Set the margins

Question 39

By default new workbooks contain three worksheets.

Question 40

Which of the following is NOT a number format available in the Number group on the Home tab?

A)Comma Style
B)Percent Style
C)Accounting Number Format
D)Date Format

Question 41

The ________ button on a worksheet appears as a triangle at the intersection of the row and column headings.

Question 42

Default margins on an Excel 2013 worksheet are .75" top and bottom.

Question 43

The Page Setup dialog box contains additional options not found on the Excel Ribbon.

Question 44

The ________ Toolbar allows a user to quickly save,undo,and redo or repeat commands in Excel 2013.

Question 45

Before printing a worksheet,click the File tab and select Print to preview the worksheet.

Question 46

While it is common to center a worksheet horizontally on a page,it is not possible to center it vertically on the page in Excel 2013.

Question 47

The ________ of a workbook displays the file name as well as the software name.

Question 48

Once cells have been merged they cannot be unmerged.

Question 49

A Special number format allows characters such as hyphens.

Question 50

The&[Page]code used in a cell displays the number of pages in a workbook.

Question 51

The Date number format only allows Long Date,for example,March 14,2016.

Question 52

Changing the number format of a cell changes the value of the number stored in the cell.

Question 53

Merge & Center is not a good tool for creating titles of headings in Excel.

Question 54

The ________ bar displays information about a selected command or operation in progress.

Question 55

Excel displays data in gridlines of columns and rows.Those grid lines always appear on the printed document.

Question 56

Use horizontal alignment to move data in a cell closer to the top or bottom of the cell.

Question 57

Comma,Date,Time,and Fraction are all number formats available in Excel 2013.

Question 58

Column headings or row labels can be repeated on multiple-page printouts using the Print Titles Page Setup option.

Question 59

Text in a cell can by angled clockwise.

Question 60

A(n)________ is a single spreadsheet.

Question 61

If you enter data into a worksheet and decide you want the columns and rows reversed,you can click the Paste arrow,and then click ________.

Question 62

For Excel to recognize a formula,it must start with a(n)________ sign.

Question 63

Click Format in the Cells group on the ________ tab to change the color of a worksheet tab.

Question 64

The ________ view displays print options and displays a worksheet in print preview mode.

Question 65

If you select cells R45:S46 and T49:V53 you have selected a(n)________ range.

Question 66

To display a different worksheet click the sheet ________ at the bottom of the workbook window.

Question 67

The ________ command is helpful for navigating to a cell that is not visible onscreen.

Question 68

The Show Formulas button is accessible from the ________ tab.

Question 69

Use ________ to complete a sequence in a worksheet such as January,February,March,and April.

Question 70

The ________ feature on in Page Setup displays a list to set or clear a print area on a worksheet.

Question 71

Use the ________ to select a range by clicking in it and typing a range address,and then pressing Enter.

Question 72

The ________ format includes an optional dollar sign placed immediately to the left of a number.

Question 73

________ refers to how data are positioned in cells.

Question 74

Adjust the column ________ to accommodate the widest entry in a column.

Question 75

The order of ________ controls the sequence in which Excel does math.

Question 76

A number that represents a quantity or amount is called a(n)________.

Question 77

A combination of cell references,arithmetic operations,values,and/or functions used in calculations is called a(n)________.

Question 78

You can copy the contents of a cell or a range of cells by dragging the ________.

Question 79

When you've selected and subsequently cut the range,it is copied to the ________.

Question 80

The default number format in Excel 2013 is ________.