Deck 2: Formatting, functions, and Formulas

Question 1

Which of the following is Excel's symbol for multiplication?

A)#
B)&
C)x
D)*

Answer 1

D

Question 2

The keyboard shortcut for apply the Comma format is ________.

A)Ctrl + !
B)Ctrl + ,
C)Ctrl + Shift + !
D)Ctrl + Shift + ,

Answer 2

C

Question 3

The AutoSum button is located in the ________.

A)Function Library on the HOME tab
B)Number group on the HOME tab
C)Function Library group on the FORMULAS tab
D)Number group on the FORMULAS tab

Answer 3

C

Question 4

The Cell Styles gallery is displayed by clicking Cell Styles in the ________.

A)Cells group on the HOME tab
B)Styles group on the HOME tab
C)Cells group on the PAGE LAYOUT tab
D)Styles group on the PAGE LAYOUT tab

Question 5

The Total Row check box is located in the ________ group on the DESIGN tab.

A)Table Style Options
B)Number Styles
C)Functions
D)Totals

Question 6

How many options are there for aligning the contents within a cell?

A)Two
B)Four
C)Six
D)Eight

Question 7

To change a table back into a range,you click Convert to Range in the ________.

A)Tools group on the DESIGN tab
B)Styles group on the DESIGN tab
C)Tools group on the VIEW tab
D)Styles group on the VIEW tab

Question 8

Which of the following lists follows Excel's order of operations?

A)Parentheses Exponentiation Addition and subtraction Multiplication and division
B)Parentheses Exponentiation Multiplication and division Addition and subtraction
C)Exponentiation Parentheses Multiplication and division Addition and subtraction
D)Exponentiation Parentheses Addition and subtraction Multiplication and division

Question 9

is the ________ button.

A)Find Illustrations
B)Snap to Grid
C)Align Objects
D)Insert Picture

Question 10

Which of the following is NOT a numerical format?

A)Integer
B)Accounting
C)Short Date
D)General

Question 11

COUNT,AVERAGE,MIN,and MAX are examples of Excel ________.

A)formulas
B)functions
C)arguments
D)expressions

Question 12

When cell D4 containing the formula =A4*B5 is copied to cell E2,the formula in cell E2 is ________.

A)=A4*B5
B)=B4*C5
C)=B2*C3
D)=A2*B3

Question 13

The Table Styles gallery is displayed by clicking Format as Table in the ________.

A)Themes group on the HOME tab
B)Styles group on the HOME tab
C)Themes group on the PAGE LAYOUT tab
D)Styles group on the PAGE LAYOUT tab

Question 14

The Picture dialog box is displayed by clicking Pictures in the ________.

A)Illustrations group on the INSERT tab
B)Show group on the INSERT tab
C)Illustrations group on the PAGE LAYOUT tab
D)Show group on the PAGE LAYOUT tab

Question 15

Following Excel's order of operations,what is the result of the formula =10-4/2*(5-2)?

A)9
B)13
C)8)5
D)4

Question 16

The first argument in the SUBTOTAL function identifies the ________.

A)number of decimal places in the result
B)cell range
C)number of significant digits in the result
D)statistic to be calculated

Question 17

________ is the SUM keyboard shortcut.

A)Ctrl + =
B)Alt + =
C)Ctrl + +
D)Alt + +

Question 18

The Themes gallery is displayed by clicking Themes in the ________.

A)Themes group on the HOME tab
B)Styles group on the HOME tab
C)Themes group on the PAGE LAYOUT tab
D)Styles group on the PAGE LAYOUT tab

Question 19

________ Format Painter allows you to use it multiple times.

A)Right-clicking
B)Double-clicking
C)Clicking while pressing Ctrl
D)Clicking while pressing Alt

Question 20

is the ________ button.

A)Bottom Align
B)Top Align
C)Align Right
D)Align Left

Question 21

A table style is a predefined set of formatting properties that control the appearance of a table.

Question 22

To hide a row of information,you place the mouse pointer over the row heading,________.

A)click once, and in the Arrange group, click Hide Row
B)click once, and in the View group, click Hide Row
C)double-click and click Hide from the shortcut menu
D)right-click and click Hide from the shortcut menu

Question 23

When using a table, is the Sort arrow.

Question 24

The default Excel theme is the Office theme.

Question 25

The AutoSum button is located in the Editing group on the HOME tab.

Question 26

The Comma format is just the Accounting format with the currency symbol.

Question 27

You can apply a different theme to each worksheet in your workbook.

Question 28

You should use at most three fonts in a worksheet.

Question 29

To remove conditional formatting from a range of cells,after selecting the range of cells,________.

