Question 1

Excel can draw a variety of ____.

Accepted Answer

A)  pictures 
B)  worksheets 
C)  charts 
D)  workbooks 
A)  pictures 
B)  worksheets 
C)  charts 
D)  workbooks C

Question 2

Organizing files in folders is part of a process known as file management.

Accepted Answer

A) True 
 B)False  True

Question 3

If no help file is available for a particular dialog box, when you press the F1 key the ____ opens.

Accepted Answer

A)  error message 
B)  Internet 
C)  main Help window 
D)  log-off screen 
A)  error message 
B)  Internet 
C)  main Help window 
D)  log-off screen C

Question 4

A ____ is like a notebook.

Accepted Answer

A)  workbook 
B)  worksheet 
C)  chart 
D)  table 
A)  workbook 
B)  worksheet 
C)  chart 
D)  table

Question 5

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user account.

Accepted Answer

A)  app 
B)  user name 
C)  user icon 
D)  password 
A)  app 
B)  user name 
C)  user icon 
D)  password

Question 6

The ____ tab opens the Backstage view for each Office app.

Accepted Answer

A)  VIEW 
B)  BACKSTAGE 
C)  FILE 
D)  MENU 
A)  VIEW 
B)  BACKSTAGE 
C)  FILE 
D)  MENU

Question 7

If you do not use the mini toolbar, it remains on the screen.

Accepted Answer

A) True 
 B)False

Question 8

If the Office app has a(n) _________________________ tab in the Backstage view, the New gallery displays various options for creating a new file.

Accepted Answer

The answer of If the Office app has a(n) _________________________...

Question 9

When you increase the screen resolution, Windows displays more information on the screen, but the information ____.

Accepted Answer

A)  decreases in size 
B)  increases in size 
C)  stays the same size 
D)  changes color 
A)  decreases in size 
B)  increases in size 
C)  stays the same size 
D)  changes color

Question 10

____ is the newest version of Microsoft Windows.

Accepted Answer

A)  Windows 8 
B)  SkyDrive 
C)  Microsoft Office 2013 
D)  Microsoft Office 365 
A)  Windows 8 
B)  SkyDrive 
C)  Microsoft Office 2013 
D)  Microsoft Office 365

Question 11

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-The process of finding a location on a storage device.

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

One method of changing the size of a window is to drag the window borders.

Accepted Answer

A) True 
 B)False

Question 13

If a particular app does not appear on the screen, you cannot find it by searching.

Accepted Answer

A) True 
 B)False

Question 14

A row number on the left side of the grid, also called a(n) _________________________, identifies each row.

Accepted Answer

The answer of A row number on the left side...

Question 15

From the Windows 8 Start screen, you can choose which apps to run using a ____.

Accepted Answer

A)  touch screen 
B)  mouse 
C)  printer 
D)  storage device 
A)  touch screen 
B)  mouse 
C)  printer 
D)  storage device

Question 16

The ____ includes a button that enables you to display all of your apps.

Accepted Answer

A)  Menu bar 
B)  Toolbar 
C)  App bar 
D)  Shortcut bar 
A)  Menu bar 
B)  Toolbar 
C)  App bar 
D)  Shortcut bar

Question 17

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

Accepted Answer

The answer of A(n) _________________________ is a horizontal or vertical...

Question 18

You cannot use the Backstage view to close an open file in other Office apps.

Accepted Answer

A) True 
 B)False

Question 19

If the destination and ____folders are on the same media, you can move a file by dragging it.

Accepted Answer

A)  graph 
B)  source 
C)  table 
D)  placeholder 
A)  graph 
B)  source 
C)  table 
D)  placeholder

Question 20

When you turn on a computer, Windows starts and displays a ____ consisting of the time and date.

Accepted Answer

A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen 
A)  Start screen 
B)  lock screen 
C)  sign-in screen 
D)  user name screen

Excel can draw a variety of ____.

Organizing files in folders is part of a process known as file management.

If no help file is available for a particular dialog box, when you press the F1 key the ____ opens.

A ____ is like a notebook.

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user account.

The ____ tab opens the Backstage view for each Office app.

If you do not use the mini toolbar, it remains on the screen.

If the Office app has a(n) _________________________ tab in the Backstage view, the New gallery displays various options for creating a new file.

When you increase the screen resolution, Windows displays more information on the screen, but the information ____.

____ is the newest version of Microsoft Windows.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of finding a location on a storage device.

One method of changing the size of a window is to drag the window borders.

If a particular app does not appear on the screen, you cannot find it by searching.

A row number on the left side of the grid, also called a(n) _________________________, identifies each row.

From the Windows 8 Start screen, you can choose which apps to run using a ____.

The ____ includes a button that enables you to display all of your apps.

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

You cannot use the Backstage view to close an open file in other Office apps.

If the destination and ____folders are on the same media, you can move a file by dragging it.

When you turn on a computer, Windows starts and displays a ____ consisting of the time and date.

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

Excel can draw a variety of ____.

Organizing files in folders is part of a process known as file management.

If no help file is available for a particular dialog box, when you press the F1 key the ____ opens.

A ____ is like a notebook.

Tapping or clicking the ____ on a sign-in screen begins the process of signing in to your user account.

The ____ tab opens the Backstage view for each Office app.

If you do not use the mini toolbar, it remains on the screen.

If the Office app has a(n) _________________________ tab in the Backstage view, the New gallery displays various options for creating a new file.

When you increase the screen resolution, Windows displays more information on the screen, but the information ____.

____ is the newest version of Microsoft Windows.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of finding a location on a storage device.

One method of changing the size of a window is to drag the window borders.

If a particular app does not appear on the screen, you cannot find it by searching.

A row number on the left side of the grid, also called a(n) _________________________, identifies each row.

From the Windows 8 Start screen, you can choose which apps to run using a ____.

The ____ includes a button that enables you to display all of your apps.

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

You cannot use the Backstage view to close an open file in other Office apps.

If the destination and ____folders are on the same media, you can move a file by dragging it.

When you turn on a computer, Windows starts and displays a ____ consisting of the time and date.

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