Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Two common ____________________ changes are adding borders to cells and changing the font size of text.

Accepted Answer

The answer of Two common ____________________ changes are adding borders...

Question 3

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

Accepted Answer

planning a

Question 4

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.

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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 wants to find out how much money she will make on her largest order,which is currently in row E.Cell E4 contains the number of items ordered and cell E5 contains the price per item.An appropriate formula would be ____.

Accepted Answer

A) =E4+E5 
B) =E5/E4 
C) =E4*E5 
D) =E4^E5 
A) =E4+E5 
B) =E5/E4 
C) =E4*E5 
D) =E4^E5

Question 7

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

Accepted Answer

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

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Press Ctrl + ` to switch to this view

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 9

____________________ view shows how the worksheet will appear when printed.

Accepted Answer

The answer of ____________________ view shows how the worksheet will...

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A named operation that replaces the arithmetic expression in a formula

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)formula view
J)template

Question 14

The order of operations for arithmetic operators is exponentiation,multiplication,division,addition,and then subtraction.In your opinion,what is the best order of precedence for the following Excel tasks and why: 1)work in editing mode,2)switch to formula view,3)rename sheet tabs,4)resize columns and rows,5)create a planning analysis sheet,and 6)enter data?

Accepted Answer

Instructors: There is some flexibility i

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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 
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 17

"AZ" is an example of a ____.

Accepted Answer

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

Question 18

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._________________________

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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 
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 20

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

Accepted Answer

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

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

Two common ____________________ changes are adding borders to cells and changing the font size of text.

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

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.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Press Ctrl + ` to switch to this view

____________________ view shows how the worksheet will appear when printed.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A named operation that replaces the arithmetic expression in a formula

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

"AZ" is an example of a ____.

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._________________________

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

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

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

Exam 1: Getting Started With Excel

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

Two common ____________________ changes are adding borders to cells and changing the font size of text.

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

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.

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Press Ctrl + ` to switch to this view

____________________ view shows how the worksheet will appear when printed.

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A named operation that replaces the arithmetic expression in a formula

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

"AZ" is an example of a ____.

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

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

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

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What If Analyses

Connecting to External Data

Collaborating on a Shared Workbook

Managing Your Files

Filters

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

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

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._________________________