Edit Game
ACA Excel Review A
 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   25  Close
The bar at the top of a Microsoft program
Ribbon
All functions and formulas begin with this.
Equal Sign =
The intersection of a row and a column in Excel (example: A1)
cell (if clicked, active cell)
Which tab is used for adding Subtotals/Groups?
Data
In order to utilize the Subtotal feature, what must your data be?
A range, NOT a table
Before adding Subtotals automatically, what must you do to the data?
Sort on the "at each change" field
To be able to use structured references, your data needs to be:
Tables with column headings
How do you name a table in Excel?
Table Tools tab, Table name at left on ribbon
What type of conditional formatting is this an example of?
Data bars
Where do you go to Edit an existing Conditional Formatting rule?
Manage Rules
How was this bottom row added to the Excel table?
Table Tools> Total Row (auto adds subtotal feature)
To use Freeze panes, you must click which Ribbon tab?
View
To freeze the panes in this example so you can always see both the day of the week AND the times, click in which cell before freezing?
C4
How would you add a custom number filter in an Excel table (like showing sales over $200,000)?
Use the filter list arrow on the column heading and go to Number Filters
What function would be used to count HOW MANY classes HAVE SPACE LEFT by looking at number data?
=COUNT(range) **counts how many have numbers
Does this function contain a structured reference?
Yes (uses the table and column names)
What is this box called and what is it used for?
Slicer; filters data
How do you sort on two levels, such as all Last Name and then on First Name?
Custom Sort; sort on two levels
What type of Excel chart is this?
histogram
Sorting DATES in Ascending order would result in?
Oldest date to newest date (1900-2022)
What chart part is marked in yellow highlight? Be specific.
Y Axis
What Excel chart part is identified in yellow?
Data Labels
What Excel chart part is identified in yellow?
Legend
What SPECIFIC type of chart is this?
3D Clustered Column
What SPECIFIC type of chart is this?
Donut


Get beautiful free images

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