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