Spreadsheet
Formulas
Charts
Random
Formatting
100
Another name for a Spreadsheet in Excel would be?
What is a workbook.
100

What must be at the front of a formula?

What is an equal sign.

100

What button do I click on to create a chart?

What is the chart button.

Insert Ribbon--> Charts

100

How would you hide column H and row 3?

Select column H --> right click hide

Select row 3 --> right click hide

OR, From Home Ribbon --> Format --> Hide & Unhide --> Hide Column/Row

100
To selct more than one cell at a time, what must you do?
What is click the mouse and drag over the cells needed.
200

What is a range?

A selected area of the spreadsheet, not just one cell.

200

How many equal signs can I have in a formula

One

200

How can I update my chart to a different one? For example, from a pie chart to a 2-D Clustered Column.

Select Chart --> Insert Ribbon --> Select new chart

OR,

Select Chart --> Chart Design --> Change Chart Type

200

How would you freeze panes so that data only rows 1-3 are visible as you scroll on the sheet?

Select row 4. 

**Remember always has to be one below.

View Ribbon -->Freeze Panes


200

How would you update the font size and text color

What is select the cells needed, Home Ribbon --> Above Font Category

300
When writing in a cell, the verbage also appears in the?
What is the formula bar.
300

How would you figure out the average of cell A1 - A5?

What is select those cells and then click Average or write Average=A1:A5

300

How can I move my chart to a new sheet named  'Chart' ?

Right click on the chart --> Move chart --> select new sheet --> name it 'Chart' OR,

Chart Design Ribbon --> Move Chart -->> select new sheet --> name it

300

How would you set a print area to only print A1:B4?

Select the range A1:B4 --> Page Layout Ribbon -->Print Area --> Set Print Area

300
What steps would I follow to make my page landscape?
What is Page layout, Orientation, and the Landscape.
400
What cell would be 6 to the right and 5 down?
What is cell F5.
400

How would I write the formula for 6% sales tax of $325.00?

What is =6%*325.00 or =0.06*325.00

400

How can I remove the chart title and add a axis title only to the Y axis? 

Select chart Elements --> make sure Chart Tile is unchecked. 

Check off Axis Title but only select 'Primary Vertical'

400

How would you import data from a CSV file that's housed in a folder labeled 'Gmetrix Template'?

Data Ribbon --> From Text/CSV --> Select File --> Make sure type is 'CSV'

400
What is the fastest way to make everything center alligned and then bold only items in row 1?
What is select the corner select all button, go to Home and click the center align. Select the 1 and click B for bold.
500

What are two different ways I could define a range

Select Range: in text box write name then hit enter OR

Select Range --> Formula Ribbon --> Define Name

500

what is the different between an 'and'/ 'or' statement. Give an example.


AND = all conditions must be TRUE

Returns TRUE only if every condition is true


 OR = at least one condition must be TRUE

Returns TRUE if any one condition is true


500

How would you update the data selection on your chart? Example to include more or less rows. 

Click on chart --> Filter Toggle --> Select Data to add or remove OR,

Click on chart --> select/drag new data

500

How would you remove all personal information from a workbook? 

Example: Authors name, etc.  

File --> Info -->Check for Issues -->Inspect Document --> Inspect --> Remove all 

500
How do I make the formula I used in A5 also apply to B5, C5, and D5?
What is put your cursor on the corner of A5 until you see a plus sign, hold your mouse down and drag it down through D5.
M
e
n
u