Filters
Question type
Study Flashcards

What is not one of the tabs in Excel?


A) Formulas
B) Page Layout
C) File
D) Mailings

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Which of the following is not considered an Excel element?


A) Formula Bar
B) Name Box
C) Active cell
D) Print Preview

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

A(n)________ is a group of cells which have been selected at the same time.

Correct Answer

verifed

verified

What can you not do directly from the Backstage, Print screen view?


A) Switch to formula view and print formulas
B) Select which printer you want to use
C) Select how much of the worksheet will be printed
D) Set the page orientation

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

Correct Answer

verifed

verified

Which of the following is not included when you use a cell style?


A) Font
B) Cell protection
C) Alignment
D) Borders

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

Correct Answer

verifed

verified

B

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

Correct Answer

verifed

verified

How is text aligned by default?


A) Left
B) Center
C) Right
D) Decimal

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

Correct Answer

verifed

verified

A(n)________ range contains several ranges.

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Formula
Fill handle
Order of operations
Pointing
Name Box
Responses
PEMDAS
Small green square used to perform various actions
Displays the address of the active cell
Always begins with an equals sign (=)
Also known as semi-selection

Correct Answer

Formula
Always begins with an equals sign (=)
Fill handle
Small green square used to perform various actions
Order of operations
PEMDAS
Pointing
Also known as semi-selection
Name Box
Displays the address of the active cell

Match the following terms with their description:

Premises
Accounting number format
Currency number format
Transpose
Paste Special , Add
Flash Fill
Responses
Puts the $ at the left margin of the cell
Puts the $ next to the leftmost number
Sums the values of the pasted cells to the cells already there
Fills in data based on previous column's data
Flips rows and columns when pasted

Correct Answer

Accounting number format
Currency number format
Transpose
Paste Special , Add
Flash Fill

The ________ color is what is visible behind the value in a cell.

Correct Answer

verifed

verified

fill

________ can be used in calculations, whereas text cannot.

Correct Answer

verifed

verified

Which keyboard shortcut puts the user in cell edit mode?


A) F2
B) Shift F2
C) F3
D) Shift F3

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

Correct Answer

verifed

verified

A(n)________ is a collection of one or more related worksheets.

Correct Answer

verifed

verified

workbook, ...

View Answer

The cell at row 4 and column B, would be identified as 4B.

A) True
B) False

Correct Answer

verifed

verified

The best way to apply Page Setup options to multiple worksheets is to ________.


A) group the worksheets
B) use the Format Painter
C) copy and Paste the formatting codes from one sheet to another
D) use the Apply to Selected Sheets formatting command

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

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Page Break Preview
Normal view
Page Layout view
Sheet tab navigation
View controls
Responses
Allows you to go to the first, previous, next, or last sheet in a workbook
Icons that let you change views
Displays data and page breaks
Displays data and margins
Does not display margins or page breaks

Correct Answer

Page Break Preview
Normal view
Page Layout view
Sheet tab navigation
View controls

The ________ area is where you store the variable you will be using in the worksheet.

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Cell
Zoom control
Worksheet
Sheet tab
Workbook
Responses
Shows the name of the worksheet
The same as a spreadsheet
Makes the text on the screen smaller or larger
Contain labels, values and formulas
The intersection of a column and a row

Correct Answer

Cell
Zoom control
Worksheet
Sheet tab
Workbook

Showing 1 - 20 of 100

Related Exams

Exam 2

Formulas and Functions

100 Questions

Exam 3

Charts

100 Questions

Exam 4

Datasets and Tables

100 Questions

Exam 5

Subtotals, Pivottables, and Pivotcharts

100 Questions

Exam 6

What-If Analysis

100 Questions

Exam 7

Specialized Functions

100 Questions

Exam 8

Statistical Functions

100 Questions

Exam 9

Multiple-Sheet Workbook Management

98 Questions

Exam 10

Imports, Xml, and Power Add-Ins

95 Questions

Exam 11

Collaboration and Workbook Distribution

96 Questions

Exam 12

Templates, Styles, and Macros

97 Questions

Exam 13

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

115 Questions

Show Answer