Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

The answer of A(n)____________________ is a named operation that replaces...

Question 3

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

Accepted Answer

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

Question 4

According to the order of operation in Excel:

Accepted Answer

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

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.

Accepted Answer

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

Question 6

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

Accepted Answer

The answer of ____________________ removes the data from the row...

Question 7

The ____________________ font size for worksheets is 11 points.

Accepted Answer

The answer of The ____________________ font size for worksheets is...

Question 8

The worksheet is organized into individual cells.

Accepted Answer

A) True 
 B)False

Question 9

Explain the following Excel 2013 terms: spreadsheet,cell,worksheet,and active cell.

Accepted Answer

A spreadsheet is a grouping of text and

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

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.
-Tyler inserts a new column between columns C and D.The newly inserted column has the ____.

Accepted Answer

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

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

Accepted Answer

The answer of A(n)____________________ of the original range is placed...

Question 18

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Contains a grid of rows and columns into which you can enter text,numbers,dates,and formulas,and display charts.

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 19

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

Accepted Answer

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

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

Accepted Answer

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

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

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

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

According to the order of operation in Excel:

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.

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

The ____________________ font size for worksheets is 11 points.

The worksheet is organized into individual cells.

Explain the following Excel 2013 terms: spreadsheet,cell,worksheet,and active cell.

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

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

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

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains a grid of rows and columns into which you can enter text,numbers,dates,and formulas,and display charts.

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

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

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

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

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

According to the order of operation in Excel:

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.

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

The ____________________ font size for worksheets is 11 points.

The worksheet is organized into individual cells.

Explain the following Excel 2013 terms: spreadsheet,cell,worksheet,and active cell.

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

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

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

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

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

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Contains a grid of rows and columns into which you can enter text,numbers,dates,and formulas,and display charts.

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

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