Data

Copy and paste the text below. It is read-only. Select All

What is global formatting? assigns formatting to all cells in a worksheet in a workbook what does the range finder do? highlight the cells that provide data to the formula When using a cell name in a formula, what symbol is used to represent a space? (_) underscore What is the PMT function? -PMT(rate/12,12*years,loan_amount) When entering a formula into a cell what does excel display? screen tip What is a data table? a range of cells that shows the answers generated by formulas in which different values have been submitted what are the two types of data tables? one-input data table and two-input data table how many active data tables are allowed in a worksheet? one What is the ROUND function? =ROUND(number,number of digits) What is consolidation? the process of summarizing data included on multiple worksheets on a worksheet what is a template? a special workbook you can create and then use as a pattern to create new, similar workbooks if you want to display a future date such as one week from today, what function would you use? =NOW()+7 how do you switch from enter mode to point mode? =clicking cells for function what is drilling an entry enter information and have it appear on multiple sheets what is dummy data? sample data used to create and test templates what is the difference between a rocord and a row? none can excel perfom database operations yes what is the difference between merge and center and center across selection merge and center ties the cells together what is validation ensure that data is within its limits to create subtotals what stpes do you follow? ... what is GIGO garbage in garbage out what is the formula for a VLOOKUP =VLOOKUP(lookup_value, table_array, col_index_num) what is the table array the fartherst column to the left how many tables can you have on a worksheet ... what is conditional formatting allows you to make formatting changes to the whole workbook how do you place a border using the same setting as the most recently defined border? click the borders button what color is the text when the color is automatic black when using the increase indent button on the Home tab, the indent is increaded by how much? 1/2 inch what is a shadow a light gray duplicate image how do you create a text watermark? page layout, watermark, text how many sections does each document have at a minimum one how do you insert a document into an open word document insert, object, text from file how do you keep a header and footer from apperaing on additional pages of a document do not link to previous or next what is the formula for summing a column in a table =SUM(ABOVE) right click on the legend and select this command to move the legend format legend how do you exit the graph and return to word double click in the document how do you select nonadjacent text in a document click, hold control, click what shape does the mouse change to when you draw a table pensil where do you find the distribute rows evenly button layout tab how do you change text direction text direction button what soes it mean to merge cells combine/group/tie cells together what is the main document the main document what is the first task to creating a mail merge select main document what is a drawing canvas box to draw in what does the green circle do on an object spins it what does the yelow diamond do on an object adjustment handle what is the data source file that data comes from what is the first step in creating a data source create field names how many field names are automatically included in a data source ? how is a data source saved? address list access what symbols surround a field name when it is inserted into a mian document merge field characters "(())" what appears first in a IF field, true text or false text true what contextual tab is uaed to change margins page layout what is the nameplate of a newsletter the title what is gradient coor colors blended into one another what contextual tac is used to insert a symol insert what do you change so that a graphic is floating instead of inline with text infront of text how do you create a drop cap select letter, click drop cap what is the difference between destination and source ojbect destination-pasted source- copied how do you balance a column section break, continuous what is a SmartArt graphic visual representation of ideas what does PDF stand for portable document file