25 January 2012, 11:21 am
Can Someone Answer These Questions For Me 1: True Or False:It is possible to change or delete row and column headings. 2: Which are ways to add color to worksheet tabs? A - Sheet tab colors cannot be changed B - Right-click on a sheet tab and select Tab Color C - Sheet tab colors change automatically when edited 3:What are problems a user might encounter when inserting photos into the background? Choose all that apply. A - Pixilation B - Seams showing C - Screen resolution D - Contrast colors overshadowing text 4:What is the keyboard shortcut for insert? A - CTRL+INSERT B - CTRL+SHIFT+INSERT C - CTRL+ALT+PLUS SIGN D - CTRL+SHIFT+PLUS SIGN 5:Which function key is the Repeat key? A - F1 B - F4 C - F6 D - F12 6:How can an entire row or column be formatted in the Accounting format? A - Each selected cell must be formatted individually B - Select the column or row, right-click, and select Format Cells from the menu that appears. Choose the Number tab, and then select Currency. C - Select the column or row, right-click, and select Format Cells from the menu that appears. Choose the Number tab, and then select Accounting 7:True Or False:Applying a currency format to an entire column will affect the header. 8:What does Format Painter do? A - Auto-format cells B - Delete cell format C - Format numbers within cells D - Copy format from one cell to other cells 9: Which are special number formats of Excel 2007? Choose all that apply. A - Zip Code B - Phone Number C - Social Security Number D - Driver's License Number 10:Which symbol, when preceding a number, can make that number into a text entry? Number to Text 11:Which symbol, when preceding a number, can make that number into a text entry? A - Comma B - Asterisk C - Apostrophe D - Quotation mark 12:True Or False:Cells can be merged and centered by clicking the Merge and Center button within the Alignment group of the Home tab. 13:True or False:Excel has added contextual tabs that appear when the user needs them and then disappear when the user is finished. 14:What happens when the user clicks outside of the table? Choose all that apply. A - The table disappears B - Table options disappear C - The contextual tab disappears D - The document is not in table mode 15:Which are options in the Summary Function drop-down menu? Choose all that apply. A - Sum B - Multiply C - Average D - Dividends 16:In which group is the Convert to Range button located? A - Data B - View C - Tools D - Insert 17: What does the equal sign signify when entered into a cell? A - Textual relationship B - Numerical relationship C - Dependent relationship D - Independent relationship 18:What is the keyboard shortcut for revealing all operations on the worksheet simultaneously? A - CTRL+` B - CTRL+' C - CTRL+! D - CTRL+* 19:Which items can be placed in a formula list? Choose all that apply. A - Numbers B - Cell addresses C - Function names D - Range of named numbers Thanks Everyone:)... Read More »