Question 1

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Accepted Answer

A) Print Active Sheets 
B) Print Selection 
C) Print Entire Workbook 
D) none of the above 
A) Print Active Sheets 
B) Print Selection 
C) Print Entire Workbook 
D) none of the above

Question 2

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

Accepted Answer

A) left parenthesis 
B) right bracket 
C) right parenthesis 
D) left bracket 
A) left parenthesis 
B) right bracket 
C) right parenthesis 
D) left bracket

Question 3

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 4

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 5

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 contain numeric data.

Accepted Answer

A) True 
 B)False

Question 6

The Insert Options button lists formatting options.

Accepted Answer

A) True 
 B)False

Question 7

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 8

____________________ view shows the worksheet divided into pages.

Accepted Answer

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

Question 9

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

Accepted Answer

The answer of ____________________ is a technique that can be...

Question 10

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Accepted Answer

A) True 
 B)False

Question 11

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

A) Find Error 
B) Explain Error 
C) Fix Error 
D) Trace Error 
A) Find Error 
B) Explain Error 
C) Fix Error 
D) Trace Error

Question 12

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

Accepted Answer

The answer of When Excel recognizes that you entered a...

Question 13

All of the following are valid Excel arithmetic operators EXCEPT ____.

Accepted Answer

A) ^ 
B) * 
C) % 
D) > 
A) ^ 
B) * 
C) % 
D) >

Question 14

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

Accepted Answer

The answer of A formula in a cell that contains...

Question 15

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 16

The equal sign (=) precedes a formula.

Accepted Answer

A) True 
 B)False

Question 17

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 18

The range automatically selected by Excel is always correct.

Accepted Answer

A) True 
 B)False

Question 19

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Accepted Answer

A) True 
 B)False

Question 20

Case 2-1
Leo, owner of Leo's Bread Company, 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 Accounting 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) Comma style 
B) Percent style 
C) Currency style 
D) General number 
A) Comma style 
B) Percent style 
C) Currency style 
D) General number

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

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 contain numeric data.

The Insert Options button lists formatting options.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

____________________ view shows the worksheet divided into pages.

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

All of the following are valid Excel arithmetic operators EXCEPT ____.

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

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

The equal sign (=) precedes a formula.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The range automatically selected by Excel is always correct.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Access_Module_1

Access_Module_2

Excel_Module_1

Excel_Module_3

PowerPoint_Module_1

PowerPoint_Module_2

PowerPoint_Module_3

Word_Module_1

Word_Module_2

Word_Module_3

Intro to Office 2016 and Windows 10 Module

Productivity App/Productivity Apps for School and Work

Filters

Exam 9: Excel_Module_2

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

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 contain numeric data.

The Insert Options button lists formatting options.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

____________________ view shows the worksheet divided into pages.

____________________ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

All of the following are valid Excel arithmetic operators EXCEPT ____.

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

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

The equal sign (=) precedes a formula.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

The range automatically selected by Excel is always correct.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Introducing Todays Technologies

Connecting and Communicating Online

Computers and Mobile Devices

Programs and Apps

Digital Security, Ethics, and Privacy

Access_Module_1

Access_Module_2

Excel_Module_1

Excel_Module_3

PowerPoint_Module_1

PowerPoint_Module_2

PowerPoint_Module_3

Word_Module_1

Word_Module_2

Word_Module_3

Intro to Office 2016 and Windows 10 Module

Productivity App/Productivity Apps for School and Work

Filters