Filters
Question type
Study Flashcards

MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell


A) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
B) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
C) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
D) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
E) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
F) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
G) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
H) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
I) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
J) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
K) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
L) MATCHING Match each of the following icons with the description that most closely matches its function. -Increases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)

Correct Answer

verifed

verified

In Excel,the table style ____ inserts a new row at the bottom of the table that adds the column values.


A) Header Row
B) Total Row
C) First Row
D) Banded Row

Correct Answer

verifed

verified

You can use a picture or image as the background for all the cells in a worksheet.

Correct Answer

verifed

verified

Excel has only two conditional formats-data bars and highlighting.

Correct Answer

verifed

verified

MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell


A) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
B) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
C) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
D) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
E) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
F) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
G) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
H) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
I) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
J) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
K) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)
L) MATCHING Match each of the following icons with the description that most closely matches its function. -Decreases the size of the indentation used in the cell A) B) C) D) E) F) G) H) I) J) K) L)

Correct Answer

verifed

verified

-In the above figure,the preset button labeled ____ adds lines within the range. A) None B) Outline C) Inside D) none of the above -In the above figure,the preset button labeled ____ adds lines within the range.


A) None
B) Outline
C) Inside
D) none of the above

Correct Answer

verifed

verified

-In the above figure,it shows that ____ is the theme font used for headings. A) Algerian B) Batang C) Cambria D) Calibri -In the above figure,it shows that ____ is the theme font used for headings.


A) Algerian
B) Batang
C) Cambria
D) Calibri

Correct Answer

verifed

verified

One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

Correct Answer

verifed

verified

A ____ is not a type of font.


A) serif
B) sans serif
C) theme
D) true type

Correct Answer

verifed

verified

To view certain columns on a large database,a good option is to ____.


A) hide columns without information you need
B) delete columns you aren't viewing
C) highlight columns you want to view
D) use data bars to find content

Correct Answer

verifed

verified

A(n) ____ specifies formats for elements in an Excel table,such as font color,fill color,and so forth.


A) sheet format
B) Excel table
C) table style
D) style guide

Correct Answer

verifed

verified

Red-green color blindness is the most common,so avoid using red text on a green background or green text on a red background.

Correct Answer

verifed

verified

-In the figure above,you can see that the following table elements were selected: Header Row and ____. A) Total Row B) Banded Columns C) First Column D) Last Column -In the figure above,you can see that the following table elements were selected: Header Row and ____.


A) Total Row
B) Banded Columns
C) First Column
D) Last Column

Correct Answer

verifed

verified

In Excel,dates are ____-aligned in the cell by default,regardless of date format.


A) right
B) left
C) center
D) not

Correct Answer

verifed

verified

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

Correct Answer

verifed

verified

Ajeesh wants to format his Excel table so that every other line is light yellow.He's seen this done on other reports and believes it will make his data easier to follow across rows.Ajeesh begins to apply highlighting to every other line by using the Ctrl key to select the odd rows,but worries that adding and deleting rows will ruin the consistency of his format.What is an alternate solution for Ajeesh?


A) Ajeesh should continue with his current formatting
B) use banded rows
C) Ajeesh should not apply this formatting
D) use Format Painter

Correct Answer

verifed

verified

____________________ is the process of changing a workbook's appearance by defining the fonts,styles,colors,and decorative features.

Correct Answer

verifed

verified

You can rotate cell contents in Excel so that they appear at any angle or orientation.

Correct Answer

verifed

verified

Fonts,colors,and cell styles are organized in ____ categories.


A) theme and non-theme
B) numbers and text
C) color and black & white
D) form and function

Correct Answer

verifed

verified

To access the dialog box shown above,you would navigate to the ____ group on the Home tab.


A) Styles
B) Font
C) Edit
D) Appearance

Correct Answer

verifed

verified

Showing 61 - 80 of 150

Related Exams

Exam 1

Getting Started With Excel

150 Questions

Exam 3

Working With Formulas and Functions

150 Questions

Exam 4

Enhancing a Workbook With Charts and Graphs

150 Questions

Exam 5

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

150 Questions

Exam 6

Managing Multiple Worksheets and Workbooks

150 Questions

Exam 7

Using Advanced Functions and Conditional Formatting

150 Questions

Exam 8

Developing an Excel Application

150 Questions

Exam 9

Working With Financial Tools and Functions

150 Questions

Exam 10

Performing What-If Analyses

150 Questions

Exam 11

Connecting to External Data

150 Questions

Exam 12

Expanding Excel With Visual Basic for Applications

150 Questions

Exam 13

Managing Your Files

150 Questions

Exam 14

Getting Started With Microsoft Office 2010

150 Questions

Show Answer