Excel Baseline

Which path allows you to change page margins

• View tab on the Ribbon then Page Layout
• Home tab on the Ribbon then Format
• Page Layout tab on the Ribbon then Margins
• Page Layout tab on the Ribbon then Print Area

What key sequence is used to view the Formula View?

• Alt + Enter
• Ctrl + `
• Alt + `
• Shift + Tab

A green triangle in the upper left side of the cell indicates what?

• The number is negative
• The cell is complete
• The formula in the cell is different than neighboring cells
• Nothing

What cells are included in Conditional Formatting?

• All cells in a column or row
• Totals, Highest, Lowest and Averages
• The selected range of cells
• You can not do Conditional Formatting in Excel

When inputting "raw data" into an Excel spreadsheet, you include $ symbols and "," separators.

• True
• False

You can reach the "Format Cells" dialog box by right clicking on your mouse.

• True
• False

Bivariate data has how many variables?

• Three
• Two
• Four

What key sequence allows for a two-line header, wraps the text within a cell to the next line?

• Ctrl + Shift
• Crtl + Enter
• Alt + Enter
• Ctrl, Shift, Enter

Which of the following equations illustrates an absolute cell reference for cell b1?

• =a1*$b1
• =a1*b$1
• =a1*$b$1
• = a1*b1

The key used to select non-adjacent ranges of cells.

• Shift Key
• Ctrl Key
• Alt Key