Multiple Choice Questions

A workbook contains _____ worksheets by default.
  • ROUND
  • one
  • linear
  • 3-D
The following sequence, Jan, Feb, Mar, etc. is an example of a _____ series.
  • Test Data
  • CRTL
  • Date
  • linear
Which of the following is the path to the fill button?
  • (Home tab | Number group)
  • home tab & editing group
  • view tab & window group
  • &[page]
You can customize a format code in a cell entry to specify how ____ are displayed in a cell.
  • &[page]
  • positive numbersnegative numberszerostext
  • on the status bar
  • home tab & editing group
Which of the following is a method of electronic document distribution?
  • If the number of digits argument is equal to zeroIf the number of argument is not included
  • Jan, Feb, Etc.1,1,1,etc2,4,6,etc1,2,3,etc
  • One DriveXPS imageBlog PostingPost on S.M.
  • view tab & window group
It is recommended that you use the _____ function on formulas that potentially can result in more decimal places than the applied format displays.
  • absolute
  • SHIFT
  • CTRL
  • ROUND
The path to the Comma Style button is ____.
  • (Home tab | Number group)
  • view tab & window group
  • ""(quotation marks)
  • on the status bar
To select adjacent sheets, select the first sheet by clicking its tab then hold down the ____ key and lick the sheet tab at the other end of the list of adjacent sheet tabs.
  • ROUND
  • SHIFT
  • Custom
  • CTRL
Which of the following keyboard shortcuts allows you to select a range of cells with entires surrounded by blank cells?
  • view tab & window group
  • 0.00%;[blue](0.00%)
  • CTRL+SHIFT+ASTERISK*
  • .(Period)
If multiple sheets are selected and you want to select the active sheet, if you are using a touch screen, press and hold and select ____ from the shortcut menu.
  • absolute
  • Ungroup Sheet
  • Consolidation
  • groupings
A ____ is a reference to a cell or range of cells in another workbook.
  • linear
  • link
  • Circular
  • CRTL
A range that spans two or more worksheets in a workbook is called a ___ range.
  • CTRL+D
  • link
  • Date
  • 3-D
to copy the content of a cell to the cell directly below it, click the target cell and press ____.
  • Custom
  • CTRL
  • .(Period)
  • CTRL+D
As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.
  • CTRL+D
  • Custom
  • absolute
  • Ungroup Sheet
You should hold down the ____ key to select the nonadjacent cells.
  • Test Data
  • CRTL
  • Date
  • CTRL
You can switch to Page Layout view by clicking the Page Layout button _____.
  • on the status bar
  • Test Data
  • ""(quotation marks)
  • groupings
Which of the following format symbols displays text along with numbers entered in a cell?
  • ""(quotation marks)
  • .(Period)
  • CTRL+SHIFT+ASTERISK*
  • 0.00%;[blue](0.00%)
You can drill all of the following down through a workbook EXCEPT ____.
  • groupings
  • Auto fill
  • Test Data
  • Page Layout
You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.
  • CTRL+D
  • Test Data
  • Custom
  • CRTL
which of the following is the path to the Switch Windows button?
  • 0.00%;[blue](0.00%)
  • ""(quotation marks)
  • view tab & window group
  • Jan, Feb, Etc.1,1,1,etc2,4,6,etc1,2,3,etc
The following sequence, 1, 1, 1, etc., is an example of a _____ series.
  • Auto fill
  • linear
  • Test Data
  • Date
Which of the following format codes shows percent values with two decimal places and shows negative percent in blue with parentheses?
  • 0.00%;[blue](0.00%)
  • CTRL+SHIFT+ASTERISK*
  • ""(quotation marks)
  • view tab & window group
Which of the following format codes insures that Excel will display a decimal point in the number?
  • 0.00%;[blue](0.00%)
  • .(Period)
  • CTRL+D
  • CTRL+SHIFT+ASTERISK*
The following sequence 2, 4, 6, etc. is an example of a ____ series.
  • Date
  • linear
  • Auto fill
  • link
The process of summarizing data included on multiple worksheets on one worksheet is called _____.
  • Consolidation
  • ""(quotation marks)
  • Auto fill
  • .(Period)
Headers, footers, and margins are all ____ options.
  • Auto fill
  • on the status bar
  • Page setup
  • Test Data
The code ____ instructs Excel to insert the page number in the header or footer section.
  • &[page]
  • home tab & editing group
  • positive numbersnegative numberszerostext
  • Date
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0