intro to business-exam 1
Which of the following is the path to the Goal Seek button? 1. (Home tab | Data Tools group) 2. (Insert tab | Goal Seek group) 3. (Analyses tab | Goal Seeking group) 4. (Data tab | Forecast)
(Data tab | Forecast)
Which of the following is the path to the Comma Style button? (Home tab | Alignment group) (Home tab | Font group) (Home tab | Cells group) (Home tab | Number group)
(Home tab | Number group)
Which of the following is the path to the Conditional Formatting button? (Home tab | Editing group) (Styles tab | Formatting group) (Formatting tab | Styles group) (Home tab | Styles group)
(Home tab | Styles group)
Which of the following is the Ribbon path to the Cell Styles button? Selected Answer: Answers: 1. (Styles tab | Home group) 2. (Format tab | Styles group) 3. (Home tab | Format group 4. (Home tab| styles group)
(home tab| styles group)
Which of the following formulas contains an absolute cell reference? 1. =$B$4 2. =B4 3. =$B4 4. =B$4
1. =$B$4
If cell c6 is selected when the cells are frozen, then columns A through C and Rows 1 through 6 will be frozen when scrolling true or false
false
If you click a 3-D Pie chart so that all of the slices are selected, you can drag one of the slices to explode it, leaving the remaining slices unexploded. true or false
false
You can select nonadjacent ranges using the SHIFT key. true or false
false
You cannot format an entire column at once. true or false
false
Combining two or more selected cells into one cell is called _____ cells. 1. mixing 2. combining 3. spanning 4. merging
merging
_____ view allows you to create or modify a worksheet while viewing how it will look in printed format.
page layout
You can use the _____ to check which cells are referenced in formula assigned to active cell. Formula Finder Range Finder Calculation Finder Function Finder
range finder
Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.
right parenthesis
A ____ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.
theme
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. 1. semi-colon (;) 2. colon (:) 3. period (.) 4. none of the above
colon
A(n) _____ chart is drawn on the same worksheet as the data. embedded emboldened embodied empowered
embedded
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. true or false
true
Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell. true or false?
true
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY. : true or false
true
If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked. true or false
true
You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box. true or false
true
You can press the CTRL+[TILDE (~)/ ACCENT MARK(`)] to display the formulas in a worksheet. true or false
true
When Excel follows the order of operations, the formula, 8 * 2 + 2, equals _____.
18
If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.
8.43
Which of the following keys toggles between Insert mode and Overtype mode? INSERT ENTER TAB ALT
INSERT
The _____ function determines the lowest number in a range.
MIN
The most popular background color is _____.
blue
____ refers to cells not wide enough to display the entire entry.
#######
Which of the following is the path to the Spelling button? (Home tab | Proofing group) (Proofing tab | Spelling group) (Review tab | Proofing group) (Review tab | Checking group)
(Review tab | Proofing group)
The _____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet. AutoFormat AutoComplete AutoFunction AutoCalculate
AUTOCALCULATE
Which of the following Option buttons gives options for filling cells following a fill operation?
Auto fill options
You can open the Format Cells dialog box by pressing the _____ keys. SHIFT+TAB CTRL+1 ALT+1 SHIFT+F1
CTRL +1
Which of the following keys moves the insertion point to the end of data in a cell? HOME DELETE END BACKSPACE
END
Which of the following keys is an alternative to double-clicking the cell to edit it? F1 F2 F3 F4
F2
Which of the following keys is an alternative to double-clicking the cell to edit it? 1. F1 2. F2 3. F3 4. F4
F2
Which of the following keys moves the insertion point to the beginning of data in a cell? HOME ENTER INSERT TAB
HOME
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values. logical constant consistent calculated
constant
A quick way to copy a cell to adjacent cells in a row, we would ______________. Use a Fill Handle Copy and paste everyone, rapidly Performs calculations by and add them None of the above
using a fill handle
When you first enter text, its angle is _____ degrees, and it reads from left to right in a cell, as shown in the accompanying figure.
zero degrees
The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
AVERAGE
The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent. 1. Percent style format 2. Accounting number format 3. Comma style format 4. Currency style format
accounting number format
The _____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.
accounting numbers format
In Excel, a number can contain the characters _____. 1. 0 1 2 3 4 5 6 7 8 9 2. + - ( ) , / 3. . $ % E e 4. all of the above
all of the above
When formatting an Excel Worksheet, we can ______________. Increase the font size Change the font color Modify a row size All the above
all of the above
