Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
excel quiz
Question 1
Which group of the Chart Tools Design tab is used to switch the rows and columns of a chart?
Chart Layouts
Chart Styles
Data
Type
5 points
Question 2Which of the following functions is written in the correct syntax?
NOW(today)
=SUM(A1:D1)
SUM(D2=A2)
=SUM(A1=B1)
5 points
Question 3Where do you type a cell reference and then move directly to that cell?
Name box
Formula bar
Status bar
Navigation pane
5 points
Question 4Which tab on the Ribbon includes the feature to freeze panes?
Page Layout
Home
View
Data
5 points
Question 5By default, how are charts inserted into a worksheet?
Source object
Paste Special object
Embedded object
Linked object
5 points
Question 6Which of the following occurs whenever a number in a referenced cell in a formula changes?
All formulas that are dependent on the changed value are deleted.
All formulas that are dependent on the changed value are edited.
All formulas that are dependent on the changed value are recalculated.
All formulas that are dependent on the changed value are highlighted.
5 points
Question 7Which of the following terms refers to separating the slices of a pie chart?
Arranging
Exploding
Imploding
Expanding
5 points
Question 8Which of the following is an absolute reference?
#E#8
E$8
$E$8
E8
5 points
Question 9Which of the following would result from setting a cell's number style to Comma [0]?
12345.67
12,345.67
$12,345.67
12,346
5 points
Question 10Which of the following is a predefined set of formatting choices that can be applied to an entire workbook in one simple step?
Theme
Screenshot
AutoFormat
SmartArt
5 points
Question 11Which of the following is not a method to rename a sheet?
Double-click the sheet tab
Page Layout tab, Page, Setup group
Home tab, Cells group, Format, Rename Sheet
Right-click the sheet tab
5 points
Question 12Which of the following is not a valid character for use in a number entry?
5
+
#
%
5 points
Question 13Which tab on the Ribbon displays error checking tools?
Home
Formulas
Data
Review
5 points
Question 14Which of the following automatically resizes the column to fit the width of the column's contents?
Clicking the column boundary line
Double-clicking the column boundary line
Right-clicking the column boundary line
Double right-clicking the column boundary line
5 points
Question 15What is the name of the square in the lower-right corner of a selection that is used to copy cells?
Copy handle
Range handle
Fill handle
Replicate handle
5 points
Question 16Which of the following displays different sections of a worksheet at the same time?
Windows
Frames
Panes
Breaks
5 points
Question 17Which of the following is the intersection of a row and a column?
Cell
Pane
Chart
Grid
5 points
Question 18Which of the following displays entries as they are made and edited in the Excel workbook window?
Formula bar
Format menu
Format menu
Title bar
5 points
Question 19What is created when two or more cells are combined?
Combination cell
Merged cell
Grouped cell
Combined cell
5 points
Question 20How many cells are included in the range A1:B3?
2
4
6
9