Question 1

Which of the following is NOT a number format available in the Number group on the Home tab?

Accepted Answer

A) Comma Style 
B) Percent Style 
C) Accounting Number Format 
D) Date Format 
A) Comma Style 
B) Percent Style 
C) Accounting Number Format 
D) Date Format

Question 2

Which of the following is NOT a way to insert a new worksheet?

Accepted Answer

A) Click New sheet to the right of the last tab 
B) Press Ctrl+F11 
C) Right-click a tab,select Insert from the shortcut menu,click Worksheet 
D) Click the Insert arrow in the Cells group,select Insert Sheet 
A) Click New sheet to the right of the last tab 
B) Press Ctrl+F11 
C) Right-click a tab,select Insert from the shortcut menu,click Worksheet 
D) Click the Insert arrow in the Cells group,select Insert Sheet

Question 3

Use the ________ to select a range by clicking in it and typing a range address,and then pressing Enter.

Accepted Answer

The answer of Use the ________ to select a range...

Question 4

Which of the following is FALSE pertaining to Excel number formats?

Accepted Answer

A) When you apply a number format,you can specify the number of decimal places. 
B) Changing number formats changes the way a number displays in a cell. 
C) Values have no special formatting when you enter data into cells. 
D) The default number format is Comma. 
A) When you apply a number format,you can specify the number of decimal places. 
B) Changing number formats changes the way a number displays in a cell. 
C) Values have no special formatting when you enter data into cells. 
D) The default number format is Comma.

Question 5

The Page Setup dialog box contains additional options not found on the Excel Ribbon.

Accepted Answer

A) True 
 B)False

Question 6

How would you print multiple worksheets?

Accepted Answer

To print multiple worksheets,click the f

Question 7

To display cell formulas,press Ctrl and the asterisk (*).

Accepted Answer

A) True 
 B)False

Question 8

Excel displays data in gridlines of columns and rows.Those grid lines always appear on the printed document.

Accepted Answer

A) True 
 B)False

Question 9

Column width:

Accepted Answer

A) is adjustable so you can display more or less characters in a column. 
B) is not adjustable so keep the formulas as short as possible. 
C) always switches back to default. 
D) is best left unchanged unless you absolutely have to. 
A) is adjustable so you can display more or less characters in a column. 
B) is not adjustable so keep the formulas as short as possible. 
C) always switches back to default. 
D) is best left unchanged unless you absolutely have to.

Question 10

A border:

Accepted Answer

A) is data from another cell that is only temporarily residing in an active cell. 
B) is a line that surrounds a cell or a range of cells. 
C) never prints. 
D) is preset and weight cannot be adjusted. 
A) is data from another cell that is only temporarily residing in an active cell. 
B) is a line that surrounds a cell or a range of cells. 
C) never prints. 
D) is preset and weight cannot be adjusted.

Question 11

Match between columns
                        Premises: Exponent
Multiplication
Parentheses
Division
Addition

Accepted Answer

The Answer of 5th in order of precedence and 4th is...

Question 12

Changing the number format of a cell changes the value of the number stored in the cell.

Accepted Answer

A) True 
 B)False

Question 13

If you have =D5*E5 in cell F5 and want to copy that down to F6 through F12,assuming data is contained in cells D6:E12,what is the quickest and easiest way to do that?

Accepted Answer

Click in cell F5,place your cu

Question 14

The ________ command is helpful for navigating to a cell that is not visible onscreen.

Accepted Answer

The answer of The ________ command is helpful for navigating...

Question 15

A workbook is defined as:

Accepted Answer

A) similar to a spreadsheet but hard copy rather than electronic. 
B) an unchangeable picture of data. 
C) the address of the current cell. 
D) a file containing related worksheets. 
A) similar to a spreadsheet but hard copy rather than electronic. 
B) an unchangeable picture of data. 
C) the address of the current cell. 
D) a file containing related worksheets.

Question 16

The order of ________ controls the sequence in which Excel does math.

Accepted Answer

The answer of The order of ________ controls the sequence...

Question 17

If you enter data into a worksheet and decide you want the columns and rows reversed,you can click the Paste arrow,and then click ________.

Accepted Answer

The answer of If you enter data into a worksheet...

Question 18

Click Format in the Cells group on the ________ tab to change the color of a worksheet tab.

Accepted Answer

The answer of Click Format in the Cells group on...

Question 19

The ________ feature on in Page Setup displays a list to set or clear a print area on a worksheet.

Accepted Answer

The answer of The ________ feature on in Page Setup...

Question 20

Text in a cell can by angled clockwise.

Accepted Answer

A) True 
 B)False

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

Which of the following is NOT a number format available in the Number group on the Home tab?

Which of the following is NOT a way to insert a new worksheet?

Use the ________ to select a range by clicking in it and typing a range address,and then pressing Enter.

Which of the following is FALSE pertaining to Excel number formats?

The Page Setup dialog box contains additional options not found on the Excel Ribbon.

How would you print multiple worksheets?

To display cell formulas,press Ctrl and the asterisk (*).

Excel displays data in gridlines of columns and rows.Those grid lines always appear on the printed document.

Column width:

A border:

Changing the number format of a cell changes the value of the number stored in the cell.

If you have =D5*E5 in cell F5 and want to copy that down to F6 through F12,assuming data is contained in cells D6:E12,what is the quickest and easiest way to do that?

The ________ command is helpful for navigating to a cell that is not visible onscreen.

A workbook is defined as:

The order of ________ controls the sequence in which Excel does math.

If you enter data into a worksheet and decide you want the columns and rows reversed,you can click the Paste arrow,and then click ________.

Click Format in the Cells group on the ________ tab to change the color of a worksheet tab.

The ________ feature on in Page Setup displays a list to set or clear a print area on a worksheet.

Text in a cell can by angled clockwise.

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