Question 1

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet.

Accepted Answer

A) True 
 B)False  True

Question 2

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

Accepted Answer

A) True 
 B)False  False

Question 3

Match between columns
                        Premises: Determines the value of a cell on which the formula depends.

Accepted Answer

The Answer of #NAME? and NUM! and Keep Source Formatting is...

Question 4

You should use a ____ chart to compare values side by side, broken down by category.

Accepted Answer

A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column 
A)  Column 
B)  Bar 
C)  Line 
D)  Clustered Column

Question 5

Critical Thinking Questions Case 3-1 George runs a mid-size accounting practice and recently upgraded to Excel 2013.He expects sales to grow in the next few months during tax season.After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office.He will start with the Reception area, which has the most visibility.In George's Sales Data worksheet, the result for a formula in cell H14 is ######.What should George do?

Accepted Answer

A)  increase the width of column H 
B)  provide a correct argument or operand 
C)  run the calculation again to find the available value 
D)  replace the incorrect formula in cell H14 with one that does not divide by zero 
A)  increase the width of column H 
B)  provide a correct argument or operand 
C)  run the calculation again to find the available value 
D)  replace the incorrect formula in cell H14 with one that does not divide by zero

Question 6

The path to the Format Painter button is ____.

Accepted Answer

Question 7

Match between columns
                        Premises: Fills a destination area using the format of the source area; no content is copied.

Accepted Answer

The Answer of IF function and what-if analysis and goal is...

Question 8

Modified Multiple Choice The arguments in an IF function are ____.

Accepted Answer

A)  logical_test 
B)  value_if_true 
C)  value_if_true_false 
D)  value_if_false 
A)  logical_test 
B)  value_if_true 
C)  value_if_true_false 
D)  value_if_false

Question 9

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Accepted Answer

The answer of A(n) ____________________ cell reference instructs a paste...

Question 10

Which of the following formulas contains an absolute cell reference?

Accepted Answer

A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4 
A)  =$B4 
B)  =B$4 
C)  =$B$4 
D)  =B4

Question 11

Cell references in a formula are called ____.

Accepted Answer

A)  assumptions 
B)  comments 
C)  numbers 
D)  content 
A)  assumptions 
B)  comments 
C)  numbers 
D)  content

Question 12

____ refers to cells not wide enough to display the entire entry.

Accepted Answer

A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++ 
A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++

Question 13

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: Indicates a cell that uses a number incorrectly.

Accepted Answer

The Answer of goal seeking and Keep Source Formatting and is...

Question 15

Many ribbon commands, galleries, and shortcut keys function as toggles or switches.

Accepted Answer

A) True 
 B)False

Question 16

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

Accepted Answer

A)  section 
B)  sparkline 
C)  special 
D)  sparkle 
A)  section 
B)  sparkline 
C)  special 
D)  sparkle

Question 17

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Accepted Answer

A)  Click or tap 
B)  Press or long-press 
C)  Double-click or double-tap 
D)  Triple-click or tap 
A)  Click or tap 
B)  Press or long-press 
C)  Double-click or double-tap 
D)  Triple-click or tap

Question 18

Match between columns
                        Premises: Indicates a cell is using a name Excel does not recognize.

Accepted Answer

The Answer of IF function and Keep Source Formatting and is...

Question 19

Modified Multiple Choice Which of the following are formatting symbols?

Accepted Answer

A)  Dollar sign ($) 
B)  Comma (,) 
C)  Pound sign (#) 
D)  Percent sign (%) 
A)  Dollar sign ($) 
B)  Comma (,) 
C)  Pound sign (#) 
D)  Percent sign (%)

Question 20

Which of the following is the path to the Insert Cells arrow?

Accepted Answer

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

You should use a ____ chart to compare values side by side, broken down by category.

The path to the Format Painter button is ____.

Modified Multiple Choice The arguments in an IF function are ____.

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Which of the following formulas contains an absolute cell reference?

Cell references in a formula are called ____.

____ refers to cells not wide enough to display the entire entry.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

Many ribbon commands, galleries, and shortcut keys function as toggles or switches.

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Modified Multiple Choice Which of the following are formatting symbols?

Which of the following is the path to the Insert Cells arrow?

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters

Exam 11: Excel: Working With Large Worksheets, Charting, and What-If Analysis

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet.

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

You should use a ____ chart to compare values side by side, broken down by category.

The path to the Format Painter button is ____.

Modified Multiple Choice The arguments in an IF function are ____.

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Which of the following formulas contains an absolute cell reference?

Cell references in a formula are called ____.

____ refers to cells not wide enough to display the entire entry.

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

Many ribbon commands, galleries, and shortcut keys function as toggles or switches.

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

____ the Format Painter button and then drag through the nonadjacent ranges to paint the formats to the ranges.

Modified Multiple Choice Which of the following are formatting symbols?

Which of the following is the path to the Insert Cells arrow?

Office 2013 and Windows 8 Essential Concepts and Skills

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Excel: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters