Edit Game
Basics of Excel
 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   45  Close
What cell is the active cell?
E1
What feature is used in cell E4?
wrap text
What feature has been applied in cell G4?
rotation
To modify the 750.00 to not have decimals, press what button twice?
Decrease decimal
What number format is used in cell G4, where the dollar sign is far left?
Accounting format
What number format is used in cell G12, where the dollar sign is hugging the number?
Currency format
What is wrong with cell A11? ####
The column is too skinny for the numbers
A formula is in cell E3. How do you quickly copy it down the column?
Click the cell and use the fill handle (notch - plus sign - drag)
A pattern started in column D and this popped up. What feature does that represent?
Flash fill
What date format is used in Column A?
Short date
Which group on the Home tab is where you locate the borders button?
Font
To autofit a column, double click where?
On the line between the two column letters (right of the column)
To autofit a column, you can use this button on the Home tab.
Format
What is the function to add up numbers in A3 to A7?
=SUM(A3:A7)
What is the function to count how many cells have numbers in A3 to A7?
=COUNT(A3:A7)
All math - functions and formulas - begin with this
Equals sign =
Function or formula? =D5-B3
Formula
Function or formula? =SUM(B7:B10)
Function (it has a name!)
Formula or function? =(B5+B6)*100
Formula (no "name" or word!)
Function or formula? =AVERAGE(B22:B34)
Function (it has a name!)
Function or formula? =D500-D499
Formula (like a number sentence!)
What does NON-ADJACENT cells mean?
Cells that aren't all touching - like A1 and C1 (because B1 is between)
To click and drag to select two areas on the sheet that are non-adjacent, select the first and hold this before selecting the rest.
Control
Identify the red box.
Name box
Identify the yellow box.
Formula bar
Identify the orange box.
Wrap text in the cell
Identify the white box.
Autosum
Double click the mouse in which spot to autofit?
Yellow arrow (between G and H)
When button can be pressed to access the Column Width dialog box?
Format (green box)
When button can be pressed to access the Flash Fill option?
White box with down arrow icon (Pink box)
Which box is used to modify the number format to Currency?
Blue box (General drop down, Number group)
If you want to insert a new row below row 9, where should you be clicked when you insert sheet rows?
On Row 10 (it inserts above)
Keystroke to return to the top, cell A1
Control+Home
The tabs at the bottom of the page in a workbook represent these.
Sheets
A10:A100 is an example of a:
Cell Range
B5 is an example of a:
Cell Reference
To multiply, use this arithmetic operator.
Asterisk *
To divide, use this arithmetic operator.
Slash /
If you do not want to delete a column but do not need to see it all the time, just do this.
Hide it
A, B, C are examples of these in a spreadsheet.
Columns
1, 2, 3 are examples of these in a spreadsheet.
Rows
In a function, the parenthesis generally should contain this:
Cell Range (example A5:A10)
If the answer to a math problem is in parenthesis, what does that mean?
It's a negative number answer
To add a cell reference to another cell, just type equals and then what?
The cell reference - example --> =A5
To clear the contents of a group of cells, press this keyboard button.
Delete


Get beautiful free images

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