Upgrade to remove ads
Only $35.99/year

Excel module 1

Terms in this set (10)

Which of the following views shows how a worksheet will appear when printed?
A) Page Layout view
B) Page Break view
C) Normal view
D) Reading view
A) Page layout view
To change the color of a cell content, you use the_____ Color list arrow.
A) cell
B) text
C) pattern
D) Font
D) Font
To View a worksheet without Gridlines showing on the screen, which of the following would you uncheck?
A) Gridlines View
B) Gridlines Print
C) Headings View
D) Headings Print
A) Gridlines View
Which of the following is true when you delete a cell?
A) when you delete a cell using the Delete list arrow, you can choose which way to move adjacent cells
B) Row and column alignment will not be affected
C) you need to manually adjust cell references and surrounding formulas
D)You can use the Delete command on the Insert tab
A) when you delete a cell using the delete list arrow, you can choose which way to move adjacent cells
A________ is the appearance and shape of letters, numbers, and special characters
A) symbol
B) Font
C) Point
D)Keyword
B) Font
To except a suggested spelling for that instance only, which of the following would you click?
A) Change
B) Change All
C) Ignore All
D) Add to Dictionary
A) Change
To format a range so that all values greater than $500 appear in red, which of the following can you use?
A) conditional formatting
B) cell Formatting
C) self styles
D) Quick Access toolbar
A) conditional formatting
Which of the following would you use to create a duplicate of the selected cells when the CTRL key is pressed?
A) Normal pointer
B) I-beam pointer
C) Move pointer
D) Copy pointer
D) copy pointer
When you double click the right border of a column headings, which of the following occurs?
A) The column is deleted
B) Autofit resizes the column to 8.43 characters wide
C) A call them is added to the right of the current column
D) Autofit resizes the column to the widest cell entry
D) Auto fit resizes the column to the widest cell entry
To combine multiple cells into one combined cell, which of the following do you use?
A) Column Width button
B) Center button
C) Merge and Center button
D) Increase Indent button
C) Merge and Center button
Sets found in the same folder