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

To enter data in a cell, the cell must be active.

Accepted Answer

A) True 
 B)False  True

Question 3

Grant is modifying the structure of his worksheet. Grant knows that the default column width is 8.43 ____.

Accepted Answer

A)  points 
B)  pixels 
C)  kilobytes 
D)  characters 
A)  points 
B)  pixels 
C)  kilobytes 
D)  characters D

Question 4

To select an entire row, click the row heading.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT true about the AutoFill command?

Accepted Answer

A)  Filling data is another method for copying data in a worksheet. 
B)  The Fill button is located in the Editing group on the Home tab. 
C)  AutoFill is faster than copying and pasting. 
D)  The AutoFill command can be used on nonadjacent cells. 
A)  Filling data is another method for copying data in a worksheet. 
B)  The Fill button is located in the Editing group on the Home tab. 
C)  AutoFill is faster than copying and pasting. 
D)  The AutoFill command can be used on nonadjacent cells.

Question 6

1A is an example of a cell reference.

Accepted Answer

A) True 
 B)False

Question 7

All cells in a range touch each other and form a rectangle.

Accepted Answer

A) True 
 B)False

Question 8

When you enter more numbers than can fit in a cell, ____.

Accepted Answer

A)  a series of number signs is displayed in the cell 
B)  you cannot enter any more numbers 
C)  by default, the column automatically widens to fit the new data 
D)  a dialog box opens 
A)  a series of number signs is displayed in the cell 
B)  you cannot enter any more numbers 
C)  by default, the column automatically widens to fit the new data 
D)  a dialog box opens

Question 9

Which of the following is NOT true about workbooks?

Accepted Answer

A)  Worksheets are always stored in workbooks. 
B)  You can only have one Excel workbook open at a time. 
C)  When working with large amounts of data, you can organize the data into multiple worksheets. 
D)  When you open a new blank workbook, Sheet1 appears in the worksheet window. 
A)  Worksheets are always stored in workbooks. 
B)  You can only have one Excel workbook open at a time. 
C)  When working with large amounts of data, you can organize the data into multiple worksheets. 
D)  When you open a new blank workbook, Sheet1 appears in the worksheet window.

Question 10

Excel is an electronic spreadsheet application.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: Moves the insertion point to the right one cell

Accepted Answer

The Answer of Up arrow and Tab and Shift+Tab and is...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

If you choose not to keep the data you have entered, you can press Esc .

Accepted Answer

A) True 
 B)False

Question 14

The AutoComplete feature in Excel corrects common mistakes as you enter data.

Accepted Answer

A) True 
 B)False

Question 15

The ____ 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 16

Excel 2010 uses the Microsoft Office Fluent user interface.

Accepted Answer

A) True 
 B)False

Question 17

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...

Question 18

The ____________________ cell is the cell that is selected.

Accepted Answer

The answer of The ____________________ cell is the cell that...

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 18: Getting Started With Excel Essentials

Excel refers to a spreadsheet as a ____.

To enter data in a cell, the cell must be active.

Grant is modifying the structure of his worksheet. Grant knows that the default column width is 8.43 ____.

To select an entire row, click the row heading.

Which of the following is NOT true about the AutoFill command?

1A is an example of a cell reference.

All cells in a range touch each other and form a rectangle.

When you enter more numbers than can fit in a cell, ____.

Which of the following is NOT true about workbooks?

Excel is an electronic spreadsheet application.

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

If you choose not to keep the data you have entered, you can press Esc .

The AutoComplete feature in Excel corrects common mistakes as you enter data.

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

Excel 2010 uses the Microsoft Office Fluent user interface.

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

The ____________________ cell is the cell that is selected.

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

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

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

Filters