ADVANCED EXCEL, MGT 2180 MODULE 3 EXAM,
COMPUTERS QUIZ: 2, ICS 100 CHAPTER 16, EXCEL
CHAPTER 1: CREATING AND EDITING WORKBOOKS,
MGT EXAM #4, CISM EXCEL 5, MGT2180 EXAM 3, CSC
110 - EXCEL QUIZ, CISM EXCEL 6, CMIN 201 EXCEL
CH. 3, MGSC 290 MC QUESTIONS
Before using the Merge & Center command, what cell should contain the data?
A) upper-left cell
B) bottom-left cell
C) upper-right cell
D) bottom-right cell - Answers - A) UPPER LEFT CELL
By default, how does Excel align numeric entries in a cell?
A) top left corner of a cell
B) top right corner of a cell
C) bottom left corner of a cell
D) bottom right corner of a cell - Answers - bottom left corner of a cell
How should you save a file if you want it to be compatible with older versions of
Microsoft Excel? - Answers - Excel 97-2003 Workbook
In Excel, which of the following keys opens the Save As dialog box? - Answers - F12
In the Excel window, which of the following continuously displays the buttons for
switching worksheet views? - Answers - Status bar
To select adjacent worksheets, which key must you press? - Answers - Shift
To select non-adjacent worksheets, which key must you press? - Answers - Crtl
What must you do to enter a number as a label in a cell? - Answers - Type an
apostrophe before the number.
What name does Excel automatically assign to a new workbook that you open? -
Answers - Book1
When printing, what are Excel's default top and bottom margin settings? - Answers -
0.75
In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following
terms describes what is going on with this formula? - Answers - circular reference
,Once you have selected a cell address, which of the following keys lets you insert dollar
signs quickly? - Answers - F4
Which of the following Formula Auditing tools displays arrows that point to the cells
referenced in the selected formula?
a. Trace Precedents
b. Trace Dependents
c. Error Checking
d. Evaluate Formula - Answers - Trace Dependents
Which of the following cell addresses contains a column reference that is absolute and
a row reference that will change when copied?
a. F2
b. $F$2
c. $F2
d. F$2 - Answers - $F2
Which of the following cell addresses will change when it is copied? - Answers - F2
Which of the following criteria can you use to sum sales for all items that begin with the
letter p? - Answers - p*
Which of the following functions counts the number of cells in a range based on
specified criteria? - Answers - COUNTIF
Which of the following functions counts the number of cells in a range that contain any
data type, text, or numbers? - Answers - COUNTA
Which of the following functions multiplies and then adds a series of arrays? - Answers -
SUMPRODUCT
Which of the following has an answer of 11? - Answers - 3+2*4
Which of the following is True about data tables? - Answers - By default, Excel does not
include data tables with charts.
How many charts can be combined in a combination chart? - Answers - 2 or more
What can pie charts graph? - Answers - a single data series
What is the thickness of an outline measured in? - Answers - points
What would you call a table added to the bottom of your chart that contains the values
of each data series? - Answers - data table
,Which of the following chart elements provides a vertical background for a 3D chart? -
Answers - Chart Wall
Which of the following chart types displays a hierarchical view of data with different
sized and colored rectangles and sub-rectangles to compare the sizes of groups? -
Answers - TreeMap
Which of the following chart types displays the distribution of data with minimum, mean,
maximum, and outlier values? - Answers - Box & Whisker
Which of the following chart types displays the frequency of multiple data series relative
to a center point? - Answers - Radar
Which of the following encompasses all of the other items? - Answers - Shape style
What symbol precedes all structured references in Formula AutoComplete lists? -
Answers - @
How does Excel treat criteria entered on different rows? - Answers - OR
How does Excel treat criteria entered on the same row? - Answers - AND
How many rows must the criteria range of an Advanced Filter have? - Answers - at least
2
In an Excel table, what is the name assigned to a column with its table called? -
Answers - structured reference
What do AutoFilter arrows replace when you scroll down in a table with many records? -
Answers - column headings
What do you call a row in a table that has exactly the same information in one or more
columns? - Answers - duplicate row
What is Microsoft SharePoint? - Answers - family of products that allows for
collaboration and simultaneous work by groups of people via the Internet
What is another name for rows that alternate shading on the rows? - Answers - banded
rows
What must you build to use an Advanced Filter? - Answers - criteria range
Which of the following should you use when data on source worksheets might be edited
after you have created the consolidation worksheet? - Answers - dynamic consolidation
, Which of the following statements is not true about using the SmartArt Tools tabs? -
Answers - You cannot change to a different image.
Which of the following statements is true? - Answers - Consolidation by category can be
either static or dynamic.
Which of the following tab and group options format a hyperlink? - Answers - Home tab,
Font group
Which of the following ungroups all sheets in a workbook? - Answers - Right-click any
sheet tab and choose Ungroup Sheets
When you place a screenshot in a worksheet, what type of object is it? - Answers -
Picture
Which of the following includes data that is referenced in a dependent workbook? -
Answers - source workbook
Which of the following includes or refers to data from another workbook? - Answers -
dependent workbook
Which of the following is a character such as an exclamation point that marks or
signifies a component of an external reference? - Answers - identifier
Which of the following is an illustration, which often includes text that can be placed in
Excel worksheets? - Answers - SmartArt graphic
Which of the following refers to a series of equal payments made at the same time of
the month or year for a specified period of time? - Answers - annuity
Which of the following represents the short date format? - Answers - 10/14/2019
Which of the following should you use to calculate the standard deviation for an entire
population instead of a sample? - Answers - STDEV.P
Which of the following shows the correct syntax for the AND function? - Answers -
=AND(LogicalN)
Which of the following shows the correct syntax for the OR function? - Answers -
=OR(LogicalN)
How many arguments do all database functions have? - Answers - three
Which function category splits, joins, or converts labels and values in a worksheet? -
Answers - Text
COMPUTERS QUIZ: 2, ICS 100 CHAPTER 16, EXCEL
CHAPTER 1: CREATING AND EDITING WORKBOOKS,
MGT EXAM #4, CISM EXCEL 5, MGT2180 EXAM 3, CSC
110 - EXCEL QUIZ, CISM EXCEL 6, CMIN 201 EXCEL
CH. 3, MGSC 290 MC QUESTIONS
Before using the Merge & Center command, what cell should contain the data?
A) upper-left cell
B) bottom-left cell
C) upper-right cell
D) bottom-right cell - Answers - A) UPPER LEFT CELL
By default, how does Excel align numeric entries in a cell?
A) top left corner of a cell
B) top right corner of a cell
C) bottom left corner of a cell
D) bottom right corner of a cell - Answers - bottom left corner of a cell
How should you save a file if you want it to be compatible with older versions of
Microsoft Excel? - Answers - Excel 97-2003 Workbook
In Excel, which of the following keys opens the Save As dialog box? - Answers - F12
In the Excel window, which of the following continuously displays the buttons for
switching worksheet views? - Answers - Status bar
To select adjacent worksheets, which key must you press? - Answers - Shift
To select non-adjacent worksheets, which key must you press? - Answers - Crtl
What must you do to enter a number as a label in a cell? - Answers - Type an
apostrophe before the number.
What name does Excel automatically assign to a new workbook that you open? -
Answers - Book1
When printing, what are Excel's default top and bottom margin settings? - Answers -
0.75
In cell D10, Rachel entered the following formula: =D8+D9+D10. Which of the following
terms describes what is going on with this formula? - Answers - circular reference
,Once you have selected a cell address, which of the following keys lets you insert dollar
signs quickly? - Answers - F4
Which of the following Formula Auditing tools displays arrows that point to the cells
referenced in the selected formula?
a. Trace Precedents
b. Trace Dependents
c. Error Checking
d. Evaluate Formula - Answers - Trace Dependents
Which of the following cell addresses contains a column reference that is absolute and
a row reference that will change when copied?
a. F2
b. $F$2
c. $F2
d. F$2 - Answers - $F2
Which of the following cell addresses will change when it is copied? - Answers - F2
Which of the following criteria can you use to sum sales for all items that begin with the
letter p? - Answers - p*
Which of the following functions counts the number of cells in a range based on
specified criteria? - Answers - COUNTIF
Which of the following functions counts the number of cells in a range that contain any
data type, text, or numbers? - Answers - COUNTA
Which of the following functions multiplies and then adds a series of arrays? - Answers -
SUMPRODUCT
Which of the following has an answer of 11? - Answers - 3+2*4
Which of the following is True about data tables? - Answers - By default, Excel does not
include data tables with charts.
How many charts can be combined in a combination chart? - Answers - 2 or more
What can pie charts graph? - Answers - a single data series
What is the thickness of an outline measured in? - Answers - points
What would you call a table added to the bottom of your chart that contains the values
of each data series? - Answers - data table
,Which of the following chart elements provides a vertical background for a 3D chart? -
Answers - Chart Wall
Which of the following chart types displays a hierarchical view of data with different
sized and colored rectangles and sub-rectangles to compare the sizes of groups? -
Answers - TreeMap
Which of the following chart types displays the distribution of data with minimum, mean,
maximum, and outlier values? - Answers - Box & Whisker
Which of the following chart types displays the frequency of multiple data series relative
to a center point? - Answers - Radar
Which of the following encompasses all of the other items? - Answers - Shape style
What symbol precedes all structured references in Formula AutoComplete lists? -
Answers - @
How does Excel treat criteria entered on different rows? - Answers - OR
How does Excel treat criteria entered on the same row? - Answers - AND
How many rows must the criteria range of an Advanced Filter have? - Answers - at least
2
In an Excel table, what is the name assigned to a column with its table called? -
Answers - structured reference
What do AutoFilter arrows replace when you scroll down in a table with many records? -
Answers - column headings
What do you call a row in a table that has exactly the same information in one or more
columns? - Answers - duplicate row
What is Microsoft SharePoint? - Answers - family of products that allows for
collaboration and simultaneous work by groups of people via the Internet
What is another name for rows that alternate shading on the rows? - Answers - banded
rows
What must you build to use an Advanced Filter? - Answers - criteria range
Which of the following should you use when data on source worksheets might be edited
after you have created the consolidation worksheet? - Answers - dynamic consolidation
, Which of the following statements is not true about using the SmartArt Tools tabs? -
Answers - You cannot change to a different image.
Which of the following statements is true? - Answers - Consolidation by category can be
either static or dynamic.
Which of the following tab and group options format a hyperlink? - Answers - Home tab,
Font group
Which of the following ungroups all sheets in a workbook? - Answers - Right-click any
sheet tab and choose Ungroup Sheets
When you place a screenshot in a worksheet, what type of object is it? - Answers -
Picture
Which of the following includes data that is referenced in a dependent workbook? -
Answers - source workbook
Which of the following includes or refers to data from another workbook? - Answers -
dependent workbook
Which of the following is a character such as an exclamation point that marks or
signifies a component of an external reference? - Answers - identifier
Which of the following is an illustration, which often includes text that can be placed in
Excel worksheets? - Answers - SmartArt graphic
Which of the following refers to a series of equal payments made at the same time of
the month or year for a specified period of time? - Answers - annuity
Which of the following represents the short date format? - Answers - 10/14/2019
Which of the following should you use to calculate the standard deviation for an entire
population instead of a sample? - Answers - STDEV.P
Which of the following shows the correct syntax for the AND function? - Answers -
=AND(LogicalN)
Which of the following shows the correct syntax for the OR function? - Answers -
=OR(LogicalN)
How many arguments do all database functions have? - Answers - three
Which function category splits, joins, or converts labels and values in a worksheet? -
Answers - Text
