Question 1

____ makes it easier to enter repetitive text in cells.

Accepted Answer

A) Editing mode 
B) AutoFit 
C) AutoComplete 
D) AutoFill 
A) Editing mode 
B) AutoFit 
C) AutoComplete 
D) AutoFill

Question 2

In ____ orientation,a page is taller than it is wide.

Accepted Answer

A) natural 
B) landscape 
C) portrait 
D) basic 
A) natural 
B) landscape 
C) portrait 
D) basic

Question 3

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

Accepted Answer

A) an outline of the new location of the selected range 
B) the range 
C) a cell reference of the old location 
D) shortcut tip 
A) an outline of the new location of the selected range 
B) the range 
C) a cell reference of the old location 
D) shortcut tip

Question 4

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 5

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Accepted Answer

planning a

Question 6

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

Accepted Answer

A) semi-colon 
B) period 
C) colon 
D) comma 
A) semi-colon 
B) period 
C) colon 
D) comma

Question 7

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 8

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 9

____ enters text based on patterns it finds in the data.

Accepted Answer

A) AutoComplete 
B) Flash Fill 
C) AutoFit 
D) Fill 
A) AutoComplete 
B) Flash Fill 
C) AutoFit 
D) Fill

Question 10

An Excel worksheet can have a maximum of ____ columns in a worksheet.

Accepted Answer

A) 156 
B) 256 
C) 16,384 
D) 17 million 
A) 156 
B) 256 
C) 16,384 
D) 17 million

Question 11

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 12

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

Accepted Answer

The answer of The ____________________ function will not include any...

Question 13

Identify the letter of the choice that best matches the phrase or definition.
-Shows the contents of the worksheet.

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 14

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points._________________________

Accepted Answer

A) True 
 B)False

Question 15

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

Accepted Answer

A) color coding 
B) bolding 
C) highlighting 
D) italicizing 
A) color coding 
B) bolding 
C) highlighting 
D) italicizing

Question 16

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

Question 17

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 18

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 19

You can move to the previous or next sheet by pressing the ____ keys.

Accepted Answer

A) Alt + Page Up or Alt + Page Down 
B) Ctrl + Page Up or Ctrl + Page Down 
C) Tab + Page Up or Tab + Page Down 
D) F4 + Page Up or F4 + Page Down 
A) Alt + Page Up or Alt + Page Down 
B) Ctrl + Page Up or Ctrl + Page Down 
C) Tab + Page Up or Tab + Page Down 
D) F4 + Page Up or F4 + Page Down

Question 20

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)

____ makes it easier to enter repetitive text in cells.

In ____ orientation,a page is taller than it is wide.

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

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

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

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

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.

____ enters text based on patterns it finds in the data.

An Excel worksheet can have a maximum of ____ columns in a worksheet.

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

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet.

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points._________________________

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

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

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

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

You can move to the previous or next sheet by pressing the ____ keys.

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

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

____ makes it easier to enter repetitive text in cells.

In ____ orientation,a page is taller than it is wide.

When you copy a selection of cells using drag and drop,which appears before you release the mouse button?

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

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

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

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.

____ enters text based on patterns it finds in the data.

An Excel worksheet can have a maximum of ____ columns in a worksheet.

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

The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet.

Column width is expressed in terms of the number of characters a column can contain or the size of the column in points._________________________

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

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

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

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

You can move to the previous or next sheet by pressing the ____ keys.

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

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