Excel Mod 1 Quiz
You can apply the Bold font style by pressing the ____ keyboard shortcut keys. a. SHIFT+B b. TAB+B c. CTRL+B d. ALT+B
CTRL+B
To enter data in a cell, you must first select the _____. a. cell b. worksheet c. column d. row
Cell
A pie chart with one or more slices offset is referred to as a(n) _____ pie chart. a. outer b. offset c. rasterized d. exploded
Exploded
_____ is/are used to place worksheet, column, and row tiles on a worksheet. a. Text b. Color c. Links d. Tabs
Text
How many chart types does Excel offer? a. 5 b. 15 c. 30 d. 50
15
Which of the following is the Ribbon path to the Cell Styles button? a. (HOME tab / Format Group) b. (FORMAT tab / Styles Group) c. (HOME tab / Styles Group) d. (STYLES tab / Home Group)
(HOME tab / Styles group)
Excel remembers the last _____ actions you have completed. a. 25 b. 50 c. 75 d. 100
100
The _____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. a. Auto Fill Options b. Formmatting Options c. Replace Options d. Copy Options
Auto Fill Options
The _____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu. a. AutoComplete b. AutoFunction c. AutoCalculate d. AutoFormat
AutoCalculate
The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. a. AutoTyping b. AutoFormat c. AutoCorrect d. AutoComplete
AutoCorrect
What effect does the Comma Style format have on the selected cells? a. converts decimals to commas within merged cells b. displays cell contents with two decimal places and commas as thousands separators c. converts decimals to commas within a cell d. allows for substitution of selected characters
Displays cell contents with two decimal places and commas as thousands separators
What effect does the Accounting Number Format have on the selected cells? a. performs tax calculations b. copies the numbers of one cell to another c. displays cell contents with two decimal places hat align vertically d. converts alphabetic characters to numbers
Displays cell contents with two decimal places that align vertically
Which of the following keys moves the insertion point to the end of data in a cell? a. BACKSPACE b. HOME c. END d. DELETE
END
To erase an entire entry in a cell and then reenter the data from the beginning, press the _____ key. a. ESC b. CTRL c. ALT d. TAB
ESC
You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. a. format b. clear c. print d. save
Format
Which of the following keys toggles between Insert mode and Overtype mode? a. TAB b. ENTER c. ALT d. INSERT
INSERT
Pressing the _____ key to complete an entry activates the adjacent cell to the right. a. RIGHT ARROW b. DOWN ARROW c. LEFT ARROW d. UP ARROW
RIGHT ARROW
_____ properties are associated with all Microsoft Offices files and include author, title, and subject. a. Replacement b. Automatic c. Hidden d. Standard
Standard
The first step in creating an effective worksheet is to make sure you _____. a. apply font formatting b. insert a chart c. enter the data d. understand what is required
Understand what is required
You use _____ to view an XPS file. a. XPS Viewer b. Microsoft Power View c. Backstage View d. Adobe Reader
XPS Viewer