Question 1

A cell is referred to by its unique address, or _________________________.

Accepted Answer

The answer of A cell is referred to by its...

Question 2

A ____ is a horizontal or vertical bar that appears when the contents of an area may not be visible completely on the screen.

Accepted Answer

A)  tilt wheel 
B)  gesture 
C)  scroll bar 
D)  scroll box 
A)  tilt wheel 
B)  gesture 
C)  scroll bar 
D)  scroll box

Question 3

Case 1
Ellie wants to use Office 2013 for her catering business. For example, she plans to use Word to maintain her collection of recipes, and Excel to manage her budget. To get started, Ellie turns to you for help in understanding the components that appear in the Microsoft Word window.
-Ellie asks you about the component located at the bottom of the document window. You tell her that it is used to present information about the document, the progress of current tasks, and controls for viewing the document. What is the name of this component?

Accepted Answer

A)  scroll bar 
B)  status bar 
C)  ribbon 
D)  mini toolbar 
A)  scroll bar 
B)  status bar 
C)  ribbon 
D)  mini toolbar

Question 4

Describe Excel and list some of its features and components.

Accepted Answer

Excel is a powerful spreadsheet app that

Question 5

-Tap or click the ____ workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Word window, as shown in the accompanying figure.

Accepted Answer

A)  Blank 
B)  New 
C)  Start 
D)  Create 
A)  Blank 
B)  New 
C)  Start 
D)  Create

Question 6

File Explorer provides a means to create a blank Office document without running an Office app.

Accepted Answer

A) True 
 B)False

Question 7

When you delete a file from a ____, the deleted file is stored in the Recycle Bin.

Accepted Answer

A)  folder 
B)  hard disk 
C)  workbook 
D)  USB flash drive 
A)  folder 
B)  hard disk 
C)  workbook 
D)  USB flash drive

Question 8

A(n) _________________________ is a named unit of storage.

Accepted Answer

The answer of A(n) _________________________ is a named unit of...

Question 9

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Exits running apps, shuts down Windows, and then turns off the computer.

Accepted Answer

A) user icon 
B) password 
C) sign-in screen 
D) Shut down command 
E) file
F)Restart command
G)folder
H)operating system
I)navigating
J)user name 
A) user icon 
B) password 
C) sign-in screen 
D) Shut down command 
E) file
F)Restart command
G)folder
H)operating system
I)navigating
J)user name

Question 10

Each worksheet has a sheet name that appears on a ____ at the bottom of a workbook.

Accepted Answer

A)  sheet tab 
B)  picture tab 
C)  tool tab 
D)  sheet button 
A)  sheet tab 
B)  picture tab 
C)  tool tab 
D)  sheet button

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Exits running apps, shuts down Windows, and then restarts Windows.

Accepted Answer

A) user icon 
B) password 
C) sign-in screen 
D) Shut down command 
E) file
F)Restart command
G)folder
H)operating system
I)navigating
J)user name 
A) user icon 
B) password 
C) sign-in screen 
D) Shut down command 
E) file
F)Restart command
G)folder
H)operating system
I)navigating
J)user name

Question 12

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

Accepted Answer

The answer of A(n) _________________________ allows you to perform tasks...

A cell is referred to by its unique address, or _________________________.

A ____ is a horizontal or vertical bar that appears when the contents of an area may not be visible completely on the screen.

Describe Excel and list some of its features and components.

-Tap or click the ____ workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Word window, as shown in the accompanying figure.

File Explorer provides a means to create a blank Office document without running an Office app.

When you delete a file from a ____, the deleted file is stored in the Recycle Bin.

A(n) _________________________ is a named unit of storage.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Exits running apps, shuts down Windows, and then turns off the computer.

Each worksheet has a sheet name that appears on a ____ at the bottom of a workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Exits running apps, shuts down Windows, and then restarts Windows.

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters

Exam 1: Essential Concepts and Skills

A cell is referred to by its unique address, or _________________________.

A ____ is a horizontal or vertical bar that appears when the contents of an area may not be visible completely on the screen.

Describe Excel and list some of its features and components.

-Tap or click the ____ workbook thumbnail on the Excel start screen to create a blank Excel workbook in the Word window, as shown in the accompanying figure.

File Explorer provides a means to create a blank Office document without running an Office app.

When you delete a file from a ____, the deleted file is stored in the Recycle Bin.

A(n) _________________________ is a named unit of storage.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Exits running apps, shuts down Windows, and then turns off the computer.

Each worksheet has a sheet name that appears on a ____ at the bottom of a workbook.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Exits running apps, shuts down Windows, and then restarts Windows.

A(n) _________________________ allows you to perform tasks using the keyboard by pressing one or more keyboard keys.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Working With Multiple Worksheets and Workbooks

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Filters