Question 1

____ displays the location of the different page breaks within the worksheet.

Accepted Answer

A)  Normal 
B)  Page Preview 
C)  Page Break Preview 
D)  Page Break Layout 
A)  Normal 
B)  Page Preview 
C)  Page Break Preview 
D)  Page Break Layout

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

Question 3

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 4

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 5

MATCHING
-A preformatted workbook with many design features and some content already filled in.

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 6

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

Accepted Answer

The answer of Keyboard ____________________ can help you work faster...

Question 7

The ____________________ font size for worksheets is 11 points.

Accepted Answer

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

Question 8

Which of the following will not change the location of the active cell?

Accepted Answer

A)  drag and drop 
B)  scrolling 
C)  clicking another cell 
D)  clicking a column heading 
A)  drag and drop 
B)  scrolling 
C)  clicking another cell 
D)  clicking a column heading

Question 9

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 10

Changing the page orientation affects only the ____________________ sheet.

Accepted Answer

The answer of Changing the page orientation affects only the...

Question 11

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

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.

Accepted Answer

A)  Ctrl + Enter 
B)  Alt + Enter 
C)  Alt + E 
D)  Ctrl + E 
A)  Ctrl + Enter 
B)  Alt + Enter 
C)  Alt + E 
D)  Ctrl + E

Question 13

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

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 15

MATCHING
-Displays the name of the sheets in the workbook

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

In the above figure, which box displays the formula in the formula bar?

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

____ displays the location of the different page breaks within the worksheet.

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

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.

MATCHING -A preformatted workbook with many design features and some content already filled in.

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

The ____________________ font size for worksheets is 11 points.

Which of the following will not change the location of the active cell?

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

Changing the page orientation affects only the ____________________ sheet.

MATCHING -Contains a grid of rows and columns into which you can enter text, numbers, dates, and formulas, and display charts.

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.

MATCHING -A named operation that replaces the arithmetic expression in a formula

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

MATCHING -Displays the name of the sheets in the workbook

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

In the above figure, which box displays the formula in the formula bar?

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 6: Getting Started With Excel

____ displays the location of the different page breaks within the worksheet.

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

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.

MATCHING -A preformatted workbook with many design features and some content already filled in.

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

The ____________________ font size for worksheets is 11 points.

Which of the following will not change the location of the active cell?

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

Changing the page orientation affects only the ____________________ sheet.

MATCHING -Contains a grid of rows and columns into which you can enter text, numbers, dates, and formulas, and display charts.

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.

MATCHING -A named operation that replaces the arithmetic expression in a formula

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

MATCHING -Displays the name of the sheets in the workbook

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

In the above figure, which box displays the formula in the formula bar?

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters