intro to business-exam 1

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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


संबंधित स्टडी सेट्स

Chapter 9 - Joining Data From Multiple Tables

View Set

Objective E: El Nino, La Nina sets

View Set

Combo with CA LIFE STATE PRACTICE EXAM PT 2(FROM EXAM FX ONLINE TEST) and 1 other

View Set