Question 1

Critical Thinking Questions 
Case 1-1 
You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company's sales to send to the General Manager. The accompanying figure is the worksheet that you have created so far. 
  Write the complete formulas for the Total row, cell C8 to calculate the second quarter sales for the three stores. 
a. =SUM(C4:C6) 
b. =TOT(C4-C6) 
c. =TOT(C4:C6) 
d. =SUM(C4_C6)

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-1 
You work...

Question 2

Critical Thinking Questions 
Case 1-1 
You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company's sales to send to the General Manager. The accompanying figure is the worksheet that you have created so far. 
  Write the complete formulas for finding the Yearly Sales figures in cell F4 for the Downtown store. 
a. =TOT(B4:E4) 
b. =SUM(B4:E4) 
c. =AVERAGE(B4:E4) 
d. =ADD(B4:E4)

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-1 
You work...

Question 3

=D8+E8*0.5 is a complex formula.

Accepted Answer

This formula contains both a letter and a number, as well as a multiplication and addition symbol, which makes it a complex formula.

Question 4

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result:  =22/2*5  =22/(2*5).

Accepted Answer

According to the order of precedence for arithmetic operators, multiplication and division have the same priority and should be performed from left to right. Therefore, the first formula is equivalent to (22/2)*5 = 11*5 = 55, while the second formula is correctly calculated as 22/(2*5) = 22/10 = 2.2.

Question 5

Match between columns
                        Premises: Used in PowerPoint, Word, and Excel to manage links between files.
Used to format a Word outline you import into PowerPoint.
Tool in Access that enables you to sort the records in a table.
Enables you to store a file with a new filename.
Item added to a file without a link to the source file.

Accepted Answer

The Answer of heading styles and embedded object and Edit is...

Question 6

Critical Thinking Questions 
Case 1-2 
You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. The accompanying figure is the worksheet that you have created so far. 
  You realize that you have made an error in the spreadsheet. Graham's score for test 2 should be 76, not 67. To fix this error, navigate to cell C4, type 76, and then press what key? 
a. [F4] 
b. [Ctrl] 
c. [Enter] 
d. [Alt]

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-2 
You are...

Question 7

An Excel complex formula uses more than one arithmetic operator.

Accepted Answer

A complex formula in Excel can use more than one arithmetic operator, such as +, -, *, /, %, ^, etc.

Question 8

Match between columns
                        Premises: Used to copy and paste more than one item from one program to another program.
Kind of file that receives information copied from another file.
A technology that enables you to integrate data between programs.
Used to paste a chart that cannot be modified.
Items such as text selections, values, and pictures.

Accepted Answer

The Answer of objects and destination and Picture button and is...

Question 9

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Accepted Answer

Auto Fill is a feature in Excel that allows users to quickly copy and/or fill data into adjacent cells. When dragging the fill handle on a cell, Excel will automatically copy the cell's contents (e.g. text, numbers, formulas) or continue a series of data (e.g. dates, days of the week, months) into adjacent cells.

Question 10

Match between columns
                        Premises: Often contains the names of data groups, such as locations, months, or years.
Often contains numerical values that help you interpret the size of chart elements.
An independent element on a worksheet.
Visually represents each data point.
Before creating this, you need to plan the information you want it to show.

Accepted Answer

The Answer of data marker and object and value axis is...

Question 11

Explain the difference between Normal view and Page Layout view in Excel.

Accepted Answer

The answer of Explain the difference between Normal view and...

Question 12

Describe calculation operators, including the different types of calculation operators.

Accepted Answer

The answer of Describe calculation operators, including the different types...

Question 13

Match between columns
                        Premises: The name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design.
Equal to 1/72 of an inch.
Has a default value of 8.43 characters, a little less than one inch.
A predefined set of attributes that gives your Excel worksheet a professional look.
A type of conditional formatting that visually illustrates differences among values.

Accepted Answer

The Answer of font and point and theme and column is...

Question 14

Discuss the five guidelines for creating calculations in Excel.

Accepted Answer

The answer of Discuss the five guidelines for creating calculations...

Question 15

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Accepted Answer

The answer of According to the order of precedence for...

Question 16

Match between columns
                        Premises: The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only."
A statistical function.
Absolute cell reference.
Predesigned workbook files that contain labels, values, formulas, and formatting.
The type of cell reference used to preserve the relationship to the formula location.
Mixed cell reference.
The Excel function that returns the number of cells in a range containing numeric data.
Allows the user to move or copy data from one cell to another without using the Clipboard.

Accepted Answer

The Answer of $G$6 and template and COUNT and drag-and-drop is...

Question 17

Critical Thinking Questions 
Case 1-2 
You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. The accompanying figure is the worksheet that you have created so far. 
  You want to put a formula in cells D4 through D11 for finding the difference between the two test scores for each student. You enter =C4-B4 in cell D4 and then use what feature to copy the formula down the column through cell D11? 
a. formula copier 
b. fill handle 
c. formula painter 
d. formula index

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-2 
You are...

Question 18

What do you have the ability to do when you use Excel?

Accepted Answer

The answer of What do you have the ability to...

Question 19

Describe Excel's AutoRecover feature.

Accepted Answer

The answer of Describe Excel's AutoRecover feature....

Question 20

Critical Thinking Questions 
Case 1-2 
You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. The accompanying figure is the worksheet that you have created so far. 
  Which of the following is NOT a valid formula for use in cell B13 for finding the average of the test? 
a. =(B4+B5+B6+B7+B8+B9+B10+B11)/8 
b. =SUM(B4:B11)/8 
c. =(B4+B5+B6+B7+B8+B9+B10+B11)/COUNT(B4:B11) 
d. =AVG(B4:B11)

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-2 
You are...

Quiz 11: Excel 2013 Getting Started With Excel 2013

=D8+E8*0.5 is a complex formula.

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/25 =22/(25).

Identify the letter of the choice that best matches the phrase or definition.

An Excel complex formula uses more than one arithmetic operator.

Identify the letter of the choice that best matches the phrase or definition.

With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

Identify the letter of the choice that best matches the phrase or definition.

Explain the difference between Normal view and Page Layout view in Excel.

Describe calculation operators, including the different types of calculation operators.

Identify the letter of the choice that best matches the phrase or definition.

Discuss the five guidelines for creating calculations in Excel.

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

Identify the letter of the choice that best matches the phrase or definition.

What do you have the ability to do when you use Excel?

Describe Excel's AutoRecover feature.