Question 1

MATCHING
-A preformatted workbook with many design features and some content already filled in.

Accepted Answer

A)  function
B)  Name box
C)  worksheet
D)  range
E)  order of operationsF) sheet tabsG) CtrlH) Normal viewI) formula viewJ) templateK) A) and G)
L) E) and F)

Question 2

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Accepted Answer

A) True 
 B)False

Question 3

MATCHING
-A named operation that replaces the arithmetic expression in a formula

Accepted Answer

A)  function
B)  Name box
C)  worksheet
D)  range
E)  order of operationsF) sheet tabsG) CtrlH) Normal viewI) formula viewJ) templateK) A) and B)
L) E) and I)

Question 4

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Accepted Answer

The answer of Keyboard ____________________ can help you work faster...

Question 5

A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

Accepted Answer

The answer of A(n) ____________________ is a named operation that...

Question 6

Changing the page orientation affects only the ____________________ sheet.

Accepted Answer

The answer of Changing the page orientation affects only the...

Question 7

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

Accepted Answer

A)   shrink
B)   size
C)   scale
D)   scrollE) All of the above
F) C) and D)

Question 8

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

Accepted Answer

A)   Ctrl + Enter
B)   Alt + Enter
C)   Alt + E
D)   Ctrl + EE) None of the above
F) A) and C)

Question 9

MATCHING
-Displays the name of the sheets in the workbook

Accepted Answer

A)  function
B)  Name box
C)  worksheet
D)  range
E)  order of operationsF) sheet tabsG) CtrlH) Normal viewI) formula viewJ) templateK) I) and J)
L) F) and I)

Question 10

In the above figure, which box displays the formula in the formula bar?

Accepted Answer

A)   1
B)   2
C)   5
D)   6E) A) and B)
F) A) and C)

Question 11

MATCHING
-Contains a grid of rows and columns into which you can enter text, numbers, dates, and formulas, and display charts.

Accepted Answer

A)  function
B)  Name box
C)  worksheet
D)  range
E)  order of operationsF) sheet tabsG) CtrlH) Normal viewI) formula viewJ) templateK) D) and F)
L) D) and G)

Question 12

Every function follows a set of rules, or syntax, which specifies how the function should be written. _________________________

Accepted Answer

A) True 
 B)False

Question 13

Samantha is a distributor of jewelry. She uses Excel 2013 to record her inventory and order forms. Samantha's worksheet for her company's monthly orders needs to display summary information including the total number of items ordered and the amount of revenue generated from those orders.
-Samantha decides to rename her worksheet "Samantha's Jewelry Business Worksheet" but she is unable to complete the word "Worksheet" because Excel ____.

Accepted Answer

A)   only allows for three words in a sheet name
B)   only allows for 31 characters in a sheet name
C)   only allows one word in a sheet name
D)   does not allow for symbols such as the apostrophe in Sam's in sheet namesE) A) and B)
F) None of the above

Question 14

To move the active cell up one row, press ____.

Accepted Answer

A)   Shift + Enter
B)   Ctrl + Tab
C)   Shift + Tab
D)   Ctrl + EnterE) C) and D)
F) A) and B)

Question 15

To change the order of operations, enclose part of the formula in ____.

Accepted Answer

A)   brackets
B)   italics
C)   parentheses
D)   quotation marksE) A) and B)
F) A) and C)

Question 16

____ displays the location of the different page breaks within the worksheet.

Accepted Answer

A)   Normal
B)   Page Preview
C)   Page Break Preview
D)   Page Break LayoutE) None of the above
F) A) and B)

Question 17

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
-Column B in Tyler's spreadsheet contains the addresses of his clients. Some of the addresses are truncated so Roger ____.

Accepted Answer

A)   uses the AutoComplete command to allow for complete entries
B)   uses the AutoFit command to remove unwanted space
C)   resizes the column width until all addresses are visible
D)   switches to Edit modeE) C) and D)
F) B) and D)

Question 18

Speed Fill enters text based on patterns it finds in the data.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following will not change the location of the active cell?

Accepted Answer

A)   drag and drop
B)   scrolling
C)   clicking another cell
D)   clicking a column headingE) All of the above
F) C) and D)

Question 20

The ____________________ font size for worksheets is 11 points.

Accepted Answer

The answer of The ____________________ font size for worksheets is...

Exam 6: Getting Started With Excel

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Correct Answer
verified

To change the order of operations, enclose part of the formula in ____.

Correct Answer
verified

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

Correct Answer
verified

A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

Correct Answer
verified

The ____________________ font size for worksheets is 11 points.

Correct Answer
verified

Correct Answer
verified

Which of the following will not change the location of the active cell?

Correct Answer
verified

Correct Answer
verified

MATCHING -A named operation that replaces the arithmetic expression in a formula

Correct Answer
verified

MATCHING -Displays the name of the sheets in the workbook

Correct Answer
verified

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Correct Answer
verified

In the above figure, which box displays the formula in the formula bar?

Correct Answer
verified

To move the active cell up one row, press ____.

Correct Answer
verified

____ displays the location of the different page breaks within the worksheet.

Correct Answer
verified

MATCHING -A preformatted workbook with many design features and some content already filled in.

Correct Answer
verified

MATCHING -Contains a grid of rows and columns into which you can enter text, numbers, dates, and formulas, and display charts.

Correct Answer
verified

Every function follows a set of rules, or syntax, which specifies how the function should be written. _________________________

Correct Answer
verified

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

Correct Answer
verified

Changing the page orientation affects only the ____________________ sheet.

Correct Answer
verified

Speed Fill enters text based on patterns it finds in the data.

Correct Answer
verified

Exam 6: Getting Started With Excel

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Correct AnswerverifiedShow Answer

To change the order of operations, enclose part of the formula in ____.

Correct AnswerverifiedShow Answer

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

Correct AnswerverifiedShow Answer

A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

Correct AnswerverifiedShow Answer

The ____________________ font size for worksheets is 11 points.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Which of the following will not change the location of the active cell?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

MATCHING -A named operation that replaces the arithmetic expression in a formula

Correct AnswerverifiedShow Answer

MATCHING -Displays the name of the sheets in the workbook

Correct AnswerverifiedShow Answer

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window.

Correct AnswerverifiedShow Answer

In the above figure, which box displays the formula in the formula bar?

Correct AnswerverifiedShow Answer

To move the active cell up one row, press ____.

Correct AnswerverifiedShow Answer

____ displays the location of the different page breaks within the worksheet.

Correct AnswerverifiedShow Answer

MATCHING -A preformatted workbook with many design features and some content already filled in.

Correct AnswerverifiedShow Answer

MATCHING -Contains a grid of rows and columns into which you can enter text, numbers, dates, and formulas, and display charts.

Correct AnswerverifiedShow Answer

Every function follows a set of rules, or syntax, which specifies how the function should be written. _________________________

Correct AnswerverifiedShow Answer

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

Correct AnswerverifiedShow Answer

Changing the page orientation affects only the ____________________ sheet.

Correct AnswerverifiedShow Answer

Speed Fill enters text based on patterns it finds in the data.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified