Excel Ch 2 Terms 2Online version Match the definition with the correct term. by Kerri Stegman 1 Displays the lowest value in a range a MIN function b MAX function c range finder d conditional formatting 2 Colors like red and orange that tend to reach toward a reader a condition b warmer colors c cooler colors d theme 3 A predefined set of colors, fonts, chart styles, cell styles, and fill effects a pixel b warmer colors c theme d cooler colors 4 Default view in Excel a best fit b theme c landscape orientation d normal view 5 Applies formatting only when the value meets a specified condition a conditional formatting b condition c debugging d values version 6 Colors like blue, green, and violet that tend to pull away from a reader a theme b cooler colors c warmer colors d pixel 7 Common content that prints on the bottom of each page a margins b page layout view c footer d header 8 Displays numbers with a dollar sign to the left and inserts a comma every three positions a percent style button b comma version c conditional formatting d accounting number format 9 Displays the highest value in a range a MAX function b MIN fuction c values version d formula version 10 Allows you to create or modify a worksheet while viewing how it will look in printed format a landscape view b page layout view c normal view d margins 11 Made up of two values and a relational operator a best fit b conditional formatting c condition d range finder 12 Dollar sign that appears immediately to the left of the first digit a accounting number format b best fit c fixed dollar sign d floating dollar sign 13 A printout that is printed such that its width is greater than its length a landscape view b best fit c margins d hiding cells 14 Dot on screen that contains color a normal view b pixel c warmer colors d cooler colors 15 Inserts a comma every three positions to the left of the decimal point and causes numbers to be displayed to the nearest hundredths a values version b accounting number format c comma style d formula version 16 Version of a worksheet that allows you to display the actual formulas instead of the values a fixed dollar sign b floating dollar sign c formula version d values version 17 Common content that prints on the top of each page a spell checker b best fit c footer d header 18 Dollar sign that appears in the far left of the cell a fixed dollar sign b floating dollar sign c comma style d accounting number format 19 Instructs Excel to display a value as a percentage by multiplying the cell entry by 100 & rounding a values version b percent style button c range finder d normal view 20 Technique used to hide data that is sensitive or not relevant a theme b spell checker c best fit d hiding cells 21 Version of a worksheet that shows the results of the formulas you have entered a values version b formula version c comma style d page layout view 22 The process of finding and correcting errors a hiding cells b debugging c condition d range finder 23 The portions of a printed page outside the main body a hiding cells b footer c margins d header 24 The width of the column will increase or decrease so the widest entry will fit a MAX function b MIN fuction c normal view d best fit 25 Used to check a worksheet for spelling errors a spell checker b condition c conditional formatting d debugging 26 Used to check which cells are referenced in a formula a debugging b range finder c condition d conditional formula