Question 1

When you hide a column or row,the data is not deleted,it is just hidden.

Accepted Answer

A) True 
 B)False

Question 2

You should use cell references in formulas instead of constant values so that:

Accepted Answer

A) you can easily include letters,numbers,and spaces. 
B) it is easier to debug the errors. 
C) you can change the input values without changing the formulas. 
D) you can control the sequence in which Excel performs arithmetic operations. 
A) you can easily include letters,numbers,and spaces. 
B) it is easier to debug the errors. 
C) you can change the input values without changing the formulas. 
D) you can control the sequence in which Excel performs arithmetic operations.

Question 3

Match between columns
                        Premises: sheet tab
Select All
active cell
Formula Bar
Name Box

Accepted Answer

The Answer of intersection of a column or row and is...

Question 4

Copy as Picture can be a useful command when:

Accepted Answer

A) you do not have a printer available. 
B) the formulas,functions,and headings need to be tested even if it's been pasted into a Word document. 
C) you simply want to paste (and not edit)into a Word document. 
D) you need to edit the data quickly even if it has been pasted into PowerPoint of Word. 
A) you do not have a printer available. 
B) the formulas,functions,and headings need to be tested even if it's been pasted into a Word document. 
C) you simply want to paste (and not edit)into a Word document. 
D) you need to edit the data quickly even if it has been pasted into PowerPoint of Word.

Question 5

Describe three features available for headers and/or footers.

Accepted Answer

A header and/or footer can appear at the

Question 6

If you select cells R45:S46 and T49:V53 you have selected a(n)________ range.

Accepted Answer

The answer of If you select cells R45:S46 and T49:V53...

Question 7

To select a range by using the name box:

Accepted Answer

A) click in the name box and type the range address such as B15:D25 and then press Enter. 
B) select the name box from the File menu and choose Range. 
C) position the mouse pointer over the column headings holding the Alt key. 
D) click in the first cell of the range,hold the Ctrl key,and then click in the last cell of the range. 
A) click in the name box and type the range address such as B15:D25 and then press Enter. 
B) select the name box from the File menu and choose Range. 
C) position the mouse pointer over the column headings holding the Alt key. 
D) click in the first cell of the range,hold the Ctrl key,and then click in the last cell of the range.

Question 8

Merge & Center is not a good tool for creating titles of headings in Excel.

Accepted Answer

A) True 
 B)False

Question 9

Excel data can be copied and pasted into a Word or PowerPoint document.

Accepted Answer

A) True 
 B)False

Question 10

By default new workbooks contain three worksheets.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: formulas
semi-selection
=C24*D24
A2+A3
starts all formulas

Accepted Answer

The Answer of text and change static numbers into meaningful is...

Question 12

A(n)________ is a single spreadsheet.

Accepted Answer

The answer of A(n)________ is a single spreadsheet....

Question 13

Which of the following is NOT a way to unhide column A in a worksheet?

Accepted Answer

A) Type A1 in the name box and then press the Enter key 
B) Right-click the hidden column heading and select Unhide 
C) Click Select All and use the Hide & Unhide submenu 
D) Click Unhide on the View tab 
A) Type A1 in the name box and then press the Enter key 
B) Right-click the hidden column heading and select Unhide 
C) Click Select All and use the Hide & Unhide submenu 
D) Click Unhide on the View tab

Question 14

The Print Preview feature in Excel 2013 is available:

Accepted Answer

A) on the Quick Access Toolbar. 
B) on the Page Layout tab. 
C) in Microsoft Office Backstage view. 
D) on the View tab. 
A) on the Quick Access Toolbar. 
B) on the Page Layout tab. 
C) in Microsoft Office Backstage view. 
D) on the View tab.

Question 15

To begin a formula in a cell,first type the # symbol.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is NOT a standard interface of Microsoft Office applications?

Accepted Answer

A) Quick Access Toolbar 
B) Scroll bars 
C) Ribbon 
D) Input area 
A) Quick Access Toolbar 
B) Scroll bars 
C) Ribbon 
D) Input area

Question 17

The order of precedence in Excel is the same as the basic order of operations in math.

Accepted Answer

A) True 
 B)False

Question 18

The ________ format includes an optional dollar sign placed immediately to the left of a number.

Accepted Answer

The answer of The ________ format includes an optional dollar...

Question 19

Use ________ to complete a sequence in a worksheet such as January,February,March,and April.

Accepted Answer

The answer of Use ________ to complete a sequence in...

Question 20

A number that represents a quantity or amount is called a(n)________.

Accepted Answer

The answer of A number that represents a quantity or...

Exam 18: Excel: Introduction to Excel: What Is a Spreadsheet

When you hide a column or row,the data is not deleted,it is just hidden.

You should use cell references in formulas instead of constant values so that:

Copy as Picture can be a useful command when:

Describe three features available for headers and/or footers.

If you select cells R45:S46 and T49:V53 you have selected a(n)________ range.

To select a range by using the name box:

Merge & Center is not a good tool for creating titles of headings in Excel.

Excel data can be copied and pasted into a Word or PowerPoint document.

By default new workbooks contain three worksheets.

A(n)________ is a single spreadsheet.

Which of the following is NOT a way to unhide column A in a worksheet?

The Print Preview feature in Excel 2013 is available:

To begin a formula in a cell,first type the # symbol.

Which of the following is NOT a standard interface of Microsoft Office applications?

The order of precedence in Excel is the same as the basic order of operations in math.

The ________ format includes an optional dollar sign placed immediately to the left of a number.

Use ________ to complete a sequence in a worksheet such as January,February,March,and April.

A number that represents a quantity or amount is called a(n)________.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters