Question 1

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Accepted Answer

A)  20xx 
B)  30xx 
C)  18xx 
D)  19xx 
A)  20xx 
B)  30xx 
C)  18xx 
D)  19xx

Question 2

The Insert Options button lists formatting options.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Accepted Answer

A)  placement 
B)  operations 
C)  positioning 
D)  selections 
A)  placement 
B)  operations 
C)  positioning 
D)  selections

Question 5

Match between columns
                        Premises: A formula in a cell that contains a reference back to itself.

Accepted Answer

The Answer of CTRL+1 and MAX and order of operations is...

Question 6

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Accepted Answer

A)  scheme 
B)  gallery 
C)  theme 
D)  style 
A)  scheme 
B)  gallery 
C)  theme 
D)  style

Question 7

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 8

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula 
A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula

Question 9

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Accepted Answer

A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder 
A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder

Question 10

When you decrease the row height to ____, the row is hidden.

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3 
A)  0 
B)  1 
C)  2 
D)  3

Question 11

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Accepted Answer

The answer of Excel includes a(n) ____________________ you can use...

Question 12

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Accepted Answer

A) True 
 B)False

Question 13

Critical Thinking Questions Case 2-2 Anna is a competitive 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 contains 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 AutoComplete 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 AutoComplete 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 column; 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 AutoComplete 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 AutoComplete 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 column; then select the SUM function from the Select Function list and then enter the function's argument.

Question 14

In designing a worksheet, visual aesthetics should come first.

Accepted Answer

A) True 
 B)False

Question 15

The Accounting number format assigns a floating dollar sign.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Displays the worksheet with formulas.

Accepted Answer

The Answer of ALT+ENTER and MAX and function and CTRL+V is...

Question 17

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 18

Which of the following calculations multiplies 23 by 0.01?

Accepted Answer

A)  =23% 
B)  =23 
C)  =23+. 01 
D)  =24-. 01 
A)  =23% 
B)  =23 
C)  =23+. 01 
D)  =24-. 01

Question 19

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 20

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Accepted Answer

A) True 
 B)False

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

The Insert Options button lists formatting options.

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

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

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

Which of the following happens when you enter the formula =G15 into a cell?

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

When you decrease the row height to ____, the row is hidden.

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

In designing a worksheet, visual aesthetics should come first.

The Accounting number format assigns a floating dollar sign.

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

Which of the following calculations multiplies 23 by 0.01?

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

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

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: Working With Large Worksheets, Charting, and What-If Analysis

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 10: Excel: Formulas, Functions, and Formatting

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

The Insert Options button lists formatting options.

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

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

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

Which of the following happens when you enter the formula =G15 into a cell?

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

When you decrease the row height to ____, the row is hidden.

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

In designing a worksheet, visual aesthetics should come first.

The Accounting number format assigns a floating dollar sign.

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

Which of the following calculations multiplies 23 by 0.01?

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

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

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: Working With Large Worksheets, Charting, and What-If Analysis

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