Question 1

Whenever you click the Save button on the Quick Access Toolbar or press the ____  keys,the workbook file is updated to reflect the latest content.

Accepted Answer

A)  Ctrl + V 
B)  Ctrl + G 
C)  Ctrl + C 
D)  Ctrl + S 
A)  Ctrl + V 
B)  Ctrl + G 
C)  Ctrl + C 
D)  Ctrl + S

Question 2

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 3

"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 4

Identify the letter of the choice that best matches the phrase or definition.
-Multiplication before addition

Accepted Answer

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

Question 5

To make A1 the active cell,you should press which of the following keys?

Accepted Answer

A)  Page Up 
B)  Page Down 
C)  Home 
D)  Ctrl + Home 
A)  Page Up 
B)  Page Down 
C)  Home 
D)  Ctrl + Home

Question 6

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 7

Identify the letter of the choice that best matches the phrase or definition.
-Hides a window so that only its program button is visible on the taskbar.

Accepted Answer

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

Question 8

An Excel formula always begins with a(n)____.

Accepted Answer

A)  parentheses 
B)  equals sign 
C)  plus sign 
D)  colon 
A)  parentheses 
B)  equals sign 
C)  plus sign 
D)  colon

Question 9

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command._________________________

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

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 12

The name of the active workbook appears in the status bar of the Excel window._________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

When text wraps within a cell,the column width increases so that all of the text within the cell is displayed._________________________

Accepted Answer

A) True 
 B)False

Question 15

In ____,the ribbon increases in height,the buttons are bigger,and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

Accepted Answer

A)  Touch Mode 
B)  Click Mode 
C)  Tap Mode 
D)  Normal Mode 
A)  Touch Mode 
B)  Click Mode 
C)  Tap Mode 
D)  Normal Mode

Question 16

A formula is written using operands that combine different values,resulting in a single value that is then displayed in the cell._________________________

Accepted Answer

A) True 
 B)False

Question 17

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 18

The formula used to multiply cell A1 by cell C1 is ____.

Accepted Answer

A)  =A1*C1 
B)  C1*A1 
C)  =A1/C1 
D)  A1*C1 
A)  =A1*C1 
B)  C1*A1 
C)  =A1/C1 
D)  A1*C1

Question 19

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

The characters +,-,*,and / are examples of ____.

Accepted Answer

A)  formulas 
B)  values 
C)  arithmetic operators 
D)  calculations 
A)  formulas 
B)  values 
C)  arithmetic operators 
D)  calculations

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys,the workbook file is updated to reflect the latest content.

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.

"AZ" is an example of a ____.

Identify the letter of the choice that best matches the phrase or definition. -Multiplication before addition

To make A1 the active cell,you should press which of the following keys?

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

Identify the letter of the choice that best matches the phrase or definition. -Hides a window so that only its program button is visible on the taskbar.

An Excel formula always begins with a(n)____.

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command._________________________

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

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

The name of the active workbook appears in the status bar of the Excel window._________________________

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

When text wraps within a cell,the column width increases so that all of the text within the cell is displayed._________________________

In ____,the ribbon increases in height,the buttons are bigger,and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

A formula is written using operands that combine different values,resulting in a single value that is then displayed in the cell._________________________

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

The formula used to multiply cell A1 by cell C1 is ____.

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

The characters +,-,*,and / are examples of ____.

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 1: Getting Started With Excel

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys,the workbook file is updated to reflect the latest content.

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.

"AZ" is an example of a ____.

Identify the letter of the choice that best matches the phrase or definition. -Multiplication before addition

To make A1 the active cell,you should press which of the following keys?

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

Identify the letter of the choice that best matches the phrase or definition. -Hides a window so that only its program button is visible on the taskbar.

An Excel formula always begins with a(n)____.

A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command._________________________

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

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

The name of the active workbook appears in the status bar of the Excel window._________________________

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

When text wraps within a cell,the column width increases so that all of the text within the cell is displayed._________________________

In ____,the ribbon increases in height,the buttons are bigger,and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

A formula is written using operands that combine different values,resulting in a single value that is then displayed in the cell._________________________

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

The formula used to multiply cell A1 by cell C1 is ____.

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

The characters +,-,*,and / are examples of ____.

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters