Show:
Basics
Cells
Formatting
Charts
Formulas
100
Ctrl-V is the shorcut for this operation.
What is the Paste function?
100
This describes where cell B3 is.
What is two columns to the right and three rows down?
100
Merge and Centre does this.
What is grouping together the selected cells and centering the content?
100
This is the fastest way to start a chart.
What is the Chart Wizard?
100
This symbol precedes a formula.
What is the = sign?
200
It is the bar found at the bottom of the screen for all Microsoft Suite programs.
What is the Status bar?
200
This is one way of editing the contents of a cell.
1) What is double clicking into the cell? 2) What is selecting the cell and editing the contents in the formula bar?
200
This is how you sort a column in ascending order.
What is selecting the column, Data > Sort > (Sort by: ascending)?
200
This type of chart is usually used to display the contribution of each value to a total.
What is a pie chart?
200
These are some of the operations that the autosum button calculates.
What is SUM, AVERAGE, MIN, MAX?
300
This is one way to select the entire spreadsheet.
1) What is Ctrl + A? OR 2) What is clicking into the upper left cell of the spreadsheet (between A and 1)?
300
The $ symbol situated BEFORE the column/row address indicates this.
What is an absolute cell reference?
300
This company is the largest producer of computer software for the personal computer.
What is Microsoft?
300
Who has the most top-10 chart hit songs in the 21st century?
Who is Beyonce?
300
If E5 = 1, what is the result of =4E5 + 2E5?
What is an error?
400
Holding this button down allows you to select cells that are in different areas of the spreadsheet (cells that are not adjacent to one another).
What is the Control (Ctrl) key?
400
True or False: If you have cells selected, it is possible to see the sum of the cells in the status bar.
What is true?
400
This is how you delete a row you have selected.
What is right click and select 'delete'? OR What is Edit -> Delete?
400
The information you select to chart is referred to as this.
What is the Data Range?
400
Instead of manually entering the same formula for an entire column, using this feature saves time.
What is fill-down?
500
This combination of keys allows to switch into Formula View.
What is Ctrl + `?
500
By default, this is the number of worksheets contained in a new notebook.
What is 3?
500
This formatting tool will convert 3.00 into 3.
What is decrease decimal?
500
This is the most widely used chart in showing data changes over time.
What is a column chart?
500
If A5 = 2, what is the result of =5*A5^2 - 1?
What is 19?