The following sequence, Jan, Feb, Mar, etc. is an example of a _____ series.
0%
Test Data
0%
CRTL
0%
Date
0%
linear
Q.3.
Which of the following is the path to the fill button?
0%
(Home tab | Number group)
0%
home tab & editing group
0%
view tab & window group
0%
&[page]
Q.4.
You can customize a format code in a cell entry to specify how ____ are displayed in a cell.
0%
&[page]
0%
positive numbersnegative numberszerostext
0%
on the status bar
0%
home tab & editing group
Q.5.
Which of the following is a method of electronic document distribution?
0%
If the number of digits argument is equal to zeroIf the number of argument is not included
0%
Jan, Feb, Etc.1,1,1,etc2,4,6,etc1,2,3,etc
0%
One DriveXPS imageBlog PostingPost on S.M.
0%
view tab & window group
Q.6.
It is recommended that you use the _____ function on formulas that potentially can result in more decimal places than the applied format displays.
0%
absolute
0%
SHIFT
0%
CTRL
0%
ROUND
Q.7.
The path to the Comma Style button is ____.
0%
(Home tab | Number group)
0%
view tab & window group
0%
""(quotation marks)
0%
on the status bar
Q.8.
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.
0%
ROUND
0%
SHIFT
0%
Custom
0%
CTRL
Q.9.
Which of the following keyboard shortcuts allows you to select a range of cells with entires surrounded by blank cells?
0%
view tab & window group
0%
0.00%;[blue](0.00%)
0%
CTRL+SHIFT+ASTERISK*
0%
.(Period)
Q.10.
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.
0%
absolute
0%
Ungroup Sheet
0%
Consolidation
0%
groupings
Q.11.
A ____ is a reference to a cell or range of cells in another workbook.
0%
linear
0%
link
0%
Circular
0%
CRTL
Q.12.
A range that spans two or more worksheets in a workbook is called a ___ range.
0%
CTRL+D
0%
link
0%
Date
0%
3-D
Q.13.
to copy the content of a cell to the cell directly below it, click the target cell and press ____.
0%
Custom
0%
CTRL
0%
.(Period)
0%
CTRL+D
Q.14.
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.
0%
CTRL+D
0%
Custom
0%
absolute
0%
Ungroup Sheet
Q.15.
You should hold down the ____ key to select the nonadjacent cells.
0%
Test Data
0%
CRTL
0%
Date
0%
CTRL
Q.16.
You can switch to Page Layout view by clicking the Page Layout button _____.
0%
on the status bar
0%
Test Data
0%
""(quotation marks)
0%
groupings
Q.17.
Which of the following format symbols displays text along with numbers entered in a cell?
0%
""(quotation marks)
0%
.(Period)
0%
CTRL+SHIFT+ASTERISK*
0%
0.00%;[blue](0.00%)
Q.18.
You can drill all of the following down through a workbook EXCEPT ____.
0%
groupings
0%
Auto fill
0%
Test Data
0%
Page Layout
Q.19.
You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.
0%
CTRL+D
0%
Test Data
0%
Custom
0%
CRTL
Q.20.
which of the following is the path to the Switch Windows button?
0%
0.00%;[blue](0.00%)
0%
""(quotation marks)
0%
view tab & window group
0%
Jan, Feb, Etc.1,1,1,etc2,4,6,etc1,2,3,etc
Q.21.
The following sequence, 1, 1, 1, etc., is an example of a _____ series.
0%
Auto fill
0%
linear
0%
Test Data
0%
Date
Q.22.
Which of the following format codes shows percent values with two decimal places and shows negative percent in blue with parentheses?
0%
0.00%;[blue](0.00%)
0%
CTRL+SHIFT+ASTERISK*
0%
""(quotation marks)
0%
view tab & window group
Q.23.
Which of the following format codes insures that Excel will display a decimal point in the number?
0%
0.00%;[blue](0.00%)
0%
.(Period)
0%
CTRL+D
0%
CTRL+SHIFT+ASTERISK*
Q.24.
The following sequence 2, 4, 6, etc. is an example of a ____ series.
0%
Date
0%
linear
0%
Auto fill
0%
link
Q.25.
The process of summarizing data included on multiple worksheets on one worksheet is called _____.
0%
Consolidation
0%
""(quotation marks)
0%
Auto fill
0%
.(Period)
Q.26.
Headers, footers, and margins are all ____ options.
0%
Auto fill
0%
on the status bar
0%
Page setup
0%
Test Data
Q.27.
The code ____ instructs Excel to insert the page number in the header or footer section.
0%
&[page]
0%
home tab & editing group
0%
positive numbersnegative numberszerostext
0%
Date
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.