Question 1

Excel refers to a spreadsheet as a ____.

Accepted Answer

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

Question 2

Excel simplifies the organization and maintenance of your data.

Accepted Answer

A) True 
 B)False  True

Question 3

Match between columns
                        Premises: Moves the insertion point to the previous row
Moves the insertion point to the right one cell
Moves the insertion point to the previous screen
Moves the insertion point to the left one cell
Moves the insertion point to the beginning of the worksheet

Accepted Answer

The Answer of Ctrl+Home and Tab and Up arrow and is...

Question 4

All cells in a range share all or part of their borders.

Accepted Answer

A) True 
 B)False

Question 5

Rows in a worksheet appear vertically and are identified by letters. ____________________

Accepted Answer

A) True 
 B)False

Question 6

Amy is new to using Excel and is learning how to enter data. Amy learns that all of the following are true about using AutoFill to fill in a series EXCEPT: ____.

Accepted Answer

A)  When you drag the fill handle down or to the right, the series is continued in descending order. 
B)  To fill a series, a pattern must be established in the initial selection of cells. 
C)  When you drag the fill handle, the pattern or series is continued. 
D)  You can modify the Fill settings in the Series dialog box. 
A)  When you drag the fill handle down or to the right, the series is continued in descending order. 
B)  To fill a series, a pattern must be established in the initial selection of cells. 
C)  When you drag the fill handle, the pattern or series is continued. 
D)  You can modify the Fill settings in the Series dialog box.

Question 7

A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.

Accepted Answer

The answer of A(n) ____________________ is a grid of rows...

Question 8

1A is an example of a cell reference.

Accepted Answer

A) True 
 B)False

Question 9

To select an entire row, click the row heading.

Accepted Answer

A) True 
 B)False

Question 10

Press the down arrow to move to the next screen in a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 11

The Enter and Cancel buttons appear in the formula bar even if you are not entering data.

Accepted Answer

A) True 
 B)False

Question 12

To enter data in a cell, you must first make the cell active.

Accepted Answer

A) True 
 B)False

Question 13

The AutoComplete feature in Excel corrects misspellings as you enter data. ____________________

Accepted Answer

A) True 
 B)False

Question 14

When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a) n ____.

Accepted Answer

A)  one-sided arrow 
B)  double-sided arrow 
C)  white plus sign 
D)  I-beam 
A)  one-sided arrow 
B)  double-sided arrow 
C)  white plus sign 
D)  I-beam

Question 15

You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.

Accepted Answer

A) True 
 B)False

Question 16

The Ribbon in Excel is similar to the Ribbon used in Word.

Accepted Answer

A) True 
 B)False

Question 17

____ view displays the column and row labels separated from the worksheet cells.

Accepted Answer

A)  Normal 
B)  Page Layout 
C)  Full Screen Reading 
D)  Page Break Preview 
A)  Normal 
B)  Page Layout 
C)  Full Screen Reading 
D)  Page Break Preview

Question 18

Which of the following is NOT true about copying and moving data?

Accepted Answer

A)  You can move or copy multiple cells of data at the same time. 
B)  When you paste data to a spreadsheet cell that already contains data, the existing data moves to make room for the new data. 
C)  The Clipboard is used to copy and paste data. 
D)  All of the above are true. 
A)  You can move or copy multiple cells of data at the same time. 
B)  When you paste data to a spreadsheet cell that already contains data, the existing data moves to make room for the new data. 
C)  The Clipboard is used to copy and paste data. 
D)  All of the above are true.

Question 19

Grant is modifying the structure of his worksheet. Grant presses F8 to enable ____ mode.

Accepted Answer

A)  Edit 
B)  Insert 
C)  Select 
D)  Delete 
A)  Edit 
B)  Insert 
C)  Select 
D)  Delete

Question 20

A(n) ____________________ is the intersection of a single row and a single column.

Accepted Answer

The answer of A(n) ____________________ is the intersection of a...

Exam 18: Getting Started With Excel Essentials

Excel refers to a spreadsheet as a ____.

Excel simplifies the organization and maintenance of your data.

All cells in a range share all or part of their borders.

Rows in a worksheet appear vertically and are identified by letters. ____________________

Amy is new to using Excel and is learning how to enter data. Amy learns that all of the following are true about using AutoFill to fill in a series EXCEPT: ____.

A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.

1A is an example of a cell reference.

To select an entire row, click the row heading.

Press the down arrow to move to the next screen in a spreadsheet.

The Enter and Cancel buttons appear in the formula bar even if you are not entering data.

To enter data in a cell, you must first make the cell active.

The AutoComplete feature in Excel corrects misspellings as you enter data. ____________________

When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a) n ____.

You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.

The Ribbon in Excel is similar to the Ribbon used in Word.

____ view displays the column and row labels separated from the worksheet cells.

Which of the following is NOT true about copying and moving data?

Grant is modifying the structure of his worksheet. Grant presses F8 to enable ____ mode.

A(n) ____________________ is the intersection of a single row and a single column.

Computers and Computer Systems

Input, Output and Processing

Computer Protection

Computer Maintenance

Computer-Related Issues

Software and Hardware Interaction

Software Fundamentals

Operating Systems

Windows Management

Operating System Customization

Exploring Microsoft Office 2010

Getting Started With Word Essentials

Editing and Formatting Documents

Sharing Documents

Working With Tables

Using Templates, Styles, and Building Blocks

Enhancing Documents

Organizing and Enhancing Worksheets

Creating Formulas and Charting Data

Getting Started With Powerpoint Essentials

Enhancing Presentations With Multimedia Effects

Getting Started With Access Essentials

Managing and Reporting Database Information

Networks Fundamentals

Communication Services

Communications and Collaboration

Using the Internet and the World Wide Web

Web Content

Technology and Society

Security, Privacy, and Ethics Online

Using Windows 7

Filters