QUESTION 1 ____ format codes allow you come specify just how a cabinet entryassigned a style will appear. A. Duplicate b. Separation, personal, instance c.Specific d. Custom 1 points save Answer concern 2 A ____ is areference to a cabinet or range of cells in an additional workbook. A. Codeb. Formula c. Duty d. Link 1 points save Answer inquiry 3 Arange that spans 2 or more worksheets in a workbook is called a____ range. A. 1-D b. 2-D c. 3-D d. 4-D 1 points conserve AnswerQUESTION 4 A workbook contains ____ worksheet(s) by default. A. Oneb. Two c. 3 d. Four 1 points save Answer question 5 A(n) ____reference is a formula that counts on its very own value. A. Implicitb. Explicit c. Singular d. One 1 points save Answer concern 6As you attach workbooks, the cabinet reference put by Excel eachtime friend tap or click a cabinet in a workbook outcomes in a(n) ____cell reference. A. Incorporated b. Dynamic c. Pure d. Loved one 1points save Answer concern 7 Headers, footers, and margins room all____ options. A. Validation b. Control c. Web page setup d. Calculation1 points save Answer question 8 If lot of sheets room selected andyou desire to choose the active sheet, if you are using a touchscreen, press and also hold and select ____ indigenous the faster way menu. A.Ungroup Sheets b. Disaggregate Sheets c. Select active Sheet d.Quick choose 1 points save Answer question 9 the is encourage thatyou use the ____ duty on formulas that potentially have the right to resultin more decimal areas than the applied format displays. A. IF b.SUM c. Day d. Round 1 points conserve Answer question 10 when you haveselected a variety to chart, you deserve to press ____ to attract a chart on aworksheet. A. F5 b. F6 c. F11 d. F12 1 points save Answer QUESTION11 The ____ keyboard shortcut copies an image of the resource area asa picture. A. CTRL+K b. CTRL+R c. CTRL+I d. CTRL+U 1 point out SaveAnswer concern 12 The ____ style is the style style that Excelinitially assigns to all cells in a workbook. A. Conventional b. Numberc. Common d. Currency 1 points conserve Answer concern 13 The code____ instructs Excel come insert the page number in the header orfooter section. A. (LoadPageNum) b. & c. d. 1 points conserve Answer inquiry 14 The following sequence,1, 1, 1, etc., is an example of a(n) ____ series. A. Linear b.growth c. Date d. Auto to fill 1 points save Answer concern 15 Thefollowing sequence, 1, 2, 3, etc., is an example of a(n) ____series. A. Direct b. Development c. Date d. Auto to fill 1 clues SaveAnswer concern 16 The complying with sequence, 2, 4, 6, etc., is anexample of a ____ series. A. Development b. To fill c. Linear d. Day 1points save Answer concern 17 The following sequence, Jan, Feb,Mar, etc., is an instance of a ____ series. A. Fill b. Direct c.growth d. Day 1 points save Answer question 18 The course to theComma Style switch is ____. A. (HOME tab | cells group) b. (HOMEtab | Alignment group) c. (HOME tab | Number group) d. (HOME tab |Font group) 1 points save Answer concern 19 The route to the Sumbutton is ____. A. (Editing tab | Calculations group) b. (Inserttab | editing and enhancing group) c. (Home tab | modifying group) d. (Data tab |Functions group) 1 points save Answer concern 20 The process ofsummarizing data contained on many worksheets ~ above one worksheetlike the one displayed in the accompanying figure is referred to as ____. A.recapitulation b. Encapsulation c. Summarization d. Consolidation 1points conserve Answer concern 21 come copy the contents of a cell tothe cabinet directly listed below it, click the target cell and press ____.a. CTRL+D b. CTRL+X c. CTRL+C d. CTRL+V 1 points save AnswerQUESTION 22 to select adjacent sheets, select the first sheet byclicking its tab and then hold down the ____ key and click thesheet tab in ~ the other finish of the perform of surrounding sheet tabs. A.CTRL b. Change c. ALT d. ESC 1 points conserve Answer question 23 Toselect nonadjacent sheets, pick the an initial sheet by click itstab and then hold down the ____ an essential and click the sheet tabs that theremaining sheets you want to select. A. CTRL b. ESC c. ALT d. SHIFT1 points save Answer concern 24 as soon as you insert a hands-on pagebreak, Excel display screens a(n) ____ line in between pages. A. Orange b.solid c. Dotted d. Red 1 points save Answer question 25 when youprint a worksheet or usage the web page Setup dialog box, Excel inserts____ division that display the limits of what will print on eachpage. A. Ar b. Paper c. Range d. Web page 1 points conserve AnswerQUESTION 26 as soon as you publish a worksheet or use the page Setup dialogbox, Excel inserts ____ that show the borders of what will certainly printon each page. A. Spare b. Indexes c. An option barriers d. Pagebreaks 1 points save Answer concern 27 i m sorry of the followingformat password insures the Excel will display screen a decimal suggest in thenumber? a. . (period) b. $* c. ( ) d. % (percent) 1 point out SaveAnswer concern 28 which of the adhering to format codes showspercent values through two decimal places and also shows negative percentvalues in blue v parentheses? a. $*#,##0_;($*#,##0_) b.0.00%;(0.00%) c. 0.00%;(0.00%) d.#,##0.00;(#,##0.00) 1 points save Answer inquiry 29 which ofthe complying with format symbols display screens text along with numbersentered in a cell? a. “ ” (quotation marks) b. # (number sign) c. 0(zero) d. _ (underscore) 1 points conserve Answer inquiry 30 i beg your pardon ofthe adhering to is the course to the division button? a. (HOME tab | PageSetup group) b. (PAGE LAYOUT tab | Sheet alternatives group) c. (PAGELAYOUT tab | web page Setup group) d. (VIEW tab | present group) 1 pointsSave Answer inquiry 31 which of the complying with is the route to theFill button? a. (FORMULAS tab | to fill group) b. (HOME tab | Editinggroup) c. (INSERT tab | editing group) d. (DATA tab | to fill group) 1points save Answer question 32 which of the complying with is the pathto the Insert cell button? a. (INSERT tab | cells group) b. (DATAtab | Insert group) c. (CELLS tab | home group) d. (HOME tab |Cells group) 1 points save Answer inquiry 33 which of thefollowing is the route to the Switch windows button? a. (VIEW tab |Window group) b. (INSERT tab | watch group) c. (VIEW tab | WorkbookViews group) d. (REVIEW tab | home windows group) 1 points conserve AnswerQUESTION 34 i beg your pardon of the following keyboard shortcuts permits you toselect a selection of cells v entries surrounded by empty cells? a.SHIFT+HOME+ASTERISK (*) b. CTRL+SHIFT+ASTERISK (*) c.ALT+SHIFT+ASTERISK (*) d. TAB+SHIFT+ASTERISK (*) 1 point out SaveAnswer inquiry 35 you can display screen the ____ tab to specify pagesetup options. A. Publish b. SETUP c. Display d. Page LAYOUT 1 pointsSave Answer inquiry 36 You have the right to drill every one of the adhering to downthrough a workbook except ____. A. Formulas b. Groupings c. Formatsd. Number 1 points save Answer concern 37 You have the right to switch come PageLayout view by clicking the page Layout switch ____. A. (VIEW tab |Show group) b. ~ above the document tab c. On the condition bar d. (HOME tab |Layout group) 1 points conserve Answer inquiry 38 You must click____ in the group list on the Number sheet in the format Cellsdialog crate to choose or produce a style code. A. Basic b. Customc. Number d. Accountancy 1 points conserve Answer question 39 you shouldcreate good ____ to ensure your workbooks are free of errors. A.color comparison b. Variety boundaries c. Test data d. No one of theabove 1 points conserve Answer concern 40 girlfriend should hold down the____ crucial to choose the nonadjacent cells. A. End b.
You are watching: The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.
See more: Inside J Lo And Casper Video Features Boyfriend, Jennifer Lopez Make
TAB c. CTRL d.SHIFT