Deck 8: Excel 3: Formatting a Worksheet

Question 1

Table styles are organized in four categories: Black & White, Light, Medium, and Dark.​

Answer 1

False

Question 2

To add an image to a worksheet, click Pictures in the Illustrations group on the Home tab. _________________________

Answer 2

False

Question 3

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width . _________________________

Answer 3

True

Question 4

The font size is measured in units called pixels . _________________________

Question 5

After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain relative cell references. _________________________

Question 6

The Format Painter button copies both the cell's content and formatting.

Question 7

With Excel, you can adjust the width of one or more columns by using the mouse.

Question 8

Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme. _________________________

Question 9

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

Question 10

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.

Question 11

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

Question 12

You can apply formatting before or after you enter data in a cell or range.

Question 13

Double-clicking the right edge of a column heading activates the AutoSize feature which automatically resizes  the column to accommodate the w​idest entry in the column. ____________________

Question 14

You can change the font and font size of any cell or range using the Mini toolbar.

Question 15

It is acceptable for dates to have a currency format.

Question 16

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

Question 17

When you change a theme, cell styles are automatically updated.​

Question 18

Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.

Question 19

You can add words to the dictionary of the spelling checker.

Question 20

Once you have formatted a range as a table, you can use Live Preview to view the table​ in other styles. ____________________

Question 21

You can change the ____ of labels and values in cells to be left, right, or center.

A) font
B) font size
C) cell style
D) alignment

Question 22

To hide a selected column, click the _____ button in the Cells group on the Home tab.​

A) ​Arrangement
B) ​Format
C) ​Hide
D) ​Columns

Question 23

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

A) Home
B) Review
C) Insert
D) View

Question 24

Which of the following removes only the contents of a selected row or column?

A) the Delete button
B) the [Delete] key
C) the Delete command on a shortcut menu
D) All of the above.

Question 25

To remove all formatting for a selected range, click the _____ button in the Editing group on the Home tab.​

A) ​Erase
B) ​Delete
C) ​Remove
D) ​Clear

Question 26

Double-clicking the column line to the right of a column activates the ____ feature for the column.

A) AutoCorrect
B) Format
C) AutoFit
D) Format as Table

Question 27

###### in a cell means that the ____.

A) formula contains an error
B) value contains an error
C) label has a spelling error
D) column is too narrow to display the value completely

Question 28

Cells and ranges in a worksheet can be formatted ____.

A) only before data is entered
B) only after data is entered
C) before or after data is entered
D) at the same time data is entered

Question 29

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on OneDrive.

A) Find Images
B) Insert Pictures
C) Add Clip Art
D) Add Images

Question 30

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

A) Alignment
B) Styles
C) Cells
D) Editing

Question 31

The default Accounting number format adds dollar signs and ____ decimal places to the data.

A) one
B) two
C) three
D) four

Question 32

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

A) red
B) blue
C) green
D) yellow

Question 33

The ____ size is the physical size of the text.

A) style
B) format
C) serif
D) font

Question 34

A ____ is an individual media file, such as art, sound, animation, or a movie.

A) point
B) cell style
C) clip
D) template

Question 35

The ____ of a cell determines how the labels and values look.

A) value
B) formula
C) label
D) format

Question 36

You can apply font styles and alignment options using the ____ dialog box.

A) Format Cells
B) Insert
C) Conditional Formatting
D) AutoCorrect

Question 37

You can apply font styles and alignment options using the ____ tab of the Ribbon.

A) Insert
B) Home
C) Page Layout
D) View

Question 38

To format a cell or range, first you select it, and then you apply the formatting using the ____, the Mini toolbar, or a keyboard shortcut.

A) Name box
B) formula box
C) Ribbon
D) Sheet tabs

Question 39

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

A) Alignment
B) Styles
C) Clipboard
D) Font

Question 40

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

A) styles
B) Formats
C) Fonts
D) Clip arts

Question 41

