Question 1

The fill handle:

Accepted Answer

A) is a red bolded circle at the bottom-right of an active cell. 
B) helps carry over the fill in an active cell to another range. 
C) is the same action as pressing the Enter key. 
D) is a small green square at the bottom-right corner of a cell. 
A) is a red bolded circle at the bottom-right of an active cell. 
B) helps carry over the fill in an active cell to another range. 
C) is the same action as pressing the Enter key. 
D) is a small green square at the bottom-right corner of a cell.

Question 2

Match between columns
                        Premises: Accounting
Concatenation
Orientation
Page Number
Vertical

Accepted Answer

The Answer of Header and Footer element and Page Setup is...

Question 3

For Excel to recognize a formula,it must start with a(n)________ sign.

Accepted Answer

The answer of For Excel to recognize a formula,it must...

Question 4

Match between columns
                        Premises: formulas
values
dates
text
AutoComplete

Accepted Answer

The Answer of Quarter 1,for example and displays other labels is...

Question 5

Double-clicking a worksheet tab allows you to rename the tab.

Accepted Answer

A) True 
 B)False

Question 6

You can copy the contents of a cell or a range of cells by dragging the ________.

Accepted Answer

The answer of You can copy the contents of a...

Question 7

Match between columns
                        Premises: fill handle
Auto Fill
display cell formulas
series of pound signs
fill pointer

Accepted Answer

The Answer of copying the contents of a cell or is...

Question 8

Match between columns
                        Premises: formula
text
F2
Shift+F11
value

Accepted Answer

The Answer of combination of cell references,operators,values,and/or functions to perform is...

Question 9

While it is common to center a worksheet horizontally on a page,it is not possible to center it vertically on the page in Excel 2013.

Accepted Answer

A) True 
 B)False

Question 10

The default number format in Excel 2013 is ________.

Accepted Answer

The answer of The default number format in Excel 2013...

Question 11

Use horizontal alignment to move data in a cell closer to the top or bottom of the cell.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is NOT an option available on the Page Layout tab of Excel 2013?

Accepted Answer

A) Select the print area 
B) Select the number format 
C) Select orientation 
D) Set the margins 
A) Select the print area 
B) Select the number format 
C) Select orientation 
D) Set the margins

Question 13

Describe page orientation when printing.What is the default and in what circumstances may you want to change orientation?

Accepted Answer

Orientation displays the orientation of

Question 14

The&[Page]code used in a cell displays the number of pages in a workbook.

Accepted Answer

A) True 
 B)False

Question 15

Auto Fill in Excel 2013:

Accepted Answer

A) enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle. 
B) is the fastest way to type A1 in the name box. 
C) is adjustable so you can display more or fewer characters in a column. 
D) helps carry over the fill to the remaining worksheets. 
A) enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle. 
B) is the fastest way to type A1 in the name box. 
C) is adjustable so you can display more or fewer characters in a column. 
D) helps carry over the fill to the remaining worksheets.

Question 16

AutoComplete:

Accepted Answer

A) adds all numbers in the row automatically. 
B) searches for and displays any other similar label in the current column when you begin typing. 
C) adds numbers within a column automatically. 
D) searches for and displays any other similar label in the current row when you begin typing. 
A) adds all numbers in the row automatically. 
B) searches for and displays any other similar label in the current column when you begin typing. 
C) adds numbers within a column automatically. 
D) searches for and displays any other similar label in the current row when you begin typing.

Question 17

Press ________ to enter data into a cell and keep that cell as the active cell.

Accepted Answer

A) F2 
B) Ctrl+F2 
C) Shift+F4 
D) Ctrl+Enter 
A) F2 
B) Ctrl+F2 
C) Shift+F4 
D) Ctrl+Enter

Question 18

To help manage your worksheets within a workbook,worksheets tabs can be assigned unique patterns and even icon pictures.

Accepted Answer

A) True 
 B)False

Question 19

The Show Formulas button is accessible from the ________ tab.

Accepted Answer

The answer of The Show Formulas button is accessible from...

Question 20

Briefly describe the data type "Text." Provide one or two examples of text entries in an Excel worksheet.

Accepted Answer

Text is any combination of letters,numbe

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

The fill handle:

For Excel to recognize a formula,it must start with a(n)________ sign.

Double-clicking a worksheet tab allows you to rename the tab.

You can copy the contents of a cell or a range of cells by dragging the ________.

While it is common to center a worksheet horizontally on a page,it is not possible to center it vertically on the page in Excel 2013.

The default number format in Excel 2013 is ________.

Use horizontal alignment to move data in a cell closer to the top or bottom of the cell.

Which of the following is NOT an option available on the Page Layout tab of Excel 2013?

Describe page orientation when printing.What is the default and in what circumstances may you want to change orientation?

The&[Page]code used in a cell displays the number of pages in a workbook.

Auto Fill in Excel 2013:

AutoComplete:

Press ________ to enter data into a cell and keep that cell as the active cell.

To help manage your worksheets within a workbook,worksheets tabs can be assigned unique patterns and even icon pictures.

The Show Formulas button is accessible from the ________ tab.

Briefly describe the data type "Text." Provide one or two examples of text entries in an Excel worksheet.

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