BCIS FINAL Exam Questions With Accurate Answers.

BCIS FINAL Exam Questions With Accurate Answers. To add a ______ to a sheet tab, right click a sheet tab, point to tab color on the short cut menu, and then click a color. a) fill color B) format color c) tab setting d) formatting style - answerA) fill color when creating an excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness. a: red and green b:black and white c: yellow and blue d: red and yellow - answera: red and green By default, numbers appear in the _____ and generally display values exactly as you type them. a: home tab b: general number toolbar c: general format d: currency format - answerc: general format Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value. a: numbers b: universal number c: text d: greenwhich mean time - answera: numbers In Excel, dates are _____-aligned in the cell by default, regardless of date format. a: right b: center c: left D:top - answerRight as a general rule, you should _____________. a: center column titles, left align text, and right align numbers b: center column titles, right align text, and left align numbers c: right align column titles, left align text, and right align numbers. - answercenter column titles, left align text, and right align numbers. ________ merges each of the rows, in the selected range across the columns in the range. a:merge build b: merge across c: merge and center d: merge cells - answermerge cross in excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the merged cell. a: A1!E! b: E1 c:A1 d: A1-E1 - answerA1 Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab. a: format b: sorter c:orientation d: alignment - answerorientation The Format Cells dialog box has six tabs, including _____. a: decimals b: security