You can search for online pictures in Office.com, through the Bing search engine, or on OneDrive by typing one or more ____________________, which are words related to your subject.

Question 42

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

A) Home
B) Data
C) Page Layout
D) Review

Question 43

How do you format a cell or range?

Question 44

The color of a tab changes depending on whether it is the ____________________ tab.

Question 45

It can be difficult to see a(n) ___________________ when a cell is selected.

Question 46

The ____________________ number format adds dollar signs and two decimal places to the data.

Question 47

When do you apply formatting to a cell or range?

Question 48

Cell ____ are predesigned combinations of formats.

A) resolutions
B) dimensions
C) alignments
D) styles

Question 49

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

A) Home
B) Page Layout
C) Review
D) Data

Question 50

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

A) Page Setup
B) AutoCorrect
C) Insert
D) Format Cells

Question 51

____ shows you how a fill color will look before you apply it.

A) Sneak Peek
B) Live Preview
C) Quick Look
D) Advance Look

Question 52

If you create a conditional formatting rule you can modify it using the Conditional Formatting ____.

A) Rules Options dialog box
B) Rules template
C) Rules Wizard
D) Rules Manager

Question 53

You can add multiple worksheets to a workbook by clicking the Home tab on the Ribbon, pressing and holding ____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clicking the Insert list arrow in the Cells group on the Home tab, then clicking Insert Sheet.

A) [Esc]
B) [Shift]
C) [F4]
D) [Alt]

Question 54

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

A) Home
B) Data
C) Page Layout
D) Review

Question 55

____ formatting is automatically updated if you change data in the worksheet.

A) Conditional
B) Spatial
C) Dynamic
D) Data

Question 56

The default format for cells that meet a condition with conditional formatting is ____.

A) Dark Blue Fill with Light Red Text
B) Light Red Fill with Dark Red Text
C) Light Blue Fill with Dark Blue Text
D) Dark Red Fill with Light Red Text

Question 57

The ____________________ heading is the box at the top of each column containing a letter.

Question 58

What is meant by the format of a cell?

Question 59

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

A) Home
B) Page Layout
C) Review
D) Data

Question 60

Discuss inserting or adjusting online pictures and other images in Excel.

Question 62

What does the Format Painter button do?

Question 63

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara wants to indicate to Excel that a given flagged word should not be marked as a misspelling in the future. Which option do you tell her to select?
A. Not misspelled
B. Ignore All
C. Add to Dictionary
D. Autospell

Question 64

Explain why you would add colors, patterns, and borders to a worksheet.

Question 65

Explain conditional formatting.

Question 67

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara has a word in the worksheet that appears to be misspelled in a given instance, but she would like it to be ignored in this one instance. Which option do you tell her to select?
A. Pass
B. Skip
C. Ignore
D. Ignore All

Question 68

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. If Sara adds words to the dictionary using any of the following EXCEPT ____, you tell her that the words will also available in Excel.
A. Word
B. PowerPoint
C. Access
D. OneNote

Question 69

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara has a proper name in the worksheet, all instances of which she would like the spell checker to skip over. What option do you tell her to select?
A. Pass Over
B. Skip All
C. Ignore
D. Ignore All

Question 70

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. After you have helped Sara fix the spelling mistakes in the workbook, she wants to send it to a business colleague. To send it as an email message attachment, you tell her to open it, click the FILE tab, and then click ____ on the navigation bar.
A. Share
B. Attach
C. Send
D. Distribute

Question 71

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Excel has flagged a spelling mistake and Sara has decided that she would like to adjust the spelling of all instances of this misspelling. Which option do you tell her to select?
A. Respell All
B. Change All
C. New Spelling
D. Autospell

Question 73

Critical Thinking Questions Case1-1 Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. Sara has a word in the worksheet, the spelling of which she would like to change in this one instance. Which option do you tell her to select?
A. Change
B. Respell
C. Adjust
D. New Spelling