Question 1

A footer refers to text that appears in the bottom margin of a worksheet when printed.

Accepted Answer

A) True 
 B)False

Question 2

The AutoRecover feature is designed to save your work so you don't have to use the Save command.

Accepted Answer

A) True 
 B)False

Question 3

An Excel file is called a worksheet .

Accepted Answer

A) True 
 B)False

Question 4

The name of a worksheet is displayed on the ____.

Accepted Answer

A)  Ribbon 
B)  status bar 
C)  sheet tab 
D)  column header

Question 5

Case EX 1-1 Clyde is using Excel to create a client invoice for the event-planning business that he operates from his home office. If Clyde wants to enter a number as text, he can type a(n) ____ before the number to signal that it is not to be used in calculations.

Accepted Answer

A)  colon (:) 
B)  apostrophe (') 
C)  equal sign (=) 
D)  question mark (?)

Question 6

If you enter text in a cell that is longer than the cell can display, the remaining text will be stored in the adjacent cell.

Accepted Answer

A) True 
 B)False

Question 7

Case EX 1-2 In her position as a financial advisor, Mallory frequently works with workbooks containing multiple worksheets. To rename a worksheet with a descriptive name that better identifies the data, Mallory would double-click the ____.

Accepted Answer

A)  Home tab on the Ribbon 
B)  Name box 
C)  sheet tab 
D)  formula bar

Question 8

Press Ctrl+Home to move to the first cell of a row.

Accepted Answer

A) True 
 B)False

Question 9

To select all cells on the worksheet, click the Select All button, located ____.

Accepted Answer

A)  on the Home tab of the Ribbon in the Editing group 
B)  in the upper-left corner of the workbook window 
C)  on the File tab 
D)  next to the sheet tabs

Question 10

When you choose Print in Backstage view, you can click the ____ button to display the worksheet at larger magnification.

Accepted Answer

A)  Page Setup 
B)  Zoom to Page 
C)  Enlarge 
D)  Magnify

Question 11

Entering data and then pressing the Tab key selects the cell below the it, making it the active cell.

Accepted Answer

A) True 
 B)False

Question 12

If you had a budget that you had created on paper, describe the process you would take to transfer the data to a worksheet. What would be the advantages of using spreadsheet software such as Excel for your budget?

Accepted Answer

The answer of If you had a budget that you...

Question 13

By default, a workbook contains ____ worksheets.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four

Question 14

You can open an existing workbook using the Office dialog box.

Accepted Answer

A) True 
 B)False

Question 15

To close a workbook without closing Excel, you select the Close command on the ____.

Accepted Answer

A)  Ribbon 
B)  File tab 
C)  status bar 
D)  formula bar

Question 16

When you ____ a sheet tab, the sheet name is selected and you can type a new name.

Accepted Answer

A)  click 
B)  double-click 
C)  right-click 
D)  point to

Question 17

After you save a file for the first time, you can use the ____ button on the Quick Access Toolbar to update it as you make changes to it.

Accepted Answer

A)  Open 
B)  Save 
C)  Save As 
D)  AutoRecover

Question 18

____________________ are displayed horizontally and have numbered headings running consecutively down the left side of the worksheet.

Accepted Answer

The answer of ____________________ are displayed horizontally and have numbered...

Question 19

You can also edit or delete data directly in the cell by selecting the cell and pressing ____.

Accepted Answer

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

Question 20

____________________ software is used to calculate, analyze, and visually represent numerical data.

Accepted Answer

The answer of ____________________ software is used to calculate, analyze,...

Exam 3: Excel Lesson 1: Understanding Excel Fundamentals

A footer refers to text that appears in the bottom margin of a worksheet when printed.

The AutoRecover feature is designed to save your work so you don't have to use the Save command.

An Excel file is called a worksheet .

The name of a worksheet is displayed on the ____.

Case EX 1-1 Clyde is using Excel to create a client invoice for the event-planning business that he operates from his home office. If Clyde wants to enter a number as text, he can type a(n) ____ before the number to signal that it is not to be used in calculations.

If you enter text in a cell that is longer than the cell can display, the remaining text will be stored in the adjacent cell.

Case EX 1-2 In her position as a financial advisor, Mallory frequently works with workbooks containing multiple worksheets. To rename a worksheet with a descriptive name that better identifies the data, Mallory would double-click the ____.

Press Ctrl+Home to move to the first cell of a row.

To select all cells on the worksheet, click the Select All button, located ____.

When you choose Print in Backstage view, you can click the ____ button to display the worksheet at larger magnification.

Entering data and then pressing the Tab key selects the cell below the it, making it the active cell.

If you had a budget that you had created on paper, describe the process you would take to transfer the data to a worksheet. What would be the advantages of using spreadsheet software such as Excel for your budget?

By default, a workbook contains ____ worksheets.

You can open an existing workbook using the Office dialog box.

To close a workbook without closing Excel, you select the Close command on the ____.

When you ____ a sheet tab, the sheet name is selected and you can type a new name.

After you save a file for the first time, you can use the ____ button on the Quick Access Toolbar to update it as you make changes to it.

____________________ are displayed horizontally and have numbered headings running consecutively down the left side of the worksheet.

You can also edit or delete data directly in the cell by selecting the cell and pressing ____.

____________________ software is used to calculate, analyze, and visually represent numerical data.