Filters
Question type
Study Flashcards

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

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

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

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

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. -Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.


A) selective
B) nonadjacent
C) consecutive
D) specific

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) top

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. -Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.


A) type the data in A1 and Merge cells A1:A5
B) type the data in A1 and Merge cells A1:E1
C) type the data in C1
D) type the data in any column in row 1 and then choose Center from the Format menu

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 and white
D) form and function

Correct Answer

verifed

verified

One of the benefits of Live Preview is that it _____.


A) lets you see and evaluate different formats as you develop your workbook
B) shows you what a document will look like when printed
C) applies thematic styles to your document
D) allows you to track changes in your document

Correct Answer

verifed

verified

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.


A) numbers
B) text
C) universal numbers
D) Greenwich Mean Time

Correct Answer

verifed

verified

Color allows you to effectively enhance a workbook, but could you ever use too much or "bad" color? Explain how or when color might detract from a workbook. Give at least four tips for effective color use.

Correct Answer

verifed

verified

When used wisely, color can enhance any ...

View Answer

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

Correct Answer

verifed

verified

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)

Correct Answer

verifed

verified

To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.

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

Correct Answer

verifed

verified

MATCHING Match each of the following icons with the description that most closely matches its function. -Merges the selected cells into a single cell


A) MATCHING Match each of the following icons with the description that most closely matches its function. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single 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. -Merges the selected cells into a single cell A) B) C) D) E) F) G) H) I) J)

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

Excel organizes fonts into theme and non-theme fonts. _________________________

Correct Answer

verifed

verified

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____.


A) Master
B) Gallery
C) Palette
D) Painter

Correct Answer

verifed

verified

If you want to print only part of a worksheet, you can set a(n) print area, which is the region of the worksheet that is sent to the printer. _________________________

Correct Answer

verifed

verified

Showing 21 - 40 of 100

Related Exams

Exam 1

Creating a Database

100 Questions

Exam 2

Building a Database and Defining Table Relationships

98 Questions

Exam 3

Maintaining and Querying a Database

100 Questions

Exam 4

Creating Forms and Reports

100 Questions

Exam 5

Essential Computer Concepts

100 Questions

Exam 6

Getting Started With Excel

100 Questions

Exam 8

Calculating Data With Formulas and Functions

100 Questions

Exam 9

Analyzing and Charting Financial Data

100 Questions

Exam 10

Exploring the Basics of Windows 8

100 Questions

Exam 11

Integrating Word, Excel, Access, and Powerpoint

100 Questions

Exam 12

Internet Basics and Information Literacy

100 Questions

Exam 13

Introduction to Cloud Computing

50 Questions

Exam 14

Managing Your Files

100 Questions

Exam 15

Creating a Presentation

100 Questions

Exam 16

Adding Media and Special Effects

100 Questions

Exam 17

Creating and Editing a Document

100 Questions

Exam 18

Navigating and Formatting a Document

100 Questions

Exam 19

Creating Tables and a Multipage Report

100 Questions

Exam 20

Enhancing Page Layout and Design

100 Questions

Show Answer