MS: Excel

10 September 2022
4.7 (114 reviews)
36 test answers

Unlock all answers in this set

Unlock answers (32)
question
The person or persons requesting the worksheet should supply their requirements in a ____ document.
answer
Requirments
question
The range of cells receiving the copied context is called the ____ area.
answer
Range
question
A ____ is a series of two or more adjacent cells in a column or two or a rectangular group of cells, as shown in the accompanying figure
answer
Range
question
The range of cells receiving the content of copied cells is called the ____
answer
Destination area
question
A ____ reference is an adjusted cell reference in a copied and pasted formula
answer
Related
question
The ____ is the small black square located in the lower right corner of the heavy border around the active cell
answer
Fill handle
question
The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting
answer
Auto fill options
question
Which of the following is the ribbon path to the cell styles button
answer
Home tab | styles group
question
What effect does comma styles format have in the selected cells
answer
Displays cell contents with two decimal places and commas as thousands separators
question
Pressing the _____ keyboard shortcut keys selects A1
answer
CTRL+HOME
question
How many chart tykes does excel offer
answer
10
question
A pie chart with one or more slices offset is referred to as an _____ pie chart
answer
Embedded
question
The date you change a file is referred to as an ___ property
answer
Automatically updated
question
_____ properties are associated with allMicrosoft office files including author, title, and subject
answer
Standard
question
You use an ____ to view an XPS file
answer
XPS
question
The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu
answer
Auto calculate
question
To start a new line in a cell, press the ___ keys
answer
ALT + SHIFT
question
All of the following are valid excel arithmetic operators except
answer
>
question
The ____ Auto complete list contains those functions that alphabetically match the letters you type following the equal sign
answer
Formula
question
Which of the following is the path to the sum arrow
answer
Home tab | clipboard
question
You can use the ___ to check which cells are referenced in the formula assigned to the active cell
answer
Range finder
question
Which of the following is the path to the comma style button
answer
Home tab | numbers group
question
Which of the following is the path to the conditional formatting button
answer
Home tab | styles group
question
Which of the following is the path to the spelling button
answer
Review tab | proofing group
question
Cells referenced in a formula are called
answer
Assumptions
question
You use the ____ sheet in the format cells dialogue box to position data in a cell by centering it
answer
Alignment
question
If you enter 90 degrees box in the ___ area of the format cells dialogue box, the text will appear vertically as read from bottom to top in the cell
answer
Orientation
question
To open the format cells dialogue box with the alignment sheet active, tap or click the alignment settings
answer
Dialogue box launcher
question
The ____ auto fill option that fills the destination area using the format of the source area; no content is filled
answer
Fill formatting only
question
The increase indent button indents the contents of a cell to the right by ___ spaces each time you click it
answer
3
question
In the context of copying a range of cells into a non adjacent location, an alternative to clicking the past button is to press the ____ key
answer
ENTER
question
Which of the following is the path to the insert cells arrow
answer
Home tab | cells group
question
An ____ chart provides a simple way to show trends and variations in a range of data within a single cell
answer
Sparkline
question
The path to the format painter button is
answer
Home tab | clipboard
question
You should use a ___ chart to compare values side by side, broken down by category
answer
Clustered column
question
Which of the following is the path to the goal seek button
answer
Data analysis | data tools group