Font size
WorksheetsMicrosoft Excel Certification Exam
Total questions: 25
Worksheet time: 17mins
In which group do you find the command for conditional formatting?
Font
Styles
Formatting
Paragraph
What view displays the location of the different page breaks within a worksheet?
Normal
Page View
Page Break Preview
Print Preview
Select ALL that apply:
Which of the following are rules that can be created with Conditional Formatting?
Top 20 items
Values between 50 and 100
Cell Shading
Red Data Bar
By default, numbers appear in the (a) format and generally display values exactly as you type them
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
cell
relative
absolute
mixed
Click the (a) key (on your keyboard) to select multiple cells in a worksheet that are not next to each other.
In Excel, what is a cell range?
The basic units of life
A group of cells in a rectangular block.
The intersection of a row and a column.
Select ALL that apply:
Which of the following unique tab(s) appear on the ribbon when a chart is selected?
Insert
Design
Format
Layout
ALL Excel formulas and functions begin with an (a) sign.
Which logical function returns a TRUE value if the logical condition is true and a FALSE value if the condition is FALSE?
AND
OR
IF
IFS
Select ALL that apply.
What options are available when you right-click on a sheet tab?
Color
Move or Copy
Delete
Font
Rename
Select ALL that apply:
How do you move a worksheet within the same workbook?
Click Copy in the Clipboard group, and then paste
Right-click the tab and select Move or Copy
Click Cut in the Clipboard group, and then paste
Click and drag the tab
You can't move worksheets within the workbook.
To change the formatting of a cell to the Totals style, click the _______ _________ button found in the Styles group on the Home tab.
(a)
How do you chart data in Excel?
Click the Insert tab, then click the appropriate chart in the Chart group
Click the Data tab, then click the appropriate chart in the Chart group
Select the data cells to include, click the Insert tab, then click the appropriate chart in the Chart group.
Select the data cells to include, click the Data tab, then click the appropriate chart in the Chart group.
Choose the correct function that will perform the task below:
Count cells in a range that meet a single condition.
COUNT
SUM
COUNTIF
SUMIF
Choose the correct function that will perform the task below:
Add the values in a range that meet criteria that you specify.
COUNT
SUM
COUNTIF
SUMIF
Choose the correct function that will perform the task below:
Calculate the average of numbers in a range that meet supplied criteria.
SUM
AVERAGE
SUMIF
AVERAGEIF
Choose the correct function that will perform the task below:
Count the number of cells that contain numbers, and counts numbers within the list of arguments.
COUNT
COUNTA
COUNTIF
COUNT#
Choose the correct function that will perform the task below:
Add values
AutoSum
SUM
COUNT
ADD
The relative cell reference for cell A1 appears as A1. An absolute cell reference appears as (a) .
In order to switch data from columns to rows and from rows to columns, you must (a) them.
TRUE OR FALSE?
The Insert Function dialogue box can help you understand and write a function.
True
False
How many arguments are there in the IF function?
(a)
Which feature will chart your pivot table?
Chart
Combo Chart
Pivot Chart
Pivot Table
When working with combination charts, you can put some data on a (a) axis to better understand the information.
