Question 1

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it. _________________________

Accepted Answer

A) True 
 B)False

Question 2

When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

Accepted Answer

The answer of When you ____________________ a workbook, a dialog...

Question 3

A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

Accepted Answer

The answer of A(n) ____________________ is a grouping of text...

Question 4

mm/dd/yyyy is known as ____.

Accepted Answer

A)  a text string 
B)  text data 
C)  a date format 
D)  number data 
A)  a text string 
B)  text data 
C)  a date format 
D)  number data

Question 5

A(n) ____ is a group of cells in a rectangular block.

Accepted Answer

A)  cluster 
B)  adjunct 
C)  selection 
D)  range 
A)  cluster 
B)  adjunct 
C)  selection 
D)  range

Question 6

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 7

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

Accepted Answer

A)  QuickFit 
B)  AutoFit 
C)  Full Column 
D)  Longest 
A)  QuickFit 
B)  AutoFit 
C)  Full Column 
D)  Longest

Question 8

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

Accepted Answer

The answer of ____________________ enters text based on patterns it...

Question 9

The worksheet is organized into individual cells.

Accepted Answer

A) True 
 B)False

Question 10

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
-To activate the AutoSum feature, Samantha clicks in the ____.

Accepted Answer

A)  cell below the group of cells she wants to add 
B)  cell to the right of the last cell in the group of cells she wants to add 
C)  formula bar 
D)  active cell 
A)  cell below the group of cells she wants to add 
B)  cell to the right of the last cell in the group of cells she wants to add 
C)  formula bar 
D)  active cell

Question 11

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 12

In the formula, =2+6*2, addition would be calculated after multiplication. _________________________

Accepted Answer

A) True 
 B)False

Question 13

____ 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 14

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 15

MATCHING
-Press Ctrl + ` to switch to this view

Accepted Answer

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

Question 16

-In the figure above Box 3, points to color coded ____ references.

Accepted Answer

A)  cell 
B)  formula 
C)  row 
D)  function 
A)  cell 
B)  formula 
C)  row 
D)  function

Question 17

You have three college bound children and you would like to keep track of each of the costs related to tuition. Do you decide to create three Excel workbooks or one Excel workbook with three worksheets and why?

Accepted Answer

Instructors: There is no right or wrong

Question 18

In the figure above, which box displays the range references?

Accepted Answer

A)  2 
B)  4 
C)  5 
D)  6 
A)  2 
B)  4 
C)  5 
D)  6

Question 19

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 20

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

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it. _________________________

When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

mm/dd/yyyy is known as ____.

A(n) ____ is a group of cells in a rectangular block.

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.

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

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

The worksheet is organized into individual cells.

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

In the formula, =2+6*2, addition would be calculated after multiplication. _________________________

____ makes it easier to enter repetitive text in cells.

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

MATCHING -Press Ctrl + ` to switch to this view

-In the figure above Box 3, points to color coded ____ references.

You have three college bound children and you would like to keep track of each of the costs related to tuition. Do you decide to create three Excel workbooks or one Excel workbook with three worksheets and why?

In the figure above, which box displays the range references?

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

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

When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it. _________________________

When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

mm/dd/yyyy is known as ____.

A(n) ____ is a group of cells in a rectangular block.

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.

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

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

The worksheet is organized into individual cells.

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

In the formula, =2+6*2, addition would be calculated after multiplication. _________________________

____ makes it easier to enter repetitive text in cells.

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

MATCHING -Press Ctrl + ` to switch to this view

-In the figure above Box 3, points to color coded ____ references.

You have three college bound children and you would like to keep track of each of the costs related to tuition. Do you decide to create three Excel workbooks or one Excel workbook with three worksheets and why?

In the figure above, which box displays the range references?

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

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