Filters
Question type
Study Flashcards

Italic,bold,bold italic,and underline are examples of _____.


A) font themes
B) font styles
C) graphics
D) character settings

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

Correct Answer

verifed

verified

To avoid splitting a worksheet in awkward places,you can insert a _____ to specify a specific breaking point.


A) page insert
B) manual page break
C) print area
D) selection

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

Correct Answer

verifed

verified

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. -In one of Harold's columns there are too many numbers after the decimal place.Harold does not need this level of detail.It is distracting from the data and he really only needs two numbers after the decimal.How could Harold make the data appear cleaner in the most efficient way?


A) reenter all numbers and only enter two decimal places
B) decrease the column width
C) decrease the font size
D) use the Number group to decrease number of digits displayed

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

Correct Answer

verifed

verified

A(n)____________________ is a key that shows each color used in the worksheet and what it means.

Correct Answer

verifed

verified

MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell


A) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
B) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
C) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
D) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
E) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
F) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
G) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
H) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
I) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)
J) MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell A) B) C) D) E) F) G) H) I) J)

K) F) and G)
L) B) and C)

Correct Answer

verifed

verified

Setting the _____ to A1:L10 will print only data in those cells.


A) Page Format
B) Print Area
C) Page Break
D) Print Preview

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

Correct Answer

verifed

verified

As a general rule,you should _____.


A) center column titles, left-align text, and right-align numbers
B) center column titles, right-align text, and left-align numbers
C) right-align column titles, left-align text, and right-align numbers
D) left-align column titles, left-align text, and right-align numbers

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

Correct Answer

verifed

verified

To add a _____ to a sheet tab,right-click a sheet tab,point to Tab Color on the shortcut menu,and then click a color.


A) fill color
B) tab setting
C) format color
D) formatting style

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

Correct Answer

verifed

verified

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.


A) Format
B) Orientation
C) Sorter
D) Alignment

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

Correct Answer

verifed

verified

What is conditional formatting and why would you apply it? Give two examples of conditional formats,and explain a method for applying conditional formatting.

Correct Answer

verifed

verified

Conditional formatting applies formattin...

View Answer

MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell


A) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
B) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
C) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
D) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
E) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
F) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
G) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
H) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
I) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)
J) MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell A) B) C) D) E) F) G) H) I) J)

K) D) and J)
L) B) and I)

Correct Answer

verifed

verified

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -Each worksheet will contain a specific class with the students' grades for the entire term.In order to determine the current student grade,Antoinette would have to use the _____ function.


A) SUM
B) AVERAGE
C) COUNT
D) MEDIAN

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

Correct Answer

verifed

verified

A(n)____________________ is a collection of formatting that specifies the fonts,colors,and graphical effects used throughout the workbook.

Correct Answer

verifed

verified

A(n)  footer ‾\underline { \text { footer } } appears at the top of each printed page._________________________

A) True
B) False

Correct Answer

verifed

verified

When using the Format Painter,double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____.


A) turn it on
B) turn it off
C) copy formatting
D) paste formatting

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

Correct Answer

verifed

verified

A(n)  conditional format ‾\underline { \text { conditional format } } applies formatting to a cell when its value meets a specified condition._________________________

A) True
B) False

Correct Answer

verifed

verified

Header and footer elements such as worksheet name,current date,and time are _____ elements.


A) descriptive
B) dynamic
C) impact
D) required

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

Correct Answer

verifed

verified

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -Antoinette wants all her worksheets to have the same formatting for text,colors,and graphical effects applied to create a specific look and feel.Antoinette needs to apply a _____.


A) theme
B) template
C) style
D) font

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

Correct Answer

verifed

verified

Information that prints on each page,like a company name or logo,may be set as a _____.


A) print setup
B) copied text
C) text header
D) print title

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

Correct Answer

verifed

verified

The header and footer sections include a _____.


A) left and right section
B) center section only
C) top and bottom section
D) left, right, and center section

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

Correct Answer

verifed

verified

Showing 21 - 40 of 100

Related Exams

Exam 1

Getting Started With Excel

100 Questions

Exam 3

Calculating Data With Formulas and Functions

100 Questions

Exam 4

Analyzing and Charting Financial Data

100 Questions

Exam 5

Working With Excel Tables, Pivot-tables, and Pivot-charts

100 Questions

Exam 6

Managing Multiple Worksheets and Workbooks

100 Questions

Exam 7

Developing an Excel Application

100 Questions

Exam 8

Working With Advanced Functions

100 Questions

Exam 9

Exploring Financial Tools and Functions

100 Questions

Exam 10

Performing What If Analyses

100 Questions

Exam 11

Connecting to External Data

99 Questions

Exam 12

Collaborating on a Shared Workbook

120 Questions

Exam 13

Managing Your Files

100 Questions

Show Answer