A)click Conditional Formatting, point to Clear Rules, and select Clear Rules from Selected Cells
B)click Conditional Formatting and click Delete Rules
C)press Backspace
D)press Delete

Question 30

The Show Formulas button in located in the ________.

A)Show group on the VIEW tab
B)Formula Auditing group on the VIEW tab
C)Show group on the FORMULAS tab
D)Formula Auditing group on the FORMULAS tab

Question 31

The keyboard shortcut to hide or show formulas in a worksheet is ________.

A)Ctrl + ~
B)Ctrl + @
C)Alt + ~
D)Alt + @

Question 32

is the Currency button.

Question 33

Excel can present information in tabular and graphical formats.

Question 34

When adding a fill color to a cell,the color palette is displayed by clicking the Fill Color button.

Question 35

Striping uses alternating background colors of rows or columns to aid in visually tracking information.

Question 36

The Conditional Formatting button is located in the ________.

A)Cells group on the FORMAT tab
B)Styles group on the FORMAT tab
C)Cells group on the HOME tab
D)Styles group on the HOME tab

Question 37

To hide or show gridlines in a worksheet,you click Gridlines in the ________.

A)Workbook Views group on the VIEW tab
B)Show group on the VIEW tab
C)Workbook Views group on the HOME tab
D)Show group on the HOME tab

Question 38

Once a range of data has been converted to a table,it CANNOT be converted back into a range.

Question 39

Formatting does not change the data value,it only changes its appearance.

Question 40

When using the Currency number format,zero values are displayed as a long dash (-)at the decimal position.

Question 41

To remove conditional formatting from a range of cells,you select the range of cells and then press Delete.

Question 42

Adding a total row to a table only allows you to sum the columns.

Question 43

To display a hidden row,you select the rows above and below the hidden row,right-click the selection,and then select Unhide from the shortcut menu.

Question 44

To find the smallest numerical value in a range of cells,you would use the MIN function.

Question 45

You can hide an individual cell by right-clicking the cell and selecting Hide from the shortcut menu.

Question 46

When cell D5 containing the formula =B5+E5 is copied to cell F6,the formula in cell F6 is =D6+G6.

Question 47

Gridlines is a toggle button.

Question 48

Conditional Formatting is a toggle button.

Question 49

The argument for the COUNT function is limited to a range of contiguous cells.

Question 50

Following Excel's order of operations,the result of the formula =2^3-6/2 is 1.

Question 51

The MAX function finds the largest number in a range of numeric cells.

Question 52

When first argument in the SUBTOTAL function is in the range 101-111,only the visible values in the specified range are used.

Question 53

You can use AutoSum function be selecting either the destination cell or the source cell(s).

Question 54

Ctrl + & is the keyboard shortcut to hide or show formulas in a worksheet.

Question 55

Clicking the AutoSum button displays a list of additional numeric functions such as COUNT and MAX.

Question 56

Only visible data is a table is used by the SUBTOTAL function in calculating results.

Question 57

Conditional formatting allows you to dynamically change the appearance of cells so that it adds information to your worksheet.

Question 58

^ is the symbol used in Excel to indicate multiplication.

Question 59

When you format a range as a table,you must name every column in the table.

Question 60

By applying a filter to a table,you can determine which data are shown.

Question 61

is the ________ button.

Question 62

A(n)________ cell style is a predefined and named combination of cell-formatting and content-formatting that can be applied to a cell or range of cells.

Question 63

The ________ paste option pastes a range of cells to a new range of cells with columns and rows switched.

Question 64

A(n)________ is a collection of fonts,styles,colors,and effects applied to a worksheet.

Question 65

Excel's ________ format is used to present information in charts,graphs,and pictures.

Question 66

The ________ number formatting displays commas and decimal points but not currency symbols.

Question 67

is the ________ button.

Question 68

Show Formulas is a toggle button.

Question 69

A(n)________ is a data-formatting tool that simplifies data sorting,filtering,and calculations.

Question 70

When adding a border to a cell,the Borders menu is displayed by clicking the ________.

Question 71

When a text format is applied to a cell,its contents are ________ aligned in the cell.

Question 72

A(n)________ is a program that perform an operation on data.

Question 73

Pressing the ________ key deactivates Format Pointer.

Question 74

Exporting worksheets in Formula View to a PDF file is an excellent way to document your workbook.

Question 75

When using the ________ number format,negative numbers can be displayed with a dash (-),parentheses,or in red.

Question 76

________ color is the background color of a cell.

Question 77

When using the Accounting number format,negative numbers are indicated by ________.

Question 78

To see more of a worksheet,you can ________ a tab to hide the Ribbon.

Question 79

When a number format is applied to a cell,its contents are ________ aligned in the cell.

Question 80

is the ________ button.