Question 1

Which of the following is the path to the sapy and Paste buttons?

Accepted Answer

Question 2

Leo, owner of Leo's Bread sampany, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Acsaunting number format. After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the value. To specify a floating dollar sign, which of the following formats should Leo apply?

Accepted Answer

A)  samma style 
B)  Percent style 
C)  Currency style 
D)  General number 
A)  samma style 
B)  Percent style 
C)  Currency style 
D)  General number

Question 3

To set row height to best fit, ____________________ the bottom boundary of the row heading.

Accepted Answer

The answer of To set row height to best fit,...

Question 4

The most sammon error when entering a formula is to reference the wrong cell in the formula.

Accepted Answer

A) True 
 B)False

Question 5

Moving from left to right, the first calculation in the order of operations is negation (-).

Accepted Answer

A) True 
 B)False

Question 6

You can click the Page Layout button on the status bar to switch to ____________________ view.

Accepted Answer

The answer of You can click the Page Layout button...

Question 7

The ____ Option button lists formatting options following an insertion of cells, rows, or salumns.

Accepted Answer

A)  Autosarrect 
B)  Insert 
C)  Auto Fill 
D)  Paste 
A)  Autosarrect 
B)  Insert 
C)  Auto Fill 
D)  Paste

Question 8

____________________ view shows the worksheet divided into pages.

Accepted Answer

The answer of ____________________ view shows the worksheet divided into...

Question 9

Which of the following is the path to the sanditional Formatting button?

Accepted Answer

Question 10

Leo, owner of Leo's Bread sampany, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Acsaunting number format. Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to acsamplish this?

Accepted Answer

A)  Spell checker 
B)  sanditional formatting 
C)  Point mode 
D)  Formulas version 
A)  Spell checker 
B)  sanditional formatting 
C)  Point mode 
D)  Formulas version

Question 11

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Accepted Answer

A)  DIVSUM 
B)  RANGEAVG 
C)  AVERAGE 
D)  MAX 
A)  DIVSUM 
B)  RANGEAVG 
C)  AVERAGE 
D)  MAX

Question 12

You can open the Format Cells dialog box by pressing the ____ keys.

Accepted Answer

A)  SHIFT+TAB 
B)  CTRL+1 
C)  ALT+1 
D)  SHIFT+F1 
A)  SHIFT+TAB 
B)  CTRL+1 
C)  ALT+1 
D)  SHIFT+F1

Question 13

The arithmetic operator, ^, directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 14

You can choose from 12 categories of formats in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 15

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Accepted Answer

A) True 
 B)False

Question 16

Anna is a sampetitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance. Her worksheet santains the following data: start and end time, total time, and distance. After three months, Anna wants to the know the average distance she runs. What should she do to calculate the average distance?

Accepted Answer

A)  Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula Autosamplete list and then enter the function's argument. 
B)  Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula Autosamplete list and then enter the function's argument. 
C)  Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D)  Enter the text =su at the end of the data in the Distance salumn; then select the SUM function from the Select Function list and then enter the function's argument. 
A)  Enter the text =av in a cell at the end of the distance data; then select the AVERAGE function from the Formula Autosamplete list and then enter the function's argument. 
B)  Enter the text =ms in a cell at the end of the distance data; then select the MAX function from the Formula Autosamplete list and then enter the function's argument. 
C)  Enter the text =function in a cell at the end of the distance data; then select the AVERAGE function from the AutoFunction list and then enter the function's argument. 
D)  Enter the text =su at the end of the data in the Distance salumn; then select the SUM function from the Select Function list and then enter the function's argument.

Question 17

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that santain numeric data.

Accepted Answer

A) True 
 B)False

Question 18

The AVERAGE function requires that the argument be included within parentheses following the function name.

Accepted Answer

A) True 
 B)False

Question 19

A ____ is a prewritten formula that is built into Excel.

Accepted Answer

A)  function 
B)  feature 
C)  task 
D)  calculation 
A)  function 
B)  feature 
C)  task 
D)  calculation

Question 20

Briefly discuss displaying the formulas version of a worksheet.

Accepted Answer

The values version of the worksheet show

Exam 13: Formulas, Functions, and Formatting Question

Which of the following is the path to the sapy and Paste buttons?

To set row height to best fit, ____________________ the bottom boundary of the row heading.

The most sammon error when entering a formula is to reference the wrong cell in the formula.

Moving from left to right, the first calculation in the order of operations is negation (-).

You can click the Page Layout button on the status bar to switch to ____________________ view.

The ____ Option button lists formatting options following an insertion of cells, rows, or salumns.

____________________ view shows the worksheet divided into pages.

Which of the following is the path to the sanditional Formatting button?

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

You can open the Format Cells dialog box by pressing the ____ keys.

The arithmetic operator, ^, directs Excel to perform the division operation.

You can choose from 12 categories of formats in the Format Cells dialog box.

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that santain numeric data.

The AVERAGE function requires that the argument be included within parentheses following the function name.

A ____ is a prewritten formula that is built into Excel.

Briefly discuss displaying the formulas version of a worksheet.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters