Upgrade to remove ads
Only $2.99/month

Comp. science

Terms in this set (26)

The IF function can be found in which area of Excel?
The Logical drop-down menu under Formulas Tab
The COUNT function can only count which item in Excel?
Numbers
Which item is used to tell the IF function that the user wants a field to remain blank?
""
Which is is a true statement concerning basic formulas in Excel?
The user does not need to alter the formulas when entering new data into the applicable cells
Which MID function element specifies which character in the cell range will be the beginning of the extraction?
Start_num
In addition to the AutoSum feature, users can simply type the SUM function into Excel
TRUE
Which item means a formula cannot perform its function in Excel?
#REF
Which best defines the CONCAT function?
Taking two pieces of text and combining them.
In conditional function like SUMIF, which item refers to where the condition is located?
Range
Which is an example of a reference in Excel?
$K$1
Which item do not affect the AVERAGE function
Blank cells
Where on the ribbon is the COUNTIF function located in Excel?
The statistical group under the More Functions drop-down
Which two tabs appear in Excel when a chart is selected? CHOOSE 2
Design, Format
Alternate text can be added to an Excel item from the __________ dialog box.
Format
Every chart element in Excel has a menu which provides additional modification options.
TRUE
Using the __________ when resizing a chart can lead to proportion issues.
Slide anchors
________ charts are most effective with a single series of data
Pie
Which button in Excel is used to change the orientation of the chart's source data?
Switch row/ columns
Data labels are most often used for which type of charts?
Pie
What is a type of gridline users can add or modify for charts in Excel?
Primary minor horizontal
Call outs and other shapes can be inserted from which area of Excel?
Illustrations drop-down menu
Logos and similar objects can be inserted to an Excel document using which item?
Illustrations drop-down menu
If a user wants to change the Lock aspect ration feature for an image in Excel, they can open:_____
Dialog box launcher
When adding partial series of data to a chart, which key on the keyboard should be held down as the additional range is selected?
Ctrl
What type of chart in Excel is horizontal?
Bar
A series in a chart with a secondary axis can be changed to ________ avoid overlapping data.
New type of chart
YOU MIGHT ALSO LIKE...