Edit Game
Excel 3&4 Review Game
 Delete

Use commas to add multiple tags

 Private  Unlisted  Public



 Save


Get beautiful free images


Delimiter between question and answer:

Tips:

  • No column headers.
  • Each line maps to a question.
  • If the delimiter is used in a question, the question should be surrounded by double quotes: "My, question","My, answer"
  • The first answer in the multiple choice question must be the correct answer.

 Import questions


Get beautiful free images






 Save   31  Close
Looking at the image, is E identifying the primary or secondary axis?
secondary
Which letter is an example of conditional formatting data bars?
F
Which letter is an example of Sparklines in trendline form?
G
To copy a formula down a column, click the cell and then pull this.
Fill handle
To fill with "formatting only" what must you do AFTER you pull the fill handle down?
Use the autofill options button that pops up and say "fill formatting only"
If you type Quarter 1 and pull the fill handle over, what happens?
It makes Quarter 2, Quarter 3, etc.
In this, what does the ZERO represent? =ROUND(K9,0)
The number of decimal places
When using a MAX function, what goes in the parenthesis?
The RANGE to find the highest number of with COLON - Example A5:A10
Which function is used to find the lowest number in a range?
MIN function
What does the TODAY function use in the parenthesis?
nothing - Example =TODAY()
To create a running total, use this tool, which pops up when you highlight a range
Quick Analysis
What is an ABSOLUTE REFERENCE to cell B15?
$B$15
Inside the parenthesis of an IF function, what is the first item in the parenthesis?
logical test that compares (like A5>100)
This feature is used to calculate how you can get to a number by changing a specific cell
Goal Seek
If you press the + Chart Elements button when on a chart, how can you remove the legend?
Uncheck Legend
To modify data labels to show both a percentage and labels, use this
Task Pane (options at right in task pane)
What does the button look like on the chart to apply a chart style?
Paint Brush
If you want both a Clustered Column AND a Line chart in one, you create this type of chart
Combination
To change the text direction of an axis title, where can you rotate the title?
Format Axis Title in the task pane for Text Direction
To define 20.0 as the Major units and 5.0 as the Minor units for a secondary axis,
Axis Options in task pane - UNITS (not Bounds - that the high and low)
To remove an entire data series from a chart (like take off 2017's number), use which button on Design tab?
Uncheck it in Select Data
How do you insert a trendline in a CHART?
Use the Chart Elements button (+)
To modify a fill color on a shape, simply use this button on the Home tab
Paint Bucket
To add Solid Fill Red Data Bars to a range, what tab has the Conditional Formatting button?
Home
To insert a Sparkline into a group of cells, go to what tab?
Insert
To insert high or low point markers into a sparkline, check this in what GROUP on the Design tab?
Show
Goal Seek is located in what command on the Data tab?
What-if Analysis
$B$2 is an example of what kind of cell reference?
Absolute
B$2 is an example of what kind of cell reference?
Mixed (the row 2 would stay put, but B would move since only one $)
What function would you use to calculate the arithmetic mean of a range?
AVERAGE
If you see a cells with blue fills of varying lengths representing the values, the cells most likely have this applied:
Conditional Formatting (with Data Bars)


Get beautiful free images

Your experience on this site will be improved by allowing cookies.