Question 1

Normal view shows how the worksheet will appear when printed._________________________

Accepted Answer

A) True 
 B)False  False

Question 2

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

Accepted Answer

A) database 
B) spreadsheet 
C) expression 
D) formula 
A) database 
B) spreadsheet 
C) expression 
D) formula B

Question 3

Numeric data is any number that can be used in a mathematical calculation._________________________

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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 6

Identify the letter of the choice that best matches the phrase or definition.
-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)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 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

The formula bar displays the value or formula of the active cell._________________________

Accepted Answer

A) True 
 B)False

Question 14

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

Accepted Answer

The answer of The range reference for a(n)____________________ range includes...

Question 15

Identify the letter of the choice that best matches the phrase or definition.
-A group of worksheet cells

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 16

Identify the letter of the choice that best matches the phrase or definition.
-Displays the cell reference of the active cell.

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 17

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

Accepted Answer

The answer of The active cell is highlighted with a...

Question 18

Identify the letter of the choice that best matches the phrase or definition.
-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)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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Normal view shows how the worksheet will appear when printed._________________________

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

Numeric data is any number that can be used in a mathematical calculation._________________________

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

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

Identify the letter of the choice that best matches the phrase or definition. -A named operation that replaces the arithmetic expression in a formula

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.

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

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.

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.

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

The formula bar displays the value or formula of the active cell._________________________

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

Identify the letter of the choice that best matches the phrase or definition. -A group of worksheet cells

Identify the letter of the choice that best matches the phrase or definition. -Displays the cell reference of the active cell.

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

Identify the letter of the choice that best matches the phrase or definition. -A preformatted workbook with many design features and some content already filled in.

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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 7: Getting Started With Excel

Normal view shows how the worksheet will appear when printed._________________________

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

Numeric data is any number that can be used in a mathematical calculation._________________________

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

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

Identify the letter of the choice that best matches the phrase or definition. -A named operation that replaces the arithmetic expression in a formula

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.

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

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.

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.

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

The formula bar displays the value or formula of the active cell._________________________

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

Identify the letter of the choice that best matches the phrase or definition. -A group of worksheet cells

Identify the letter of the choice that best matches the phrase or definition. -Displays the cell reference of the active cell.

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

Identify the letter of the choice that best matches the phrase or definition. -A preformatted workbook with many design features and some content already filled in.

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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