Filters
Question type

Study Flashcards

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

Correct Answer

verifed

verified

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


A) brackets
B) italics
C) parentheses
D) quotation marks

E) A) and D)
F) None of the above

Correct Answer

verifed

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.


A) shrink
B) size
C) scale
D) scroll

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

The ____________________ font size for worksheets is 11 points.

Correct Answer

verifed

verified

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 ____.


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 names

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

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


A) drag and drop
B) scrolling
C) clicking another cell
D) clicking a column heading

E) A) and B)
F) A) and D)

Correct Answer

verifed

verified

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 ____.


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 mode

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

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


A) function
B) Name box
C) worksheet
D) range
E) order of operations
F) sheet tabs
G) Ctrl
H) Normal view
I) formula view
J) template

K) B) and E)
L) E) and I)

Correct Answer

verifed

verified

MATCHING -Displays the name of the sheets in the workbook


A) function
B) Name box
C) worksheet
D) range
E) order of operations
F) sheet tabs
G) Ctrl
H) Normal view
I) formula view
J) template

K) D) and E)
L) C) and G)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A) 1
B) 2
C) 5
D) 6

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

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


A) Shift + Enter
B) Ctrl + Tab
C) Shift + Tab
D) Ctrl + Enter

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

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


A) Normal
B) Page Preview
C) Page Break Preview
D) Page Break Layout

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

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


A) function
B) Name box
C) worksheet
D) range
E) order of operations
F) sheet tabs
G) Ctrl
H) Normal view
I) formula view
J) template

K) A) and F)
L) I) and J)

Correct Answer

verifed

verified

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


A) function
B) Name box
C) worksheet
D) range
E) order of operations
F) sheet tabs
G) Ctrl
H) Normal view
I) formula view
J) template

K) B) and C)
L) A) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

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.


A) Ctrl + Enter
B) Alt + Enter
C) Alt + E
D) Ctrl + E

E) None of the above
F) All of the above

Correct Answer

verifed

verified

Changing the page orientation affects only the ____________________ sheet.

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Showing 81 - 100 of 100

Related Exams

Show Answer