MCQExams
CBSE
JEE
NTSE
NEET
Practice
Homework
×
practice
Excel Study Guide Quiz
Solution
Q.1.
You use ___ to view an XPS file
0%
XPS viewer
0%
enter
0%
CTRL+ Home
0%
worksheet
Q.2.
The ___ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry
0%
auto correct
0%
AutoCorrect Options
0%
auto fill options
0%
auto calculate
Q.3.
Pressing the ___ keyboard shortcut selects cell A1
0%
RIGHT ARROW
0%
enter
0%
worksheet
0%
CTRL+ Home
Q.4.
The range of cells receiving copied content is called the_______ area.
0%
Destination Area
0%
Paste
0%
text
0%
Releative
Q.5.
Pressing the ____ key to complete an entry activates the adjacent cell to the right
0%
relative
0%
CTRL+ Home
0%
RIGHT ARROW
0%
Releative
Q.6.
The ____button allows you to choose whether you want to copy the values from the source area to the destination area with formatting
0%
Operations
0%
auto correct
0%
auto fill options
0%
auto calculate
Q.7.
You___ a worksheet to emphasize certain entries and make the worksheet easier to read and understand
0%
standard
0%
CTRL+B
0%
format
0%
Colon(;)
Q.8.
How many chart type does excel offer?
0%
26
0%
cell
0%
XPS viewer
0%
15
Q.9.
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ______ that you use in algebra.
0%
Operations
0%
relative
0%
auto fill options
0%
auto calculate
Q.10.
The person or person requesting the worksheet should supply their requirements in a ____ document.
0%
requirements
0%
auto correct
0%
Operations
0%
Releative
Q.11.
A pie chart with one or more slices offset is reffered to as an ___ pie chart
0%
CTRL+B
0%
standard
0%
exploded
0%
relative
Q.12.
Which of the following Option buttons gives options for filling cells following a fill operation?
0%
Auto Fill Options
0%
auto calculate
0%
Excel assigns the value in cell G15 to the active cell
0%
auto correct
Q.13.
Which of the following is the Ribbon path to the cell styles button?
0%
Auto Fill Options
0%
=23%
0%
Excel assigns the value in cell G15 to the active cell
0%
(Home Tab styles group)
Q.14.
___ is/are used to place worksheet, column, and row titles on a worksheet
0%
CTRL+B
0%
text
0%
cell
0%
relative
Q.15.
You can apply the bold font style by pressing the ___ keyboarding shortcut keys
0%
Merging
0%
AutoCorrect Options
0%
CTRL+B
0%
Colon(;)
Q.16.
The range of cells receiving the content of copied cells is called the____.
0%
Destination Area
0%
understand what is required
0%
Paste
0%
Automatically updated
Q.17.
What effect does the comma style format have on the selected cells?
0%
Displays cell content with two decimal places that align vertically
0%
understand what is required
0%
Displays cell contents with two decimal places and commas as thousands separators
0%
(Home Tab styles group)
Q.18.
The adjusted cell references in a copied and pasted formula are called _______ cell references.
0%
Destination Area
0%
relative
0%
Releative
0%
Operations
Q.19.
Combining two or more selected cells into one cell is called ___cells
0%
Function
0%
enter
0%
CTRL+ Home
0%
Merging
Q.20.
The first step in creating an effective worksheet is to make sure you
0%
(Home Tab styles group)
0%
Destination Area
0%
understand what is required
0%
AutoCorrect Options
Q.21.
An Excel ___ allows data to be summarized and charted easily
0%
CTRL+ Home
0%
XPS viewer
0%
worksheet
0%
exploded
Q.22.
You can enter the correct range in a function by typing the beginning and ending cell reference separated by a____.
0%
Releative
0%
CTRL+B
0%
auto correct
0%
Colon(;)
Q.23.
Which of the following happens when you enter the formula =G5 into a cell?
0%
Displays cell content with two decimal places that align vertically
0%
Auto Fill Options
0%
(Home Tab styles group)
0%
Excel assigns the value in cell G15 to the active cell
Q.24.
clicking the ____ box completes an entry
0%
CTRL+ Home
0%
RIGHT ARROW
0%
Paste
0%
enter
Support mcqexams.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page