Question 1

Before printing a worksheet,click the File tab and select Print to preview the worksheet.

Accepted Answer

A) True 
 B)False

Question 2

The ________ of a workbook displays the file name as well as the software name.

Accepted Answer

The answer of The ________ of a workbook displays the...

Question 3

A combination of cell references,arithmetic operations,values,and/or functions used in calculations is called a(n)________.

Accepted Answer

The answer of A combination of cell references,arithmetic operations,values,and/or functions...

Question 4

The order of precedence in Excel 2013:

Accepted Answer

A) includes letters,numbers,and spaces. 
B) controls the sequence in which Excel performs arithmetic operations. 
C) is a software application used to create and modify business communications. 
D) includes formulas,functions,and formatting. 
A) includes letters,numbers,and spaces. 
B) controls the sequence in which Excel performs arithmetic operations. 
C) is a software application used to create and modify business communications. 
D) includes formulas,functions,and formatting.

Question 5

What does a sheet tab display?

Accepted Answer

A) The worksheet and workbook name 
B) All formulas included on that worksheet 
C) The address of the current cell 
D) The name of a worksheet within a workbook 
A) The worksheet and workbook name 
B) All formulas included on that worksheet 
C) The address of the current cell 
D) The name of a worksheet within a workbook

Question 6

________ refers to how data are positioned in cells.

Accepted Answer

The answer of ________ refers to how data are positioned...

Question 7

A cell address:

Accepted Answer

A) identifies the active cell and worksheet. 
B) identifies a cell by a column letter and a row number. 
C) contains a column letter,a row number,and a worksheet tab name. 
D) identifies a worksheet by its column letter and row number. 
A) identifies the active cell and worksheet. 
B) identifies a cell by a column letter and a row number. 
C) contains a column letter,a row number,and a worksheet tab name. 
D) identifies a worksheet by its column letter and row number.

Question 8

Comma,Date,Time,and Fraction are all number formats available in Excel 2013.

Accepted Answer

A) True 
 B)False

Question 9

Once cells have been merged they cannot be unmerged.

Accepted Answer

A) True 
 B)False

Question 10

The ________ button on a worksheet appears as a triangle at the intersection of the row and column headings.

Accepted Answer

The answer of The ________ button on a worksheet appears...

Question 11

A value:

Accepted Answer

A) controls the sequence in which Excel performs arithmetic operations. 
B) is a number that represents a quantity and can be the basis of calculations. 
C) includes letters,numbers,and spaces. 
D) is a combination of cell references,operators,values,and/or functions used to perform calculations. 
A) controls the sequence in which Excel performs arithmetic operations. 
B) is a number that represents a quantity and can be the basis of calculations. 
C) includes letters,numbers,and spaces. 
D) is a combination of cell references,operators,values,and/or functions used to perform calculations.

Question 12

Match between columns
                        Premises: Page Down
Ctrl+Home
Tab
Ctrl+End
Page Up

Accepted Answer

The Answer of move insertion point up one screen and is...

Question 13

A spreadsheet is:

Accepted Answer

A) the core of a slide presentation. 
B) an electronic file that is used to write text and graphics on the Web. 
C) an electronic file of a grid of columns and rows of related data. 
D) another word for a letter written on a computer. 
A) the core of a slide presentation. 
B) an electronic file that is used to write text and graphics on the Web. 
C) an electronic file of a grid of columns and rows of related data. 
D) another word for a letter written on a computer.

Question 14

A Special number format allows characters such as hyphens.

Accepted Answer

A) True 
 B)False

Question 15

When you've selected and subsequently cut the range,it is copied to the ________.

Accepted Answer

The answer of When you've selected and subsequently cut the...

Question 16

To display a long text label on two or more lines within a single cell:

Accepted Answer

A) type the first line,press Enter,and type the remaining line. 
B) insert a line break with Alt+Enter. 
C) insert a line break with Ctrl+Enter. 
D) use F2 to insert a line break after the first line. 
A) type the first line,press Enter,and type the remaining line. 
B) insert a line break with Alt+Enter. 
C) insert a line break with Ctrl+Enter. 
D) use F2 to insert a line break after the first line.

Question 17

Describe alignment in relation to Excel 2013.How is text automatically aligned,how are values automatically aligned,and how are dates automatically aligned?

Accepted Answer

Alignment refers to how data a

Question 18

The Formula Bar:

Accepted Answer

A) displays the name of a worksheet within a workbook. 
B) is located at the intersection of a column and a row. 
C) identifies the address of the current cell in a worksheet. 
D) displays the formula or contents of an active cell. 
A) displays the name of a worksheet within a workbook. 
B) is located at the intersection of a column and a row. 
C) identifies the address of the current cell in a worksheet. 
D) displays the formula or contents of an active cell.

Question 19

The ________ view displays print options and displays a worksheet in print preview mode.

Accepted Answer

The answer of The ________ view displays print options and...

Question 20

The Date number format only allows Long Date,for example,March 14,2016.

Accepted Answer

A) True 
 B)False

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

Before printing a worksheet,click the File tab and select Print to preview the worksheet.

The ________ of a workbook displays the file name as well as the software name.

A combination of cell references,arithmetic operations,values,and/or functions used in calculations is called a(n)________.

The order of precedence in Excel 2013:

What does a sheet tab display?

________ refers to how data are positioned in cells.

A cell address:

Comma,Date,Time,and Fraction are all number formats available in Excel 2013.

Once cells have been merged they cannot be unmerged.

The ________ button on a worksheet appears as a triangle at the intersection of the row and column headings.

A value:

A spreadsheet is:

A Special number format allows characters such as hyphens.

When you've selected and subsequently cut the range,it is copied to the ________.

To display a long text label on two or more lines within a single cell:

Describe alignment in relation to Excel 2013.How is text automatically aligned,how are values automatically aligned,and how are dates automatically aligned?

The Formula Bar:

The ________ view displays print options and displays a worksheet in print preview mode.

The Date number format only allows Long Date,for example,March 14,2016.

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